[Koha] DBMS auto increment problem

shankar reddy Kolle stkolle at gmail.com
Mon Oct 15 23:34:00 NZDT 2018


Dear sir/madam
We have installed Koha in 16.04 Ubuntu using package method. The koha
version installed is 18.05.02.000. mysql Ver 15.1 Distrib 10.0.36-MariaDB,
for debian-linux-gnu (x86_64) using readline 5.2.

We have come across the problem:
Data problems

Some of your tables have problems with their auto_increment values which
may lead to data loss.

*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 found Items

The following ids exist in both tables *items* and *deleteditems*:

102358
-- 
Best regards
Dr. Shankar Reddy Kolle


More information about the Koha mailing list