[Koha] auto_increment problem with holds in Koha 21.11

[Jonathan Druart]

Do you have the init-file trick setup correctly?

https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Current_Solution

Le jeu. 27 avr. 2023 à 10:06, Michael Kuhn <mik at adminkuhn.ch> a écrit :
>
> Hi
>
> We are working on Debian GNU/Linux 10 with MariaDB 10.3.38 and Koha
> 21.11.09.
>
> Since about September 2022 after the update from Koha 18.11 to 21.11 we
> see auto_increment problems with tables "reserves" and "old_reserves"
> (but NOT with any of the other tables):
>
>   The following ids exist in both tables reserves and old_reserves:
>
>   372
>
> In fact every single hold evokes the problem. Deleting the id manually
> from table "old_reserves" does always solve the problem:
>
>   DELETE FROM old_reserves WHERE reserve_id IN (372);
>
> According to
> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix the
> auto_increment problem should not occur at all after Koha 17.05.
>
> What could be the reason for this behavior?
>
> Best wishes: Michael
> --
> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> T 0041 (0)61 261 55 61 · E mik at adminkuhn.ch · W www.adminkuhn.ch
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha