| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "pgsql-sql" <pgsql-sql(at)fc(dot)emc(dot)com(dot)ph> |
| Cc: | zakkr(at)zf(dot)jcu(dot)cz, tjk(at)tksoft(dot)com, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Re(2): Re(2): Large Object dump ? |
| Date: | 2000-11-02 17:17:05 |
| Message-ID: | 25781.973185425@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
"pgsql-sql" <pgsql-sql(at)fc(dot)emc(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Boettcher | 2000-11-02 23:58:23 | PL/PGSQL beginning is hard.... |
| Previous Message | Josh Berkus | 2000-11-02 16:55:36 | Re: Outer Joins |