566653 - Push SUMO 1.5.4.1 on Thursday, May 20

Status: VERIFIED FIXED

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

Description

[Paul Craciunoiu [:paulc]]

We've got a small set of changes that need to go live (in particular - one regression and one fix for our tracking system).
(SVN tag coming shortly)

* Run SQL in bug 565320 -- attachment 445008 [details] [diff] [review]
* Flush file caches, Zeus and memcache

That should be it. Will add to this in later comments if anything's missing.

Comment 1

[James Socol [:jsocol, :james]]

There will be a new tag for both SVN and Git, as well. We haven't tagged them yet but the versions are 1.5.4.1 and 2.0.4 respectively.

Comment 2

[matthew zeier [:mrz]]

Still on for 4pm?  Duration?  Will the site be offline?

Comment 3

[James Socol [:jsocol, :james]]

Still on for 4. Duration 30 minutes. Now downtime.

Comment 4

[James Socol [:jsocol, :james]]

s/Now/No/

Comment 5

[Paul Craciunoiu [:paulc]]

Remember that the SQL should happen first. Then these code updates:

Git tag: 2.0.4

SVN tag:
https://svn.mozilla.org/projects/sumo/tags/1.5/1.5.4.1_20100520/

After all that, flush all caches (file caches, memcache...)

Comment 6

[James Socol [:jsocol, :james]]

(In reply to comment #5)
> SVN tag:
> https://svn.mozilla.org/projects/sumo/tags/1.5/1.5.4.1_20100520/

Before the SVN switch, just for safety and piece of mind, could you please save the output of `svn diff`. After the switch, you should do an `svn revert` to clean out the local changes. (We changed the file `webroot/lib/userslib.php` to bandaid a missing DB index.)

Comment 7

[chizu]

mysql> -- Adding back any omitted indexes
mysql> 
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, 90390 rows affected (3.66 sec)
Records: 90390  Duplicates: 0  Warnings: 0

mysql> 
mysql> 
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.33 sec)
Records: 211  Duplicates: 0  Warnings: 0

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

mysql> 
mysql> 
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, 36285 rows affected (3.26 sec)
Records: 36285  Duplicates: 0  Warnings: 0

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

mysql> 
mysql> 
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 (1.07 sec)
Records: 213  Duplicates: 0  Warnings: 0

Comment 8

[chizu]

Switched svn/git tags, cleared filecache/memcached/zeus.

Comment 9

[Stephen Donner [:stephend] Not actively reading bugmail]

Verified FIXED; ran a few post-push tests, as well as re-verified the Omniture removal, on prod.