Getting the error below, any insight?
```2022-08-1...
# advice-data-ingestionr
Rocky Appiah
08/19/2022, 4:33 PMGetting the error below, any insight?
Copy code
2022-08-19 15:54:53 source > 2022-08-19 15:54:53 ERROR i.d.p.ErrorHandler(setProducerThrowable):35 - Producer failure
2022-08-19 15:54:53 source > io.debezium.DebeziumException: java.time.format.DateTimeParseException: Text '0' could not be parsed at index 0
2022-08-19 15:54:53 source > at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:85) ~[debezium-core-1.9.2.Final.jar:1.9.2.Final]g
gunu
08/21/2022, 11:48 PMa few people running into this issue now
https://discuss.airbyte.io/t/potgres-sync-fail-after-update-0-4-0-1-0-2/2270/4
must be due to an update on the cursor field for incremental models. see PR https://github.com/airbytehq/airbyte/pull/14356
gunu
08/21/2022, 11:49 PMif you’re using MySQL source, reverting back to
0.6.2r
Ryan
08/22/2022, 5:31 PM@Rocky Appiah would you be willing to share the logs on this github issue that was filed? Our team is actively prioritizing this error
r
Rocky Appiah
08/22/2022, 6:06 PM@Ryan: yes, will do
Rocky Appiah
08/22/2022, 6:08 PMnote: source is postgres, not mysql
Rocky Appiah
08/22/2022, 6:08 PMShould I change postgres to 1.0.0?
Rocky Appiah
08/22/2022, 6:08 PMor 1.0.1?
s
Subodh (Airbyte)
08/22/2022, 6:10 PM
Can you also share the schema of the tables so that we can reproduce this on our end
r
Ryan Fu (Airbyte)
08/22/2022, 6:54 PM@Rocky Appiah I would suggest you revert back to the previous version of
source-postgresr
Rocky Appiah
08/22/2022, 7:39 PM Copy code
\d audit;
Table "public.audit"
Column | Type | Collation | Nullable | Default
------------+-----------------------------+-----------+----------+-----------------------------------
id | integer | | not null | nextval('audit_id_seq'::regclass)
objectid | text | | |
accountid | text | | |
created | timestamp without time zone | | | now()
eventtime | timestamp without time zone | | |
meta | jsonb | | |
token | text | | |
action | text | | |
objecttype | text | | |
originator | text | | |
Indexes:
"audit_pkey" PRIMARY KEY, btree (id)
"audit_accountid" btree (accountid)
"audit_action" btree (action)
"audit_cardreport_originator" btree (originator) WHERE originator = 'CARD_REPORT'::text
"audit_objectid" btree (objectid)
"audit_objecttype" btree (objecttype)
"audit_time" btree (eventtime)
"auditmeta" gin (meta jsonb_path_ops)
Publications:
"airbyte_publication"Rocky Appiah
08/22/2022, 7:39 PMthat’s what the table looks like
Rocky Appiah
08/22/2022, 7:40 PMuploaded log file to issue here as requested.
s
Subodh (Airbyte)
08/23/2022, 6:32 PM
Fix for postgres has been merged and published, version 1.0.4 should work without this issue
r
Rocky Appiah
08/23/2022, 7:50 PMthanks - will test shortly!
Rocky Appiah
08/23/2022, 7:56 PMit worked!!! awesome, thank you.
4 Views