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

Clarify Debezium Server documentation for signaling via source table channel

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Unresolved
    • Icon: Minor Minor
    • 3.4.0.Beta1
    • None
    • documentation
    • None
    • Important

      Which use case/requirement will be addressed by the proposed feature?

      The current Debezium Server documentation for signaling via table channel (source) is missing some essential configuration details that are required for the feature to work correctly.

      Implementation ideas (optional)

      The Debezium Server documentation should explicitly mention that when signaling is enabled through a table channel, the signal table must be included in the connector configuration:

      1. Add the signal table (<db>.debezium_signal) to debezium.source.table.include.list.
      2. Add the table’s columns (id, type, data) to debezium.source.column.include.list.
      3. Without these entries, the signaling mechanism fails silently with the warning: The signal event 'Struct{}' should have 3 fields but has 0

      Additionally, the documentation should state that the Debezium source database user must have write (INSERT) permissions on the signal table.
      Without this permission, the connector will fail with an error similar to:

      Caused by: java.sql.SQLSyntaxErrorException: INSERT command denied to user 'debezium'@'...' for table 'debezium_signal'

              Unassigned Unassigned
              jfelipends José Felipe Nunes da Silva
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: