Closed
Bug 580393
Opened 14 years ago
Closed 14 years ago
Run query on AMO prod to block IDM
Categories
(mozilla.org Graveyard :: Server Operations, task, P1)
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: morgamic, Assigned: fox2mike)
References
Details
Attachments
(1 file)
271 bytes,
text/plain
|
Details |
insert into blapps (guid, blitem_id, min, max) values ('{ec8030f7-c20a-464f-9b0e-13a3a9e97384}', (select max(id) from blitems where guid='mozilla_cc@internetdownloadmanager.com'), ' ', '3.7'); This effectively blocks all IDM running on versions greater than 3.7. For more info see bug 578443.
Reporter | ||
Comment 1•14 years ago
|
||
Err hold on, I'll attach the query.
Reporter | ||
Comment 2•14 years ago
|
||
Reporter | ||
Updated•14 years ago
|
Severity: minor → major
Updated•14 years ago
|
Assignee: server-ops → jeremy.orem+bugs
Comment 3•14 years ago
|
||
mysql> insert into blitems (guid) values ('mozilla_cc@internetdownloadmanager.com'); Query OK, 1 row affected (0.02 sec) mysql> insert into blapps (guid, blitem_id, min, max) values ('{ec8030f7-c20a-464f-9b0e-13a3a9e97384}', (select max(id) from blitems where guid='mozilla_cc@internetdownloadmanager.com'), ' ', '3.7'); Query OK, 1 row affected (0.02 sec)
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Comment 4•14 years ago
|
||
Looks like something is wrong with the query, and all the wrong users are being blocked. See bug 382356 for just a taste of what's happening. Please reverse this block ASAP.
Severity: major → critical
Status: RESOLVED → REOPENED
Priority: -- → P1
Resolution: FIXED → ---
Comment 5•14 years ago
|
||
If you want something fixed, need to mark this a blocker in order to ring a pager.
Updated•14 years ago
|
Severity: critical → blocker
Updated•14 years ago
|
Assignee: jeremy.orem+bugs → server-ops
Assignee | ||
Comment 6•14 years ago
|
||
Just to be sure something isn't messed up even more, I'd need someone to verify the query to run, or give me a new one to run. Which is it going to be?
Assignee: server-ops → shyam
Assignee | ||
Comment 7•14 years ago
|
||
What was added today was removed : mysql> DELETE FROM blapps WHERE id=7; Query OK, 1 row affected (0.00 sec) mysql> DELETE FROM blitems where id=16; Query OK, 1 row affected (0.00 sec)
Status: REOPENED → RESOLVED
Closed: 14 years ago → 14 years ago
Resolution: --- → FIXED
Assignee | ||
Comment 8•14 years ago
|
||
(In reply to comment #5) > If you want something fixed, need to mark this a blocker in order to ring a > pager. And re-assign to server-ops :) (In reply to comment #4) > Looks like something is wrong with the query, and all the wrong users are being > blocked. See bug 382356 for just a taste of what's happening. > > Please reverse this block ASAP. Wrong Bug number, just curious as to what the right one is.
Reporter | ||
Comment 9•14 years ago
|
||
It's bug 578443. Thanks for fixing Shyam. min/max version were wrong.
Updated•9 years ago
|
Product: mozilla.org → mozilla.org Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•