Import Error while importing postgres data

General
#1

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
#2

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

#3

Filed the github issue as below -

1 Like