[Koha] SQL for Auto Increment verification

[Tom Hanstra]

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


-- 
*Tom Hanstra*
*Sr. Systems Administrator*
hanstra at nd.edu

<http://library.nd.edu/>