MySQL Forums
Forum List  »  Stored Procedures

Re: ERROR 1206 The total number of locks exceeds the lock table size
Posted by: John Rocha
Date: December 19, 2012 10:30AM

Upate.

I modified the logic wrapping the UPDATE in TRANSACTION/COMMIT and it got farther. this time it didn't fail with the 12006 error until approximately 182,000 entries were completed.


START TRANSACTION;
UPDATE `UMS`.`event_notify_occurrence_cache`
SET event_type_value=etype_value
WHERE event_type_value=0 AND xml LIKE query_str
LIMIT 1000;

-- set changes_not_done to the number of rows modified by the
-- previous command. If it's zero, then we are done. If it's
-- non-zero then we have more to do.
SELECT ROW_COUNT() INTO changes_not_done;
COMMIT;

-=John

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR 1206 The total number of locks exceeds the lock table size
5721
December 19, 2012 10:30AM


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.