Details
-
Bug
-
Resolution: Obsolete
-
Major
-
None
-
0.9.2.Final
-
None
-
- Start up a new connector with an empty dbhistory topic
- Synchronize a table with a not-nullable timestamp field with some 0000-00-00 00:00:00 values
- Snapshot will fail
Description
When taking an initial snapshot of a table with a not-nullable timestamp column with some zero values, snapshotting fails with the following errors:
[2019-03-06 02:01:15] ERROR Failed due to error: Aborting snapshot due to error when last running 'SELECT * FROM `database`.`table`': Zero date value prohibited (io.debezium.connector.mysql.SnapshotReader)
[2019-03-06 02:01:16] ERROR WorkerSourceTask{id=prd2234-nonprod3-us-east-1-bootstrap-v0-0} Task threw an uncaught and unrecoverable exception (org.apache.kafka.connect.runtime.WorkerTask)
[2019-03-06 02:01:16] ERROR WorkerSourceTask{id=prd2234-nonprod3-us-east-1-bootstrap-v0-0} Task is being killed and will not recover until manually restarted (org.apache.kafka.connect.runtime.WorkerTask)
0.8.3.Final with the same database works like a champ. May be a regression of DBZ-114.
