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

              Assignee:
              marko Marko Mäkelä
              Reporter:
              hholzgra Hartmut Holzgraefe
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: