[Koha] SQL for Auto Increment verification

Tom Hanstra hanstra at nd.edu
Wed Apr 24 02:58:25 NZST 2019


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/>


More information about the Koha mailing list