Incremental snapshot interrupted by schema retrieval failure

[Brigitte Izabella]

Hello,

I am trying to run incremental snapshots on a few big tables with more than 1G rows, and every time the connector (postgresql) is restarted, the snapshot ends as completed, with status=UNKNOWN_SCHEMA, and with the following warning: "Schema retrieval failed due to an exception for <table name>". 

I am using debezium 3.1.3.Final.
I have tried to increase the snapshot.delay.ms configuration to 1 minute in order to leave some time for the connector to ingest a WAL event on the table, but it doesn't work. 

Do you have any ideas what could be the issue? Thank you!

 

[jiri.p...@gmail.com]

Hi,

could you please try Debezium 3.4?

Jiri

[jiri.p...@gmail.com]

Still, it would be good to give it a test ride before we will dive into deep investigation. Still I'd like to remind that current maintained version is 3.4 so even if the issue is identified we are not going to do another 3.1 release.

Jiri