error restoring large objects during pg_restore

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

Responses

Browse pgsql-general by date

  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