MariaDB 연결이 임의로 실패하지만 계속 유지됨

MariaDB 연결이 임의로 실패하지만 계속 유지됨

저는 이클립스의 Ubuntu 20 TLS에서 제 주니어 테스트를 실행하고 있습니다.

설정:

• testcontainers.org 과 함께 도커 컨테이너에 있는 mariadb.
• 스프링 5 매립형 제트기에 적용(준유닛 테스트 전용)

내장된 제트티가 데이터베이스 연결에 실패하는 이유가 궁금합니다.

Caused by: java.net.SocketTimeoutException: Read timed out

저는 이것을 며칠 동안 (그리고 밤 동안) 분석했습니다 :( ) ...아무것도 발견되지 않았습니다.

그래서 테스트 용기 설정에 문제가 있는지 알아보기 위해 테스트 하네스를 작성했는데, 안타깝게도 다음과 같습니다.

연결하려고 하고, 문을 호출하고, 연결을 끊고, 이를 반복하려고 하면 mariadbin 컨테이너가 잠시 후 연결을 거부하는 것 같습니다.

package de.enno.testcontainers_mariadb;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

import org.junit.Rule;
import org.junit.Test;
import org.testcontainers.containers.MariaDBContainer;

public class MariaDBTest {

    @Rule
    public MariaDBContainer mariaDB = new MariaDBContainer("mariadb:10.3.6").withUsername("test").withPassword("test");

    @Test
    public void test() throws SQLException {

        Connection connection = DriverManager.getConnection(mariaDB.getJdbcUrl(), "test", "test");
        Statement stmt = connection.createStatement();
        stmt.executeUpdate("CREATE TABLE a (id int not null primary key, value varchar(20))");
        stmt.close();
        connection.close();

        for (int i = 0; i < 10000000; i++) {
            if (i % 1000 == 0) {
                System.err.println("Connect " + i + "...");
            }
            connection = DriverManager.getConnection(mariaDB.getJdbcUrl(), "test", "test");
            stmt = connection.createStatement();
            stmt.execute("SELECT * FROM a");
            stmt.close();
            connection.close();
        }
    }

}

<?xml version="1.0"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

    <groupId>de.enno</groupId>
    <artifactId>testcontainers-mariadb</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <modelVersion>4.0.0</modelVersion>
    <name>testcontainers-mariadb app</name>

    <build>
        <plugins>
            <plugin>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>2.0.2</version>
                <configuration>
                    <source>1.11</source>
                    <target>1.11</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
        </plugins>
    </build>

    <dependencies>
        <dependency>
            <groupId>org.mariadb.jdbc</groupId>
            <artifactId>mariadb-java-client</artifactId>
            <version>2.7.1</version>
        </dependency>

        <dependency>
            <groupId>org.testcontainers</groupId>
            <artifactId>mariadb</artifactId>
            <version>1.15.0</version>
            <scope>test</scope>
        </dependency>

    </dependencies>
</project> 

...
Connect 0...
Connect 1000...
Connect 2000...
Connect 3000...
Connect 4000...
Connect 5000...
java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=localhost)(port=33135)(type=master) : Read timed out
    at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
    at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192)
    at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1392)
    at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635)
    at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150)
    at org.mariadb.jdbc.Driver.connect(Driver.java:89)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
    at de.enno.testcontainers_mariadb.MariaDBTest.test(MariaDBTest.java:30)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    at org.testcontainers.containers.FailureDetectingExternalResource$1.evaluate(FailureDetectingExternalResource.java:30)
    at org.junit.rules.RunRules.evaluate(RunRules.java:20)
    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89)
    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:542)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:770)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:464)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:210)
Caused by: java.sql.SQLNonTransientConnectionException: Read timed out
    at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2075)
    at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1529)
    at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1508)
    at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.readPipelineAdditionalData(AbstractConnectProtocol.java:1031)
    at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.postConnectionQueries(AbstractConnectProtocol.java:880)
    at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:595)
    at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1387)
    ... 31 more
Caused by: java.net.SocketTimeoutException: Read timed out
    at java.base/java.net.SocketInputStream.socketRead0(Native Method)
    at java.base/java.net.SocketInputStream.socketRead(SocketInputStream.java:115)
    at java.base/java.net.SocketInputStream.read(SocketInputStream.java:168)
    at java.base/java.net.SocketInputStream.read(SocketInputStream.java:140)
    at java.base/java.io.FilterInputStream.read(FilterInputStream.java:133)
    at org.mariadb.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:131)
    at org.mariadb.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:104)
    at org.mariadb.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:247)
    at org.mariadb.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:218)
    at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1527)
    ... 36 more

시간 초과 문제는 아닌 것 같습니다. 어떤 경우에는 테스트가 몇 초 동안 실행되고, 어떤 경우에는 몇 시간 동안 실행되지만, 그러나 항상 발생합니다.

어떻게 해결할 것인지에 대한 아이디어가 있나요?

충고에 감사드립니다!

[update]: 오류가 발생한 후 mariadb에 연결하려고 하면 연결이 다시 설정됩니다.

언급URL : https://stackoverflow.com/questions/65163268/mariadb-connection-fails-randomly-but-stady