304356 - table locking issue when trying to view my votes

Status: VERIFIED FIXED

(bugzilla.mozilla.org :: General, defect, P1)

Description

[Marc Bejarano]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.10) Gecko/20050716 Firefox/1.0.6
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.10) Gecko/20050716 Firefox/1.0.6

currently (16:38 GMT-4), one cannot view their votes.  clicking on "My Votes" in
the b.m.o footer takes you to
https://bugzilla.mozilla.org/votes.cgi?action=show_user which currently gives
the following error:
===
Software error:

DBD::mysql::db selectcol_arrayref failed: Table 'groups' was not locked with
LOCK TABLES [for Statement "SELECT DISTINCT groups.name, group_id
                                              FROM groups, user_group_map
                                             WHERE groups.id=user_group_map.group_id
                                               AND user_id=?
                                               AND isbless=0"] at
Bugzilla/User.pm line 227
	Bugzilla::User::groups('Bugzilla::User=HASH(0x99be944)') called at
Bugzilla/User.pm line 277
	Bugzilla::User::can_see_bug('Bugzilla::User=HASH(0x99be944)', 28357) called at
/opt/webtools/bugzilla/votes.cgi line 188
	main::show_user() called at /opt/webtools/bugzilla/votes.cgi line 76

For help, please send mail to the webmaster (root@localhost), giving this error
message and the time and date of the error.
===

Reproducible: Always

Steps to Reproduce:

Comment 1

[Michael Newton]

I can confirm this:

Software error:

DBD::mysql::db selectcol_arrayref failed: Table 'groups' was not locked with
LOCK TABLES [for Statement "SELECT DISTINCT groups.name, group_id
                                              FROM groups, user_group_map
                                             WHERE groups.id=user_group_map.group_id
                                               AND user_id=?
                                               AND isbless=0"] at
Bugzilla/User.pm line 227
	Bugzilla::User::groups('Bugzilla::User=HASH(0x93270dc)') called at
Bugzilla/User.pm line 277
	Bugzilla::User::can_see_bug('Bugzilla::User=HASH(0x93270dc)', 253449) called at
/opt/webtools/bugzilla/votes.cgi line 188
	main::show_user() called at /opt/webtools/bugzilla/votes.cgi line 76

For help, please send mail to the webmaster (root@localhost), giving this error
message and the time and date of the error. 

Comment 2

[Dave Miller [:justdave]]

This has been fixed upstream, we should pick it up when we upgrade

Comment 3

[Marc Bejarano]

hrm... it kind of sucks for nobody to be able to check their votes in the
meantime.  is there a schedule for the next upgrade?  is there some bandaid we
can use in the meantime?

Comment 4

[Dave Miller [:justdave]]

The upstream patch turned out to be pretty low-risk, so I applied it now instead
of waiting for the upgrade.  This apparently showed up suddenly as a result of
our MySQL 4.0 -> 4.1 upgrade the other day.

Comment 5

[Marc Bejarano]

thanks!  works like a charm, now :)