From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
---|---|
To: | Ron Snyder <snyder(at)roguewave(dot)com> |
Cc: | "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Logging function calls to figure out lo_close log |
Date: | 2002-05-08 18:36:28 |
Message-ID: | 1020882988.1596.8.camel@inspiron.cramers |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-jdbc |
Ron,
Can you send the relevant java code as well
Dave
On Tue, 2002-05-07 at 22:08, Ron Snyder wrote:
> Given the following log entries:
>
> May 7 09:40:05 vault pgqv[13698]: [353] DEBUG: ProcessUtility: begin;
> May 7 09:40:05 vault pgqv[13698]: [354] DEBUG: query: SELECT COMPRESSED,
> DATA FROM ATTACHMENTS WHERE ID=460739 AND ATYPE='X'
> May 7 09:40:05 vault pgqv[13698]: [355] DEBUG: query: end
> May 7 09:40:05 vault pgqv[13698]: [356] DEBUG: ProcessUtility: end
> May 7 09:40:08 vault pgqv[13698]: [357] DEBUG: query: begin;
> May 7 09:40:08 vault pgqv[13698]: [358] DEBUG: ProcessUtility: begin;
> May 7 09:40:08 vault pgqv[13698]: [359] DEBUG: query: SELECT COMPRESSED,
> DATA FROM ATTACHMENTS WHERE ID=460739 AND ATYPE='X'
> May 7 09:40:08 vault pgqv[13698]: [360] DEBUG: query: end
> May 7 09:40:08 vault pgqv[13698]: [361] DEBUG: ProcessUtility: end
> May 7 09:40:08 vault pgqv[13698]: [362] ERROR: lo_close: invalid large obj
> descriptor (0)
> May 7 09:40:08 vault pgqv[13698]: [363] ERROR: lo_close: invalid large obj
> descriptor (0)
> May 7 09:40:08 vault pgqv[13698]: [364] ERROR: lo_close: invalid large obj
> descriptor (0)
> May 7 09:40:08 vault pgqv[13698]: [365] ERROR: lo_close: invalid large obj
> descriptor (0)
> May 7 09:40:08 vault pgqv[13698]: [366] ERROR: lo_close: invalid large obj
> descriptor (0)
>
> I'm trying to help some programmers figure out what portion of their java
> code might be causing this, but I don't know java to help them debug their
> code-- I was wondering if there is anything on the server end that I could
> change to help them track this down. They're using the jdbc that was
> current shortly after the 7.2 release and the 7.2 server (they're still in
> acceptance testing for 7.2.1).
>
> They do turn autocommit off, and they've discovered that they may not have
> been turning it back on explicitly so are going to make a change to that
> portion of code. Are there any other easy mistakes that people have made
> that may result in the above behavior?
>
> -ron
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Marzen | 2002-05-08 20:01:05 | Re: Performance issues with compaq server |
Previous Message | Steve Atkins | 2002-05-08 17:53:08 | Re: Performance issues with compaq server |
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Snyder | 2002-05-08 20:00:37 | Re: Logging function calls to figure out lo_close log entr |
Previous Message | Dave Cramer | 2002-05-08 18:28:14 | Re: Fwd: help with jdbc driver building -postgresql sources |