pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re(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