Skip site navigation (1) Skip section navigation (2)

RE: fastpath error?

From: "chris markiewicz" <cmarkiew(at)commnav(dot)com>
To: "'Peter Mount'" <peter(at)retep(dot)org(dot)uk>, <pgsql-general(at)postgresql(dot)org>, <pgsql-jdbc(at)postgresql(dot)org>
Cc: <chris(dot)markiewicz(at)commnav(dot)com>
Subject: RE: fastpath error?
Date: 2001-04-12 13:35:50
Message-ID: 014001c0c355$7d9b2550$dbb846c6@cmarkiewicz (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc
Regarding the fastpath error (ERROR:  lo_close: invalid large obj descriptor
(0)...i also get this with lo_tell, etc)...

is there any possible cause that is not related to autoCommit?  our app does
a lot of transactional stuff so autocommit is set to false for all
connections (i added some logging that shows me the autocommit attribute and
it's false even when this error occurs)...i still see this problem
occasionally/randomly.

i appreciate your help.
chris

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Peter Mount
Sent: Thursday, March 29, 2001 4:13 AM
To: cmarkiew(at)commnav(dot)com; pgsql-general(at)postgresql(dot)org
Subject: Re: fastpath error?


At 07:56 28/03/01 -0500, chris markiewicz wrote:
>Hello.
>
>I am occasionally (seemingly randomly) seeing the following error when I
try
>to load a large object.
>
>FastPath call returned ERROR:  lo_close: invalid large obj descriptor (0)

You must setAutoCommit(false) before using any large object.

Can someone give me some insight on this?  Can I call lo_close explicitly if
>i get this error?  Can I ignore it or will that leave me with open
>resources?

There are no open resources at the time of the error. Because lo's need to
be within a transaction when the transaction closes, so do the lo's.

Peter


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


In response to

Responses

pgsql-jdbc by date

Next:From: Andrew B. LuckDate: 2001-04-12 20:22:58
Subject: jdbc works with java programs. not with tomcat.
Previous:From: Rajesh BallaDate: 2001-04-12 02:33:54
Subject: jdbc driver Multiple Resultsets

pgsql-general by date

Next:From: Alessio BragadiniDate: 2001-04-12 14:03:42
Subject: Re: to_char(now(), 'YYYY') and time zones
Previous:From: Justin CliftDate: 2001-04-12 12:40:56
Subject: Re: [GENERAL] Re: ongoing holy grail thread

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group