Failed testcase in MSSQL testcontainer

[emeroad]

[INFO] Running com.pinpoint.test.plugin.spring.data.r2dbc.R2dbcMssqlTest
SLF4J: No SLF4J providers were found.
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See https://www.slf4j.org/codes.html#noProviders for further details.
Sep 20, 2024 2:03:10 AM com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin
WARNING: ConnectionID:1 ClientConnectionId: 7a60fdda-4561-4c02-819d-2c3af7c5e85d Prelogin error: host localhost port 32771 Error reading prelogin response: Connection reset ClientConnectionId:7a60fdda-4561-4c02-819d-2c3af7c5e85d
Sep 20, 2024 2:03:10 AM com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin
WARNING: ConnectionID:1 ClientConnectionId: 6be23d1b-54f4-463f-a121-d38c382ec918 Prelogin error: host localhost port 32771 Unexpected end of prelogin response after 0 bytes read
Sep 20, 2024 2:03:10 AM com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin
WARNING: ConnectionID:1 ClientConnectionId: 303606f0-9360-4635-9572-84854ddd4ce6 Prelogin error: host localhost port 32771 Unexpected end of prelogin response after 0 bytes read
Sep 20, 2024 2:03:11 AM com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin
WARNING: ConnectionID:1 ClientConnectionId: 489980cc-45be-4939-93e8-887fdea89a3d Prelogin error: host localhost port 32771 Unexpected end of prelogin response after 0 bytes read
Sep 20, 2024 2:03:12 AM com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin
WARNING: ConnectionID:1 ClientConnectionId: 9ee49486-2a85-49d0-82cc-b774408c63fd Prelogin error: host localhost port 32771 Unexpected end of prelogin response after 0 bytes read
Sep 20, 2024 2:03:13 AM com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin
WARNING: ConnectionID:1 ClientConnectionId: 3cc1357a-e91c-43d0-a141-f2f99b81bdb3 Prelogin error: host localhost port 32771 Unexpected end of prelogin response after 0 bytes read
Error:  Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 254.8 s <<< FAILURE! -- in com.pinpoint.test.plugin.spring.data.r2dbc.R2dbcMssqlTest
Error:  com.pinpoint.test.plugin.spring.data.r2dbc.R2dbcMssqlTest -- Time elapsed: 254.8 s <<< ERROR!
org.testcontainers.containers.ContainerLaunchException: Container startup failed for image mcr.microsoft.com/mssql/server:2017-CU12
	at org.testcontainers.containers.GenericContainer.doStart(GenericContainer.java:359)
	at org.testcontainers.containers.GenericContainer.start(GenericContainer.java:330)
	at com.pinpoint.test.plugin.spring.data.r2dbc.R2dbcMssqlTest.beforeClass(R2dbcMssqlTest.java:37)
	at java.base/java.lang.reflect.Method.invoke(Method.java:569)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)
Caused by: org.rnorth.ducttape.RetryCountExceededException: Retry limit hit with exception
	at org.rnorth.ducttape.unreliables.Unreliables.retryUntilSuccess(Unreliables.java:88)
	at org.testcontainers.containers.GenericContainer.doStart(GenericContainer.java:344)
	... 4 more
Caused by: org.testcontainers.containers.ContainerLaunchException: Could not create/start container
	at org.testcontainers.containers.GenericContainer.tryStart(GenericContainer.java:563)
	at org.testcontainers.containers.GenericContainer.lambda$doStart$0(GenericContainer.java:354)
	at org.rnorth.ducttape.unreliables.Unreliables.retryUntilSuccess(Unreliables.java:81)
	... 5 more
Caused by: java.lang.IllegalStateException: Wait strategy failed. Container exited with code 1
	at org.testcontainers.containers.GenericContainer.tryStart(GenericContainer.java:533)
	... 7 more
Caused by: java.lang.IllegalStateException: Container is started, but cannot be accessed by (JDBC URL: jdbc:sqlserver://localhost:32771;encrypt=false), please check container logs
	at org.testcontainers.containers.JdbcDatabaseContainer.waitUntilContainerStarted(JdbcDatabaseContainer.java:176)
	at org.testcontainers.containers.GenericContainer.tryStart(GenericContainer.java:500)
	... 7 more
Caused by: java.sql.SQLException: Could not create new connection
	at org.testcontainers.containers.JdbcDatabaseContainer.createConnection(JdbcDatabaseContainer.java:262)
	at org.testcontainers.containers.JdbcDatabaseContainer.createConnection(JdbcDatabaseContainer.java:218)
	at org.testcontainers.containers.JdbcDatabaseContainer.waitUntilContainerStarted(JdbcDatabaseContainer.java:158)
	... 8 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 32771 has failed. Error: "Connection refused. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:237)
	at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:288)
	at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2720)
	at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:761)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3180)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2833)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2671)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1640)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:936)
	at org.testcontainers.containers.JdbcDatabaseContainer.createConnection(JdbcDatabaseContainer.java:253)
	... 10 more

[INFO] Running com.pinpoint.test.plugin.spring.data.r2dbc.R2dbcMysqlTest

Related issues

• MSSQL containers crashing after recent update actions/runner-images#10649