X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B1DE93A6323; Sat, 11 Dec 2004 17:42:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 92100-04; Sat, 11 Dec 2004 17:42:19 +0000 (GMT) Received: from sj-iport-4.cisco.com (sj-iport-4.cisco.com [171.68.10.86]) by svr1.postgresql.org (Postfix) with ESMTP id 06D003A630A; Sat, 11 Dec 2004 17:42:19 +0000 (GMT) Received: from sj-core-3.cisco.com (171.68.223.137) by sj-iport-4.cisco.com with ESMTP; 11 Dec 2004 09:42:33 -0800 X-BrightmailFiltered: true X-Brightmail-Tracker: AAAAAA== Received: from cjwhitew2k02 (sjc-vpn1-221.cisco.com [10.21.96.221]) by sj-core-3.cisco.com (8.12.10/8.12.6) with ESMTP id iBBHgF6n015475; Sat, 11 Dec 2004 09:42:16 -0800 (PST) Message-Id: <200412111742.iBBHgF6n015475@sj-core-3.cisco.com> Reply-To: From: "Chris White (cjwhite)" To: "'Tom Lane'" Cc: , Subject: Re: [JDBC] Issue with large objects Date: Sat, 11 Dec 2004 09:42:15 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Thread-Index: AcTfp/B1T58JFweQS/iT/QIku7rMjAAAHDhw In-Reply-To: <17161.1102786562@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.589 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200412/91 X-Sequence-Number: 15677 This is 7.4.5. I'm not sure I can get it to happen on an empty database, the database this is happening on has about 300 large objects, but I will try. Also, I found by re-indexing the pg_largeobject table the problem seems to have gone away. Chris White -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Saturday, December 11, 2004 9:36 AM To: cjwhite@cisco.com Cc: pgsql-admin@postgresql.org; pgsql-jdbc@postgresql.org Subject: Re: [JDBC] Issue with large objects "Chris White (cjwhite)" writes: > I am putting a large object into my database using jdbc interface and > using LargeObjectManager to do largeobject open, write and close. > After several largeobject writes I get the following message > 'failed to re-find parent-key in "pg_largeobject_loid_pn_index"' What PG version is this? Can you put together a self-contained test case (ie, one that causes the error starting from an empty database)? regards, tom lane