pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe(2): Re(2): Large Object dump ?
2+ messages / 2 participants
[nested] [flat]
* Re(2): Re(2): Large Object dump ?
@ 2000-11-01 13:44 pgsql-sql <pgsql-sql@fc.emc.com.ph>
2000-11-02 17:17 ` Re: Re(2): Re(2): Large Object dump ? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: pgsql-sql @ 2000-11-01 13:44 UTC (permalink / raw)
To: zakkr@zf.jcu.cz; +Cc: tjk@tksoft.com; pgsql-sql
because of some problems (see below). i was also thinking that it was
just a compatibility problem of pg_dumplo-0.0.5 to postgresql 6.5.3.
and because i needed it badly, i wrote a "quick & dirty" perl script.
1. When I tried showing all LO of my_db, I got this message:
pg_dumplo -w -d my_db
NOTICE: (transaction aborted): queries ignored until END
NOTICE: (transaction aborted): queries ignored until END
NOTICE: (transaction aborted): queries ignored until END
Database 'my_db' contains 0 large objects.
My observation: my_db actually contains large objects.
2. When I tried this
pg_dumplo -a -d my_db -s /my_dump/dir
I got this.
<< CUT >>
dump for_payment.application (218 large obj)
lo_export: can't open inv object 4654657:
/fs/linux/work/tools/pg_dumplo-0.0.5/pg_dumplo
lo_export: can't open inv object 4654689:
/fs/linux/work/tools/pg_dumplo-0.0.5/pg_dumplo
lo_export: can't open inv object 4654881:
/fs/linux/work/tools/pg_dumplo-0.0.5/pg_dumplo
lo_export: can't open inv object 4654081:
/fs/linux/work/tools/pg_dumplo-0.0.5/pg_
<< CUT >>
Exported 1131 large objects.
NOTICE: LockReleaseAll: xid loop detected, giving up
My observation: The tree (directories) were created but 1131 large objects
were not there.
The lo_dump.index file is not readable
(contains garbage).
peace,
sherwin
zakkr@zf.jcu.cz writes:
>
>On Wed, 1 Nov 2000, pgsql-sql wrote:
>
>> You can try the script I made for exporting all my Pg database.
>> Ideas were borrowed from pg_dumplo-0.0.5.
>> Make it sure that you have "Perl5 extension for PostgreSQL - Pg.pm"
>> installed.
>
> Why you re-write pg_dumplo to perl and not use directly it? Perl
>love? :-)
>
> Karel
>
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Re(2): Re(2): Large Object dump ?
2000-11-01 13:44 Re(2): Re(2): Large Object dump ? pgsql-sql <pgsql-sql@fc.emc.com.ph>
@ 2000-11-02 17:17 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2000-11-02 17:17 UTC (permalink / raw)
To: pgsql-sql <pgsql-sql@fc.emc.com.ph>; +Cc: zakkr@zf.jcu.cz; tjk@tksoft.com; pgsql-sql
"pgsql-sql" <pgsql-sql@fc.emc.com.ph> writes:
> Exported 1131 large objects.
> NOTICE: LockReleaseAll: xid loop detected, giving up
Pre-7.0 LockReleaseAll() contained an entirely arbitrary assumption
that it should never encounter a situation where there were more than
1000 locks held by one transaction :-(. So it chokes when you access
more than 1000 LOs in the same transaction.
Dunno about your other issue, but clearly your application is
failing to report whatever error message was returned when the
transaction was aborted...
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-11-02 17:17 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-01 13:44 Re(2): Re(2): Large Object dump ? pgsql-sql <pgsql-sql@fc.emc.com.ph>
2000-11-02 17:17 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox