Connection timeouts since version 2.6.7 or 2.6.6

[michaelmejaeger]

Describe the bug

We upgraded the aws-advanced-jdbc-wrapper from version 2.6.5 to 2.6.7. Since then, we have the problem that a connection times out when the Aurora Serverless database we are using, is not up. This was not a problem before. We are using the following parameters for connections:

• wrapperPlugins=initialConnection
• openConnectionRetryTimeoutMs=180000
• loginTimeout=40000
• connectTimeout=40000

Before, we had lower values for the timeouts but increased them, because we assumed that this would fix the problem.

Expected Behavior

If the Aurora Serverless database is not up, we expect that the connection attempt is not immediately aborted but a retry happens for the timeout specified.

What plugins are used? What other connection properties were set?

wrapperPlugins=initialConnection&openConnectionRetryTimeoutMs=180000&loginTimeout=40000&connectTimeout=40000

Current Behavior

It seems like that the connection runs quickly into a timeout.

Reproduction Steps

We are using that in the Maven DependencyCheck plugin.

Possible Solution

No response

Additional Information/Context

No response

The AWS Advanced JDBC Wrapper version used

2.6.7

JDK version used

OpenJDK 64-Bit Server VM Temurin-17.0.17+10 (build 17.0.17+10, mixed mode, sharing)

Operating System and version

Ubuntu 24.04.3 LTS

[michaelmejaeger]

I tried to reproduce the problem using JBang and Testcontainers, but this does not work with plain PostgreSQL:

// filepath: Test.java
//DEPS org.testcontainers:testcontainers:1.19.7
//DEPS org.testcontainers:postgresql:1.19.7
//DEPS org.postgresql:postgresql:42.7.3
//DEPS org.slf4j:slf4j-simple:2.0.13
//DEPS software.amazon.jdbc:aws-advanced-jdbc-wrapper:2.6.5

import org.testcontainers.containers.PostgreSQLContainer;
import java.sql.Connection;
import java.sql.DriverManager;
import com.github.dockerjava.api.model.ExposedPort;
import com.github.dockerjava.api.model.HostConfig;
import com.github.dockerjava.api.model.PortBinding;
import com.github.dockerjava.api.model.Ports;

public class Test {
  public static void main(String[] args) throws Exception {
    var PORT = 5432;
    try (PostgreSQLContainer<?> postgres = new PostgreSQLContainer<>("postgres:16.2").withExposedPorts(PORT)
        .withCreateContainerCmdModifier(
            cmd -> cmd.withHostConfig(
                new HostConfig()
                    .withPortBindings(
                        new PortBinding(
                            Ports.Binding.bindPort(PORT), new ExposedPort(PORT)))))) {
      postgres.start();

      String jdbcUrl = postgres.getJdbcUrl();
      String username = postgres.getUsername();
      String password = postgres.getPassword();

      jdbcUrl = jdbcUrl.replaceAll(":postgresql:", ":aws-wrapper:postgresql:");
      jdbcUrl = jdbcUrl
          + "&wrapperPlugins=initialConnection&openConnectionRetryTimeoutMs=180000&loginTimeout=40000&connectTimeout=40000";

      System.out.println("Got JDBC-URL: " + jdbcUrl);

      try (Connection conn = DriverManager.getConnection(jdbcUrl, username, password)) {
        if (conn.isValid(2)) {
          System.out.println("Connected to PostgreSQL testcontainer!");
        } else {
          System.out.println("Failed to validate connection.");
        }
      }

      postgres.stop();
    }
  }
}

[karenc-bq]

Hi @michaelmejaeger, thank you for raising this issue.
What kind of endpoints are you using? e.g. are you using a writer cluster endpoint, a custom endpoint or something else?

[michaelmejaeger]

Yes, sorry, we are using a writer cluster endpoint. Do you need more configuration details?

[michaelmejaeger]

BTW, I was now able to reproduce the Problem only with version 2.6.7. With version 2.6.6 it still worked as expected.

I used the following JBang script:

// filepath: Test.java
//DEPS org.postgresql:postgresql:42.7.3
//DEPS org.slf4j:slf4j-simple:2.0.13
//DEPS software.amazon.jdbc:aws-advanced-jdbc-wrapper:2.6.6

import java.sql.Connection;
import java.sql.DriverManager;

public class Test {
  public static void main(String[] args) throws Exception {
    String jdbcUrl = "url";
    String username = "name";
    String password = "password;

    System.out.println("Connecting to: " + jdbcUrl);

    try (Connection conn = DriverManager.getConnection(jdbcUrl, username, password)) {
      if (conn.isValid(2)) {
        System.out.println("Connected to PostgreSQL testcontainer!");
      } else {
        System.out.println("Failed to validate connection.");
      }
    }
  }
}