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

          is part of

          Task - A task that needs to be done. MDEV-22357 Clearing InnoDB autoincrement counter when upgrading from MariaDB < 10.2.4

          • Major - Major loss of function.
          • Open
          relates to

          Task - A task that needs to be done. MDEV-6076 Persistent AUTO_INCREMENT for InnoDB

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22167 auto_increment counters changed weirdly after direct 10.1 -> 10.3 upgrade

          • Major - Major loss of function.
          • Closed

          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.