[Koha] Auto- increment problem reoccurred after machine restart

[Katrin Fischer]

Hi,

the DELETE command will fix the data, but not prevent the issue from
happening again. As this is not a problem with Koha, but with
MySQL/MariaDB, updating to a newer Koha version won't fix the issue.

See the wiki for more information and a possible fix to prevent the
problem from reappearing when your database server is restarted:

https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix

Hope this helps,

Katrin

On 30.06.19 05:27, Shivendra wrote:
> Hi Friends, recently I set up koha 18.05 versions on Ubuntu 18.04 and
> migrated data from local software after doing necessary marc editing.
> Everything worked well, however while checking for missing barcodes, I came
> across a good number of duplicate barcode, which I later deleted using
> batch item deletion module. In between I also edited lots of data having
> both minor and major corrections. Simultaneously I created patrons and
> checked for book check-in and check-outs and to my surprise, I was able to
> check-out books, but was not able to check-in. while looking for the
> reasons, the problem emerged of auto- increment with an exact error “The
> following ids exist in both tables issues and old_issues:”. While looking
> for solution, I came across “DELETE FROM old_issues WHERE issue_id IN (1,
> 2);” command and applied it after making necessary changes in numbers as
> per system information. This solution worked and I was once again able to
> check-in and check-out. But, the moment I restarted machine, the problem
> reoccurred and am still wondering for solution.  Of late, I upgraded my
> machine to koha 19.05, but the problem still persists.
>
> I shall feel grateful, should you help me to fix this auto increment
> problem and do share the reasons, as what actuated this problem .
>
> Thanking you.
>
> Shivendra Singh
> Assistant Librarian
> BFUHS, Faridkot, Punjab 151203
> India
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha