[Koha-bugs] [Bug 18966] Move of checkouts - Deal with duplicate IDs at DBMS level

[bugzilla-daemon at bugs.koha-community.org]

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

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |katrin.fischer at bsz-bw.de

--- Comment #6 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
(In reply to David Cook from comment #5)
> Do you have a test plan for testers to follow for this one?

Check an item out (issue_id = 1)
Check an item in (issue_id = 1)
Restart MySQL (reset auto increment for issue_id to 1)
Check an item out (issue_id = 1)
Check an item in => BOOM, the issue_id is a PK in old_issues and the move
fails.

For starters, instead of BOOM we should see the new warning ;) Please note the
dependencies.

> => It will only reject 1 checkin (max is 1 * MySQL restart), no need to deal with race conditions,

Hm, I think it can be more than one, depending on how many items you check out
and return immediately before the restart (check-out 3, check-in 3, restart
mysql, PK is behind by 3)

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