Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4948

Making Postgres `PSQLException: This connection has been closed.` retriable

    XMLWordPrintable

Details

    • False
    • None
    • False

    Description

      This error results in the entire connector completely crashing and usually happens when our cloud provider primary server has a network glitch or restart. I feel it should be a retriable error over here https://github.com/debezium/debezium/blob/main/debezium-connector-postgres/src/main/java/io/debezium/connector/postgresql/PostgresErrorHandler.java.

      This type of error also appears to be retriable in SQL Server but not for Postgres?

      https://github.com/debezium/debezium/blob/main/debezium-connector-sqlserver/src/main/java/io/debezium/connector/sqlserver/SqlServerErrorHandler.java#L33

      If this error cannot be made retriable, may I know the main reason why?

      Attachments

        Activity

          People

            Unassigned Unassigned
            yzia2000 Mohammad Yousuf Minhaj Zia (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: