Details
-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
None
Description
Hi @jpechane
I'm facing following issue on prod can you pls suggest me the solution for this. Thank you.
org.apache.kafka.connect.errors.ConnectException: Text '0000-00-00 00:00:00' could not be parsed, unparsed text found at index 10 mysql-connect | at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:230) mysql-connect | at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:208) mysql-connect | at io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:477) mysql-connect | at com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1095) mysql-connect | at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:943) mysql-connect | at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:580) mysql-connect | at com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:825) mysql-connect | at java.lang.Thread.run(Thread.java:748) mysql-connect | Caused by: java.time.format.DateTimeParseException: Text '0000-00-00 00:00:00' could not be parsed, unparsed text found at index 10 mysql-connect | at java.time.format.DateTimeFormatter.parseResolved0(DateTimeFormatter.java:1952) mysql-connect | at java.time.format.DateTimeFormatter.parse(DateTimeFormatter.java:1777) mysql-connect | at io.debezium.connector.mysql.MySqlDefaultValuePreConverter.convertToLocalDate(MySqlDefaultValuePreConverter.java:100) mysql-connect | at io.debezium.connector.mysql.MySqlDefaultValuePreConverter.convert(MySqlDefaultValuePreConverter.java:59) mysql-connect | at io.debezium.connector.mysql.antlr.listener.ColumnDefinitionParserListener.convertDefaultValueToSchemaType(ColumnDefinitionParserListener.java:261) mysql-connect | at io.debezium.connector.mysql.antlr.listener.ColumnDefinitionParserListener.enterDefaultValue(ColumnDefinitionParserListener.java:129) mysql-connect | at io.debezium.ddl.parser.mysql.generated.MySqlParser$DefaultValueContext.enterRule(MySqlParser.java:46631) mysql-connect | at io.debezium.antlr.ProxyParseTreeListenerUtil.delegateEnterRule(ProxyParseTreeListenerUtil.java:46) mysql-connect | at io.debezium.connector.mysql.antlr.listener.MySqlAntlrDdlParserListener.enterEveryRule(MySqlAntlrDdlParserListener.java:89) mysql-connect | at org.antlr.v4.runtime.tree.ParseTreeWalker.enterRule(ParseTreeWalker.java:41) mysql-connect | at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:25) mysql-connect | at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) mysql-connect | at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) mysql-connect | at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) mysql-connect | at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) mysql-connect | at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) mysql-connect | at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) mysql-connect | at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) mysql-connect | at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) mysql-connect | at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28) mysql-connect | at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:85) mysql-connect | at io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:304) mysql-connect | at io.debezium.connector.mysql.BinlogReader.handleQueryEvent(BinlogReader.java:663) mysql-connect | at io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:461)
Attachments
Issue Links
- relates to
-
DBZ-3511 Exception on altering DATE fields with malformed default value
- Open