Re: [Koha] SQL for Auto Increment verification

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 pointin

Re: [Koha] SQL for Auto Increment verification

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 fixe

Re: [Koha] SQL for Auto Increment verification

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

[Koha] SQL for Auto Increment verification

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 downt