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

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.

    Details

      Description

      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)
      

        Gliffy Diagrams

          Attachments

          1. twice-rr.jpg
            twice-rr.jpg
            403 kB
          2. engine.jpg
            engine.jpg
            70 kB
          3. 20191009184337.jpg
            20191009184337.jpg
            134 kB
          4. 2.png
            2.png
            322 kB
          5. 1.png
            1.png
            545 kB

            Activity

              People

              • Assignee:
                jpechanec Jiri Pechanec
                Reporter:
                j5land herry jiang
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: