Closed Bug 465469 Opened 16 years ago Closed 16 years ago

SQL push for 11/18

Categories

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Product:
Infrastructure & Operations Graveyard
Component:
WebOps: Other
Platform:
All
Other
Type:
task
Priority:
Not set
Severity:
major

Tracking

(Not tracked)

Status:
VERIFIED FIXED

People

(Reporter: wenzel, Assigned: mrz)

References

Details

Attachments

(1 file)

new add-on list for Fashion your Firefox
2.90 KB, text/plain
Details 
drolnitzky asked to remove an add-on off the collection that will be presented on 11/8 in the morning, so please do this one soon:

Please execute the attached SQL on both the prod and preview AMO DBs.

Thanks a lot.
Comment on attachment 348712 [details]
new add-on list for Fashion your Firefox

Seriously, bugzilla, it's SQL!
Attachment #348712 - Attachment mime type: application/octet-stream → text/plain
Blocks: 465468
a=morgamic
Assignee: server-ops → mrz
On production - 

mysql> DELETE FROM `addons_collections` WHERE `collection_id` = 1;                                                      Query OK, 38 rows affected (0.05 sec)                                                                                   
mysql> INSERT INTO `addons_collections` VALUES (3945, 1, '0000-00-00 00:00:00', 1);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (5579, 1, '0000-00-00 00:00:00', 1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (3590, 1, '0000-00-00 00:00:00', 1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (424, 1, '0000-00-00 00:00:00', 2);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (398, 1, '0000-00-00 00:00:00', 2);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (2677, 1, '0000-00-00 00:00:00', 2);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (7661, 1, '0000-00-00 00:00:00', 2);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (4980, 1, '0000-00-00 00:00:00', 3);
lections` VALUES (5045, 1, '0000-00-00 00:00:00', 4);
INSERT INTO `addons_collections` VALUES (3615, 1, '0000-00-00 00:00:00', 4);
INSERT INTO `addons_collections` VALUES (5457, 1, '0000-00-00 00:00:00', 5);
INSERT INTO `addons_collections` VALUES (3794, 1, '0000-00-00 00:00:00', 5);
INSERT INTO `addons_collections` VALUES (5081, 1, '0000-00-00 00:00:00', 5);
INSERT INTO `addons_collections` VALUES (1833, 1, '0000-00-00 00:00:00', 5);
INSERT INTO `addons_collections` VALUES (1512, 1, '0000-00-00 00:00:00', 5);
INSERT INTO `addons_collections` VALUES (5203, 1, '0000-00-00 00:00:00', 6);
INSERT INTO `addons_collections` VALUES (4999, 1, '0000-00-00 00:00:00', 6);
INSERT INTO `addons_collections` VALUES (138, 1, '0000-00-00 00:00:00', 6);
INSERT INTO `addons_collections` VALUES (6198, 1, '0000-00-00 00:00:00', 7);
INSERT INTO `addons_collections` VALUES (7403, 1, '0000-00-00 00:00:00', 7);
INSERT INTO `addons_collections` VALUES (72, 1, '0000-00-00 00:00:00', 7);
INSERT INTO `addons_collections` VALUES (4908, Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (5202, 1, '0000-00-00 00:00:00', 3);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (5966, 1, '0000-00-00 00:00:00', 3);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (6089, 1, '0000-00-00 00:00:00', 3);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (2410, 1, '0000-00-00 00:00:00', 4);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (5721, 1, '0000-00-00 00:00:00', 4);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (5045, 1, '0000-00-00 00:00:00', 4);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (3615, 1, '0000-00-00 00:00:00', 4);
Query OK, 1 row affected (0.03 sec)

mysql> INSERT INTO `addons_collections` VALUES (5457, 1, '0000-00-00 00:00:00', 5);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (3794, 1, '0000-00-00 00:00:00', 5);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (5081, 1, '0000-00-00 00:00:00', 5);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (1833, 1, '0000-00-00 00:00:00', 5);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (1512, 1, '0000-00-00 00:00:00', 5);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (5203, 1, '0000-00-00 00:00:00', 6);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (4999, 1, '0000-00-00 00:00:00', 6);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (138, 1, '0000-00-00 00:00:00', 6);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (6198, 1, '0000-00-00 00:00:00', 7);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (7403, 1, '0000-00-00 00:00:00', 7);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (72, 1, '0000-00-00 00:00:00', 7);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (4908, 1, '0000-00-00 00:00:00', 7);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (122, 1, '0000-00-00 00:00:00', 7);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (1368, 1, '0000-00-00 00:00:00', 7);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (1529, 1, '0000-00-00 00:00:00', 7);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (3918, 1, '0000-00-00 00:00:00', 7);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (3481, 1, '0000-00-00 00:00:00', 8);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (1191, 1, '0000-00-00 00:00:00', 8);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (4865, 1, '0000-00-00 00:00:00', 8);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (219, 1, '0000-00-00 00:00:00', 9);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (7684, 1, '0000-00-00 00:00:00', 9);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `addons_collections` VALUES (3982, 1, '0000-00-00 00:00:00', 9);
Query OK, 1 row affected (0.00 sec)
(In reply to comment #3)
> On production - 

Thanks, mrz! The lines in the middle are weird though, can you confirm that
SELECT COUNT(*) FROM addons_collections WHERE collection_id = 1;
is 37?
mysql> use addons_remora
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SELECT COUNT(*) FROM addons_collections WHERE collection_id = 1;
+----------+
| COUNT(*) |
+----------+
|       37 | 
+----------+
1 row in set (0.00 sec)
(In reply to comment #1)
> (From update of attachment 348712 [details])
> Seriously, bugzilla, it's SQL!

File a bug under mozilla.org :: Bugzilla: Other b.m.o issues about adding that sniff.
If I had half a clue where the preview db is, I'd do the changes there.  Using what I thought was right got me:

mysql> use preview_addons

mysql> DELETE FROM `addons_collections` WHERE `collection_id` = 1;
ERROR 1146 (42S02): Table 'preview_addons.addons_collections' doesn't exist
Done - 

mysql> use addons_reskin
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> DELETE FROM `addons_collections` WHERE `collection_id` = 1;
Query OK, 38 rows affected (0.05 sec)

mysql> INSERT INTO `addons_collections` VALUES (3945, 1, '0000-00-00 00:00:00', 1);
lections` VALUES (5045, 1, '0000-00-00 00:00:00', 4);
INSERT INTO `addons_collections` VALUES (3615, 1, '0000-00-00 00:00:00', 4);
INSERT INTO `addons_collections` VALUES (5457, 1, '0000-00-00 00:00:00', 5);
INSERT INTO `addons_collections` VALUES (3794, 1, '0000-00-00 00:00:00', 5);
INSERT INTO `addons_collections` VALUES (5081, 1, '0000-00-00 00:00:00', 5);
INSERT INTO `addons_collections` VALUES (1833, 1, '0000-00-00 00:00:00', 5);
INSERT INTO `addons_collections` VALUES (1512, 1, '0000-00-00 00:00:00', 5);
INSERT INTO `addons_collections` VALUES (5203, 1, '0000-00-00 00:00:00', 6);
INSERT INTO `addons_collections` VALUES (4999, 1, '0000-00-00 00:00:00', 6);
INSERT INTO `addons_collections` VALUES (138, 1, '0000-00-00 00:00:00', 6);
INSERT INTO `addons_collections` VALUES (6198, 1, '0000-00-00 00:00:00', 7);
INSERT INTO `addons_collections` VALUES (7403, 1, '0000-00-00 00:00:00', 7);
INSERT INTO `addons_collections` VALUES (72, 1, '0000-00-00 00:00:00', 7);
INSERT INTO `addons_collections` VALUES (4908, 1, '0000-00-00 00:00:00', 7);
INSERT INTO `addons_collections` VALUES (122, 1, '0000-00-00 00:00:00', 7);
INSERT INTO `addons_collections` VALUES (1368, 1, '0000-00-00 00:00:00', 7);
INSERT INTO `addons_collections` VALUES (1529, 1, '0000-00-00 00:00:00', 7);
INSERT INTO `addons_collections` VALUES (3918, 1, '0000-00-00 00:00:00', 7);
INSERT INTO `addons_collections` VALUES (3481, 1, '0000-00-00 00:00:00', 8);
INSERT INTO `addons_collections` VALUES (1191, 1, '0000-00-00 00:00:00', 8);
INSERT INTO `addons_collections` VALUES (4865, 1, '0000-00-00 00:00:00', 8);
INSERT INTO `addons_collections` VALUES (219, 1, '0000-00-00 00:00:00', 9);
INSERT INTO `addons_collections` VALUES (7684, 1, '0000-00-00 00:00:00', 9);
INSERT INTO `addons_collections` VALUES (3982, 1, '0000-00-00 00:00:00', 9);
Query OK, 1 row affected (0.05 sec)

mysql> INSERT INTO `addons_collections` VALUES (5579, 1, '0000-00-00 00:00:00', 1);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (3590, 1, '0000-00-00 00:00:00', 1);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (424, 1, '0000-00-00 00:00:00', 2);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (398, 1, '0000-00-00 00:00:00', 2);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (2677, 1, '0000-00-00 00:00:00', 2);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (7661, 1, '0000-00-00 00:00:00', 2);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (4980, 1, '0000-00-00 00:00:00', 3);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (5202, 1, '0000-00-00 00:00:00', 3);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (5966, 1, '0000-00-00 00:00:00', 3);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (6089, 1, '0000-00-00 00:00:00', 3);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (2410, 1, '0000-00-00 00:00:00', 4);
Query OK, 1 row affected (0.04 sec)

mysql> INSERT INTO `addons_collections` VALUES (5721, 1, '0000-00-00 00:00:00', 4);
Query OK, 1 row affected (0.02 sec)

mysql> INSERT INTO `addons_collections` VALUES (5045, 1, '0000-00-00 00:00:00', 4);
Query OK, 1 row affected (0.02 sec)

mysql> INSERT INTO `addons_collections` VALUES (3615, 1, '0000-00-00 00:00:00', 4);
Query OK, 1 row affected (0.03 sec)

mysql> INSERT INTO `addons_collections` VALUES (5457, 1, '0000-00-00 00:00:00', 5);
Query OK, 1 row affected (0.09 sec)

mysql> INSERT INTO `addons_collections` VALUES (3794, 1, '0000-00-00 00:00:00', 5);
Query OK, 1 row affected (0.02 sec)

mysql> INSERT INTO `addons_collections` VALUES (5081, 1, '0000-00-00 00:00:00', 5);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (1833, 1, '0000-00-00 00:00:00', 5);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (1512, 1, '0000-00-00 00:00:00', 5);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (5203, 1, '0000-00-00 00:00:00', 6);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (4999, 1, '0000-00-00 00:00:00', 6);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (138, 1, '0000-00-00 00:00:00', 6);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (6198, 1, '0000-00-00 00:00:00', 7);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO `addons_collections` VALUES (7403, 1, '0000-00-00 00:00:00', 7);                                     Query OK, 1 row affected (0.01 sec)                                                                                                                                                                                                             mysql> INSERT INTO `addons_collections` VALUES (72, 1, '0000-00-00 00:00:00', 7);                                       Query OK, 1 row affected (0.01 sec)                                                                                                                                                                                                             mysql> INSERT INTO `addons_collections` VALUES (4908, 1, '0000-00-00 00:00:00', 7);                                     Query OK, 1 row affected (0.02 sec)                                                                                                                                                                                                             mysql> INSERT INTO `addons_collections` VALUES (122, 1, '0000-00-00 00:00:00', 7);                                      Query OK, 1 row affected (0.01 sec)                                                                                                                                                                                                             mysql> INSERT INTO `addons_collections` VALUES (1368, 1, '0000-00-00 00:00:00', 7);                                     Query OK, 1 row affected (0.01 sec)                                                                                                                                                                                                             mysql> INSERT INTO `addons_collections` VALUES (1529, 1, '0000-00-00 00:00:00', 7);                                     Query OK, 1 row affected (0.01 sec)                                                                                                                                                                                                             mysql> INSERT INTO `addons_collections` VALUES (3918, 1, '0000-00-00 00:00:00', 7);                                     Query OK, 1 row affected (0.01 sec)                                                                                                                                                                                                             mysql> INSERT INTO `addons_collections` VALUES (3481, 1, '0000-00-00 00:00:00', 8);                                     Query OK, 1 row affected (0.02 sec)                                                                                                                                                                                                             mysql> INSERT INTO `addons_collections` VALUES (1191, 1, '0000-00-00 00:00:00', 8);                                     Query OK, 1 row affected (0.01 sec)                                                                                                                                                                                                             mysql> INSERT INTO `addons_collections` VALUES (4865, 1, '0000-00-00 00:00:00', 8);                                     Query OK, 1 row affected (0.01 sec)                                                                                                                                                                                                             mysql> INSERT INTO `addons_collections` VALUES (219, 1, '0000-00-00 00:00:00', 9);                                      Query OK, 1 row affected (0.01 sec)                                                                                                                                                                                                             mysql> INSERT INTO `addons_collections` VALUES (7684, 1, '0000-00-00 00:00:00', 9);                                     Query OK, 1 row affected (0.11 sec)                                                                                                                                                                                                             mysql> INSERT INTO `addons_collections` VALUES (3982, 1, '0000-00-00 00:00:00', 9);                                     Query OK, 1 row affected (0.02 sec)                                                                                                                                                                                                             mysql> SELECT COUNT(*) FROM addons_collections WHERE collection_id = 1;                                                 +----------+
| COUNT(*) |
+----------+
|       37 | 
+----------+
1 row in set (0.00 sec)
Status: NEW → RESOLVED
Closed: 16 years ago
Resolution: --- → FIXED
Looks good - thanks mrz.
Status: RESOLVED → VERIFIED
(In reply to comment #7)
> (In reply to comment #1)
> > (From update of attachment 348712 [details] [details])
> > Seriously, bugzilla, it's SQL!
> 
> File a bug under mozilla.org :: Bugzilla: Other b.m.o issues about adding that
> sniff.

Done: bug 465516. Thanks.
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: