[CAY-1782] Deadlock when performing many concurrent inserts

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0, 3.2.M1, 3.1
• Fix Version/s: 3.2.M1
• Component/s: Core Library
• Assignee: John Huss
• Reporter: John Huss
• Due: 18/Dec/12
• Created: 18/Dec/12 17:03
• Updated: 07/Aug/14 20:07
• Resolved: 07/Aug/14 20:07

Description

I've encountered a deadlock issue in production in an app performing many INSERTs. The deadlock was between the PK generator and the PoolManager (getting a DB connection). It is very bad. I added a unit test demonstrating the problem and a fix for it.

The fix is possibly not ideal because it requires a larger data structure for holding the cached primary keys, but it is far better than the previous behavior.

If this fix is acceptable this should be back-ported to 3.1 as well.