Details
-
Bug
-
Resolution: Done
-
Blocker
-
0.7.5
-
None
Description
Hi, I need help with Debezium Postgres Source connector (or confirmation what I observe is a bug)
I see this error:
ERROR Failed to properly convert data value for 'public.dbo.testmssqltable.DateTime_Test' of type timestamp for row [...]: (io.debezium.relational.TableSchemaBuilder)
java.time.DateTimeException: Invalid value for NanoOfSecond (valid values 0 - 999999999): -57000000
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 java.time.LocalDateTime.of(LocalDateTime.java:362)
at io.debezium.time.Conversions.toLocalDateTime(Conversions.java:140)
at io.debezium.time.NanoTimestamp.toEpochNanos(NanoTimestamp.java:68)
at io.debezium.jdbc.JdbcValueConverters.convertTimestampToEpochNanos(JdbcValueConverters.java:479)
but only for initial load or first batch of records streamed
All records that follow are streamed correctly (with timestamps that have negative values)
Moreover if in initial records there is no negative timestamp, then this error is not present at all.
The result is a streamed record without value in this timestamp column, which prevents us from using this connector.