From: | Debraj Manna <subharaj(dot)manna(at)gmail(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Timeouts in Postgresql JDBC Driver |
Date: | 2024-06-01 09:40:35 |
Message-ID: | CAF6DVKPF_+mkZ7NSEXOmU4K+F4fd0skEjrWTLxL7_Ep488Yt4g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi
I am using Postgresql JDBC Driver 42.7.3 with Postgres 14.9 with
default settings.
I am observing sometimes my Postgres Client thread getting stuck like
below. I have observed it for about ~12 hours and the thread was stuck like
below. Can someone let me know if there are some known issues with the JDBC
Driver that I am using or are there any timeout settings that I can set in
either the Postgres server or JDBC client level that will allow me to not
land in this situation
pool-9-thread-1" #352 prio=5 os_prio=0 cpu=28470.75ms elapsed=175425.73s
tid=0x00007fd1a0053e50 nid=0x1cb runnable [0x00007fd17ecfd000]
java.lang.Thread.State: RUNNABLE
at sun.nio.ch.Net.poll(java(dot)base(at)17(dot)0(dot)10/Native Method)
at sun.nio.ch.NioSocketImpl.park(java(dot)base(at)17(dot)0(dot)10/NioSocketImpl.java:186)
at sun.nio.ch.NioSocketImpl.park(java(dot)base(at)17(dot)0(dot)10/NioSocketImpl.java:195)
at sun.nio.ch.NioSocketImpl.implRead(java(dot)base(at)17(dot)0(dot)10
/NioSocketImpl.java:319)
at sun.nio.ch.NioSocketImpl.read(java(dot)base(at)17(dot)0(dot)10/NioSocketImpl.java:355)
at sun.nio.ch.NioSocketImpl$1.read(java(dot)base(at)17(dot)0(dot)10/NioSocketImpl.java:808)
at java.net.Socket$SocketInputStream.read(java(dot)base(at)17(dot)0(dot)10/Socket.java:966)
at sun.security.ssl.SSLSocketInputRecord.read(java(dot)base(at)17(dot)0(dot)10
/SSLSocketInputRecord.java:484)
at sun.security.ssl.SSLSocketInputRecord.readHeader(java(dot)base(at)17(dot)0(dot)10
/SSLSocketInputRecord.java:478)
at
sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(java(dot)base(at)17(dot)0(dot)10
/SSLSocketInputRecord.java:70)
at sun.security.ssl.SSLSocketImpl.readApplicationRecord(java(dot)base(at)17(dot)0(dot)10
/SSLSocketImpl.java:1465)
at sun.security.ssl.SSLSocketImpl$AppInputStream.read(java(dot)base(at)17(dot)0(dot)10
/SSLSocketImpl.java:1069)
at
org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:162)
at
org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:129)
at
org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:114)
at
org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:74)
at org.postgresql.core.PGStream.receiveChar(PGStream.java:467)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2166)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)
at
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
at
org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:180)
at
com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at
com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
...
at
com.sp.gossiper.producers.GossiperProducerScheduler.readCheckpoint(GossiperProducerScheduler.java:369)
From | Date | Subject | |
---|---|---|---|
Next Message | Muhammad Ikram | 2024-06-01 10:53:11 | Re: Timeouts in Postgresql JDBC Driver |
Previous Message | Muhammad Imtiaz | 2024-06-01 03:58:03 | Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` |