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 m...@adminkuhn.ch · W www.adminkuhn.ch
_______________________________________________

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to