| 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: | 2004-12-14 13:40:39 |
| Message-ID: | 41BEED57.2090904@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schaber | 2004-12-14 14:06:58 | Re: [BUGS] BUG #1347: Bulk Import stopps after a while ( |
| Previous Message | Kris Jurka | 2004-12-14 09:48:07 | Re: [JDBC] Updated french translation for JDBC driver |