| From: | Anoop K <anoopk6(at)gmail(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: REINDEX deadlock - Postgresql -9.1 |
| Date: | 2013-02-11 06:25:33 |
| Message-ID: | CADK_1hJLF7oJEg89-1-NL1i2=nmGY5W1j-Ey=pgYg4A-MQmWMQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Yes, we do that.
On Mon, Feb 11, 2013 at 11:53 AM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> On 2/10/2013 9:55 PM, Anoop K wrote:
>
> We analyzed the application side. It doesn't seem to be create a
> transaction and keep it open. StackTraces indicate that it is BLOCKED in
> JDBC openConnection.
>
> Any JDBC driver issue or other scenarios which can result in <*idle in
> transaction*> ?
>
>
> JDBC has a wretched habit of autostarting transactions on any query if the
> connection is not in autocommit mode. if you don't want to use autocommit
> mode, then you need to issue Commit() calls after each batch of queries,
> even if the queries are read only, to release any implied locks.
>
>
>
>
> --
> john r pierce 37N 122W
> somewhere on the middle of the left coast
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2013-02-11 06:26:03 | Re: REINDEX deadlock - Postgresql -9.1 |
| Previous Message | John R Pierce | 2013-02-11 06:23:51 | Re: REINDEX deadlock - Postgresql -9.1 |