FlinkCDC 踩坑日志

1.使用Flink 1.13.5 配合 FlinkCDC 2.1.0 和 2.2.0,读取mysql数据发现初始化成功了,但是数据更新和删除时候不会自动刷新,暂时退回去只用FlinkCDC 2.0.0

2.FlinkCDC 2.0.0 使用从时间戳读取数据时候不生效,

.startupOptions(StartupOptions.timestamp(1666065600000L))

目前只有 initial 和 latest 生效

3.FlinkCDC 2.0.0 目前不支持checkpoint

4.Flink 1.13.5   FlinkCDC 2.0.0  配合使用在生产环境目前发现数据更新大的时候,不会自动更新

mysql数据输出到sqlserver,数据量变少了 

5.目前flink 1.14.4 配合 flinkcdc sql 2.2.0 才比较稳,抓捕全量和binlog更新

6.

java.lang.RuntimeException: One or more fetchers have encountered exception
  at org.apache.flink.connector.base.source.reader.fetcher.SplitFetcherManager.checkErrors(SplitFetcherManager.java:225)
  at org.apache.flink.connector.base.source.reader.SourceReaderBase.getNextFetch(SourceReaderBase.java:169)
  at org.apache.flink.connector.base.source.reader.SourceReaderBase.pollNext(SourceReaderBase.java:130)
  at org.apache.flink.connector.base.source.reader.SourceReaderBase.pollNext(SourceReaderBase.java:156)
  at org.apache.flink.streaming.api.operators.SourceOperator.emitNext(SourceOperator.java:351)
  at org.apache.flink.streaming.runtime.io.StreamTaskSourceInput.emitNext(StreamTaskSourceInput.java:68)
  at org.apache.flink.streaming.runtime.io.StreamOneInputProcessor.processInput(StreamOneInputProcessor.java:65)
  at org.apache.flink.streaming.runtime.tasks.StreamTask.processInput(StreamTask.java:496)
  at org.apache.flink.streaming.runtime.tasks.mailbox.MailboxProcessor.runMailboxLoop(MailboxProcessor.java:203)
  at org.apache.flink.streaming.runtime.tasks.StreamTask.runMailboxLoop(StreamTask.java:809)
  at org.apache.flink.streaming.runtime.tasks.StreamTask.invoke(StreamTask.java:761)
  at org.apache.flink.runtime.taskmanager.Task.runWithSystemExitMonitoring(Task.java:958)
  at org.apache.flink.runtime.taskmanager.Task.restoreAndInvoke(Task.java:937)
  at org.apache.flink.runtime.taskmanager.Task.doRun(Task.java:766)
  at org.apache.flink.runtime.taskmanager.Task.run(Task.java:575)
  at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.RuntimeException: SplitFetcher thread 0 received unexpected exception while polling the records
  at org.apache.flink.connector.base.source.reader.fetcher.SplitFetcher.runOnce(SplitFetcher.java:150)
  at org.apache.flink.connector.base.source.reader.fetcher.SplitFetcher.run(SplitFetcher.java:105)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  ... 1 more
Caused by: com.ververica.cdc.connectors.shaded.org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.
  at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:42)
  at io.debezium.connector.mysql.MySqlStreamingChangeEventSource$ReaderThreadLifecycleListener.onCommunicationFailure(MySqlStreamingChangeEventSource.java:1185)
  at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:973)
  at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:606)
  at com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:850)
  ... 1 more
Caused by: io.debezium.DebeziumException: Failed to deserialize data of EventHeaderV4{timestamp=1667487625000, eventType=EXT_UPDATE_ROWS, serverId=155, headerLength=19, dataLength=8109, nextPosition=987673468, flags=0}
  at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.wrap(MySqlStreamingChangeEventSource.java:1146)
  ... 5 more
Caused by: com.github.shyiko.mysql.binlog.event.deserialization.EventDataDeserializationException: Failed to deserialize data of EventHeaderV4{timestamp=1667487625000, eventType=EXT_UPDATE_ROWS, serverId=155, headerLength=19, dataLength=8109, nextPosition=987673468, flags=0}
  at com.github.shyiko.mysql.binlog.event.deserialization.EventDeserializer.deserializeEventData(EventDeserializer.java:309)
  at com.github.shyiko.mysql.binlog.event.deserialization.EventDeserializer.nextEvent(EventDeserializer.java:232)
  at io.debezium.connector.mysql.MySqlStreamingChangeEventSource$1.nextEvent(MySqlStreamingChangeEventSource.java:233)
  at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:945)
  ... 3 more
Caused by: java.io.EOFException
  at com.github.shyiko.mysql.binlog.io.ByteArrayInputStream.fill(ByteArrayInputStream.java:113)
  at com.github.shyiko.mysql.binlog.io.ByteArrayInputStream.read(ByteArrayInputStream.java:104)
  at io.debezium.connector.mysql.RowDeserializers.deserializeVarString(RowDeserializers.java:264)
  at io.debezium.connector.mysql.RowDeserializers$UpdateRowsDeserializer.deserializeVarString(RowDeserializers.java:130)
  at com.github.shyiko.mysql.binlog.event.deserialization.AbstractRowsEventDataDeserializer.deserializeCell(AbstractRowsEventDataDeserializer.java:189)
  at com.github.shyiko.mysql.binlog.event.deserialization.AbstractRowsEventDataDeserializer.deserializeRow(AbstractRowsEventDataDeserializer.java:143)
  at com.github.shyiko.mysql.binlog.event.deserialization.UpdateRowsEventDataDeserializer.deserializeRows(UpdateRowsEventDataDeserializer.java:71)
  at com.github.shyiko.mysql.binlog.event.deserialization.UpdateRowsEventDataDeserializer.deserialize(UpdateRowsEventDataDeserializer.java:58)
  at com.github.shyiko.mysql.binlog.event.deserialization.UpdateRowsEventDataDeserializer.deserialize(UpdateRowsEventDataDeserializer.java:33)
  at com.github.shyiko.mysql.binlog.event.deserialization.EventDeserializer.deserializeEventData(EventDeserializer.java:303)
  ... 6 more

 flinkcdc2.2  经常任务时不时出现这个错误怀疑是网络连接问题

调大mysql服务器的网络参数

set global slave_net_timeout=120;

set global thread_pool_idle_timeout=120;

7. java flink1.14.4  目前还无法与flinkCDC 2.2.1  结合 ，运行了初始化不了数据

8.最近遇到一个问题，flink sql 1.14.4   cdc 数据到sqlserver，有一个初始化同步到一半就报错，错误日志找不到主要问题，最后先用离线同步了旧数据，flink sql任务设置scan最新数据任务正常，目标表格注意设置成忽略唯一性限制，这样重启数据插入会跳过

例如：sqlserver设置成

ALTER TABLE member.[db].[Master] ADD CONSTRAINT UK_Master UNIQUE (No,tNo) WITH (IGNORE_DUP_KEY = ON)；