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

[Draft] Dump created by mysqldump is not loadable

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11
    • N/A
    • None
    • None

    Description

      Reproducible at least on 10.11 (including previous 10.11 releases), needs cleaning and eventually converting into MTR.
      The upgrade (restore) scenario, fails on dump upgrade because the dump fails to load into the new server with

      ERROR 1180 (HY000) at line 4546: Got error 1 "Operation not permitted" during COMMIT
      

      Most likely the dump contains a duplicate key, need to find out where it comes from. There are no unique blobs in the table, the enum/set column is a suspect.

      MariaDB/randgen 44ff68b26612faef806f4a8f126c04cff72ac1fb

      perl ./run.pl --base-port=14000 --basedir=/data/bld/10.11.14-asan --compatibility=101199 --duration=180 --engine=InnoDB --filter=conf/ff/restrict_dynamic_vars.ff --gendata=advanced --gendata=simple --grammar=conf/yy/concurrent.yy --grammar=conf/yy/dml-ps-params.yy --grammar=conf/yy/dml.yy --mysqld=--aria_recover_options=NORMAL --mysqld=--character-set-server=utf8 --mysqld=--collation-server=utf8_polish_ci --mysqld=--default-tmp-storage-engine=HEAP --mysqld=--delay_key_write=OFF --mysqld=--innodb-lock-wait-timeout=5 --mysqld=--lock-wait-timeout=10 --mysqld=--max-statement-time=20 --mysqld=--mysql56_temporal_format=OFF --mysqld=--plugin-maturity=experimental --mysqld=--slave-transaction-retry-errors="" --queries=1000000 --reporters=Backtrace,Deadlock,FeatureUsage,UniqueConstraintValidity --scenario=MariaBackupIncremental --scenario=NormalUpgrades   --threads=8 --vardir=/ssd/logs/var-rqg0 --variator=DisableOptimizations --variator=EnableOptimizations --variator=ExecuteAsSPTwice --variator=InlineSubqueries --seed=1769556357
      

      Attachments

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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