Skip to main content

Error on large COPY: lost synchronization with server: got message type "F"

  • July 10, 2013
  • 2 replies
  • 15 views
Oleg_Mürk
Executing vsql with a COPY FROM LOCAL ABORT ON ERROR with large enough input (split into multiple files) results in: ----------------------- Error: lost synchronization with server: got message type "F", length 43729 connection to server was lost ----------------------- What can be causing this and how to avoid it? Thank You!

    2 replies

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • July 11, 2013
    Hi Oleg, Out of curiosity, are you using the latest version of vsql? (And what version of Vertica?) Various issues have been fixed with COPY LOCAL in recent driver versions. If that's not it: How many files do you have, and how big is each file? How far does Vertica get before failing? Does it reach an error (ie., an invalid line) and abort as requested, just giving the wrong error message? Adam
    njvijay
    • njvijay
    • Participating Frequently
    • October 31, 2013
    I am facing same issue today. COPY LOCAL is trying to load several hundreds of load files  in a single command. Does vertica have any limitation on request buffer size or limitation on number files to be loaded through COPY LOCAL command. It works fine with small number of files.
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement