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

mysqldump uses MASTER_LOG_POS with dump-slave

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.11, 11.0(EOL), 11.2(EOL), 11.3(EOL), 11.4
    • 10.11.8, 11.0.6, 11.1.5, 11.2.4
    • Backup
    • None

    Description

      mysqldump access 21 index of result array from show slave status as master_log_pos.
      Commit 1a057a9 adds column Replicate_Rewrite_DB and move Exec_Master_Log_Pos to 22 position.

      This causes dump-slave option to put wrong value in to MASTER_LOG_POS in dump file.

      Attachments

        Activity

          knielsen Kristian Nielsen added a comment -

          Thanks a lot for the informative bug report.

          It's not just mysqldump that is the problem, this will break 3rd-party and user scripts as well that rely on the output of SHOW SLAVE STATUS.

          The patch 1a057a9 is wrong and needs to be reverted. The output of SHOW SLAVE STATUS must not be changed except to add additional rows at the end, to preserve backwards compatibility.

          It's particularly embarrassing to see a change like this go in and break backwards compatibility not just with user's and 3rd-party's scripts, but with a command-line utility mysqldump included with the MariaDB source code itself

          knielsen Kristian Nielsen added a comment - Thanks a lot for the informative bug report. It's not just mysqldump that is the problem, this will break 3rd-party and user scripts as well that rely on the output of SHOW SLAVE STATUS. The patch 1a057a9 is wrong and needs to be reverted. The output of SHOW SLAVE STATUS must not be changed except to add additional rows at the end , to preserve backwards compatibility. It's particularly embarrassing to see a change like this go in and break backwards compatibility not just with user's and 3rd-party's scripts, but with a command-line utility mysqldump included with the MariaDB source code itself

          People

            knielsen Kristian Nielsen
            ghost Wojciech Matusiak
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.