flink cdc失败

博客内容记录了一次数据库连接错误,具体为在尝试执行快照读取时由于自动提交设置为true导致无法进行回滚操作。错误源于Debezium MySQL连接器,在尝试从'hupu_du_community'库的'trend'表中选择数据时失败。
摘要由CSDN通过智能技术生成
[] - Step 8: rolling back transaction after abort
2021-06-04 17:18:57,132 ERROR io.debezium.connector.mysql.SnapshotReader                   [] - Failed due to error: Aborting snapshot due to error when last running 'SELECT * FROM `hupu_du_community`.`trend`': Can't call rollback when autocommit=true
org.apache.kafka.connect.errors.ConnectException: Can't call rollback when autocommit=true Error code: 0; SQLSTATE: 08003.
	at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:241) ~[ververica-connector-mysql-1.12-vvr-3.0.1-SNAPSHOT-jar-with-dependencies.jar:1.12-vvr-3.0.1-SNAPSHOT]
	at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:218) ~[ververica-connector-mysql-1.12-vvr-3.0.1-SNAPSHOT-jar-with-dependencies.jar:1.12-vvr-3.0.1-SNAPSHOT]
	at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:857) ~[ververica-connector-mysql-1.12-vvr-3.0.1-SNAPSHOT-jar-with-dependencies.jar:1.12-vvr-3.0.1-SNAPSHOT]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1147) [?:1.8.0_102]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622) [?:1.8.0_102]
	at java.lang.Thread.run(Thread.java:834) [?:1.8.0_102]
Caused by: java.sql.SQLNonTransientConnectionException: Can't call rollback when autocommit=true
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[ververica-connector-mysql-1.12-vvr-3.0.1-SNAPSHOT-jar-with-dependencies.jar:1.12-vvr-3.0.1-SNAPSHOT]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[ververica-connector-mysql-1.12-vvr-3.0.1-SNAPSHOT-jar-with-dependencies.jar:1.12-vvr-3.0.1-SNAPSHOT]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[ververica-connector-mysql-1.12-vvr-3.0.1-SNAPSHOT-jar-with-dependencies.jar:1.12-vvr-3.0.1-SNAPSHOT]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[ververica-connector-mysql-1.12-vvr-3.0.1-SNAPSHOT-jar-with-dependencies.jar:1.12-vvr-3.0.1-SNAPSHOT]
	at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1833) ~[ververica-connector-mysql-1.12-vvr-3.0.1-SNAPSHOT-jar-with-dependencies.jar:1.12-vvr-3.0.1-SNAPSHOT]
	at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:766) ~[ververica-connector-mysql-1.12-vvr-3.0.1-SNAPSHOT-jar-with-dependencies.jar:1.12-vvr-3.0.1-SNAPSHOT]
	... 3 more
2021-06-04 17:18:57,144 INFO  io.debezium.jdbc.JdbcConnection                              [] - Connection gracefully closed

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 5
    评论
评论 5
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值