[Koha] SQL for Auto Increment verification

Alvaro Cornejo cornejo.alvaro at gmail.com
Wed Apr 24 05:13:56 NZST 2019


Hi Tom

The auto increment issue is an issue from mysql. It is not a koha issue.

Also, this issue only happens on mysql restart. It should not be necessary
to run the sql code you mention if mysql was not restarted.

Regards,

Alvaro


|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
              Visitenos en www.perusms.com


Le mar. 23 avr. 2019 à 09:59, Tom Hanstra <hanstra at nd.edu> a écrit :

> Based upon a blog post from a couple of versions back, we regularly run
> some SQL on our databases to ensure that auto increment is working properly
> on a number of tables. We have had some problems with this, however, in
> version 17.11 with database locks on table updates which have resulted in
> downtime for Koha.
>
> My question is whether this code is still necessary in 17.11 and beyond or
> if this is now obsolete. If I don't need to run this, I will stop doing so.
>
> And the second question would be, if it is necessary, have others run into
> similar issues and how might it be cleared up?
>
> Thanks in advance for any guidance you can provide,
> Tom
>
> --
> *Tom Hanstra*
> *Sr. Systems Administrator*
> hanstra at nd.edu
>
> <http://library.nd.edu/>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>


More information about the Koha mailing list