[Koha] Reoccurring DBMS auto increment issue

[Javi Legido]

Hi there.

Given that web application logs are so laconic maybe you can temporary
enable SQL query logging in your database to see which query is producing
the error.

Cheers.

Javier

On Tue, 22 Jun 2021 at 09:48, Michael Kuhn <mik at adminkuhn.ch> wrote:

> 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
>
>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>