Flink报错Lock wait timeout exceeded; try restarti...
已解决Flink报错Lock wait timeout exceeded; try restarting transaction
展开
收起
1
条回答
写回答
写回答
-
开发者社区问答官方账号官方回答采纳回答【报错详情】org.apache.kafka.connect.errors.ConnectException: Lock wait timeout exceeded; try restarting transaction Error code: 1205; SQLSTATE: 40001.at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:241)at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:218)at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:857)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1147)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)at java.lang.Thread.run(Thread.java:834)Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transactionat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:123)at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200)at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:554)at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:497)at io.debezium.connector.mysql.SnapshotReader.readTableSchema(SnapshotReader.java:888)at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:550)... 3 more【报错原因】当MySQL CDC源表不开启增量快照读取时，申请锁时可能发生的超时错误。【解决方案】升级到VVR 4.0.8及以上版本即可，新版本默认使用无锁算法，不需要申请锁。2024-06-08 10:06:47赞同 展开评论 打赏
问答分类：
问答标签：
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
相关问答
