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.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.0.0.Beta2
    • 0.9.4.Final
    • mysql-connector
    • None

    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)
      

      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

            jpechane Jiri Pechanec
            j5land herry jiang (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: