565701 - SUMO: sync db from prod to stage-new and run SQL script from bug 565320

Status: RESOLVED FIXED

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

Description

[Paul Craciunoiu [:paulc]]

We'd like to sync stage-new with prod and run some SQL to fix bug 565320 and (hopefully also) bug 565606.

Steps:
1. Import latest copy of prod database on stage-new (I believe the db name is something like support_stage_new)
2. Run sql from attachment 445008 [details] [diff] [review]
3. Clear caches (! most importantly file caches)

Thanks!

Comment 1

[Shyam Mani [:fox2mike]]

1. DB Synced.
2. SQL run :

mysql> SELECT '3: tiki_pages_translation_bits.original_translation_bit_2' AS progress;
+-----------------------------------------------------------+
| progress                                                  |
+-----------------------------------------------------------+
| 3: tiki_pages_translation_bits.original_translation_bit_2 | 
+-----------------------------------------------------------+
1 row in set (0.00 sec)

mysql> ALTER TABLE `tiki_pages_translation_bits` ADD KEY `original_translation_bit_2` (`original_translation_bit`);
Query OK, 89914 rows affected (0.81 sec)
Records: 89914  Duplicates: 0  Warnings: 0

mysql> SELECT '7: tiki_tracker_item_fields' AS progress;
+-----------------------------+
| progress                    |
+-----------------------------+
| 7: tiki_tracker_item_fields | 
+-----------------------------+
1 row in set (0.00 sec)

mysql> ALTER TABLE `tiki_tracker_item_fields` DROP INDEX `value`;
Query OK, 211 rows affected (0.10 sec)
Records: 211  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE `tiki_tracker_item_fields` ADD FULLTEXT `ft` (`value`);
Query OK, 211 rows affected (0.19 sec)
Records: 211  Duplicates: 0  Warnings: 0

mysql> SELECT '12: tiki_objects' AS progress;
+------------------+
| progress         |
+------------------+
| 12: tiki_objects | 
+------------------+
1 row in set (0.00 sec)

mysql> ALTER TABLE `tiki_objects` DROP INDEX `itemId`;
Query OK, 36179 rows affected (0.84 sec)
Records: 36179  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE `tiki_objects` ADD INDEX `itemId` (`itemId`, `type`);
Query OK, 36179 rows affected (1.21 sec)
Records: 36179  Duplicates: 0  Warnings: 0

mysql> SELECT '17: users_permissions' AS progress;
+-----------------------+
| progress              |
+-----------------------+
| 17: users_permissions | 
+-----------------------+
1 row in set (0.00 sec)

mysql> ALTER TABLE `users_permissions` ADD UNIQUE KEY `permName` (`permName`);
Query OK, 213 rows affected (0.25 sec)
Records: 213  Duplicates: 0  Warnings: 0

3. Will happen automatically once in 16 mins.

All done.