[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