In our case, we use an Amazon Web Services RDS instance, which does not restart regularly. So I was running the script periodically just to be sure things were working properly. But, I think I will start running this much less frequently, since it is only needed once on restart.
Thanks for pointing that out, Tom On Tue, Apr 23, 2019 at 1:22 PM Katrin Fischer <[email protected]> wrote: > Hi Tom, > > you can find more information about the issue on the wiki. There is a > fix that will run the SQL automatically on MySQL restart, it should not > be necessary to do anything manually if you have implemented it > correctly. Also, we have noted the MariaDB and MySQL versions where the > bug is fixed: > > https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix > > Hope this helps, > > Katrin > > On 23.04.19 19:13, Alvaro Cornejo wrote: > > 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 <[email protected]> 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* > >> [email protected] > >> > >> <http://library.nd.edu/> > >> _______________________________________________ > >> Koha mailing list http://koha-community.org > >> [email protected] > >> https://lists.katipo.co.nz/mailman/listinfo/koha > >> > > _______________________________________________ > > Koha mailing list http://koha-community.org > > [email protected] > > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > -- *Tom Hanstra* *Sr. Systems Administrator* [email protected] <http://library.nd.edu/> _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
