-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
0.9.0.Final
-
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.