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 <katrin.fischer.83@web.de> 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 <hanstra@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@nd.edu
<http://library.nd.edu/> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- *Tom Hanstra* *Sr. Systems Administrator* hanstra@nd.edu <http://library.nd.edu/>