Hello friends, my Vertica Management Console this showing that database is with CRITICAL status, but I'm emitrindo sql commands and is normal, you know it can be?
Could you please explain error in more detail?? if possible, could you please attach screenshot
Annex images of the console.
Could you please restart the database through management console UI and also share me with the following information
1) Status of vertica agent on all nodes You can get this by executing below mentioned command /etc/init.d/vertica_agent status 2) Plese check if vertica process is running on management console server. ps -ef | grep vertica 3) Please send us agent.log from all the nodes : /opt/vertica/log/agent /opt/vertica/log/agentStdMsg.log /opt/vertica/log/agentTool-<username>.log
root@:~# /etc/init.d/vertica_agent status
Vertica Agent: (pid 2342) is running...
root@:~#root@:~# ps -ef | grep vertica
dbadmin 2290 1 2 10:18 ? 00:02:37 /opt/vconsole/vendor/oracle/java/jre/1.7.0_51/bin/java -Dvertica.home=/opt/vertica -Dvconsole.home=/opt/vconsole -Djava.library.path=/opt/vconsole/lib -Dderby.system.home=/opt/vconsole/mcdb/derby -Xmx2048m -Xms1024m -XX:MaxPermSize=256m -jar /opt/vconsole/lib/webui.wardbadmin 2342 1 0 10:18 ? 00:00:00 /bin/bash /opt/vertica/agent/agent.sh /opt/vertica/config/users/dbadmin/agent.confdbadmin 2354 2342 1 10:18 ? 00:01:04 /opt/vertica/oss/python/bin/python ./simply_fast.pydbadmin 3966 1 0 10:25 ? 00:00:00 /opt/vertica/spread/sbin/spread -c /home/dbadmin/BIHC/v_bihc_node0001_catalog/spread.confdbadmin 3968 1 2 10:25 ? 00:01:48 /opt/vertica/bin/vertica -D /home/dbadmin/BIHC/v_bihc_node0001_catalog -C BIHC -n v_bihc_node0001 -h xxxxxxxx -p 5433 -P 4803 -Y ipv4dbadmin 3972 3968 0 10:25 ? 00:00:01 /opt/vertica/bin/vertica-udx-zygote 12 10 3968 debug-log-off /home/dbadmin/BIHC/v_bihc_node0001_catalog/UDxLogsroot 28758 3199 0 11:55 pts/0 00:00:00 grep --color=auto vertica
A CRITICAL node is a node which has the final copy of some peice of information or would require that the cluster stop if it failed.
Vertica uses data replication to ensure that if a fault occurs, you do not lose data. If you have 2 copies of data then you can lose 1 copy and continue operating. This is called K-Safety with k=1.
A 1-node database cannot have K-Safety, since there is no where else to place your data. k=0.
Therefore your node will always be critical. If something happens to that node, your database stops and you may lose your data.
The K Safety and Critical concepts should be available in our documentation.
I got it , okay thanks for the help!