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. 1.png
            1.png
            545 kB
          2. 2.png
            2.png
            322 kB
          3. 20191009184337.jpg
            20191009184337.jpg
            134 kB
          4. engine.jpg
            engine.jpg
            70 kB
          5. twice-rr.jpg
            twice-rr.jpg
            403 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: