Skip to main content

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

  • August 11, 2016
  • 7 replies
  • 15 views
UJJWAL_RANA
Forum|alt.badge.img+2

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

    7 replies

    Thakur
    Forum|alt.badge.img
    • Thakur
    • Participating Frequently
    • August 11, 2016

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

    UJJWAL_RANA
    Forum|alt.badge.img+2
    • UJJWAL_RANA
    • Author
    • Participating Frequently
    • August 12, 2016

    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

    K__
    Forum|alt.badge.img
    • K__
    • Participating Frequently
    • August 12, 2016

    Just run select * from nodes. 

    UJJWAL_RANA
    Forum|alt.badge.img+2
    • UJJWAL_RANA
    • Author
    • Participating Frequently
    • August 15, 2016

    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

    K__
    Forum|alt.badge.img
    • K__
    • Participating Frequently
    • August 15, 2016

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

    UJJWAL_RANA
    Forum|alt.badge.img+2
    • UJJWAL_RANA
    • Author
    • Participating Frequently
    • August 16, 2016

    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

    K__
    Forum|alt.badge.img
    • K__
    • Participating Frequently
    • August 16, 2016

    Do you have IPVS setup? 

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement