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

Sqlserver connector block cdc cleanup job

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Major
    • 1.3.0.Final
    • 0.9.5.Final
    • sqlserver-connector
    • None
    • Hide

      Just run the connector on a large number of tables (> 100) and a large message flow (> 2000 / s).

      Show
      Just run the connector on a large number of tables (> 100) and a large message flow (> 2000 / s).

    Description

      Because of jdbcConnection.setAutoCommit(false) , I have a never ending transaction that blocks the CDC cleanup task.

      setAutoCommit(false) made transaction implicit and i think i got this
      https://www.brentozar.com/archive/2018/02/set-implicit_transactions-one-hell-bad-idea/

      After setAutoCommit to True, the problem disappears.

      Attachments

        Activity

          People

            Unassigned Unassigned
            manve88 Viktor Bobrov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: