MySQL Forums
Forum List  »  Stored Procedures

Re: ERROR 1206 The total number of locks exceeds the lock table size
Posted by: Rick James
Date: December 20, 2012 03:25PM

Something to try...

-- 1. Find the rows:
CREATE TEMPORARY TABLE foo
SELECT id FROM `UMS`.`event_notify_occurrence_cache`
WHERE event_type_value != etype_value
AND event_type_value=0
AND xml LIKE query_str;

-- 2. Use a multi-table UPDATE to join foo and your table, doing the update.
(This may or may not need the loop and LIMIT.)

Use START & COMMENT around step 2, not step 1.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR 1206 The total number of locks exceeds the lock table size
5942
December 20, 2012 03:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.