353568 - Got error "Tables already locked" when trying to change several bugs

Status: RESOLVED DUPLICATE of bug 314109

(Bugzilla :: Creating/Changing Bugs, defect)

Description

[Heikki Toivonen (remove -bugzilla when emailing directly)]

I did a query to find all open bugs that contained the word 'flawfinder' in the summary. I chose to change several bugs, selected all of them, added a comment, changed resolution to WORKSFORME.

I got:

Internal Error

Bugzilla has suffered an internal error. Please save this page and send it to [e-mail] with details of what you were doing at the time this message appeared.

URL: https://bugzilla.mozilla.org/process_bug.cgi
Attempted to lock a table without releasing previous lock first:

Tables already locked:
bugs WRITE, bugs_activity WRITE, cc WRITE, cc AS selectVisible_cc WRITE, profiles WRITE, dependencies WRITE, votes WRITE, products READ, components READ, keywords WRITE, longdescs WRITE, fielddefs WRITE, bug_group_map WRITE, flags WRITE, duplicates WRITE, user_group_map WRITE, group_group_map READ, flagtypes READ, flaginclusions AS i READ, flagexclusions AS e READ, keyworddefs READ, groups READ, attachments READ, group_control_map AS oldcontrolmap READ, group_control_map AS newcontrolmap READ, group_control_map READ, email_setting READ

Tables requesting locking:
profiles WRITE, user_group_map WRITE, group_group_map READ, groups READ

Comment 1

[Heikki Toivonen (remove -bugzilla when emailing directly)]

Attachment: page as text

Comment 2

[Max Kanat-Alexander]

What version of Bugzilla are you using, exactly? Have you customized it at all?

Comment 3

[Frédéric Buclin]

I'm pretty sure this has been fixed in 2.22.

Comment 4

[Frédéric Buclin]

(In reply to comment #2)
> What version of Bugzilla are you using, exactly? Have you customized it at all?
> 

Max, the attachment shows that's it's b.m.o. So 2.20+ and hacked a lot. :)

Comment 5

[Max Kanat-Alexander]

Okay. I think this is a dup of some bug we fixed in 2.20.1, also, but I'm not sure which one.

It's definitely fixed in 2.22, since this is an attempt to derive groups in the middle of process_bug, and 2.22 doesn't derive groups anymore.

Comment 6

[Frédéric Buclin]

*** This bug has been marked as a duplicate of 314109 ***