In Vertica:::::-> server 100.70.200.221 down , switching to 1100.70.200.222

Hello Everyone

From ETL log file i see following statement. But when i went through vertica.log. I could not find any server down failure statement in vertica. Therefore i wonder if there is other way to verfiy whether vertica server 100.70.200.221 were really down or not then please advise? If there is any sql query through which we can can find/check the below mentioned status in vertica then please advise.

 

2016/08/09 09:01:00 - Invoke COPY Loaded File Properties - (stdout) server 100.70.200.221  down , switching to 1100.70.200.222 \
n
2016/08/09 09:01:01 - Invoke COPY Loaded File Properties - (stdout)  Server_Status
2016/08/09 09:01:01 - Invoke COPY Loaded File Properties - (stdout) ---------------

 

Will look forward to hear from you

 

Thank You

 

Ujjwal

Comments

  • ThakurThakur Employee

    select distinct node_name from nodes where node_state<>'UP';

  • Hi Thakur

    I trigger above mentioned query but it does not shows any output. Attached is the screenshot here with. Please advise.

     

     

     

    With Regards

     

    Ujjwal

  • Just run select * from nodes. 

  • I tried that already before but it shows nothing due to which only i post my queries. Please let me know if there is any other way to verify

  • Would you mind logging on to your server and running that command using vsql client? 

  • I already did that but it does not show node down status. Once again switching down issued on fraction of time may be on second due to which i might not been able to see from select * from nodes.

     

    Please let me know if there is any other way to verify.

     

     

    With Regards

  • Do you have IPVS setup? 

Leave a Comment

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