[Koha] DBMS auto increment problem

[Jonathan Druart]

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 at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>