Node Status Down
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.
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.
0
Comments
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!
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