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

Wrong priviledges in mysql replica image

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not a Bug
    • Icon: Major Major
    • None
    • 3.0.7.Final
    • container-images
    • None
    • False
    • Hide

      None

      Show
      None
    • False

      Reported by the user under this PR:
      debezium example mysql replication:
      with DEBEZIUM_VERSION=3.0.7.Final docker-compose up --build .

      mysql-replication-connect-1    | org.apache.kafka.connect.errors.RetriableException: An exception occurred in the change event producer. This connector will be restarted.
      mysql-replication-connect-1    | 	at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:63)
      mysql-replication-connect-1    | 	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:150)
      mysql-replication-connect-1    | 	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
      mysql-replication-connect-1    | 	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
      mysql-replication-connect-1    | 	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
      mysql-replication-connect-1    | 	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
      mysql-replication-connect-1    | 	at java.base/java.lang.Thread.run(Thread.java:1583)
      mysql-replication-connect-1    | Caused by: io.debezium.DebeziumException: java.sql.SQLSyntaxErrorException: Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation
      mysql-replication-connect-1    | 	at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:105)
      mysql-replication-connect-1    | 	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:297)
      mysql-replication-connect-1    | 	at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:281)
      mysql-replication-connect-1    | 	at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:192)
      mysql-replication-connect-1    | 	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143)
      mysql-replication-connect-1    | 	... 5 more
      mysql-replication-connect-1    | Caused by: java.sql.SQLSyntaxErrorException: Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation
      mysql-replication-connect-1    | 	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112)
      mysql-replication-connect-1    | 	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
      mysql-replication-connect-1    | 	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:837)
      mysql-replication-connect-1    | 	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:685)
      mysql-replication-connect-1    | 	at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1490)
      mysql-replication-connect-1    | 	at io.debezium.connector.binlog.BinlogSnapshotChangeEventSource.tableLock(BinlogSnapshotChangeEventSource.java:524)
      mysql-replication-connect-1    | 	at io.debezium.connector.binlog.BinlogSnapshotChangeEventSource.readTableStructure(BinlogSnapshotChangeEventSource.java:301)
      mysql-replication-connect-1    | 	at io.debezium.connector.binlog.BinlogSnapshotChangeEventSource.readTableStructure(BinlogSnapshotChangeEventSource.java:67)
      mysql-replication-connect-1    | 	at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:163)
      mysql-replication-connect-1    | 	at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:96)
      mysql-replication-connect-1    | 	... 9 more
      

              vjuranek@redhat.com Vojtech Juranek
              vjuranek@redhat.com Vojtech Juranek
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: