JDBC error: Unexpected packet type: 25 - Mailing list pgsql-general

From Ignacio Rey
Subject JDBC error: Unexpected packet type: 25
Date
Msg-id 039e6f11-d5f6-e218-19be-b517b824ae7d@virgilio.it
Whole thread Raw
Responses Re: JDBC error: Unexpected packet type: 25
List pgsql-general
Hello,

I'm sometimes getting this error from the PostgreSQL JDBC driver 
(version 42.2.10):

    java.io.IOException: Unexpected packet type: 25

(Full stack trace at the end of this message).

Looks a lot like a bug or a version mismatch. The latter is unlikely 
since the driver is relatively new but the server is a bit older (11.4). 
If it were a bug I would expect more people to reproduce it, but I 
haven't found anything on google (the only result is not even about 
PostgreSQL).

For the moment I have no idea how to reproduce this error. It appears to 
happen just randomly.

I'd like to know if someone can suggest a way to gather more information 
so I can eventually turn it into reproducible steps and fill a bug report.

Also, can pg_bouncer be related?

Thanks.
Ignacio


Stack trace:

org.hibernate.TransactionException: commit failed
     at 
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:185) 
~[hibernate-core-4.1.4.Final.jar:4.1.4.Final]

     (8 stack frames of custom application software omitted)

     at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) 
[?:1.8.0_191]
     at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
[?:1.8.0_191]
     at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
[?:1.8.0_191]
     at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
[?:1.8.0_191]
     at java.lang.Thread.run(Thread.java:748) [?:1.8.0_191]
Caused by: org.hibernate.TransactionException: unable to commit against 
JDBC connection
     at 
org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doCommit(JdbcTransaction.java:116) 
~[hibernate-core-4.1.4.Final.jar:4.1.4.Final]
     at 
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:178) 
~[hibernate-core-4.1.4.Final.jar:4.1.4.Final]
     ... 13 more
Caused by: org.postgresql.util.PSQLException: An I/O error occurred 
while sending to the backend.
     at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338) 
~[postgresql-42.2.10.jar:42.2.10]
     at 
org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:829) 
~[postgresql-42.2.10.jar:42.2.10]
     at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:851) 
~[postgresql-42.2.10.jar:42.2.10]
     at 
org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doCommit(JdbcTransaction.java:112) 
~[hibernate-core-4.1.4.Final.jar:4.1.4.Final]
     at 
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:178) 
~[hibernate-core-4.1.4.Final.jar:4.1.4.Final]
     ... 13 more
Caused by: java.io.IOException: Unexpected packet type: 25
     at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2395) 
~[postgresql-42.2.10.jar:42.2.10]
     at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:311) 
~[postgresql-42.2.10.jar:42.2.10]
     at 
org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:829) 
~[postgresql-42.2.10.jar:42.2.10]
     at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:851) 
~[postgresql-42.2.10.jar:42.2.10]
     at 
org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doCommit(JdbcTransaction.java:112) 
~[hibernate-core-4.1.4.Final.jar:4.1.4.Final]
     at 
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:178) 
~[hibernate-core-4.1.4.Final.jar:4.1.4.Final]
     ... 13 more


=> select version();
                                                  version 

---------------------------------------------------------------------------------------------------------
  PostgreSQL 11.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 
20150623 (Red Hat 4.8.5-36), 64-bit
(1 row)



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: bottom / top posting
Next
From: Vijaykumar Jain
Date:
Subject: Re: JDBC error: Unexpected packet type: 25