airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
16.02k stars 4.11k forks source link

Source MySQL - Maridb connect for source and destination fails #18307

Open marcosmarxm opened 2 years ago

marcosmarxm commented 2 years ago

This Github issue is synchronized with Zendesk:

Ticket ID: #2692 Priority: normal Group: Community Assistance Engineer Assignee: Sajarin

Original ticket description:

  • Is this your first time deploying Airbyte?: Yes
  • OS Version / Instance: Debian
  • Memory / Disk: 4Gb
  • Deployment: Docker
  • Airbyte Version: latest
  • Source name/version: mysql 1.0.3
  • Destination name/version: mysql 1.0.3
  • Step: Creating the source or destination
  • Description:

Error when connecting mySQL/mariaDB as source: State code: 08S01; Message: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Error when connecting mySQL/MariaDB as destination: Could not connect with provided configuration. HikariPool-1 - Connection is not available, request timed out after 60001ms.

There is no entry in the error log of maria.

Is this related to JDBC driver. If so, can you explain how to find if within docker and what to do about it?

Any alternative explanations are more than welcome :slight_smile:

Thanks - Valentin

[Discourse post]
marcosmarxm commented 2 years ago

Comment made from Zendesk by Marcos Marx on 2022-10-10 at 16:02:

Hello there! You are receiving this message because none of your fellow community members has stepped in to respond to your topic post. (If you are a community member and you are reading this response, feel free to jump in if you have the answer!) As a result, the Community Assistance Team has been made aware of this topic and will be investigating and responding as quickly as possible.
Some important considerations that will help your to get your issue solved faster:
* It is best to use our topic creation template; if you haven’t yet, we recommend posting a followup with the requested information. With that information the team will be able to more quickly search for similar issues with connectors and the platform and troubleshoot more quickly your specific question or problem.
* Make sure to upload the complete log file; a common investigation roadblock is that sometimes the error for the issue happens well before the problem is surfaced to the user, and so having the tail of the log is less useful than having the whole log to scan through.
* Be as descriptive and specific as possible; when investigating it is extremely valuable to know what steps were taken to encounter the issue, what version of connector / platform / Java / Python / docker / k8s was used, etc. The more context supplied, the quicker the investigation can start on your topic and the faster we can drive towards an answer.
* We in the Community Assistance Team are glad you’ve made yourself part of our community, and we’ll do our best to answer your questions and resolve the problems as quickly as possible. Expect to hear from a specific team member as soon as possible.

Thank you for your time and attention.
Best,
The Community Assistance Team
marcosmarxm commented 2 years ago

Comment made from Zendesk by Marcos Marx on 2022-10-11 at 07:10:

Hello. Same thing happens to me.

I was going to open a new post about it.

MariaDB 10.5. I can add it as a Source normally but the same DB with the same credentials for destination fails.

Can anyone help?

Thanks.

[Discourse post]
marcosmarxm commented 2 years ago

Comment made from Zendesk by Sajarin on 2022-10-12 at 21:25:

Hi @vjmayr and @Mulen, 
 
Thanks for this post and welcome to the community! 
 
The compatibility with MySQL and MariaDB for our connector is very buggy and is prone to breaking. Have you both recently upgraded from an older version? Please share logs and screenshots so that I can escalate this to Github. 
marcosmarxm commented 2 years ago

Comment made from Zendesk by Marcos Marx on 2022-10-13 at 12:01:

This is the log from when i press “Setup Destination”

airbyte-temporal    | {"level":"info","ts":"2022-10-13T11:53:02.212Z","msg":"Get dynamic config","name":"history.defaultWorkflowRetryPolicy","value":{"BackoffCoefficient":2,"InitialIntervalInSeconds":1,"MaximumAttempts":0,"MaximumIntervalCoefficient":100},"default-value":{"BackoffCoefficient":2,"InitialIntervalInSeconds":1,"MaximumAttempts":0,"MaximumIntervalCoefficient":100},"logging-call-at":"config.go:79"}
airbyte-temporal    | {"level":"info","ts":"2022-10-13T11:53:02.235Z","msg":"Get dynamic config","name":"system.enableReadFromHistoryArchival","value":true,"default-value":true,"logging-call-at":"config.go:79"}
airbyte-temporal    | {"level":"info","ts":"2022-10-13T11:53:02.236Z","msg":"Get dynamic config","name":"history.longPollExpirationInterval","value":20,"default-value":20,"logging-call-at":"config.go:79"}
airbyte-worker      | 2022-10-13 11:53:02 INFO i.a.w.t.TemporalAttemptExecution(get):108 - Docker volume job log path: /tmp/workspace/bfd63f19-055b-439d-bd10-4ea24751f8c3/0/logs.log
airbyte-worker      | 2022-10-13 11:53:02 INFO i.a.w.t.TemporalAttemptExecution(get):113 - Executing worker wrapper. Airbyte version: 0.40.14
airbyte-worker      | 2022-10-13 11:53:03 INFO i.a.c.i.LineGobbler(voidCall):114 -
airbyte-worker      | 2022-10-13 11:53:03 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- START CHECK -----
airbyte-worker      | 2022-10-13 11:53:03 INFO i.a.c.i.LineGobbler(voidCall):114 -
airbyte-worker      | 2022-10-13 11:53:03 INFO i.a.c.i.LineGobbler(voidCall):114 - Checking if airbyte/destination-mysql:0.1.20 exists...
airbyte-worker      | 2022-10-13 11:53:03 INFO i.a.c.i.LineGobbler(voidCall):114 - airbyte/destination-mysql:0.1.20 was found locally.
airbyte-worker      | 2022-10-13 11:53:03 INFO i.a.w.p.DockerProcessFactory(create):119 - Creating docker container = destination-mysql-check-bfd63f19-055b-439d-bd10-4ea24751f8c3-0-qghnt with resources io.airbyte.config.ResourceRequirements@2e77e28f[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=]
airbyte-worker      | 2022-10-13 11:53:03 INFO i.a.w.p.DockerProcessFactory(create):163 - Preparing command: docker run --rm --init -i -w /data/bfd63f19-055b-439d-bd10-4ea24751f8c3/0 --log-driver none --name destination-mysql-check-bfd63f19-055b-439d-bd10-4ea24751f8c3-0-qghnt --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e USE_STREAM_CAPABLE_STATE=true -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.40.14 -e WORKER_JOB_ID=bfd63f19-055b-439d-bd10-4ea24751f8c3 airbyte/destination-mysql:0.1.20 check --config source_config.json
airbyte-worker      | 2022-10-13 11:53:04 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Class path contains multiple SLF4J bindings.
airbyte-worker      | 2022-10-13 11:53:04 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
airbyte-worker      | 2022-10-13 11:53:04 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
airbyte-worker      | 2022-10-13 11:53:04 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]
airbyte-worker      | 2022-10-13 11:53:04 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
airbyte-worker      | 2022-10-13 11:53:04 ERROR i.a.c.i.LineGobbler(voidCall):114 - SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
airbyte-temporal    | {"level":"info","ts":"2022-10-13T11:53:04.862Z","msg":"none","service":"matching","component":"matching-engine","wf-task-queue-name":"/_sys/CONNECTION_UPDATER/1","wf-task-queue-type":"Workflow","lifecycle":"Starting","logging-call-at":"taskQueueManager.go:238"}
airbyte-temporal    | {"level":"info","ts":"2022-10-13T11:53:04.862Z","msg":"none","service":"matching","component":"matching-engine","wf-task-queue-name":"/_sys/CONNECTION_UPDATER/1","wf-task-queue-type":"Workflow","lifecycle":"Started","logging-call-at":"taskQueueManager.go:242"}
airbyte-worker      | 2022-10-13 11:53:05 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:53:05 INFO i.a.i.d.m.MySQLDestination(main):136 - starting destination: class io.airbyte.integrations.destination.mysql.MySQLDestination
airbyte-worker      | 2022-10-13 11:53:05 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:53:05 INFO i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {check=null, config=source_config.json}
airbyte-worker      | 2022-10-13 11:53:05 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:53:05 INFO i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
airbyte-worker      | 2022-10-13 11:53:05 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:53:05 INFO i.a.i.b.IntegrationRunner(runInternal):124 - Command: CHECK
airbyte-worker      | 2022-10-13 11:53:05 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:53:05 INFO i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'}
airbyte-temporal    | {"level":"info","ts":"2022-10-13T11:53:05.984Z","msg":"none","service":"matching","component":"matching-engine","wf-task-queue-name":"/_sys/GET_SPEC/1","wf-task-queue-type":"Workflow","lifecycle":"Starting","logging-call-at":"taskQueueManager.go:238"}
airbyte-temporal    | {"level":"info","ts":"2022-10-13T11:53:05.984Z","msg":"none","service":"matching","component":"matching-engine","wf-task-queue-name":"/_sys/GET_SPEC/1","wf-task-queue-type":"Workflow","lifecycle":"Started","logging-call-at":"taskQueueManager.go:242"}
airbyte-worker      | 2022-10-13 11:53:05 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:53:05 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
airbyte-worker      | 2022-10-13 11:53:05 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:53:05 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
airbyte-worker      | 2022-10-13 11:53:05 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:53:05 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
airbyte-worker      | 2022-10-13 11:53:05 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:53:05 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
airbyte-worker      | 2022-10-13 11:53:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:53:06 INFO i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL
airbyte-worker      | 2022-10-13 11:53:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:53:06 INFO c.z.h.HikariDataSource(<init>):80 - HikariPool-1 - Starting...
airbyte-worker      | 2022-10-13 11:53:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:53:06 INFO c.z.h.HikariDataSource(<init>):82 - HikariPool-1 - Start completed.
airbyte-server      | 2022-10-13 11:53:16 INFO i.a.s.RequestLogger(filter):112 - REQ 172.18.0.5 GET 200 /api/v1/health
airbyte-webapp      | 172.21.4.98 - - [13/Oct/2022:11:53:16 +0000] "GET /api/v1/health HTTP/1.1" 200 18 "http://172.21.4.122:8000/workspaces/1d2e0d74-d27e-4dcd-9c53-330e7055eebe/destination/new-destination" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:105.0) Gecko/20100101 Firefox/105.0" "-"
airbyte-temporal    | {"level":"info","ts":"2022-10-13T11:53:22.236Z","msg":"Get dynamic config","name":"frontend.sendRawWorkflowHistory","value":false,"default-value":false,"logging-call-at":"config.go:79"}
airbyte-server      | 2022-10-13 11:53:36 INFO i.a.s.RequestLogger(filter):112 - REQ 172.18.0.5 GET 200 /api/v1/health
airbyte-webapp      | 172.21.4.98 - - [13/Oct/2022:11:53:36 +0000] "GET /api/v1/health HTTP/1.1" 200 18 "http://172.21.4.122:8000/workspaces/1d2e0d74-d27e-4dcd-9c53-330e7055eebe/destination/new-destination" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:105.0) Gecko/20100101 Firefox/105.0" "-"
airbyte-server      | 2022-10-13 11:53:56 INFO i.a.s.RequestLogger(filter):112 - REQ 172.18.0.5 GET 200 /api/v1/health
airbyte-webapp      | 172.21.4.98 - - [13/Oct/2022:11:53:56 +0000] "GET /api/v1/health HTTP/1.1" 200 18 "http://172.21.4.122:8000/workspaces/1d2e0d74-d27e-4dcd-9c53-330e7055eebe/destination/new-destination" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:105.0) Gecko/20100101 Firefox/105.0" "-"
airbyte-temporal    | {"level":"info","ts":"2022-10-13T11:54:01.370Z","msg":"none","service":"matching","component":"matching-engine","wf-task-queue-name":"/_sys/CHECK_CONNECTION/1","wf-task-queue-type":"Workflow","lifecycle":"Starting","logging-call-at":"taskQueueManager.go:238"}
airbyte-temporal    | {"level":"info","ts":"2022-10-13T11:54:01.370Z","msg":"none","service":"matching","component":"matching-engine","wf-task-queue-name":"/_sys/CHECK_CONNECTION/1","wf-task-queue-type":"Workflow","lifecycle":"Started","logging-call-at":"taskQueueManager.go:242"}
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:54:06 ERROR i.a.i.d.m.MySQLDestination(check):83 - Exception while checking connection:
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 60004ms.
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:181) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:146) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at io.airbyte.db.jdbc.DefaultJdbcDatabase.execute(DefaultJdbcDatabase.java:43) ~[io.airbyte.airbyte-db-db-lib-0.39.21-alpha.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at io.airbyte.db.jdbc.JdbcDatabase.execute(JdbcDatabase.java:47) ~[io.airbyte.airbyte-db-db-lib-0.39.21-alpha.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      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:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at io.airbyte.integrations.base.sentry.AirbyteSentry.executeWithTracing(AirbyteSentry.java:54) ~[io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at io.airbyte.integrations.destination.jdbc.JdbcSqlOperations.createSchemaIfNotExists(JdbcSqlOperations.java:50) ~[io.airbyte.airbyte-integrations.connectors-destination-jdbc-0.39.21-alpha.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at io.airbyte.integrations.destination.jdbc.AbstractJdbcDestination.attemptSQLCreateAndDropTableOperations(AbstractJdbcDestination.java:88) ~[io.airbyte.airbyte-integrations.connectors-destination-jdbc-0.39.21-alpha.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at io.airbyte.integrations.destination.mysql.MySQLDestination.check(MySQLDestination.java:69) ~[io.airbyte.airbyte-integrations.connectors-destination-mysql-0.39.21-alpha.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at io.airbyte.integrations.base.ssh.SshTunnel.sshWrap(SshTunnel.java:205) [io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at io.airbyte.integrations.base.ssh.SshWrappedDestination.check(SshWrappedDestination.java:53) [io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at io.airbyte.integrations.base.IntegrationRunner.runInternal(IntegrationRunner.java:140) [io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at io.airbyte.integrations.base.IntegrationRunner.run(IntegrationRunner.java:107) [io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at io.airbyte.integrations.destination.mysql.MySQLDestination.main(MySQLDestination.java:137) [io.airbyte.airbyte-integrations.connectors-destination-mysql-0.39.21-alpha.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed.
airbyte-worker      | errors: $: unknown found, object expected
airbyte-worker      | 2022-10-13 11:54:06 ERROR i.a.w.i.DefaultAirbyteStreamFactory(validate):77 - Validation failed: null
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.lang.Thread.run(Thread.java:833) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.v.j.JsonSchemaValidator(test):71 - JSON schema validation failed.
airbyte-worker      | errors: $: unknown found, object expected
airbyte-worker      | 2022-10-13 11:54:06 ERROR i.a.w.i.DefaultAirbyteStreamFactory(validate):77 - Validation failed: null
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at jdk.internal.reflect.GeneratedConstructorAccessor29.newInstance(Unknown Source) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.lang.reflect.Constructor.newInstance(Constructor.java:480) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:340) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:167) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1348) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.NativeSession.connect(NativeSession.java:157) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.lang.Thread.run(Thread.java:833) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at sun.security.ssl.HandshakeContext.<init>(HandshakeContext.java:172) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at sun.security.ssl.ClientHandshakeContext.<init>(ClientHandshakeContext.java:103) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at sun.security.ssl.TransportContext.kickstart(TransportContext.java:239) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:443) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:421) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:317) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:188) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:97) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:331) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:167) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1348) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.NativeSession.connect(NativeSession.java:157) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:956) ~[mysql-connector-java-8.0.22.jar:8.0.22]

This is a screenshot from the error at AirByte UI

image
image706×116 9.8 KB

[Discourse post]
marcosmarxm commented 2 years ago

Comment made from Zendesk by Marcos Marx on 2022-10-13 at 12:02:

Continue log

airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.22.jar:8.0.22]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712) ~[HikariCP-5.0.1.jar:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 -      at java.lang.Thread.run(Thread.java:833) ~[?:?]
airbyte-worker      | 2022-10-13 11:54:06 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:54:06 INFO c.z.h.HikariDataSource(close):350 - HikariPool-1 - Shutdown initiated...
airbyte-worker      | 2022-10-13 11:54:07 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:54:07 INFO c.z.h.HikariDataSource(close):352 - HikariPool-1 - Shutdown completed.
airbyte-worker      | 2022-10-13 11:54:07 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:54:07 INFO i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination
airbyte-worker      | 2022-10-13 11:54:07 INFO i.a.w.i.DefaultAirbyteStreamFactory(parseJson):68 - 2022-10-13 11:54:07 INFO i.a.i.d.m.MySQLDestination(main):138 - completed destination: class io.airbyte.integrations.destination.mysql.MySQLDestination
airbyte-worker      | 2022-10-13 11:54:07 INFO i.a.c.i.LineGobbler(voidCall):114 -
airbyte-worker      | 2022-10-13 11:54:07 INFO i.a.c.i.LineGobbler(voidCall):114 - ----- END CHECK -----
airbyte-worker      | 2022-10-13 11:54:07 INFO i.a.c.i.LineGobbler(voidCall):114 -
airbyte-worker      | 2022-10-13 11:54:07 INFO i.a.w.t.TemporalAttemptExecution(get):134 - Stopping cancellation check scheduling...
airbyte-server      | 2022-10-13 11:54:07 INFO i.a.s.RequestLogger(filter):112 - REQ 172.18.0.5 POST 200 /api/v1/scheduler/destinations/check_connection - {"connectionConfiguration":"REDACTED","destinationDefinitionId":"ca81ee7c-3163-4246-af40-094cc31e5e42"}
airbyte-webapp      | 172.21.4.98 - - [13/Oct/2022:11:54:07 +0000] "POST /api/v1/scheduler/destinations/check_connection HTTP/1.1" 200 28178 "http://172.21.4.122:8000/workspaces/1d2e0d74-d27e-4dcd-9c53-330e7055eebe/destination/new-destination" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:105.0) Gecko/20100101 Firefox/105.0" "-"
airbyte-server      | 2022-10-13 11:54:16 INFO i.a.s.RequestLogger(filter):112 - REQ 172.18.0.5 GET 200 /api/v1/health
airbyte-webapp      | 172.21.4.98 - - [13/Oct/2022:11:54:16 +0000] "GET /api/v1/health HTTP/1.1" 200 18 "http://172.21.4.122:8000/workspaces/1d2e0d74-d27e-4dcd-9c53-330e7055eebe/destination/new-destination" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:105.0) Gecko/20100101 Firefox/105.0" "-"
[Discourse post]
marcosmarxm commented 2 years ago

Comment made from Zendesk by Marcos Marx on 2022-10-19 at 06:26:

Any chance you saw my reply?

Thank you.

[Discourse post]
marcosmarxm commented 2 years ago

Comment made from Zendesk by Sajarin on 2022-10-21 at 17:12:

Hey @Mulen, 
 
Sorry for the delay and thanks for the reply. I went ahead and escalated this to github: https://github.com/airbytehq/airbyte/issues/18307

Thanks for posting the logs, curious to know if the latest version of the connectors solves this issue?
marcosmarxm commented 2 years ago

Comment made from Zendesk by Marcos Marx on 2022-10-27 at 13:47:

Hello.

No still for the destination is not working.

image

For the source it works just fine.

[Discourse post]
marcosmarxm commented 2 years ago

Comment made from Zendesk by Marcos Marx on 2022-10-27 at 15:36:

@Mulen , @sajarin - sorry for my late reply. I reworked everything. THe source was fixed through doing the docker network right. The destination works as of the last update of the connector. Thanks!

[Discourse post]
marcosmarxm commented 2 years ago

Comment made from Zendesk by Sajarin on 2022-10-27 at 17:39:

Thanks for the reply. Happy to hear it is working!
marcosmarxm commented 2 years ago

Comment made from Zendesk by Sajarin on 2022-10-27 at 17:40:

@Mulen, is it working for you as well?
marcosmarxm commented 2 years ago

Comment made from Zendesk by Marcos Marx on 2022-10-31 at 09:36:

@sajarin @vjmayr

Sorry but for the Destination Connector same thing happen and can’t connect, non-json response.

The latest version for Destination MySql connector i have in my dashboard is 0.1.20. Is there a new one available to test it and how to get it?

[Discourse post]
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2022-11-01 at 14:49:

@Mulen, there is a new version of the MySQL connector (0.1.21) let me know if you can upgrade and if the latest version solves this problem.

Again, I have to mention that we don’t explicitly have a MariaDB connector so using the MySQL connector is fragile.

[Discourse post]
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2022-11-07 at 13:53:

Hello again.

Still not working for the Destination.

From the settings, the Destination connector has version 0.1.20 and it’s the latest.

image
image1593×57 5.99 KB

To summarize again.

The MySql connector works at Source but NOT at Destination.

[Discourse post]
marcosmarxm commented 1 year ago

Comment made from Zendesk by Sajarin on 2022-11-09 at 17:06:

@Mullen, 
 
There are two different MySQL Destination connectors, one of them being strict-encrypt and the other being the default MySQL. 
 
The strict-encrypt version is on 0.1.20, the default connector is on 0.1.21. If you can, can you try setting up the default connector on version 0.1.21? 
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2022-11-14 at 14:01:

Hey, i have the same issue but i only have one mysql desitination connector.
Is it also named “Mysql”?

image
image1578×167 17.4 KB

[Discourse post]
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2022-12-06 at 18:22:

Valentin commented that updating to latest version solved the issue. Can you try that? If doesn't work please share the complete log file.
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2022-12-12 at 13:49:

Sorry for the late reply.

Am i missing something? I can not find version 0.1.21.

I installed latest airbyte from scratch and the Destionation Connector of MySQL is 0.1.20.

How i can install version 0.1.21?

[Discourse post]
marcosmarxm commented 1 year ago

Comment made from Zendesk by Sajarin on 2022-12-30 at 18:12:

@Mullen, I mispoke earlier, it seems like the strict-encrypt version is on 1.21 based on the dockerfile on Github: https://github.com/airbytehq/airbyte/blob/master/airbyte-integrations/connectors/destination-mysql-strict-encrypt/Dockerfile

Can you share the complete log files? Also I should mention again the MySQL connector may be very fragile when trying to use it with a mariadb database. 
mrn3 commented 1 year ago

Is there a reason there isn't just a dedicated MariaDB destination connector? I have tried to use the MySQL and MariaDB ColumnStore ones and it isn't working. Any ideas?

marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2023-04-03 at 23:12:

Closed due to no response from requester.
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2023-04-03 at 23:13:

Closed due to no response from requester.
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2023-04-03 at 23:14:

Closed due to no response from requester.
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2023-04-03 at 23:14:

Closed due to no response from requester.
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2023-04-03 at 23:15:

Closed due to no response from requester.
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2023-04-03 at 23:16:

Closed due to no response from requester.
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2023-04-03 at 23:20:

Closed due to no response from requester.
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2023-04-03 at 23:21:

Closed due to no response from requester.
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2023-04-03 at 23:21:

Closed due to no response from requester.
marcosmarxm commented 1 year ago

Comment made from Zendesk by Marcos Marx on 2023-04-03 at 23:23:

Closed due to no response from requester.
smitterer commented 1 year ago

I'm also not able to connect to a MariaDB:

Tried it with localhost, the external IP, via domain and via mysql and destination-mysql-strict-encrypt (while the second one wont work since (my) mariadb does not provide ssl/tls.

2023-04-11 08:22:32 INFO i.a.w.t.TemporalAttemptExecution(get):142 - Docker volume job log path: /tmp/workspace/61c15880-5d85-4544-be2b-d503177da53c/0/logs.log 2023-04-11 08:22:32 INFO i.a.w.t.TemporalAttemptExecution(get):147 - Executing worker wrapper. Airbyte version: 0.43.1 2023-04-11 08:22:32 INFO i.a.a.c.AirbyteApiClient(retryWithJitter):179 - Attempt 0 to save workflow id for cancellation 2023-04-11 08:22:32 INFO i.a.c.EnvConfigs(getEnvOrDefault):1222 - Using default value for environment variable SIDECAR_KUBE_CPU_LIMIT: '2.0' 2023-04-11 08:22:32 INFO i.a.c.EnvConfigs(getEnvOrDefault):1222 - Using default value for environment variable SOCAT_KUBE_CPU_LIMIT: '2.0' 2023-04-11 08:22:32 INFO i.a.c.EnvConfigs(getEnvOrDefault):1222 - Using default value for environment variable SIDECAR_KUBE_CPU_REQUEST: '0.1' 2023-04-11 08:22:32 INFO i.a.c.EnvConfigs(getEnvOrDefault):1222 - Using default value for environment variable SOCAT_KUBE_CPU_REQUEST: '0.1' 2023-04-11 08:22:32 INFO i.a.c.EnvConfigs(getEnvOrDefault):1222 - Using default value for environment variable LAUNCHDARKLY_KEY: '' 2023-04-11 08:22:32 INFO i.a.c.EnvConfigs(getEnvOrDefault):1222 - Using default value for environment variable FEATURE_FLAG_CLIENT: '' 2023-04-11 08:22:32 INFO i.a.c.i.LineGobbler(voidCall):149 - 2023-04-11 08:22:32 INFO i.a.c.i.LineGobbler(voidCall):149 - ----- START CHECK ----- 2023-04-11 08:22:32 INFO i.a.c.i.LineGobbler(voidCall):149 - 2023-04-11 08:22:32 INFO i.a.c.i.LineGobbler(voidCall):149 - Checking if airbyte/destination-mysql:0.1.20 exists... 2023-04-11 08:22:33 INFO i.a.c.i.LineGobbler(voidCall):149 - airbyte/destination-mysql:0.1.20 was found locally. 2023-04-11 08:22:33 INFO i.a.w.p.DockerProcessFactory(create):133 - Creating docker container = destination-mysql-check-61c15880-5d85-4544-be2b-d503177da53c-0-ibkjr with resources io.airbyte.config.ResourceRequirements@7d7176c1[cpuRequest=,cpuLimit=,memoryRequest=,memoryLimit=] and allowedHosts null 2023-04-11 08:22:33 INFO i.a.w.p.DockerProcessFactory(create):184 - Preparing command: docker run --rm --init -i -w /data/61c15880-5d85-4544-be2b-d503177da53c/0 --log-driver none --name destination-mysql-check-61c15880-5d85-4544-be2b-d503177da53c-0-ibkjr --network host -v airbyte_workspace:/data -v /tmp/airbyte_local:/local -e DEPLOYMENT_MODE=OSS -e WORKER_CONNECTOR_IMAGE=airbyte/destination-mysql:0.1.20 -e AUTO_DETECT_SCHEMA=true -e LAUNCHDARKLY_KEY= -e SOCAT_KUBE_CPU_REQUEST=0.1 -e SOCAT_KUBE_CPU_LIMIT=2.0 -e USE_STREAM_CAPABLE_STATE=true -e FIELD_SELECTION_WORKSPACES= -e AIRBYTE_ROLE= -e WORKER_ENVIRONMENT=DOCKER -e APPLY_FIELD_SELECTION=false -e WORKER_JOB_ATTEMPT=0 -e FEATURE_FLAG_CLIENT= -e AIRBYTE_VERSION=0.43.1 -e WORKER_JOB_ID=61c15880-5d85-4544-be2b-d503177da53c airbyte/destination-mysql:0.1.20 check --config source_config.json 2023-04-11 08:22:33 INFO i.a.w.i.VersionedAirbyteStreamFactory(create):145 - Reading messages from protocol version 0.2.0 2023-04-11 08:22:34 ERROR i.a.c.i.LineGobbler(voidCall):149 - SLF4J: Class path contains multiple SLF4J bindings. 2023-04-11 08:22:34 ERROR i.a.c.i.LineGobbler(voidCall):149 - SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2023-04-11 08:22:34 ERROR i.a.c.i.LineGobbler(voidCall):149 - SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2023-04-11 08:22:34 ERROR i.a.c.i.LineGobbler(voidCall):149 - SLF4J: Found binding in [jar:file:/airbyte/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2023-04-11 08:22:34 ERROR i.a.c.i.LineGobbler(voidCall):149 - SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2023-04-11 08:22:34 ERROR i.a.c.i.LineGobbler(voidCall):149 - SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 2023-04-11 08:22:35 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:22:35 \u001B[32mINFO\u001B[m i.a.i.d.m.MySQLDestination(main):136 - starting destination: class io.airbyte.integrations.destination.mysql.MySQLDestination" 2023-04-11 08:22:35 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:22:35 \u001B[32mINFO\u001B[m i.a.i.b.IntegrationCliParser(parseOptions):118 - integration args: {check=null, config=source_config.json}" 2023-04-11 08:22:35 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:22:35 \u001B[32mINFO\u001B[m i.a.i.b.IntegrationRunner(runInternal):123 - Running integration: io.airbyte.integrations.base.ssh.SshWrappedDestination" 2023-04-11 08:22:35 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:22:35 \u001B[32mINFO\u001B[m i.a.i.b.IntegrationRunner(runInternal):124 - Command: CHECK" 2023-04-11 08:22:35 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:22:35 \u001B[32mINFO\u001B[m i.a.i.b.IntegrationRunner(runInternal):125 - Integration config: IntegrationConfig{command=CHECK, configPath='source_config.json', catalogPath='null', statePath='null'}" 2023-04-11 08:22:35 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:22:35 \u001B[33mWARN\u001B[m 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" 2023-04-11 08:22:35 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:22:35 \u001B[33mWARN\u001B[m 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" 2023-04-11 08:22:35 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:22:35 \u001B[33mWARN\u001B[m 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" 2023-04-11 08:22:35 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:22:35 \u001B[33mWARN\u001B[m 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" 2023-04-11 08:22:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:22:36 \u001B[32mINFO\u001B[m i.a.i.b.s.SshTunnel(getInstance):170 - Starting connection with method: NO_TUNNEL" 2023-04-11 08:22:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:22:36 \u001B[32mINFO\u001B[m c.z.h.HikariDataSource(<init>):80 - HikariPool-1 - Starting..." 2023-04-11 08:22:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:22:36 \u001B[32mINFO\u001B[m c.z.h.HikariDataSource(<init>):82 - HikariPool-1 - Start completed." 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:23:36 \u001B[1;31mERROR\u001B[m i.a.i.d.m.MySQLDestination(check):83 - Exception while checking connection: " 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 60003ms." 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:181) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:146) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat io.airbyte.db.jdbc.DefaultJdbcDatabase.execute(DefaultJdbcDatabase.java:43) ~[io.airbyte.airbyte-db-db-lib-0.39.21-alpha.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat io.airbyte.db.jdbc.JdbcDatabase.execute(JdbcDatabase.java:47) ~[io.airbyte.airbyte-db-db-lib-0.39.21-alpha.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat io.airbyte.integrations.destination.jdbc.JdbcSqlOperations.lambda$createSchemaIfNotExists$0(JdbcSqlOperations.java:51) ~[io.airbyte.airbyte-integrations.connectors-destination-jdbc-0.39.21-alpha.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat io.airbyte.integrations.base.sentry.AirbyteSentry.executeWithTracing(AirbyteSentry.java:54) ~[io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat io.airbyte.integrations.destination.jdbc.JdbcSqlOperations.createSchemaIfNotExists(JdbcSqlOperations.java:50) ~[io.airbyte.airbyte-integrations.connectors-destination-jdbc-0.39.21-alpha.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat io.airbyte.integrations.destination.jdbc.AbstractJdbcDestination.attemptSQLCreateAndDropTableOperations(AbstractJdbcDestination.java:88) ~[io.airbyte.airbyte-integrations.connectors-destination-jdbc-0.39.21-alpha.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat io.airbyte.integrations.destination.mysql.MySQLDestination.check(MySQLDestination.java:69) ~[io.airbyte.airbyte-integrations.connectors-destination-mysql-0.39.21-alpha.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat io.airbyte.integrations.base.ssh.SshTunnel.sshWrap(SshTunnel.java:205) [io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat io.airbyte.integrations.base.ssh.SshWrappedDestination.check(SshWrappedDestination.java:53) [io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat io.airbyte.integrations.base.IntegrationRunner.runInternal(IntegrationRunner.java:140) [io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat io.airbyte.integrations.base.IntegrationRunner.run(IntegrationRunner.java:107) [io.airbyte.airbyte-integrations.bases-base-java-0.39.21-alpha.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat io.airbyte.integrations.destination.mysql.MySQLDestination.main(MySQLDestination.java:137) [io.airbyte.airbyte-integrations.connectors-destination-mysql-0.39.21-alpha.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "Caused by: java.sql.SQLException: The server time zone value 'CEST' 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." 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat java.lang.Thread.run(Thread.java:833) ~[?:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'CEST' 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." 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat jdk.internal.reflect.GeneratedConstructorAccessor26.newInstance(Unknown Source) ~[?:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) ~[?:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat java.lang.reflect.Constructor.newInstance(Constructor.java:480) ~[?:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:134) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2186) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2209) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1318) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:967) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.22.jar:8.0.22]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712) ~[HikariCP-5.0.1.jar:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "\tat java.lang.Thread.run(Thread.java:833) ~[?:?]" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:23:36 \u001B[32mINFO\u001B[m c.z.h.HikariDataSource(close):350 - HikariPool-1 - Shutdown initiated..." 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:23:36 \u001B[32mINFO\u001B[m c.z.h.HikariDataSource(close):352 - HikariPool-1 - Shutdown completed." 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:23:36 \u001B[32mINFO\u001B[m i.a.i.b.IntegrationRunner(runInternal):171 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedDestination" 2023-04-11 08:23:36 ERROR i.a.w.i.DefaultAirbyteStreamFactory(toAirbyteMessage):119 - Deserialization failed: "2023-04-11 08:23:36 \u001B[32mINFO\u001B[m i.a.i.d.m.MySQLDestination(main):138 - completed destination: class io.airbyte.integrations.destination.mysql.MySQLDestination" 2023-04-11 08:23:37 INFO i.a.w.g.DefaultCheckConnectionWorker(run):115 - Check connection job received output: io.airbyte.config.StandardCheckConnectionOutput@49940ef8[status=failed,message=Could not connect with provided configuration. HikariPool-1 - Connection is not available, request timed out after 60003ms.] 2023-04-11 08:23:37 INFO i.a.w.t.TemporalAttemptExecution(get):169 - Stopping cancellation check scheduling... 2023-04-11 08:23:37 INFO i.a.c.i.LineGobbler(voidCall):149 - 2023-04-11 08:23:37 INFO i.a.c.i.LineGobbler(voidCall):149 - ----- END CHECK ----- 2023-04-11 08:23:37 INFO i.a.c.i.LineGobbler(voidCall):149 -

Bc-Aqr commented 11 months ago

I have also encountered this problem. I use the latest version 0.50.34, and the mysql connector uses airbyte/source-mysql 3.1.7. I don't know what to do, because my mysql is currently started and can be connected externally