https://linen.dev logo
c

Chris (deprecated profile)

03/19/2021, 2:57 PM
We’ve got another weird case of failures happening in the CI on github for MySQL source connector, but it’s working perfectly fine when ran locally.. https://status-api.airbyte.io/tests/summary/source-mysql/ for example: https://github.com/airbytehq/airbyte/runs/2142398916?check_suite_focus=true
u

user

03/19/2021, 2:57 PM
The logs shows:
Copy code
MySqlJdbcStandardTest > initializationError FAILED
    org.testcontainers.containers.ContainerLaunchException: Container startup failed
        at org.testcontainers.containers.GenericContainer.doStart(GenericContainer.java:330)
        at org.testcontainers.containers.GenericContainer.start(GenericContainer.java:311)
        at io.airbyte.integrations.source.mysql.MySqlJdbcStandardTest.init(MySqlJdbcStandardTest.java:59)

        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:323)
            ... 2 more

            Caused by:
            org.testcontainers.containers.ContainerLaunchException: Could not create/start container
                at org.testcontainers.containers.GenericContainer.tryStart(GenericContainer.java:497)
                at org.testcontainers.containers.GenericContainer.lambda$doStart$0(GenericContainer.java:325)
                at org.rnorth.ducttape.unreliables.Unreliables.retryUntilSuccess(Unreliables.java:81)
                ... 3 more

                Caused by:
                org.testcontainers.ext.ScriptUtils$UncategorizedScriptException: Failed to execute database script from resource [CREATE USER 'test'@'%' IDENTIFIED BY 'test';
                GRANT ALL PRIVILEGES ON *.* TO 'test'@'%';
                ]
                    at org.testcontainers.ext.ScriptUtils.executeDatabaseScript(ScriptUtils.java:375)
                    at org.testcontainers.ext.ScriptUtils.executeDatabaseScript(ScriptUtils.java:313)
                    at org.testcontainers.ext.ScriptUtils.runInitScript(ScriptUtils.java:302)
                    at org.testcontainers.containers.JdbcDatabaseContainer.runInitScriptIfRequired(JdbcDatabaseContainer.java:285)
                    at org.testcontainers.containers.JdbcDatabaseContainer.containerIsStarted(JdbcDatabaseContainer.java:172)
                    at org.testcontainers.containers.GenericContainer.containerIsStarted(GenericContainer.java:659)
                    at org.testcontainers.containers.GenericContainer.tryStart(GenericContainer.java:476)
                    ... 5 more

                    Caused by:
                    org.testcontainers.exception.ConnectionCreationException: Could not obtain JDBC connection
                        at org.testcontainers.jdbc.JdbcDatabaseDelegate.createNewConnection(JdbcDatabaseDelegate.java:34)
                        at org.testcontainers.jdbc.JdbcDatabaseDelegate.createNewConnection(JdbcDatabaseDelegate.java:17)
                        at org.testcontainers.delegate.AbstractDatabaseDelegate.getConnection(AbstractDatabaseDelegate.java:23)
                        at org.testcontainers.jdbc.JdbcDatabaseDelegate.execute(JdbcDatabaseDelegate.java:42)
                        at org.testcontainers.delegate.AbstractDatabaseDelegate.execute(AbstractDatabaseDelegate.java:34)
                        at org.testcontainers.ext.ScriptUtils.executeDatabaseScript(ScriptUtils.java:362)
                        ... 11 more

                        Caused by:
                        java.sql.SQLException: Could not create new connection
                            at org.testcontainers.containers.JdbcDatabaseContainer.createConnection(JdbcDatabaseContainer.java:228)
                            at org.testcontainers.jdbc.JdbcDatabaseDelegate.createNewConnection(JdbcDatabaseDelegate.java:31)
                            ... 16 more
u

user

03/19/2021, 3:48 PM
Might need to run the integration test on the github runner with
--debug
to get more information. Maybe there’s some error or warning that shows why it’s unable to start the image in the first place?
u

user

03/19/2021, 6:30 PM
I ran gradlew on github with
--debug
here: https://github.com/airbytehq/airbyte/runs/2150997365?check_suite_focus=true Logs are huge… still going through the logs…
u

user

03/19/2021, 7:07 PM
Around line 108671:
Copy code
2021-03-19T18:21:26.7353542Z 2021-03-19T18:21:26.639+0000 [DEBUG] [TestEventLogger]     2021-03-19 18:21:26 [36mDEBUG[m o.t.s.c.g.d.c.e.InspectContainerCmdExec(execute):29 - *** - GET: DefaultWebTarget***path=[/containers/14952e594f298cae40956fa51573edff6d771f0c70377e2b1e53676942a92dbd/json], queryParams=***
2021-03-19T18:21:26.8064667Z 2021-03-19T18:21:26.741+0000 [DEBUG] [TestEventLogger]     2021-03-19 18:21:26 [32mINFO[m o.t.c.JdbcDatabaseContainer(waitUntilContainerStarted):167 - *** - Container is started (JDBC URL: jdbc:<mysql://localhost:49159/test>)
2021-03-19T18:21:26.8079293Z 2021-03-19T18:21:26.741+0000 [DEBUG] [TestEventLogger]     2021-03-19 18:21:26 [32mINFO[m o.t.c.GenericContainer(tryStart):475 - *** - Container mysql:8.0 started in PT6M17.305853S
2021-03-19T18:21:26.8086211Z 2021-03-19T18:21:26.741+0000 [DEBUG] [TestEventLogger]     2021-03-19 18:21:26 [32mINFO[m o.t.e.ScriptUtils(executeDatabaseScript):345 - *** - Executing database script from init.sql
2021-03-19T18:21:26.8094525Z 2021-03-19T18:21:26.741+0000 [DEBUG] [TestEventLogger]     2021-03-19 18:21:26 [36mDEBUG[m o.t.s.c.g.d.c.c.AbstrDockerCmd(exec):34 - *** - Cmd: 14952e594f298cae40956fa51573edff6d771f0c70377e2b1e53676942a92dbd,false
2021-03-19T18:21:26.8107022Z 2021-03-19T18:21:26.742+0000 [DEBUG] [TestEventLogger]     2021-03-19 18:21:26 [36mDEBUG[m o.t.s.c.g.d.c.e.InspectContainerCmdExec(execute):29 - *** - GET: DefaultWebTarget***path=[/containers/14952e594f298cae40956fa51573edff6d771f0c70377e2b1e53676942a92dbd/json], queryParams=***
2021-03-19T18:21:26.8113449Z 2021-03-19T18:21:26.743+0000 [DEBUG] [TestEventLogger]     2021-03-19 18:21:26 [1;31mERROR[m o.t.j.JdbcDatabaseDelegate(createNewConnection):33 - *** - Could not obtain JDBC connection
2021-03-19T18:21:26.8118484Z 2021-03-19T18:21:26.745+0000 [DEBUG] [TestEventLogger]     2021-03-19 18:21:26 [1;31mERROR[m o.t.c.GenericContainer(tryStart):484 - *** - Could not start container
2021-03-19T18:21:26.8124535Z 2021-03-19T18:21:26.745+0000 [DEBUG] [TestEventLogger]     org.testcontainers.ext.ScriptUtils$UncategorizedScriptException: Failed to execute database script from resource [CREATE USER 'test'@'%' IDENTIFIED BY 'test';
2021-03-19T18:21:26.8131036Z 2021-03-19T18:21:26.745+0000 [DEBUG] [TestEventLogger]     GRANT ALL PRIVILEGES ON *.* TO 'test'@'%';
2021-03-19T18:21:26.8135457Z 2021-03-19T18:21:26.745+0000 [DEBUG] [TestEventLogger]     ]
2021-03-19T18:21:26.8140335Z 2021-03-19T18:21:26.745+0000 [DEBUG] [TestEventLogger]     	at org.testcontainers.ext.ScriptUtils.executeDatabaseScript(ScriptUtils.java:375) ~[database-commons-1.15.1.jar:?]
2021-03-19T18:21:26.8146504Z 2021-03-19T18:21:26.745+0000 [DEBUG] [TestEventLogger]     	at org.testcontainers.ext.ScriptUtils.executeDatabaseScript(ScriptUtils.java:313) ~[database-commons-1.15.1.jar:?]
2021-03-19T18:21:26.8192429Z 2021-03-19T18:21:26.746+0000 [DEBUG] [TestEventLogger]     	at org.testcontainers.ext.ScriptUtils.runInitScript(ScriptUtils.java:302) ~[database-commons-1.15.1.jar:?]
2021-03-19T18:21:26.8200093Z 2021-03-19T18:21:26.746+0000 [DEBUG] [TestEventLogger]     	at org.testcontainers.containers.JdbcDatabaseContainer.runInitScriptIfRequired(JdbcDatabaseContainer.java:285) ~[jdbc-1.15.1.jar:?]
2021-03-19T18:21:26.8208674Z 2021-03-19T18:21:26.746+0000 [DEBUG] [TestEventLogger]     	at org.testcontainers.containers.JdbcDatabaseContainer.containerIsStarted(JdbcDatabaseContainer.java:172) ~[jdbc-1.15.1.jar:?]
2021-03-19T18:21:26.8242368Z 2021-03-19T18:21:26.746+0000 [DEBUG] [TestEventLogger]     	at org.testcontainers.containers.GenericContainer.containerIsStarted(GenericContainer.java:659) ~[testcontainers-1.15.1.jar:?]
u

user

03/19/2021, 7:08 PM
Copy code
2021-03-19T18:21:26.9177278Z 2021-03-19T18:21:26.770+0000 [DEBUG] [TestEventLogger]     2021-03-19 18:19:26+00:00 [ERROR] [Entrypoint]: MYSQL_USER="root", MYSQL_USER and MYSQL_PASSWORD are for configuring a regular user and cannot be used for the root user
2021-03-19T18:21:26.9182000Z 2021-03-19T18:21:26.770+0000 [DEBUG] [TestEventLogger] 
2021-03-19T18:21:26.9186513Z 2021-03-19T18:21:26.770+0000 [DEBUG] [TestEventLogger]         Remove MYSQL_USER="root" and use one of the following to control the root user password:
2021-03-19T18:21:26.9190499Z 2021-03-19T18:21:26.771+0000 [DEBUG] [TestEventLogger] 
2021-03-19T18:21:26.9194295Z 2021-03-19T18:21:26.771+0000 [DEBUG] [TestEventLogger]         - MYSQL_ROOT_PASSWORD
2021-03-19T18:21:26.9197911Z 2021-03-19T18:21:26.771+0000 [DEBUG] [TestEventLogger] 
2021-03-19T18:21:26.9202229Z 2021-03-19T18:21:26.771+0000 [DEBUG] [TestEventLogger]         - MYSQL_ALLOW_EMPTY_PASSWORD
2021-03-19T18:21:26.9205933Z 2021-03-19T18:21:26.771+0000 [DEBUG] [TestEventLogger] 
2021-03-19T18:21:26.9210271Z 2021-03-19T18:21:26.771+0000 [DEBUG] [TestEventLogger]         - MYSQL_RANDOM_ROOT_PASSWORD
2021-03-19T18:21:26.9214463Z 2021-03-19T18:21:26.771+0000 [DEBUG] [TestEventLogger]
u

user

03/19/2021, 7:09 PM
is it the password thing??
u

user

03/19/2021, 7:23 PM
huh
u

user

03/19/2021, 7:23 PM
weird
u

user

03/19/2021, 7:23 PM
why wouldn’t that happen locally though
5 Views