PostgreSQL DB connections not being released with 42.7.5 JDBC driver

[Zackster]

Does the problem still occur with the older 42.7.3 JDBC driver?

There really aren’t that many changes to 5.4 between those two LTS releases

Comparing 5.4.5.23...5.4.7.3 · lucee/Lucee

I just published the latest 42.7.7 postgres driver (it’s a minor CVE update, the 42.7.6 release had a lot of fixes)

https://luceeserver.atlassian.net/browse/LDEV-5661

Another user had also reported problems with the 42.7.5 driver

PostgreSQL queries are getting stuck on ClientRead

Hello all, I am using Lucee 5.4.7.3 with PostgreSQL Extension 42.7.5. Our Postgres database is on version 17.5. We’ve recently started having issues with UPDATE statements (and sometimes INSERT statements) getting stuck in the database with a “ClientRead” wait event (“Waiting to read data from the client”). This usually indicates that it’s waiting on the client to send more data to complete the query. [image] These queries have been in use and unchanged in my application for years, and the…