UESPWiki:Upgrade History/2015

27 November 2015
Fixed an issue with the Patroller extension using a removed function. Changed ChangesList:newFromUser() to ChangesList:newFromContext($this->getContext()). -- Daveh   18:31, 27 November 2015 (UTC)
Made Squid not cache Special:Patrol. -- Daveh   18:31, 27 November 2015 (UTC)
Edited hard-coded list of namespaces for prefix search in /w/resources/src/mediawiki/mediawiki.searchSuggest.js. -- Daveh   18:31, 27 November 2015 (UTC)

26 November 2015
Upgraded MediaWiki to 1.23.11. -- Daveh   18:31, 27 November 2015 (UTC)
Re-indexed search. -- Daveh   18:31, 27 November 2015 (UTC)
Made Squid not cache Special:RecentChanges. -- Daveh   18:31, 27 November 2015 (UTC)

20 November 2015
Removed several anonymous MySQL users on content3/db1/db2 (''@'localhost', ''@'content3.uesp.net', etc...). The recent addition of reverse DNS entries meant that local connections using the IP were being resolved to the domain name which matched the anonymous MySQL users causing "ACCESS DENIED" for the connection. -- Daveh   20:39, 20 November 2015 (UTC)

26 October 2015
Ran maintenance script cleanupUploadStash.php to get rid of several years worth of leftover stash files from aborted uploads.  &ndash;       22:14, 26 October 2015 (UTC)

6 October 2015
Upgraded the Zabbix monitoring package from 1.8 to 2.4.6 on all servers. See  for notes. -- Daveh   13:37, 6 October 2015 (UTC)

24 September 2015
Disabled the SearchLog extension on content1/2/3 to clear up all the error messages it was making. -- Daveh   15:03, 24 September 2015 (UTC)
Updated the mobile wikis on content1/2/3 with all the recent wiki configuration and file tweaks. -- Daveh   20:30, 24 September 2015 (UTC)
Set $wgObjectCacheSessionExpiry = 100000; (from the 3600 default) on content1/2/3 wikis to prevent sessions from expiring too quickly when editing maps. -- Daveh   20:51, 24 September 2015 (UTC)

23 September 2015
Set $wgSessionsInObjectCache=true and removed the deprecated $wgSessionsInMemcached line from LocalSettings.php on content1/2/3. This removes the issue of the session file lock preventing asynchronous page loads from happening quickly. Reloads of the main page went from ~5 sec to ~2 sec with this change.  -- Daveh   23:44, 23 September 2015 (UTC)
Updated the two map systems (MW/OB/SR map and the ESO map) to use the memcached session data to check for credentials when editing. -- Daveh   23:44, 23 September 2015 (UTC)

22 September 2015
Installed ElasticSearch index on files1 (2GB memory size) and the related MediaWiki extensions on content1/2/3. Rebuilt the index and switched over the MW search to use the new index. Stopped the old Lucene index on content2. -- Daveh   12:44, 23 September 2015 (UTC)
Changed $wgTmpDirectory from {$wgUploadDirectory}/tmp to /imagetmp on content1/2/3. This solves a performance issue on pages with a lot of images as using a temp directory which is a NFS share requires ~50 ms per file creation. -- Daveh   16:32, 23 September 2015 (UTC)

17 September 2015
Changed the binlog_cache_size for MySQL on content3 from the default (32kb) to 50MB to try and get to stop filling up /tmp repeatedly. -- Daveh   20:38, 17 September 2015 (UTC)

27 July 2015
Installed a TeamSpeak3 server on content3 with the domain name ts.uesp.net for ESO. -- Daveh   14:35, 27 July 2015 (UTC)

17 June 2015
Looks like a random power outage on two of our power supplies that run db1 and db2 which caused them to reboot. This subsequently corrupted one table on db1 and messed up the slave replication on db2. Both fixed quickly and things are back to working again. -- Daveh   19:39, 17 June 2015 (UTC)

15 June 2015
LocalSettings.php
Created Legends namespace.
Updated missing ESOMod namespace info.
Harmonized $wgCacheEpoch setting across all servers (was off by a day on some).  &ndash;       02:00, 16 June 2015 (UTC)

11 June 2015
LocalSettings.php
Added   as a (hopefully) temporary workaround for  and similar large pages which are taking a long time to load.
Re-removed deprecated   per discussion on AN.  &ndash;       02:42, 11 June 2015 (UTC)
Rebuilt the Lucene search index on content2 ( ). Note that it seems to ignore the selected db slave and always perform the dump from db2. This will cause performance issues on the live site especially if the dump script locks up as it tends to do. Approximate time to dump and rebuild index is 15-20 minutes. The incremental updater was not working before and after the dump and index update. -- Daveh   18:56, 11 June 2015 (UTC)

9 June 2015
LocalSettings.php: Added missing   as a possible first step in resolving search suggestion issues.  &ndash;       05:18, 9 June 2015 (UTC)

2 June 2015
Installed the PHP-Lua extension on content3. For reference the steps involved are as follows: -- Daveh   19:01, 2 June 2015 (UTC)
::* yum install lua-devel lua-static
::* Download/extract the lua-1.0.0 source from here
::* Modify lua.c and lua_closure.h on the two lines where #if (PHP_MINOR_VERSION   19:10, 2 June 2015 (UTC)

29 May 2015
Changed $wgCacheEpoch to 20150521151500 on all wikis on content1/2/3 (no visible change in server loads). -- Daveh   12:50, 29 May 2015 (UTC)

27 May 2015
UsersEditCount_body.php: Changed to be user id-based, internally, due to changes in query functionality.  &ndash;       04:54, 27 May 2015 (UTC)

26 May 2015
Set the  page to not be cached by Squid (using a cache deny ... acl). -- Daveh   13:36, 26 May 2015 (UTC)

25 May 2015
Restarted memcached on content1 (small increase in server loads for 20 minutes). -- Daveh   12:09, 25 May 2015 (UTC)

22 May 2015
Upgraded wiki to v1.22.15. -- Daveh   15:19, 22 May 2015 (UTC)
Restarted memcached on content1. -- Daveh   15:19, 22 May 2015 (UTC)
Set the $wgCacheEpoch for the wiki/mobile-wiki on content1/2/3 to 20150522151500. -- Daveh   15:23, 22 May 2015 (UTC)
Re-applied the removal of the "What is this Ad?" and "Report Ad" buttons as done on the live site recently (changes were not propagated to the dev wiki). -- Daveh   15:41, 22 May 2015 (UTC)
Reverted $wgCacheEpoch back to a 2014 date due to very high loads on the content servers. Will slowly increase it to a post-upgrade date in the coming days/weeks. -- Daveh   16:07, 22 May 2015 (UTC)
Disabled the SearchLog extension on content1/2 to clear up the error log for better visibility of other problems. -- Daveh   16:57, 22 May 2015 (UTC)
Removed leftover  s from MetaTemplateSaveData.php.  &ndash;       20:12, 22 May 2015 (UTC)
Set   to allow CSS customizations to apply to preferences and login pages.  &ndash;       21:44, 22 May 2015 (UTC)

13 May 2015
Set innodb_file_per_table to ON in MySQL on content3 (for testing innobackupex partial restores). -- Daveh   12:55, 13 May 2015 (GMT)

8 May 2015
Set Squid on squid1 to only permit connections on port 80. -- Daveh   18:35, 8 May 2015 (GMT)

6 May 2015
Started vsftpd on content1 and set to start automatically on boot. -- Daveh   19:03, 6 May 2015 (GMT)

31 March 2015
Made several ad related changes at the request of Google to better agree with Adsense terms of use:
::* Tweaked wording on the support page (should not encourage users to click ads).
::* Removed the two links/labels surrounding ads ("What is this Ad" and "Report Ad"). The report ad feature doesn't work anyways due to changes in the Adsense API.
::* Added padding to the top of ad units to better separate them from the content.
::* Removed containing ``div`` explicit size and hidden overflow.
::* Removed old "report ad" JavaScript code from /w/extensions/UespCustomCode/modules/uesp.js..
::* All changes are in the skins/MonoBook.php and extensions/UespCustomCode/SiteMonobook.php files.
::* Updated files on content1/2/3 wikis (mobile uses different ad units and is not affected).
: -- Daveh   14:01, 31 March 2015 (GMT)

2 March 2015
Removed the old squid1 IP from the $wgSquidServers settings on all UESP wikis on content1/2/3. It was causing +10 sec delays on page saves due to timeouts trying to reach the old Squid server. -- Daveh   17:42, 2 March 2015 (GMT)

14 February 2015
Disabled /etc/cron.weekly/uesp-dumpxml-current on content3 as it was still causing a lock up on db2. -- Daveh   15:26, 14 February 2015 (GMT)

1 February 2015
Finish migrating all UESP services to new servers. -- Daveh   15:26, 14 February 2015 (GMT)

16 January 2015
UespEsoItemLink.php: Removed jQuery script line from   (after updating sidebar code) to fix issues with other Javascript applets.  &ndash;       03:06, 17 January 2015 (GMT)