From: | Ron Snyder <snyder(at)roguewave(dot)com> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | error restoring large objects during pg_restore |
Date: | 2003-06-10 22:50:27 |
Message-ID: | F888C30C3021D411B9DA00B0D0209BE803BBA621@cvo-exchange.cvo.roguewave.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to pg_restore a database using a process that I've used a bunch
(10-15) times in the past, and this is the first time it's ever failed on
me. It's failing with the following error:
[snip]
pg_restore: creating table for large object cross-references
pg_restore: [custom archiver] could not read data block - expected 1, got 0
pg_restore: *** aborted because of error
When I look in the logs, I see the following:
[snip]
Jun 10 14:24:19 vault pgqv[16995]: [242519] DEBUG: query: Insert Into
dump_blob_xref(oldOid, newOid) Values (57898427, 60983741);
Jun 10 14:24:19 vault pgqv[16995]: [242520] DEBUG: query: Insert Into
dump_blob_xref(oldOid, newOid) Values (57898503, 60983743);
Jun 10 14:24:19 vault pgqv[16995]: [242521] DEBUG: query: Insert Into
dump_blob_xref(oldOid, newOid) Values (57898534, 60983745);
Jun 10 14:24:19 vault pgqv[16995]: [242522] DEBUG: query: Insert Into
dump_blob_xref(oldOid, newOid) Values (57898544, 60983747);
Jun 10 14:24:19 vault pgqv[16995]: [242523] DEBUG: query: Insert Into
dump_blob_xref(oldOid, newOid) Values (57898552, 60983749);
Jun 10 14:24:19 vault pgqv[16995]: [242524] DEBUG: query: Insert Into
dump_blob_xref(oldOid, newOid) Values (57898564, 60983751);
Jun 10 14:24:19 vault pgqv[16995]: [242525] DEBUG: query: Insert Into
dump_blob_xref(oldOid, newOid) Values (57898570, 60983753);
Jun 10 14:24:19 vault pgqv[16995]: [242526] DEBUG: query: Insert Into
dump_blob_xref(oldOid, newOid) Values (57898584, 60983755);
Jun 10 14:24:19 vault pgqv[16995]: [242527] DEBUG: query: Insert Into
dump_blob_xref(oldOid, newOid) Values (57898592, 60983757);
Jun 10 14:24:19 vault pgqv[16995]: [242528] DEBUG: query: Insert Into
dump_blob_xref(oldOid, newOid) Values (1, 60983759);
I've done this twice, with two different db dumps, and both have given me
the same error. I'm wondering if that last line (with the oldOid value of
1) is significant.
Thoughts, ideas?
-ron
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-06-10 22:56:53 | Re: referential integrity violations |
Previous Message | Erik Price | 2003-06-10 22:26:29 | pg_dump -> \i infile |