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

Warnings and notifications from PostgreSQL are ignored by the connector until the connection is closed

    XMLWordPrintable

Details

    Description

      Run Debezium on a PostgreSQL cluster that is generating warnings, in our case it was with the wal2json plugin with a badly configured setup containing a table with no primary keys. So it was constantly generating the following warnings

       

      table "blah" without primary key or replica identity is nothing
      CONTEXT: slot "debezium", output plugin "wal2json", in the change callback, associated LSN 1E5C/A250A154

       

      This bug seems to have been fixed within DBZ-279 but then parts of the fix, mainly the processing of warnings every n reads was removed within DBZ-258, I believe from a possible merge error as within the review/PR I see no mention of why it was removed (https://github.com/debezium/debezium/pull/290/files#diff-3a5f1faacab73b62ee731f00e38fe609300a5cc0cdc00a8a8b4351651f7147a1L175).

       

       

      Attachments

        Activity

          People

            jpechane Jiri Pechanec
            stevendpclark Steven Clark (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: