Tablespace import issue with auto_increment columns - MySQL Bug

MySQL & MariaDB Percona Server for MySQL 8.0
1

I can export and import tables using tablespace. However I am running into MySQL bug as reported here.

https://bugs.mysql.com/bug.php?id=100965

import table which contain auto_increment column, then restart the DB server, insert the new row, it will report error : ERROR 1062 (23000): Duplicate entry ‘1’ for key ‘t2.PRIMARY’ the mysql-test script as follow.

Is there a workaround to this problem? Any MySQL command to force the MySQL to adhere to appropriate auto increment values?

This bug has been marked as normal for the MySQL side so I don’t know when it will get fixed.

1 Like
2

I have figured out the solution and it is working. I have posted it on the original ticket itself. I am posting it here for the reference again.

The idea is to reset the AUTO_INCREMENT after the import.

ALTER TABLE <table_name> AUTO_INCREMENT = 0;

1 Like