The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Vertica Start Issue and Spread Socket file missing after Restart

Hello Everyone, I have vertica 9 installed on 3 linux RHEL nodes. After a restart on the servers the database is down and can't be started. I checked the dbLog file and found this error : unable to connect via UNIX socket to /opt/vertica/spread/tmp/4803 (pid=14883): Error: No such file or directory. the file 4803 which is missing seems to be the cause of this failure. Would you please suggest any solution ? Thanks

Answers

  • Jim_KnicelyJim_Knicely Administrator Administrator

    Hi,

    Did something change with the network? Like a subnet change?

    How are you restarting the DB? What command?

    Note that the /opt/vertica/spread/tmp/4803 file only exists when the DB is up.

    [[email protected] ~]$ ps -ef | grep [4]803
    dbadmin  474660      1  1 Aug05 ?        00:49:47 /opt/vertica/bin/vertica -D /home/dbadmin/test_db/v_test_db_node0001_catalog -C test_db -n v_test_db_node0001 -h 172.16.61.176 -p 5433 -P 4803 -Y ipv4
    
    [[email protected] ~]$ ls /opt/vertica/spread/tmp/4803
    /opt/vertica/spread/tmp/4803
    
    [[email protected] ~]$ admintools -t stop_db -d test_db -F
    Info: no password specified, using none
            Connecting to database
            Issuing shutdown command to database
    Database test_db stopped successfully
    
    [[email protected] ~]$ ls /opt/vertica/spread/tmp/4803
    ls: cannot access /opt/vertica/spread/tmp/4803: No such file or directory
    
    [[email protected] tmp]$ admintools -t start_db -d test_db -F
    Info: no password specified, using none
            Starting nodes:
                    v_test_db_node0001 (172.16.61.176)
                    v_test_db_node0002 (172.16.61.177)
                    v_test_db_node0003 (172.16.61.178)
            Starting Vertica on all nodes. Please wait, databases with a large catalog may take a while to initialize.
            Node Status: v_test_db_node0001: (DOWN) v_test_db_node0002: (DOWN) v_test_db_node0003: (DOWN)
            Node Status: v_test_db_node0001: (DOWN) v_test_db_node0002: (DOWN) v_test_db_node0003: (DOWN)
            Node Status: v_test_db_node0001: (DOWN) v_test_db_node0002: (DOWN) v_test_db_node0003: (DOWN)
            Node Status: v_test_db_node0001: (DOWN) v_test_db_node0002: (DOWN) v_test_db_node0003: (DOWN)
            Node Status: v_test_db_node0001: (DOWN) v_test_db_node0002: (DOWN) v_test_db_node0003: (DOWN)
            Node Status: v_test_db_node0001: (INITIALIZING) v_test_db_node0002: (INITIALIZING) v_test_db_node0003: (INITIALIZING)
            Node Status: v_test_db_node0001: (UP) v_test_db_node0002: (UP) v_test_db_node0003: (UP)
    Database test_db: Startup Succeeded.  All Nodes are UP
    
    [[email protected] tmp]$ ls /opt/vertica/spread/tmp/4803
    /opt/vertica/spread/tmp/4803
    

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.