[Koha] Reoccurring DBMS auto increment issue

[Michael Kuhn]

Hi Jonathan

 > Nothing in plack-error.log?
 > If you have a 500 you should see something useful there.

No, sorry - absolutely nothing in "plack-error.log".

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



> Le mar. 22 juin 2021 à 09:48, Michael Kuhn <mik at adminkuhn.ch> a écrit :
>>
>> Hi Jonathan
>>
>> You wrote:
>>
>>   > Hi Michael, what do you have in the Koha log files?
>>
>> When trying to delete a user, logfile "/var/log/koha/embl/plack.log" says:
>>
>> 192.168.210.80 - - [21/Jun/2021:17:16:58 +0200] "GET
>> /intranet/members/deletemem.pl?member=83 HTTP/1.1" 200 32438
>> "https://libcatalog-testusers.embl.de/cgi-bin/koha/members/moremember.pl?borrowernumber=84"
>> "Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Firefox/78.0"
>> 192.168.210.80 - - [21/Jun/2021:17:17:44 +0200] "GET
>> /intranet/members/deletemem.pl?csrf_token=9aea7e6464047b5c52c5ee3c6af5955bbf1b78a6%2Cbfb8e2961b2275e44a1fa49235060091ccece7fe%2C1624288618&member=83&op=delete_confirmed
>> HTTP/1.1" 500 136
>> "https://libcatalog-testusers.embl.de/cgi-bin/koha/members/deletemem.pl?member=84"
>> "Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Firefox/78.0"
>>
>> At the same time "/var/log/apache2/other_vhosts_access.log" says:
>>
>> libcatalog-test.embl.de:443 192.168.210.80 - - [21/Jun/2021:17:16:58
>> +0200] "GET /cgi-bin/koha/members/deletemem.pl?member=83 HTTP/1.1" 200
>> 7192
>> "https://libcatalog-testusers.embl.de/cgi-bin/koha/members/moremember.pl?borrowernumber=84"
>> "Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Firefox/78.0"
>> libcatalog-test.embl.de:443 192.168.210.80 - - [21/Jun/2021:17:17:44
>> +0200] "GET
>> /cgi-bin/koha/members/deletemem.pl?csrf_token=9aea7e6464047b5c52c5ee3c6af5955bbf1b78a6%2Cbfb8e2961b2275e44a1fa49235060091ccece7fe%2C1624288618&member=83&op=delete_confirmed
>> HTTP/1.1" 500 532
>> "https://libcatalog-testusers.embl.de/cgi-bin/koha/members/deletemem.pl?member=84"
>> "Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Firefox/78.0"
>>
>>
>> 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
>>
>>
>>
>>> Le lun. 21 juin 2021 à 21:01, Michael Kuhn <mik at adminkuhn.ch> a écrit :
>>>>
>>>> Hi
>>>>
>>>> We are working with Debian GNU/Linux 10, MariaDB 10.3.27 and Koha
>>>> 20.11.00 (using Shibboleth authentication).
>>>>
>>>> To avoid auto increment issues we have implemented the solution
>>>> described in
>>>> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Single_instance_setup
>>>> - of course replacing "koha_kohadev" with the name of our own database,
>>>> then restarted MariaDB.
>>>>
>>>> We did this even if the page says only versions prior to MariaDB 10.2.24
>>>> are affected. However, if we implement the fix or not, the following
>>>> problem occurs:
>>>>
>>>> When we manually create a new Koha user (e. g. 84) and then try to
>>>> delete it in the staff client, the message appears "An Error Occurred /
>>>> 500 Internal Server Error". In Koha menu "About Koha > System
>>>> information" it says "The following ids exist in both tables borrowers
>>>> and deletedborrowers: 84".
>>>>
>>>> So we delete that number in MariaDB using SQL statement "DELETE FROM
>>>> deletedborrowers where borrowernumber=84;". After that table
>>>> "deletedborrowers" is empty and Koha menu "About Koha > System
>>>> information" says "No warnings.". Again we try to delete the user, the
>>>> internal server error occurs, etc ad infinitum.
>>>>
>>>> Are we doing something wrong?
>>>>
>>>> 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
>>
>>


-- 
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