Message-ID: <gh-pgjdbc-pgjdbc-194-c561463897@github.com>
From: "oobles (@oobles)" <noreply+oobles@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Wed, 04 Dec 2019 03:46:11 +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: oobles
X-GitHub-Comment-Id: 561463897
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 194
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/194#issuecomment-561463897
Content-Type: text/plain; charset=utf-8

We've observed this using 42.2.8. Is there a way to code around this issue?  Will setting a timeout work?

`	at java.net.SocketOutputStream.socketWrite0(java.base@11.0.5/Native Method)
	at java.net.SocketOutputStream.socketWrite(java.base@11.0.5/Unknown Source)
	at java.net.SocketOutputStream.write(java.base@11.0.5/Unknown Source)
	at sun.security.ssl.SSLSocketOutputRecord.deliver(java.base@11.0.5/SSLSocketOutputRecord.java:319)
	at sun.security.ssl.SSLSocketImpl$AppOutputStream.write(java.base@11.0.5/SSLSocketImpl.java:983)
	at java.io.BufferedOutputStream.flushBuffer(java.base@11.0.5/BufferedOutputStream.java:81)
	at java.io.BufferedOutputStream.write(java.base@11.0.5/BufferedOutputStream.java:127)
	at java.io.FilterOutputStream.write(java.base@11.0.5/FilterOutputStream.java:108)
	at org.postgresql.core.PGStream.sendInteger4(org.postgresql.jdbc@42.2.8/PGStream.java:255)
	at org.postgresql.core.v3.QueryExecutorImpl.sendBind(org.postgresql.jdbc@42.2.8/QueryExecutorImpl.java:1611)
	at org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(org.postgresql.jdbc@42.2.8/QueryExecutorImpl.java:1853)
	at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(org.postgresql.jdbc@42.2.8/QueryExecutorImpl.java:1378)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(org.postgresql.jdbc@42.2.8/QueryExecutorImpl.java:496)
	at org.postgresql.jdbc.PgStatement.executeBatch(org.postgresql.jdbc@42.2.8/PgStatement.java:853)
	at org.postgresql.jdbc.PgPreparedStatement.executeBatch(org.postgresql.jdbc@42.2.8/PgPreparedStatement.java:1546)
	at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(com.zaxxer.hikari@3.3.1/ProxyStatement.java:128)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(com.zaxxer.hikari@3.3.1/HikariProxyPreparedStatement.java)`