Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.11.2, 10.10.3, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
-
Ubuntu 22.04.2 LTS, Hyper-V virtual machine
Description
I imported sql dump from MySQL 5.5.62 to MariaDB. Imported file has about 2GB. Import was successful, but after MariaDB restart AUTO_INCREMENT values on some tables changed (for example: on table with max ID 11504 AUTO_INCREMENT changed from 11505 to 2).
After some testing I figured out that removing UNIQUE_CHECKS option from import file fixes this. I cannot see any common cause, some affected tables have unique keys and some doesn't. There are no errors on log or anywhere. Import was tested on newly installed Ubuntu server without any additional software running.
What other information should I provide?
SQL dump was created with mysqldump Ver 10.13 Distrib 5.5.62:
mysqldump -p --single-transaction --no-create-db --no-create-info --skip-add-drop-table --skip-comments "database_name" > db.sql
|
Command for file import:
mariadb -u root "database_name" < "db.sql"
|
Attachments
Issue Links
- causes
-
MDEV-32008 auto_increment value on table increments by one after restart
- Closed
- is caused by
-
MDEV-24621 In bulk insert, pre-sort and build indexes one page at a time
- Closed