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

Restoring the database using mysql and .sql file name results in ERROR 1556 (HY000) at line 819: You can't use locks with log tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • None
    • N/A
    • OTHER
    • None

    Description

      I am facing this issue when try to restore the database that was dumped using mysqldump utility.
      This is the command that I am using to take dump of the database

      mysqldump --column-statistics=0 -u root --password=${root_password} -h <host> --single-transaction  --all-databases
      

      now if I try to restore the things using the `.sql` file that is generated by above command, this is the error that I get

      ERROR 1556 (HY000) at line 819: You can't use locks with log tables
      

      so I tried to exclude the log table that are in mysql database, while taking dump and modified the command to

      mysqldump --column-statistics=0 -u root --password=${root_password} -h <host> --single-transaction --ignore-table=mysql.slow_log --ignore-table=mysql.general_log  --all-databases
      

      and even after this command it looks like the logs tables are there in the backup `.sql` and I get the same error while restore.

      I have seen at some places that this error can be ignored. So here are some questions
      1. Can/Should we ignore the error that we are getting while restore
      2. Why are we not able to exclude log tables from the mysqldump command (this is more related to mysqldump than maria I think)

      Attachments

        Activity

          People

            Unassigned Unassigned
            viveksinghggits Vivek Singh
            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.