Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4049

Debezium Server uses MySQL driver version as defined in Quarkus not in Debezium

    XMLWordPrintable

Details

    • Hide

      application.properties

       

      debezium.sink.type=eventhubs
      debezium.sink.eventhubs.connectionstring=[redacted]
      debezium.sink.eventhubs.hubname=mysql
      debezium.tasks.max: 1,
      debezium.source.offset.storage.file.filename=data/offsets.dat
      debezium.source.offset.flush.interval.ms=0
      debezium.source.database.history=io.debezium.relational.history.FileDatabaseHistory
      debezium.source.database.history.file.filename=history.dat
      debezium.source.connector.class=io.debezium.connector.mysql.MySqlConnector
      debezium.source.database.hostname=[ip address]
      debezium.source.database.port=3306
      debezium.source.database.user=[username]
      debezium.source.database.password=[password]
      debezium.source.database.dbname=test
      debezium.source.database.server.id=3322891223
      debezium.source.database.server.name=test
      debezium.source.whitelist=test
      
      Show
      application.properties   debezium.sink.type=eventhubs debezium.sink.eventhubs.connectionstring=[redacted] debezium.sink.eventhubs.hubname=mysql debezium.tasks.max: 1, debezium.source.offset.storage.file.filename=data/offsets.dat debezium.source.offset.flush.interval.ms=0 debezium.source.database.history=io.debezium.relational.history.FileDatabaseHistory debezium.source.database.history.file.filename=history.dat debezium.source.connector.class=io.debezium.connector.mysql.MySqlConnector debezium.source.database.hostname=[ip address] debezium.source.database.port=3306 debezium.source.database.user=[username] debezium.source.database.password=[password] debezium.source.database.dbname=test debezium.source.database.server.id=3322891223 debezium.source.database.server.name=test debezium.source.whitelist=test

    Description

      I'm trying to run Debezium server against a MySQL database source using latin1.

      The first update that comes through throws the following exception:

      2021-09-27 15:58:26,464 ERROR [io.deb.pip.ErrorHandler] (debezium-mysqlconnector-sitepro-change-event-source-coordinator) Producer failure: java.lang.NoSuchMethodError: com.mysql.cj.CharsetMapping.getStaticCollationNameForCollationIndex(Ljava/lang/Integer;)Ljava/lang/String;2021-09-27 15:58:26,464 ERROR [io.deb.pip.ErrorHandler] (debezium-mysqlconnector-test-change-event-source-coordinator) Producer failure: java.lang.NoSuchMethodError: com.mysql.cj.CharsetMapping.getStaticCollationNameForCollationIndex(Ljava/lang/Integer;)Ljava/lang/String; at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.extractCharset(MySqlAntlrDdlParser.java:404) at io.debezium.connector.mysql.antlr.listener.CreateAndAlterDatabaseParserListener.enterCreateDatabaseOption(CreateAndAlterDatabaseParserListener.java:49) at io.debezium.ddl.parser.mysql.generated.MySqlParser$CreateDatabaseOptionContext.enterRule(MySqlParser.java:5907) at io.debezium.antlr.ProxyParseTreeListenerUtil.delegateEnterRule(ProxyParseTreeListenerUtil.java:46) at io.debezium.connector.mysql.antlr.listener.MySqlAntlrDdlParserListener.enterEveryRule(MySqlAntlrDdlParserListener.java:89) at org.antlr.v4.runtime.tree.ParseTreeWalker.enterRule(ParseTreeWalker.java:41) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:25) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:87) at io.debezium.connector.mysql.MySqlDatabaseSchema.parseDdl(MySqlDatabaseSchema.java:216) at io.debezium.connector.mysql.MySqlDatabaseSchema.parseSnapshotDdl(MySqlDatabaseSchema.java:196) at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.addSchemaEvent(MySqlSnapshotChangeEventSource.java:303) at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.readTableStructure(MySqlSnapshotChangeEventSource.java:357) at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.readTableStructure(MySqlSnapshotChangeEventSource.java:47) at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:119) at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:70) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:118) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:834)
      

      Attachments

        Issue Links

          Activity

            People

              jpechane Jiri Pechanec
              jamesbewley@gmail.com James Bewley (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: