Hey everyone! I have a Postgres source with incremental syncing (no CDC), which failed after updating the source connector to a version larger than 1.0.30. I am seeing this message in the log:

Stack Trace: org.postgresql.util.PSQLException: ERROR: syntax error at or near "FROM"
  Position: 30

and

"failureOrigin" : "source",
  "failureType" : "system_error",
  "internalMessage" : "org.postgresql.util.PSQLException: ERROR: syntax error at or near \"FROM\"\n  Position: 30",
  "externalMessage" : "Something went wrong in the connector. See the logs for more details.",
  "metadata" : {
    "attemptNumber" : 2,
    "jobId" : 392,
    "from_trace_message" : true,
    "connector_command" : "read"
  },

I can revert to version 1.0.30, and then the error disappears. Does anyone have the same issue or know what this could be? Thanks!

Hi Nils! This is a GA connector so it should be well supported. Are you on the latest version of Airbyte?

Hi @Nataly Merezhuk (Airbyte) sorry for the late reply! I am on version 0.40.25!

I see - could you give me the full logs? They might shed light on what's going on. And then if we can't figure this out I'll open an issue!

Okido! I will check where I can find the logs!

If anyone is still looking for an answer, a user has reported that the new postgres source connector version 1.0.38 resolved the issue 🙂