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

Exception on altering DATE fields with malformed default value

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor Minor
    • 1.9-backlog
    • 1.4.2.Final
    • mysql-connector
    • None
    • False
    • False
    • Undefined
    • Hide
      1. Create table with DATE field
      2. Configure connector to monitor this table
      3. Perform alter on this table with query {{}} 
        ALTER TABLE test_table_1 ALTER COLUMN data_type_DATE SET DEFAULT 123
      Show
      Create table with DATE field Configure connector to monitor this table Perform alter on this table with query {{}} ALTER TABLE test_table_1 ALTER COLUMN data_type_DATE SET DEFAULT 123

      When altering MySQL with query

      ALTER TABLE test_table_1 ALTER COLUMN data_type_DATE SET DEFAULT 123

      Connector fails with message

      connect_1 | 2021-04-29 11:40:02,435 ERROR || WorkerSourceTask{id=mysql-connector-0} Task threw an uncaught and unrecoverable exception [org.apache.kafka.connect.runtime.WorkerTask] connect_1 | org.apache.kafka.connect.errors.ConnectException: Text '123' could not be parsed at index 0 connect_1 | at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:241) connect_1 | at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:218) connect_1 | at io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:607) connect_1 | at com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1104) connect_1 | at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:955) connect_1 | at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:595) connect_1 | at com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:839) connect_1 | at java.base/java.lang.Thread.run(Thread.java:834) connect_1 | Caused by: java.time.format.DateTimeParseException: Text '123' could not be parsed at index 0

       
       
      123 Is not a valid value for DATE field, but MySQL accepts this alter query and sets default value to 2020-01-23

            Unassigned Unassigned
            oryzhenko Oleksandr Ryzhenko (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: