[Koha] Auto- increment problem reoccurred after machine restart

[Shivendra]

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