Import Error while importing postgres data

I just started exploring cockroach db. I am trying to import some data from postgres to cockroach as mentioned in this link.

I am getting some errors like below in the console-

psql -p 26257 -h localhost -d van -U root < config_blob.sql
CREATE TABLE
ERROR:  expected 7 values, got 1
message type 0x5a arrived from server while idle
message type 0x5a arrived from server while idle


message type 0x5a arrived from server while idle

Can someone let me know what this error mean? Where can I check for some meaningful error?

Environment

  • Mac OS X 10.12.6
  • Postgre 9.6.5
  • Cockroach 1.1.0

Hi @tuk,

Expected 7 values, got 1 sounds like the dump is malformed - could you check that the COPY command inside the dump has the right number of columns for the created table?

On the other hand, message type 0x5a arrived from server while idle sounds like a problem on our side. If you could send us the table schema and sample COPY line that would be great (feel free to anonymize).

Thanks,
Jordan

Filed the github issue as below -

1 Like