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

Поиск
Список
Период
Сортировка
От Greg Johnson
Тема BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin
Дата
Msg-id 201107211613.p6LGDXLC082569@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      6127
Logged by:          Greg Johnson
Email address:      greg.johnson@interprose.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@awing ~]# pg_dump --version
pg_dump (PostgreSQL) 8.4.8


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

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

[root@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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Artem Andreev"
Дата:
Сообщение: BUG #6126: CC parameter in to_char() behaves incorrectly
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6127: pg_restore failing: unexpected message type 0x58 during COPY from stdin