Skip to main content

Receive on v_node0001: Message receipt from v_node0009 failed []

  • February 10, 2020
  • 3 replies
  • 6 views
karthik
Forum|alt.badge.img+1

Hi,
I'm really unable to figure out a troubleshooting article in vertica portal regarding the below type of message seen in vertica.log
_Receive on v_node0001: Message receipt from v_node0009 failed []___
Can somebody please provide me with pointers on how to trouble-shoot this?
This is vertica 8.1.1

    3 replies

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • February 10, 2020

    There is a great response per that error from Tom Wall (Vertica Senior Engineering Manager) here:

    https://stackoverflow.com/questions/56964830/insert-query-failed-in-vertica-with-error-code-4534-when-triggered-from-rstudio

    karthik
    Forum|alt.badge.img+1
    • karthik
    • Author
    • Participating Frequently
    • February 12, 2020

    Thanks Jim. That helps

    karthik
    Forum|alt.badge.img+1
    • karthik
    • Author
    • Participating Frequently
    • February 14, 2020

    Hi,
    I did troubleshoot this further. I am seeing the issue in the below scenario. I have concurrent copy (direct) commands being executed against my vertica cluster. If I double the no. of records for each of the copy commands and load them to vertica, I can see that I'm hitting "Message receipt from node failed" error ... I can clearly see that this message is seen only when i am sending more data..
    Can anyone explain what could be going wrong here and how to prevent this?

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement