DBMS auto increment problem
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
Hello, Did you read the wiki page pointed by the URL in the warning message? If so, which part did not you understand? Regards, Jonathan On Mon, 15 Oct 2018 at 07:34 shankar reddy Kolle <stkolle@gmail.com> wrote:
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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Jonathan Druart -
shankar reddy Kolle