Content-Type: multipart/alternative;
 boundary="------------cZBvlydAR2aRbEqaDIQx4Cf8"
Message-ID: <2c2e0f5d-4fe2-472f-a213-5cf58ec993c5@yahoo.com>
Date: Tue, 28 Nov 2023 14:27:27 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: en-US
To: pgsql-jdbc@lists.postgresql.org
From: Martin Lichtin <lichtin@yahoo.com>
Subject: Driver hangs in
 connect->MakeSSL.convert->SSLSocketImpl.startHandshake
References: <2c2e0f5d-4fe2-472f-a213-5cf58ec993c5.ref@yahoo.com>
Content-Length: 5381
Archived-At: 
 <https://www.postgresql.org/message-id/2c2e0f5d-4fe2-472f-a213-5cf58ec993c5%40yahoo.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------cZBvlydAR2aRbEqaDIQx4Cf8
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Hi

I'm seeing this thread hanging in the "getConnection" method, with no 
timeout in sight.
However, the PGXADataSource is configured with a "connectTimeout" of 10 
seconds.

    java.lang.Thread.State: RUNNABLE
     at java.net.SocketInputStream.socketRead0(Native Method)
     at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
     at java.net.SocketInputStream.read(SocketInputStream.java:171)
     at java.net.SocketInputStream.read(SocketInputStream.java:141)
     at 
sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:464)
     at 
sun.security.ssl.SSLSocketInputRecord.decode(SSLSocketInputRecord.java:165)
     at sun.security.ssl.SSLTransport.decode(SSLTransport.java:109)
     at sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1392)
     at 
sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1300)
     at 
sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:435)
     at org.postgresql.ssl.MakeSSL.convert(MakeSSL.java:41)
     at 
org.postgresql.core.v3.ConnectionFactoryImpl.enableSSL(ConnectionFactoryImpl.java:571)
     at 
org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:168)
     at 
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:235)
     at 
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
     at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:223)
     at org.postgresql.Driver.makeConnection(Driver.java:402)
     at org.postgresql.Driver.connect(Driver.java:261)
     at java.sql.DriverManager.getConnection(DriverManager.java:664)
     at java.sql.DriverManager.getConnection(DriverManager.java:247)
     at 
org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:103)
     at 
org.postgresql.xa.PGXADataSource.getXAConnection(PGXADataSource.java:49)
     at 
org.postgresql.xa.PGXADataSource.getXAConnection(PGXADataSource.java:35)

Any reason this timeout is not being applied here?

The version in use here is 42.3.6

- Martin

--------------cZBvlydAR2aRbEqaDIQx4Cf8
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p><font face="Calibri">Hi</font></p>
    <p><font face="Calibri">I'm seeing this thread hanging in the
        "getConnection" method, with no timeout in sight.<br>
      </font><font face="Calibri">However, the </font><font
        face="Calibri">PGXADataSource </font><font face="Calibri">is
        configured with a</font> "connectTimeout" of 10 seconds. </p>
    <p><font face="Calibri">   java.lang.Thread.State: RUNNABLE<br>
            at java.net.SocketInputStream.socketRead0(Native Method)<br>
            at
        java.net.SocketInputStream.socketRead(SocketInputStream.java:116)<br>
            at
        java.net.SocketInputStream.read(SocketInputStream.java:171)<br>
            at
        java.net.SocketInputStream.read(SocketInputStream.java:141)<br>
            at
sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:464)<br>
            at
sun.security.ssl.SSLSocketInputRecord.decode(SSLSocketInputRecord.java:165)<br>
            at
        sun.security.ssl.SSLTransport.decode(SSLTransport.java:109)<br>
            at
        sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1392)<br>
            at
sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1300)<br>
            at
        sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:435)<br>
            at org.postgresql.ssl.MakeSSL.convert(MakeSSL.java:41)<br>
            at
org.postgresql.core.v3.ConnectionFactoryImpl.enableSSL(ConnectionFactoryImpl.java:571)<br>
            at
org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:168)<br>
            at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:235)<br>
            at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)<br>
            at
        org.postgresql.jdbc.PgConnection.&lt;init&gt;(PgConnection.java:223)<br>
            at org.postgresql.Driver.makeConnection(Driver.java:402)<br>
            at org.postgresql.Driver.connect(Driver.java:261)<br>
            at
        java.sql.DriverManager.getConnection(DriverManager.java:664)<br>
            at
        java.sql.DriverManager.getConnection(DriverManager.java:247)<br>
            at
org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:103)<br>
            at
        org.postgresql.xa.PGXADataSource.getXAConnection(PGXADataSource.java:49)<br>
            at
        org.postgresql.xa.PGXADataSource.getXAConnection(PGXADataSource.java:35)</font></p>
    <p>Any reason this timeout is not being applied here?</p>
    <p>The version in use here is 42.3.6<br>
    </p>
    <p>- Martin<br>
    </p>
  </body>
</html>

--------------cZBvlydAR2aRbEqaDIQx4Cf8--