BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin

From: "Greg Johnson" <greg(dot)johnson(at)interprose(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin
Date: 2011-07-21 16:13:33
Message-ID: 201107211613.p6LGDXLC082569@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6127
Logged by: Greg Johnson
Email address: greg(dot)johnson(at)interprose(dot)com
PostgreSQL version: pg_dump (Postgr
Operating system: CentOS release 5.6 (Final)
Description: pg_restore failing: unexpected message type 0x58 during
COPY from stdin
Details:

I am running into an error loading a backup of the production database..
never had a problem before.

These are dump /restore commands I am using:
pg_dump -Fc -h ackbar -U webar_admin webar -f
/var/portal/backup/db/webar-20110719180003.gz

pg_restore -d webar_dev -U webar_admin -Fc webar-20110719180003.gz

Both machines have same version of postgres :
[root(at)awing ~]# pg_dump --version
pg_dump (PostgreSQL) 8.4.8

[root(at)dev ~]# pg_restore --version
pg_restore (PostgreSQL) 8.4.8

MD5s are the same:
[root(at)awing db]# md5sum webar-20110719180003.gz
f4ec991e4635cd70a1f85864e04e6214 webar-20110719180003.gz

[root(at)dev ~]# md5sum webar-20110719180003.gz
f4ec991e4635cd70a1f85864e04e6214 webar-20110719180003.gz

This is the error from dev while trying to restore:
pg_restore: [custom archiver] could not read from input file: end of file

Here is what I found in the pg_log file:
LOG: checkpoint starting: xlog
LOG: checkpoint complete: wrote 8147 buffers (3.1%); 0 transaction log
file(s) added, 0 removed, 128 recycled; write=192.644 s, sync=1.613 s,
total=194.269 s
ERROR: unexpected message type 0x58 during COPY from stdin
CONTEXT: COPY form_big, line 9195632

Here is another log entry:
TRUNCATE TABLE ONLY form_field_config;
LOG: statement: COPY form_field_config (form_field_config_id,
form_config_id, identifier, label, field_type, field_group, required,
display_on_summary, new_line, col_span, field_order, searchable,
fk_form_config_id, fk_label, fk_on_delete_action, primary_key,
form_big_column) FROM stdin;
LOG: checkpoint starting: time
LOG: checkpoint complete: wrote 160 buffers (0.1%); 0 transaction log
file(s) added, 0 removed, 0 recycled; write=31.811 s, sync=0.066 s,
total=33.898 s
ERROR: unexpected message type 0x58 during COPY from stdin
CONTEXT: COPY form_config, line 1
STATEMENT: COPY form_config (form_config_id, customer_id, identifier,
form_config_type, label, description, icon, location, allow_multiple,
created_by, create_date, last_updated_by, last_updated, view_on_update,
view_on_insert, "position", record_label, converted, text_count,
bigint_count, timestamp_count, real_count, boolean_count) FROM stdin;
LOG: could not send data to client: Broken pipe
STATEMENT: COPY form_config (form_config_id, customer_id, identifier,
form_config_type, label, description, icon, location, allow_multiple,
created_by, create_date, last_updated_by, last_updated, view_on_update,
view_on_insert, "position", record_label, converted, text_count,
bigint_count, timestamp_count, real_count, boolean_count) FROM stdin;
LOG: unexpected EOF on client connection
ERROR: unexpected message type 0x58 during COPY from stdin

Looks like they are happening at different spots..

I have tried 5 different dump/restores and all error out.

There is nothing in /var/log/messages

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-07-21 18:44:48 Re: BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin
Previous Message Robert Haas 2011-07-21 12:43:15 Re: BUG #6086: Segmentation fault