testcontainers / testcontainers/testcontainers-java
[Bug]: PostgreSQLContainer skips the JDBC readiness gate, leaving host-side port reachability unverified
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 8.7k
- Forks
- 1.9k
- Avg merge
- 2d 17h
- Merged PRs (30d)
- 9
Description
Module
PostgreSQL
Problem
PostgreSQLContainer — both the deprecated org.testcontainers.containers.PostgreSQLContainer and the new org.testcontainers.postgresql.PostgreSQLContainer — overrides waitUntilContainerStarted() to call only the wait strategy:
@Override
protected void waitUntilContainerStarted() {
getWaitStrategy().waitUntilReady(this);
}
This deliberately skips JdbcDatabaseContainer#waitUntilContainerStarted(), which repeatedly opens a JDBC connection from the host and runs the test query until it succeeds.
The consequence is that Postgres readiness is gated purely on container-side log output. Nothing verifies that the mapped port is routable from the calling JVM, or that a connection can actually be established. Every other JDBC container gets that host-side gate; Postgres is the exception.
On Docker environments that publish ports through a VM (Colima, Docker Desktop), the mapped host port can become routable slightly after database system is ready to accept connections appears in the log, so the first connection after start() returns Connection refused.
Why the override may no longer be needed
git log -L traces the override to #327, which fixed #317. The motive there was noise, not correctness: the Postgres JDBC driver had just moved to java.util.logging and was printing a stack trace for every failed attempt of the connect-retry loop. The PR description even says:
I've changed the
PostgreSQLContainerto use theWaitingConsumerfor waiting for Log output, instead of performing SQL queries. It's basically the same code as inLogWaitStrategy, but I've figured we'll refactor theJdbcDatabaseContainersat a later stage, to make use of aWaitStrategy?
That concern is handled independently today. PostgreSQLContainer#configure() sets:
// Disable Postgres driver use of java.util.logging to reduce noise at startup time
withUrlParam("loggerLevel", "OFF");
So the retry loop no longer produces the log spam the override was introduced to avoid.
Proposal
Have the override run the wait strategy and then delegate:
@Override
protected void waitUntilContainerStarted() {
getWaitStrategy().waitUntilReady(this);
super.waitUntilContainerStarted();
}
This keeps the property the override was preserving — a user-supplied waitingFor(...) is actually honored, which JdbcDatabaseContainer otherwise ignores entirely — while restoring the JDBC readiness gate that every other JDBC container already has.
Downstream context
Surfaced from testcontainers-jooq-codegen-maven-plugin#59. That plugin worked around the missing host-side gate by replacing the container's wait strategy with HostPortWaitStrategy, which then removed the log gate and let code generation run against a database still reporting FATAL: the database system is starting up. Neither gate alone is sufficient, and a downstream caller cannot compose them: GenericContainer#getWaitStrategy is protected, so external code cannot read a container's default in order to wrap it in a WaitAllStrategy.
Happy to open a PR if this direction looks right.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the deprecated and new PostgreSQLContainer implementations and compare their waitUntilContainerStarted() methods with JdbcDatabaseContainer#waitUntilContainerStarted(). Verify that the wait strategy remains honored before the JDBC readiness check, then add or update tests for host-side connection readiness and custom waiting behavior. Done means PostgreSQLContainer covers both gates without regressing user-supplied wait strategies.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- docker, java, postgresql
- Domain
- databases, testing-qa
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Active
- Clarity
- Clearly specified
- Newbie friendliness
- 75/100