Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12340

mysqldump with single-transaction on slave doesn't stop applying binlogs

    XMLWordPrintable

Details

    Description

      I have MariaDB replica server for making consistent database dumps, and after the latest update I noticed that mysqldump with --single-transaction option does not stop applying binary logs, e.g. Seconds_Behind_Master not increasing and Exec_Master_Log_Pos counter increasing during dump. I have all data in INNODB tables, and such --single-transaction behaviour looks odd. My mysqldump options are:
      --force --quick --single-transaction --routines --triggers

      Changing --single-transaction to --lock-all-tables - locking tables, and I see correct blocking database from changes during mysqldump.

      Please check current mysqldump with --single-transaction option behaviour.

      Attachments

        Activity

          People

            Unassigned Unassigned
            kpvadm Pavel Kaidalov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.