table locking issue when trying to view my votes

VERIFIED FIXED

Status

()

bugzilla.mozilla.org
General
P1
blocker
VERIFIED FIXED
13 years ago
7 years ago

People

(Reporter: Marc Bejarano, Assigned: justdave)

Tracking

Details

(URL)

(Reporter)

Description

13 years ago
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:
(Reporter)

Updated

13 years ago
Component: Bugzilla-General → Bugzilla: Other b.m.o Issues
Product: Bugzilla → mozilla.org
Version: unspecified → other

Comment 1

13 years ago
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. 

Updated

13 years ago
Assignee: general → justdave
QA Contact: default-qa → myk
This has been fixed upstream, we should pick it up when we upgrade
Status: UNCONFIRMED → ASSIGNED
Depends on: 280371
Ever confirmed: true
Priority: -- → P1
(Reporter)

Comment 3

13 years ago
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?
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.
Status: ASSIGNED → RESOLVED
Last Resolved: 13 years ago
Depends on: 273665
No longer depends on: 280371
Resolution: --- → FIXED
(Reporter)

Comment 5

13 years ago
thanks!  works like a charm, now :)
Status: RESOLVED → VERIFIED
Component: Bugzilla: Other b.m.o Issues → General
Product: mozilla.org → bugzilla.mozilla.org
You need to log in before you can comment on or make changes to this bug.