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

10.3 server is not compatible with previous versions of mysqldump

    XMLWordPrintable

Details

    Description

      mysqldump of 10.2 cannot dump mysql database of 10.3, it fails with

      mysqldump: Got error: 1556: "You can't use locks with log tables" when using LOCK TABLES
      

      due to mysql.transaction_registry table. The change is apparently intentional, since 10.3 mysqldump has special logic to deal with it, introduced by the commit below (and possibly more):

      commit af88c662527e9a989fe44e653c2e7adde29f3876
      Author: Aleksey Midenkov
      Date:   Wed Nov 15 14:46:13 2017 +0300
       
          SQL,Client: mysqldump for TRT fix [#302]
          
          Test results:
          main.
          mysqldump
          mysqldump-max
          mysqld--help
          openssl_1
      

      This unfortunate incompatibility needs to be documented somewhere.

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.