-
Bug
-
Resolution: Done
-
Major
-
0.9.4.Final
-
None
-
confluent-3.3.0
debezium 0.9.4.Final
mysql 5.6.16(ali)
5019 [2019-08-13 14:26:47,145] ERROR Failed due to error: Aborting snapshot due to error when last running 'UNLOCK TABLES': Only REPEATABLE READ isolation level is supported for START TRANSACTION WITH CONSISTENT SNAPSHOT in RocksDB Storage Engine. (io.debezium.connector.mysql.SnapshotReader) 5020 org.apache.kafka.connect.errors.ConnectException: Only REPEATABLE READ isolation level is supported for START TRANSACTION WITH CONSISTENT SNAPSHOT in RocksDB Storage Engine. Error code: 3045; SQLSTATE: HY000. 5021 at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:230) 5022 at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:208) 5023 at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:678) 5024 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 5025 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 5026 at java.lang.Thread.run(Thread.java:748) 5027 Caused by: java.sql.SQLException: Only REPEATABLE READ isolation level is supported for START TRANSACTION WITH CONSISTENT SNAPSHOT in RocksDB Storage Engine. 5028 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) 5029 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 5030 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) 5031 at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782) 5032 at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666) 5033 at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1091) 5034 at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:241) 5035 ... 3 more 5036 [2019-08-13 14:26:47,553] ERROR Task binlog.dmp_20190813-0 threw an uncaught and unrecoverable exception (org.apache.kafka.connect.runtime.WorkerTask) 5037 org.apache.kafka.connect.errors.ConnectException: Only REPEATABLE READ isolation level is supported for START TRANSACTION WITH CONSISTENT SNAPSHOT in RocksDB Storage Engine. Error code: 3045; SQLSTATE: HY000. 5038 at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:230) 5039 at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:208) 5040 at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:678) 5041 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 5042 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 5043 at java.lang.Thread.run(Thread.java:748) 5044 Caused by: java.sql.SQLException: Only REPEATABLE READ isolation level is supported for START TRANSACTION WITH CONSISTENT SNAPSHOT in RocksDB Storage Engine. 5045 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) 5046 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 5047 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) 5048 at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782) 5049 at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666) 5050 at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1091) 5051 at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:241) 5052 ... 3 more 5053 [2019-08-13 14:26:47,554] ERROR Task is being killed and will not recover until manually restarted (org.apache.kafka.connect.runtime.WorkerTask)