Can not create MySQL destination, but source is OK

n9yty · August 8, 2022, 5:53pm

Is this your first time deploying Airbyte?: Yes
OS Version / Instance: MacOS Monterey 12.5
Memory / Disk: 16Gb / 2 Tb
Deployment: Docker
Airbyte Version: * 0.39.42-alpha
Source name/version: n/a
Destination name/version: MySQL 0.1.20
Step: Creating Destination
Description: I get a timeout error when trying to connect to my host machine’s MySQL DB using host.docker.internal. “Could not connect with provided configuration. HikariPool-1 - Connection is not available, request timed out after 60002ms.” This is without SSL, although trying SSL still gives the same timeout. Other docker containers have no problem, and when I created a MySQL source it had no problems. I was able to get into the spawned ‘destination-mysql-check’ container before it went away and installed ping and verified it could ping my host on host.docker.internal.

n9yty · August 8, 2022, 7:55pm

Oddly enough, I set up a Jitsu test environment and I had no problems with the MySQL Destination. I thought it used the Airbyte connectors, so that is a bit puzzling.

natalyjazzviolin · August 8, 2022, 7:56pm

Hello @n9yty, sorry to hear you’re experiencing issues! Would you be able to give me the logs while I’m looking further into this?

n9yty · August 9, 2022, 5:30am

Let’s see if I get the right log… There has to be an easier way, but I copied it out of the setup page piece by piece as I couldn’t select the whole set of lines in one go:

2022-08-09 04:59:41 INFO i.a.w.t.TemporalAttemptExecution(get):105 - Docker volume job log path: /tmp/workspace/db1e964c-7fbb-4e13-82fa-780530cb987e/0/logs.log
2022-08-09 04:59:41 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.39.42-alpha
2022-08-09 04:59:41 INFO i.a.c.i.LineGobbler(voidCall):82 - Checking if airbyte/destination-mysql:0.1.20 exists...
2022-08-09 04:59:41 INFO i.a.c.i.LineGobbler(voidCall):82 - airbyte/destination-mysql:0.1.20 was found locally.
2022-08-09 04:59:41 INFO i.a.w.p.DockerProcessFactory(create):108 - Creating docker job ID: db1e964c-7fbb-4e13-82fa-780530cb987e
2022-08-09 04:59:41 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/db1e964c-7fbb-4e13-82fa-780530cb987e/0 --log-driver none --name destination-mysql-check-db1e964c-7fbb-4e13-82fa-780530cb987e-0-owgwf --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=false -e WORKER_ENVIRONMENT=DOCKER -e AIRBYTE_ROLE= -e WORKER_CONNECTOR_IMAGE=airbyte/destination-mysql:0.1.20 -e WORKER_JOB_ATTEMPT=0 -e AIRBYTE_VERSION=0.39.42-alpha -e WORKER_JOB_ID=db1e964c-7fbb-4e13-82fa-780530cb987e airbyte/destination-mysql:0.1.20 check --config source_config.json
2022-08-09 04:59:42 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Class path contains multiple SLF4J bindings.
2022-08-09 04:59:42 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
2022-08-09 04:59:42 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
2022-08-09 04:59:42 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]
2022-08-09 04:59:42 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
2022-08-09 04:59:43 ERROR i.a.c.i.LineGobbler(voidCall):82 - SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
2022-08-09 04:59:43 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 04:59:43 INFO i.a.i.d.m.MySQLDestination(main):136 - starting destination: class io.airbyte.integrations.destination.mysql.MySQLDestination
2022-08-09 04:59:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 04:59:44 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {check=null, config=source_config.json}
2022-08-09 04:59:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 04:59:44 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
2022-08-09 04:59:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 04:59:44 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: CHECK
2022-08-09 04:59:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 04:59:44 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'}
2022-08-09 04:59:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 04:59:44 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword order - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword
2022-08-09 04:59:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 04:59:44 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword examples - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword
2022-08-09 04:59:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 04:59:44 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword airbyte_secret - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword
2022-08-09 04:59:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 04:59:44 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword multiline - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword
2022-08-09 04:59:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 04:59:44 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL
2022-08-09 04:59:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 04:59:44 INFO c.z.h.HikariDataSource(<init>):80 - HikariPool-1 - Starting...
2022-08-09 04:59:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 04:59:44 INFO c.z.h.HikariDataSource(<init>):82 - HikariPool-1 - Start completed.
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 05:00:44 ERROR i.a.i.d.m.MySQLDestination(check):83 - Exception while checking connection: 
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 60003ms.
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:181) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:146) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at io.airbyte.db.jdbc.DefaultJdbcDatabase.execute(DefaultJdbcDatabase.java:43) ~[io.airbyte.airbyte-db-db-lib-0.39.21-alpha.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at io.airbyte.db.jdbc.JdbcDatabase.execute(JdbcDatabase.java:47) ~[io.airbyte.airbyte-db-db-lib-0.39.21-alpha.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at io.airbyte.integrations.destination.jdbc.JdbcSqlOperations.lambda$createSchemaIfNotExists$0(JdbcSqlOperations.java:51) ~[io.airbyte.airbyte-integrations.connectors-destination-jdbc-0.39.21-alpha.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at io.airbyte.integrations.base.sentry.AirbyteSentry.executeWithTracing(AirbyteSentry.java:54) ~[io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at io.airbyte.integrations.destination.jdbc.JdbcSqlOperations.createSchemaIfNotExists(JdbcSqlOperations.java:50) ~[io.airbyte.airbyte-integrations.connectors-destination-jdbc-0.39.21-alpha.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at io.airbyte.integrations.destination.jdbc.AbstractJdbcDestination.attemptSQLCreateAndDropTableOperations(AbstractJdbcDestination.java:88) ~[io.airbyte.airbyte-integrations.connectors-destination-jdbc-0.39.21-alpha.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at io.airbyte.integrations.destination.mysql.MySQLDestination.check(MySQLDestination.java:69) ~[io.airbyte.airbyte-integrations.connectors-destination-mysql-0.39.21-alpha.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at io.airbyte.integrations.base.ssh.SshTunnel.sshWrap(SshTunnel.java:205) [io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at io.airbyte.integrations.base.ssh.SshWrappedDestination.check(SshWrappedDestination.java:53) [io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at io.airbyte.integrations.base.IntegrationRunner.runInternal(IntegrationRunner.java:140) [io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at io.airbyte.integrations.base.IntegrationRunner.run(IntegrationRunner.java:107) [io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at io.airbyte.integrations.destination.mysql.MySQLDestination.main(MySQLDestination.java:137) [io.airbyte.airbyte-integrations.connectors-destination-mysql-0.39.21-alpha.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - Caused by: java.sql.SQLException: The server time zone value 'CDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specific time zone value if you want to utilize time zone support.
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at java.lang.Thread.run(Thread.java:833) ~[?:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'CDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specific time zone value if you want to utilize time zone support.
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at jdk.internal.reflect.GeneratedConstructorAccessor26.newInstance(Unknown Source) ~[?:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) ~[?:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at java.lang.reflect.Constructor.newInstance(Constructor.java:480) ~[?:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:134) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2186) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2209) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1318) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:967) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.22.jar:8.0.22]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712) ~[HikariCP-5.0.1.jar:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 	at java.lang.Thread.run(Thread.java:833) ~[?:?]
2022-08-09 05:00:44 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 05:00:44 INFO c.z.h.HikariDataSource(close):350 - HikariPool-1 - Shutdown initiated...
2022-08-09 05:00:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 05:00:45 INFO c.z.h.HikariDataSource(close):352 - HikariPool-1 - Shutdown completed.
2022-08-09 05:00:45 WARN c.n.s.JsonMetaSchema(newValidator):338 - Unknown keyword existingJavaType - you should define your own Meta Schema. If the keyword is irrelevant for validation, just use a NonValidationKeyword
2022-08-09 05:00:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 05:00:45 INFO i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
2022-08-09 05:00:45 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - 2022-08-09 05:00:45 INFO i.a.i.d.m.MySQLDestination(main):138 - completed destination: class io.airbyte.integrations.destination.mysql.MySQLDestination
2022-08-09 05:00:45 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling...

Seeing that error, I googled a bit and found this:

https://confluence.atlassian.com/bitbucketserverkb/database-migration-to-mysql-fails-java-sql-sqlexception-the-server-time-zone-value-cdt-is-unrecognized-or-represents-more-than-one-time-zone-847457613.html

I added to JDBC URL Params per their recommendation without further research, so there may be a better option, but here it is:

useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

It now returns this error:

Could not connect with provided configuration. Access denied for user 'airbyte'@'localhost' to database 'airbyte_square'

Why did it change the database name from airbyte-square in the configuration screen to airbyte_square??

Changing the DB name to one without a _ character, such as just “airbyte”, succeeded.

Odd that none of these issues existed in the MySQL Source connector when I could connect the same database without any of these steps.

n9yty · August 9, 2022, 5:31am

This is probably now a new topic, and I will try to research it first, but source is Square and dest is MySQL. It looks like it creates a set of tmp tables, then raw tables, but fails trying to do transformations… But I haven’t even read about that stuff yet and didn’t customize anything, but much to learn.

natalyjazzviolin · August 9, 2022, 5:32pm

That’s interesting that you’re able to connect to the MySQL destination with the other source! Would you say this is solved then, or not yet? It looks like it may be a permissions issue, I’m looking further into it.

n9yty · August 9, 2022, 7:18pm

So MariaDB is not compatible with the transformation. I am converting my system over to MySQL now. I probably should just throw up a docker container for this.

The only part I am really left to be confused by is why the table name was changed from ‘airbyte-square’ to ‘airbyte_square’. Everything else makes sense.

natalyjazzviolin · August 9, 2022, 7:34pm

Got it, glad you figured it out! The underscore is certainly a mystery!

Topic		Replies	Views
Error when creating a destination to mysql Connector Questions & Issues destination-mysql	2	400	October 29, 2022
Destination MySQL - Timeout Error on Remotely Hosted Bluehost server Connector Questions & Issues destination-mysql , getting-started , connectors	1	538	August 13, 2022
Can not create MySQL destination, but source is work Connector Questions & Issues connectors , mysql	2	318	May 18, 2023
Maridb connect for source and destination fails Connector Questions & Issues getting-started , connectors	20	2618	May 9, 2023
Error with MySQL Connector Connector Questions & Issues connectors	2	433	September 22, 2022

Can not create MySQL destination, but source is OK

Related Topics