wait until container started - doesn't end and in the meantime creates multiple containers (MySQLContainer)

[ori-n]

I tried this simple code:
try (MySQLContainer mySQLContainer = new MySQLContainer()) { mySQLContainer.start(); mySQLContainer.stop(); }
In the log I get:
[INFO] 2017-12-05 16:50:48,709 [main] 🐳 [mysql:latest] waitUntilContainerStarted - Waiting for database connection to become available at jdbc:mysql://localhost:32770/test using query 'SELECT 1'

And in the meantime containers are created every 2 min:
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS
7504e73de3d5 mysql:latest "docker-entrypoint..." 11 minutes ago Up 11 minutes 0.0.0.0:32770->3306/tcp
1ae62c3a699c mysql:latest "docker-entrypoint..." 13 minutes ago Up 13 minutes 0.0.0.0:32769->3306/tcp

Am I doing something wrong. Tries both on docker on windows and docker on ubuntu and got the same results

[kiview]

Hi @ori-n, can you please share a more complete example of your code?
Are you using testcontainers in a JUnit context or somewhere else?

[ori-n]

Below is the complete function - I'm using junit

    @Test
    public void runMySql() throws Exception {
        try (MySQLContainer mySQLContainer = new MySQLContainer()) {
            mySQLContainer.start();
            // connect to the db here
            mySQLContainer.stop();
        }
    }

[kiview]

Can't reproduce this behavior on Docker for Windows. Are both containers removed once the tests have finished?

[ori-n]

I tried both win and linux. It simply gets stuck. Did you try the exact code? Maybe i can try to change the code. The mysql I use is base on alpine Thanks, Ori

…

________________________________ From: Kevin Wittek <[email protected]> Sent: Friday, December 8, 2017 1:07:30 AM To: testcontainers/testcontainers-java Cc: ori-n; Mention Subject: Re: [testcontainers/testcontainers-java] wait until container started - doesn't end and in the meantime creates multiple containers (#511) Can't reproduce this behavior on Docker for Windows. Are both containers removed once the tests have finished? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#511 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AfvrAAi37cZRNg7JVwykhhVY5GIh9S6Eks5s-G-ygaJpZM4Q2brs>.

[kiview]

I tried your exakt code on the current master branch of testcontainers and it works as expected.

How is it possible for your MySQLContainer to be alpine based? If you don't specify any constructor paramters, the container will use mysql:latest, which is Debian based (see https://hub.docker.com/_/mysql/).

Did you override your local mysql:latest manually on your system?

[ori-n]

Sorry. Alpine before was a mistake. I did not override Thanks, Ori

…

________________________________ From: Kevin Wittek <[email protected]> Sent: Friday, December 8, 2017 10:55:39 AM To: testcontainers/testcontainers-java Cc: ori-n; Mention Subject: Re: [testcontainers/testcontainers-java] wait until container started - doesn't end and in the meantime creates multiple containers (#511) I tried your exakt code on the current master branch of testcontainers and it works as expected. How is it possible for your MySQLContainer to be alpine based? If you don't specify any constructor paramters, the container will use mysql:latest, which is Debian based (see https://hub.docker.com/_/mysql/). Did you override your local mysql:latest manually on your system? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#511 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AfvrADSq_Yzk3U7soyaLXUwIzJoWTkeoks5s-PmLgaJpZM4Q2brs>.

[kiview]

Can you maybe upload a complete example project on Github?
Also, what's your Docker version?

[tv-plot]

@kiview
Please take a look at https://github.com/pol12va/testcontainers-demo. I'm having exactly the same issue with MySQL container. Tried with different mysql docker images and different testcontainers versions.
Docker version: Version 17.12.0-ce-mac55 (23011)

[kiview]

@pol12va
Thanks for your example, I can reproduce the described behavior. I will look into this.

[jvujcic]

@kiview
Is there any progress on this. I'm also stuck at
Waiting for database connection to become available at jdbc:mysql://localhost:32770/test using query 'SELECT 1'

[johnedmonds]

I fixed this by adding the mysql connector dependency to my test.

[EvgeniGordeev]

Adding mysql connector made it work for mysql:5.7.24, but not for mysql:8.0.13.

[guss77]

The problem with MySQL 8 could be because of the different authentication scheme introduced in MySQL 8. This is likely the same problem as issue #736.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. If you believe this is a mistake, please reply to this comment to keep it open. If there isn't one already, a PR to fix or at least reproduce the problem in a test case will always help us get back on track to tackle this.

[rnorth]

The spawning of multiple containers may be fixed by #1433

[rui-ferreira]

If you manually connect to the container's DB, while it's "waiting for database connection to become available", the loop resumes. This is just a hint on what may be wrong, not a workaround.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. If you believe this is a mistake, please reply to this comment to keep it open. If there isn't one already, a PR to fix or at least reproduce the problem in a test case will always help us get back on track to tackle this.

[rnorth]

I’m going to close. As mentioned previously #1433 should have resolved this. If the issue still occurs then of course please reopen.

_{Sent with GitHawk}