Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-2478

DateTimeParseException(Text '0000-00-00 00:00:00' could not be parsed, unparsed text found at index 10)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • Backlog
    • None
    • mysql-connector
    • 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

          Activity

            People

              jpechane Jiri Pechanec
              kushalreddy Kushal Reddy (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: