Node Status Down

Ashley_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.

Daniel_Leybovic

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

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