580393 - Run query on AMO prod to block IDM

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task, P1)

Description

[Michael Morgan [:morgamic]]

insert into blapps (guid, blitem_id, min, max) values ('{ec8030f7-c20a-464f-9b0e-13a3a9e97384}', (select max(id) from blitems where guid='[e-mail]'), ' ', '3.7');

This effectively blocks all IDM running on versions greater than 3.7.  For more info see bug 578443.

Comment 1

[Michael Morgan [:morgamic]]

Err hold on, I'll attach the query.

Comment 2

[Michael Morgan [:morgamic]]

Attachment: blocklist sql for idm

Comment 3

[Jeremy Orem [:oremj]]

mysql> insert into blitems (guid) values ('[e-mail]');
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='[e-mail]'), ' ', '3.7');
Query OK, 1 row affected (0.02 sec)

Comment 4

[Jorge Villalobos [:jorgev] (he/him)]

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.

Comment 5

[Mike Beltzner [:beltzner, not reading bugmail]]

If you want something fixed, need to mark this a blocker in order to ring a pager.

Comment 6

[Shyam Mani [:fox2mike]]

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?

Comment 7

[Shyam Mani [:fox2mike]]

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)

Comment 8

[Shyam Mani [:fox2mike]]

(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.

Comment 9

[Michael Morgan [:morgamic]]

It's bug 578443.  Thanks for fixing Shyam.  min/max version were wrong.