We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Adding 2nd node to Vertica — Vertica Forum

Adding 2nd node to Vertica

I iNstalled Vertica 7.0.1 on single node , created VMart database , later set up 2nd host and tried to add 2nd host with /opt/vertica/sbin/update_vertica -A command , it got stuck in INITIALIZATION stage, i tried the same from MC too , that too got stuck wehn rebooting node 1. Can you help me to troubleshoot

Comments

  • Navin_CNavin_C Vertica Customer
    Hi Jumsheed,

    How did you install Vertica on single node. What parameters you used while installation.

    If you used localhost parameter without -s parameter (for multinode installation) while installation, then you cannot upgrade your cluster to a two node cluster.

    Vertica installation

    Hope this helps
    NC
  • Sorry for the late reply, i added node with IP address not localhost, like -s host1,host2 option , while adding database to host2 it got stuck in recovering node portion(completed 80%) , here is the log
    2014-08-13 17:35:31.001 LowDiskSpaceCheck:0x7fe2b8010ba0-a000000000034a [Txn] <INFO> Begin Txn: a000000000034a 'LowDiskSpaceCheck'
    2014-08-13 17:35:31.001 LowDiskSpaceCheck:0x7fe2b8010ba0-a000000000034a [Txn] <INFO> Rollback Txn: a000000000034a 'LowDiskSpaceCheck'
    2014-08-13 17:35:31.002 LowDiskSpaceCheck:0x7fe2b8010ba0 [Util] <INFO> Task 'LowDiskSpaceCheck' enabled
    2014-08-13 17:35:38.777 Init Session:0x7fe2b4010540 <LOG> @v_vmart_node0001: 00000/2705: Connection received: host=20.20.203.75 port=41522 (connCnt 2)
    2014-08-13 17:35:38.777 Init Session:0x7fe2b4010540 <LOG> @v_vmart_node0001: 00000/4540: Received SSL negotiation startup packet
    2014-08-13 17:35:38.777 Init Session:0x7fe2b4010540 <LOG> @v_vmart_node0001: 00000/4691: Sending SSL negotiation response 'N'
    2014-08-13 17:35:38.778 Init Session:0x7fe2b4010540 <FATAL> @v_vmart_node0001: {SessionRun} 57V03/5785: Cluster Status Request by 20.20.203.75:41522
            HINT:  Cluster State: VMart
                    UP: 1 of 2 (v_vmart_node0001)
                    ----
  • i found the issue now, time between those guests were not in sync. i fixed that and added 2nd node,

Leave a Comment

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