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

DateTimeParseException: Text '0001-01-01 BC' could not be parsed, unparsed text found at index 10

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • 2.4-backlog
    • 1.8.0.Final
    • postgresql-connector
    • None
    • False
    • False

      Hi, there was an error trying to process an event coming from postgres.

      I noticed that this error had already been dealt with, but it doesn't seem to fit this situation.

       

         Caused by: org.apache.kafka.connect.errors.ConnectException: java.time.format.DateTimeParseException: Text '0001-01-01 BC' could not be parsed, unparsed text found at index 10
      	at io.debezium.connector.postgresql.connection.wal2json.DateTimeFormat$ISODateTimeFormat.format(DateTimeFormat.java:154) ~[debezium-connector-postgres-1.8.0.Final.jar!/:1.8.0.Final]
      	at io.debezium.connector.postgresql.connection.wal2json.DateTimeFormat$ISODateTimeFormat.date(DateTimeFormat.java:135) ~[debezium-connector-postgres-1.8.0.Final.jar!/:1.8.0.Final]
      	at io.debezium.connector.postgresql.connection.AbstractColumnValue.asLocalDate(AbstractColumnValue.java:44) ~[debezium-connector-postgres-1.8.0.Final.jar!/:1.8.0.Final]
      	at io.debezium.connector.postgresql.connection.ReplicationMessageColumnValueResolver.resolveValue(ReplicationMessageColumnValueResolver.java:103) ~[debezium-connector-postgres-1.8.0.Final.jar!/:1.8.0.Final]
      	at io.debezium.connector.postgresql.connection.pgoutput.PgOutputReplicationMessage.getValue(PgOutputReplicationMessage.java:97) ~[debezium-connector-postgres-1.8.0.Final.jar!/:1.8.0.Final]
      	at io.debezium.connector.postgresql.connection.pgoutput.PgOutputMessageDecoder$1.getValue(PgOutputMessageDecoder.java:729) ~[debezium-connector-postgres-1.8.0.Final.jar!/:1.8.0.Final]
      	at io.debezium.connector.postgresql.PostgresChangeRecordEmitter.columnValues(PostgresChangeRecordEmitter.java:185) ~[debezium-connector-postgres-1.8.0.Final.jar!/:1.8.0.Final]
      	at io.debezium.connector.postgresql.PostgresChangeRecordEmitter.getNewColumnValues(PostgresChangeRecordEmitter.java:128) ~[debezium-connector-postgres-1.8.0.Final.jar!/:1.8.0.Final]
      	at io.debezium.relational.RelationalChangeRecordEmitter.emitCreateRecord(RelationalChangeRecordEmitter.java:68) ~[debezium-core-1.8.0.Final.jar!/:1.8.0.Final]
      	at io.debezium.relational.RelationalChangeRecordEmitter.emitChangeRecords(RelationalChangeRecordEmitter.java:46) ~[debezium-core-1.8.0.Final.jar!/:1.8.0.Final]
      	at io.debezium.connector.postgresql.PostgresChangeRecordEmitter.emitChangeRecords(PostgresChangeRecordEmitter.java:97) ~[debezium-connector-postgres-1.8.0.Final.jar!/:1.8.0.Final]
      	at io.debezium.pipeline.EventDispatcher.dispatchDataChangeEvent(EventDispatcher.java:215) ~[debezium-core-1.8.0.Final.jar!/:1.8.0.Final]
      	... 17 common frames omitted
      Caused by: java.time.format.DateTimeParseException: Text '0001-01-01 BC' could not be parsed, unparsed text found at index 10
      	at java.time.format.DateTimeFormatter.parseResolved0(DateTimeFormatter.java:1952) ~[na:1.8.0_275]
      	at java.time.format.DateTimeFormatter.parse(DateTimeFormatter.java:1851) ~[na:1.8.0_275]
      	at java.time.LocalDate.parse(LocalDate.java:400) ~[na:1.8.0_275]
      	at io.debezium.connector.postgresql.connection.wal2json.DateTimeFormat$ISODateTimeFormat.lambda$date$0(DateTimeFormat.java:135) ~[debezium-connector-postgres-1.8.0.Final.jar!/:1.8.0.Final]
      	at io.debezium.connector.postgresql.connection.wal2json.DateTimeFormat$ISODateTimeFormat.format(DateTimeFormat.java:150) ~[debezium-connector-postgres-1.8.0.Final.jar!/:1.8.0.Final]
      	... 28 common frames omitted

       

       

            Unassigned Unassigned
            tiagogouribeiro Tiago Ribeiro (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: