Message-ID: <gh-pgjdbc-pgjdbc-194-c514940757@github.com>
From: "zistrong (@zistrong)" <noreply+zistrong@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Thu, 25 Jul 2019 08:00:27 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #194: PgJDBC can experience client/server deadlocks during batch execution
In-Reply-To: <gh-pgjdbc-pgjdbc-194@github.com>
References: <gh-pgjdbc-pgjdbc-194@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: zistrong
X-GitHub-Comment-Id: 514940757
X-GitHub-Comment-Type: issue_comment
X-GitHub-Edited-At: 2019-07-25T08:20:07Z
X-GitHub-Issue: 194
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/194#issuecomment-514940757
Content-Type: text/plain; charset=utf-8

`"__ejb-thread-pool13" daemon prio=10 tid=0x00007f9f135d0000 nid=0x413e runnable [0x00007f9f0be35000]
   java.lang.Thread.State: RUNNABLE
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.read(SocketInputStream.java:152)
        at java.net.SocketInputStream.read(SocketInputStream.java:122)
        at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:140)
        at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:109)
        at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:67)
        at org.postgresql.core.PGStream.receiveChar(PGStream.java:293)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1952)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
        - locked <0x00000005b56f9d80> (a org.postgresql.core.v3.QueryExecutorImpl)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:150)
        at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:127)
        at sun.reflect.GeneratedMethodAccessor374.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
"http-thread-pool-8080(13)" daemon prio=10 tid=0x00007f9f58028800 nid=0x41ff waiting for monitor entry [0x00007f9f0b7db000]
   java.lang.Thread.State: BLOCKED (on object monitor)
        at org.postgresql.core.QueryExecutorBase.getStandardConformingStrings(QueryExecutorBase.java:247)
        - waiting to lock <0x00000005b56f9d80> (a org.postgresql.core.v3.QueryExecutorImpl)
        at org.postgresql.core.CachedQueryCreateAction.create(CachedQueryCreateAction.java:40)
        at org.postgresql.core.CachedQueryCreateAction.create(CachedQueryCreateAction.java:17)
        at org.postgresql.util.LruCache.borrow(LruCache.java:115)
        - locked <0x00000005c5de8cd8> (a org.postgresql.util.LruCache)
        at org.postgresql.core.QueryExecutorBase.borrowQuery(QueryExecutorBase.java:271)
        at org.postgresql.jdbc.PgConnection.borrowQuery(PgConnection.java:146)
        at org.postgresql.jdbc.PgPreparedStatement.<init>(PgPreparedStatement.java:85)
        at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:1223)
        at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:1681)
`

is it a same issue? the driver version is 42.2.4;