Skip to main content

Node Status Down

  • February 21, 2014
  • 2 replies
  • 18 views
Ashley_1
Forum|alt.badge.img+1
Couldn't start the database after upgrading to V7.
Node Status: v_analytics_node0001: (DOWN)
Node Status: v_analytics_node0001: (DOWN) Error starting database, no nodes are up
After click continue, got this message:"Database startup failed, but enough information is available to start the database from a previous epoch.  WARNING: if you say 'yes', changes made to database after '0' (epoch 0) will be permanently lost."
What's the issue? Should I start from 0 epoch? I don't want to lose any data.

    2 replies

    Daniel_Leybovic
    Forum|alt.badge.img+1
    • Daniel_Leybovic
    • Participating Frequently
    • February 21, 2014
    If you will start from epoch 0, so 99.999999% you will lose data.

    1. Can you run CRC and indexer check?
    https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/AdministratorsGuide/OperatingTheDatabase/...

    2. Collect logs and share them somewhere
    * dbLog
    * startup.log
    * vertica.log

    be sure that any sensitive info is deleted!
    arunpandian
    • arunpandian
    • New Participant
    • May 12, 2016

    Vertica 7.1

     

    10.10.100.62 (DOWN) --- > node0003

    10.10.100.63 (UP)       ----> node0002

    10.10.100.64 (UP)       ----> node0001

     

     

    Startup.log- is Empty

    Vertica.log - Not shows error

     

    Error :

    10.10.100.62 failed with exit code 1. Check /home/dbadmin/S2_bigdata/dbLog for more information.
    Press RETURN to continue

     

    Check:

    ps -ef | grep spread

     

    spread is not run for Down node.

     

     

    tail -f  /home/dbadmin/S2_bigdata/dbLog

     

    vertica: invalid data in PID file [/home/dbadmin/XXXXXXXX/XXXX]

     

    10.10.100.62 :  vi /home/dbadmin/S2_bigdata/v_s2_bigdata_node0003_catalog/vertica.pid

     

    file is Empty

     

    10.10.100.63 : vi /home/dbadmin/S2_bigdata/v_s2_bigdata_node0002_catalog/vertica.pid

     

    418
    /home/dbadmin/S2_bigdata/v_s2_bigdata_node0002_catalog

     

    copy this content and paste 10.10.100.62 vi /home/dbadmin/S2_bigdata/v_s2_bigdata_node0003_catalog/vertica.pid file  and change 

     

    418
    /home/dbadmin/S2_bigdata/v_s2_bigdata_node0003_catalog

     

    save this file 

     

    and finally 

     

    /opt/vertica/sbin/verticad start

     

    and Enter your dbadmin Password Its automattically startup your node.

     

     

     

    10.10.100.62 (UP)       --- > node0003

    10.10.100.63 (UP)       ----> node0002

    10.10.100.64 (UP)       ----> node0001

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement