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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: N/A
    • Component/s: OTHER
    • Labels:
      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

            Assignee:
            Unassigned Unassigned
            Reporter:
            viveksinghggits Vivek Singh
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration