Configuring and starting Spread

I already have vertica installed in AWS and after days of troubleshooting I discovered that I needed to -T option in install_vertica to configure point to point. Can I get some help on:


1) how to re-configure spread to use -T (point to point)?

2) how to restart?


I tried using 


[root@ip-10-241-251-220 ~]# /opt/vertica/sbin/update_vertica -s host1,host2,host3 -r ./v/vertica-7.1.1-0.x86_64.RHEL5.rpm -u vertica -T --failure-threshold NONE


but I see this message when I run the update:



Running upgrade logic
No spread upgrade required: /opt/vertica/config/vspread.conf not found on any node
Installation complete.



But I do see vspread.conf in catalog directory but not sure how to configure it.



  • Options



    Since you are running on AWS request you to kindly run below command (-T -N required in the cloud) & let us know if it still fails:


    Run this:

    /opt/vertica/sbin/update_vertica -s host1,host2,host3 -r ./v/vertica-7.1.1-0.x86_64.RHEL5.rpm -u vertica -T -N --failure-threshold NONE


    In place of:

    /opt/vertica/sbin/update_vertica -s host1,host2,host3 -r ./v/vertica-7.1.1-0.x86_64.RHEL5.rpm -u vertica -T --failure-threshold NONE


    Also I hope you are installing this on dev/test cluster.If its a prod one I would recommend not to use "failure-threshold NONE"  and resolve the warnings if comes any.



    Rahul Choudhary

  • Options

    I believe that the installer will tell you to use -T on AWS if you let it validate your environment for you -- using a failure threshold of NONE suppresses those helpful warnings.



  • Options

    It looks like that command didn't update any files. I see the following message:

    No spread upgrade required: /opt/vertica/config/vspread.conf not found on any node


    There is one vspread.conf and it's contents are:


    Spread_Segment {
    N127000000001 {
    EventLogFile = /dev/null
    EventTimeStamp = "[%a %d %b %Y %H:%M:%S]"
    DaemonUser = spread
    DaemonGroup = verticadba
    DebugFlags = { EXIT }


    [vertica@ip-10-241-251-220 ~]$ ps -eaf|grep spread
    vertica 4192 1 0 12:48 pts/0 00:00:00 /opt/vertica/spread/sbin/spread -c /home/vertica/test/v_test_node0001_catalog/spread.conf

    There is spread.conf that I think spread is using and it's contents are:

    # 1
    # Auto-generated by vertica - do not edit
    ActiveIPVersion = IPv4
    Spread_Segment {
    N010241251220 {
    # begin end matter
    EventLogFile = /dev/null
    EventTimeStamp = "[%a %d %b %Y %H:%M:%S]"
    DebugFlags = { PRINT EXIT }
    ExitOnIdle = yes

  • Options
    SruthiASruthiA Vertica Employee Administrator



      As far as I know, That warning message may not cause any problems to your AWS cluster. DId you try creating a database and perform some operations on it?




  • Options

    After vertica 7 the spread config file is in catalog. Once that the database is created to change from broadcast ( default setting) to point to point ( the -T) option,  you need to execute

    •select set_control_mode('pt2pt');
    •select reload_spread(true);


    To go back to broadcast is

    • select set_control_mode('broadcast');


    Your database may go down while doing the reload, or if does not you should restart the cluster. You can check that the change happen by looking at the spread.conf file that is on your catalog directory.

    if it is broadcast you will have un spread segment, it it is point to point, you will have one segment per node.





  • Options

    On a related node, what is the proper procedure to migrate a 7.x HP Vertica cluster from a set of IPs to another one? The cluster was incorrectly configured using public IPs and I would like to change them to private. Given the changes in Vertica 7.x , it would be nice to have this procedure documented. 

  • Options

    Yes, for now the process of changing IP is with Support Assistance as it needs to change the catalog objects before. 



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file