同步mysql数据造成了mysql flush tables with read lock锁全表问题

itinycheng / flink-connector-clickhouse

Flink SQL connector for ClickHouse. Support ClickHouseCatalog and read/write primary data, maps, arrays to clickhouse.

Apache License 2.0

349 stars 149 forks source link

同步mysql数据造成了mysql flush tables with read lock锁全表问题 #16

Closed mjp27258 closed 2 years ago

mjp27258 commented 2 years ago

Caused by: org.apache.kafka.connect.errors.ConnectException: Lock wait timeout exceeded; try restarting transaction Error code: 1205; SQLSTATE: 40001.

itinycheng commented 2 years ago

This seems to be a flink-connector-kafka issue, you can go to flink community for help.

mjp27258 commented 2 years ago

The problem has been solved. Upgrade flink-connector-mysql-cdc to 2.1.1