[Koha] auto_increment problem with holds in Koha 21.11

[Michael Kuhn]

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