Continue Handler Not Invoked In Stored Function or Trigger After Lock Wait Timeout, Deadlock, or Lock Structs Have Exhausted the Buffer Pool
Last updated on MARCH 08, 2017
Applies to:MySQL Server - Version 5.5 to 5.7 [Release 5.5 to 5.7]
Information in this document applies to any platform.
After one of the following errors have occurred:
- Lock wait timeout
- Lock structs have exhausted the buffer pool
and a stored function or trigger is invoked in the same connection, then continue handlers in the function/trigger are ignored.
An example is:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms