Auto- increment problem reoccurred after machine restart
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
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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Katrin Fischer -
Shivendra