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

Cannot parse time(7) data type

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • 0.9.0.Final
    • sqlserver-connector
    • None

      If there is a column of type `time(7)` Debezium fails to parse it:

      2019-05-23 14:02:05,432 ERROR Failed to properly convert data value for 'XXXXX' of type time for row [7, 2, 2017-01-30, null, 1, 0, 00:00:00, 1, 34299, 00:00:01, 2, null, null, 1, 13738, 00:00:01, 2017-01-29 20:00:00.447, 1, 00:00:03]: (io.debezium.relational.TableSchemaBuilder:222)
      java.time.DateTimeException: Invalid value for NanoOfSecond (valid values 0 - 999999999): -417000000
              at java.time.temporal.ValueRange.checkValidValue(ValueRange.java:311)
              at java.time.temporal.ChronoField.checkValidValue(ChronoField.java:703)
              at java.time.LocalTime.of(LocalTime.java:342)
              at io.debezium.time.Conversions.toLocalTime(Conversions.java:89)
              at io.debezium.time.MicroTime.toMicroOfDay(MicroTime.java:67)
              at io.debezium.jdbc.JdbcValueConverters.lambda$convertTimeToMicrosPastMidnight$36(JdbcValueConverters.java:529)
              at io.debezium.jdbc.JdbcValueConverters.convertValue(JdbcValueConverters.java:1165)
              at io.debezium.jdbc.JdbcValueConverters.convertTimeToMicrosPastMidnight(JdbcValueConverters.java:527)
              at io.debezium.jdbc.JdbcValueConverters.lambda$converter$15(JdbcValueConverters.java:292)
              at io.debezium.relational.TableSchemaBuilder.lambda$createValueGenerator$2(TableSchemaBuilder.java:214)
              at io.debezium.relational.TableSchema.valueFromColumnData(TableSchema.java:135)
              at io.debezium.relational.RelationalChangeRecordEmitter.emitReadRecord(RelationalChangeRecordEmitter.java:75)
              at io.debezium.relational.RelationalChangeRecordEmitter.emitChangeRecords(RelationalChangeRecordEmitter.java:43)
              at io.debezium.pipeline.EventDispatcher.dispatchSnapshotEvent(EventDispatcher.java:89)
              at io.debezium.relational.HistorizedRelationalSnapshotChangeEventSource.createDataEventsForTable(HistorizedRelationalSnapshotChangeEventSource.java:343)
              at io.debezium.relational.HistorizedRelationalSnapshotChangeEventSource.createDataEvents(HistorizedRelationalSnapshotChangeEventSource.java:296)
              at io.debezium.relational.HistorizedRelationalSnapshotChangeEventSource.execute(HistorizedRelationalSnapshotChangeEventSource.java:146)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:80)
              at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
              at java.util.concurrent.FutureTask.run(FutureTask.java:266)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
              at java.lang.Thread.run(Thread.java:745)
      

      In result, corresponding columns have null value.

            Unassigned Unassigned
            grzegorz.kolakowski Grzegorz Kołakowski (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: