[Koha] DBMS auto increment

Scott Owen sowen at almaschools.net
Thu Sep 23 07:37:21 NZST 2021

Hi All,


Is this still the best procedure when getting the following error ?


You should not ignore this warning.

The problem is that InnoDB does not keep auto_increment across SQL server
restarts (it is only set in memory). So on server startup the
auto_increment values are set to max(table.id)+1.

To know how to avoid this problem see the related wiki page: DBMS auto
increment fix <https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix>
Problems foundCheckouts

The following ids exist in both tables issues and old_issues:

4782, 4781


Any sql to clean things up in the two tables ?

More information about the Koha mailing list