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

MySQL Connector should use "snapshot.lock.timeout.ms"

    Details

      Description

      I'd like to modify the snapshot to set lock_wait_timeout equal to the value of "snapshot.lock.timeout.ms", defined in RelationalDatabaseConnectorConfig. This will allow the connector to wait to acquire a lock on the database during snapshot, rather than failing right away.

      If there is an existing exclusive lock on the database during the snapshot steps, a connector with default configuration will fail on lock wait timeout (LWTO), while running

      FLUSH TABLES WITH READ LOCK;

      link
      and then later exit on

      FLUSH TABLES [table_list] WITH READ LOCK;

      link

      I've attached logs from the failure described above to the issue.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                johnjmartin John Martin
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: