Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [BUGS] BUG #1347: Bulk Import stopps after a while (
- From: Oliver Jowett <oliver(at)opencloud(dot)com>
- To: Bahadur Singh <bahadursingh(at)yahoo(dot)com>
- Cc: Kris Jurka <books(at)ejurka(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
- Subject: Re: [BUGS] BUG #1347: Bulk Import stopps after a while (
- Date: Wed, 15 Dec 2004 02:40:39 +1300
- Message-id: <41BEED57.2090904@opencloud.com> <text/plain>
Bahadur Singh wrote:
Finally I am able to force the driver to do the DEBUG level output on the console. err.zip contains Debug level output.
OK, it looks like it is the connection deadlock issue, but triggered by a case I hadn't considered. For some reason every query in the batch is creating a new named statement on the backend .. and the statement cleanup process that happens before query execution is flooding statement Close commands down the connection on the second batch execution, which appears to deadlock the connection. The exact behaviour will be fairly unpredicatable as it depends on when the JVM does garbage collection.
I will try to find some time to investigate this properly tomorrow. -O
- Follow-Ups:
- Re: [BUGS] BUG #1347: Bulk Import stopps after a while (
- From: Kris Jurka
- Re: [BUGS] BUG #1347: Bulk Import stopps after a while (
- Prev by Date: Re: Updated french translation for JDBC driver
- Next by Date: Re: [BUGS] BUG #1347: Bulk Import stopps after a while (
- Previous by thread: Updated french translation for JDBC driver
- Next by thread: Re: [BUGS] BUG #1347: Bulk Import stopps after a while (
- Indexes: