[Koha-bugs] [Bug 18651] Move of checkouts is still not correctly handled

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Jul 20 00:22:49 CEST 2017


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18651

--- Comment #66 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
I've tested the patches for 16.11.x, but I think this is still pretty
problematic:

1) Unable to check-in more than one problematic issue at once

- Check out some items
- Check them in again
- Restart MySql
- Check out some items again
- Check them in all at once using the checkboxes in circulation
=> Only the first item will be returned, the others report: Unable to check in

2) Once out of sync, PKs stay out of sync

- Check out some items
- Check them in again
- Restart MySQL
- Check item out => issue_id will be in old_issues already, say it's 8
- Check the item in => issue_id in old_issues is changed, say 9
- Check out next item => issues.issue_id is 9
- Check in item => old_issues.issue_id is changed to 10
...

So I think we will keep changing numbers once the bug manifested, as the PK is
never fixed. Not sure if I might have a thinking error there?

Could we use something like this to fix the PK when we notice that the issue_id
has to be changed in order to be able to move it?
ALTER TABLE issues AUTO_INCREMENT = (bigger max(issue_id) from old_issues and
issues) +1

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list