-
Bug
-
Resolution: Not a Bug
-
Major
-
None
-
3.0.7.Final
-
None
-
False
-
-
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