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

Strange auto_increment counter setting changes on direct upgrade from 10.1 to 10.3

    XMLWordPrintable

Details

    Description

      After a direct upgrade from 10.1.40 to 10.3.17, SHOW CREATE TABLE output in mysqldump shows correct AUTO_INCREMENT counter values on the first two tables, but then flips to

      Before the upgrade:

      ENGINE=InnoDB AUTO_INCREMENT=2284
      ENGINE=InnoDB AUTO_INCREMENT=4763
      ENGINE=InnoDB AUTO_INCREMENT=1621982
      ENGINE=InnoDB AUTO_INCREMENT=3
      ENGINE=InnoDB AUTO_INCREMENT=1395246
      ENGINE=InnoDB AUTO_INCREMENT=927
      ...
      

      becomes this after upgrade:

      ENGINE=InnoDB AUTO_INCREMENT=2284
      ENGINE=InnoDB AUTO_INCREMENT=4763
      ENGINE=InnoDB AUTO_INCREMENT=4784423209
      ENGINE=InnoDB AUTO_INCREMENT=4784423220
      ENGINE=InnoDB AUTO_INCREMENT=4784423231
      ENGINE=InnoDB AUTO_INCREMENT=4784423242
      ...
      

      Note how starting with the third auto-inrement table the counter becomes way higher then originally, and then gets incremented by 11 for each following table.

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              hholzgra Hartmut Holzgraefe
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.