05:24 PuppyKun: ndkilla@cp1: removed two files from /srv/mediawiki-static/bgowiki/ at the request of boardgame-online.com staff (reason: personal/inappropriate use of photographs)
14:29 Southparkfan: ran insert into cw_wikis values (‘mychartwiki’, ‘Music Charts’, ’es’, 0, 0, NULL); - Reception123 accidentally thought this wiki was eligible for deletion
21:58 Southparkfan: Ran git reset –hard origin/master for puppet git on all cache proxies. Ran puppet on cp1 (which restarted Varnish), now fighting with a lack of RAM on cp2 to run puppet there too…
21:53 John: for puppet, to clarify
21:53 John: protected “master” branch in GitHub
15:38 John: upgraded
15:37 John: upgrading phabricator
15:23 John: SocialProfile SQL changes on all wikis
01:59 PuppyKun: PLEASE FOR THE LOVE OF GOD UPDATE THE SSL SCRIPT AND THE DIRECTIONS THIS ENTIRE ISSUE WAS CAUSED BY PUSHING THE WRONG KEY TO PRIVATE-GIT BECAUSE THERE WERE 3 ATT KEYS
01:59 PuppyKun: puppet force-push put mw1 back in production, worked anyways
14:51 Reception123: ran sudo -u www-data php importDump.php –wiki pluspiwiki –uploads /home/reception/pluspi.xml/ (not all uploads were done; requested by user)
02:03 PuppyKun: ensured runJobs cron creation on mw1
02:02 PuppyKun: stopped jobrunner on mw1
01:26 PuppyKun: restarted redis-server (OOM at 0043 server time)
00:51 labster: ran php /srv/mediawiki/w/maintenance/showJobs.php –group –wiki allthetropeswiki and it took two whole hours thanks to me editing a template
17:28 Reception123: ran sudo -u www-data /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblist/all.dblist /srv/mediawiki/w/maintenance/runJobs.php
17:27 Reception123: sudo service jobrunner restart
16:04 PuppyKun: restarted jobrunner on mw1
14:20 Southparkfan: force-run of runJobs.php on all wikis
14:09 Southparkfan: restarted jobrunner on mw1. Not in failed state (unlike previous failures)
10:45 Reception123: ran sudo -u www-data /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblist/all.dblist /srv/mediawiki/w/maintenance/runJobs.php (restarting jobrunner service has no effect)
10:44 Reception123: restarted jobrunner on mw1 (still doesn’t work)
10:09 Reception123: restarted jobrunner on mw1 (T621, SPF)
04:42 Reception123: ran sudo -u www-data /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblist/all.dblist /srv/mediawiki/w/maintenance/runJobs.php on mw* (NOTE: I know that I shouldn’t have done this, but there was no other sysadmin and this issue is urgent to resolve as more people were complaining about it.)
04:20 Reception123: ran sudo -u www-data php /srv/mediawiki/w/maintenance/rebuildLocalisationCache.php –wiki extloadwiki (error with categories; making sure it’s not because of this)
18:06 Reception123: ran sudo -u www-data php /srv/mediawiki/w/maintenance/rebuildLocalisationCache.php –wiki extloadwiki on mw*
11:14 PuppyKun: restarted redis-server on misc2. Not sure what affect this has on current logins but the service stopped unexpectedly roughly 13 hours ago
09:57 Reception123: ran sudo -u www-data php /srv/mediawiki/w/maintenance/rebuildLocalisationCache.php –wiki extloadwiki on mw* (attempting to fix error with extension)
22:02 labster: [allthetropeswiki]> drop table time_zone; drop table time_zone_leap_second; drop table time_zone_name; drop table time_zone_transition; drop table time_zone_transition_type;
20:55 John: MariaDB [allthetropeswiki]> DROP TABLE event,general_log,procs_priv,proxies_priv,servers,tables_priv;
20:48 John: MariaDB [allthetropeswiki]> DROP TABLE proc;
14:37 John: update phabricator to stable
08:56 John: rm /bacula/backups/STATIC-0004 /bacula/backups/STATIC-0008 on bacula1
08:34 John: MariaDB [allthetropeswiki]> DROP TABLE host;
08:34 John: MariaDB [allthetropeswiki]> DROP TABLE columns_priv, func, db;
21:10 Southparkfan: MariaDB [allthetropeswiki]> update page set page_content_model = ‘flow-board’ where page_namespace = 3 and page_title not like ‘%/%’ and page_content_model = ‘wikitext’; to fix https://phabricator.miraheze.org/T340
15:44 Southparkfan: /srv/mediawiki/w/extensions/CentralAuth/maintenance# php deleteEmptyAccounts.php –wiki metawiki –fix –safe-migrate to delete global acocunts without any attached users
15:16 Southparkfan: foreachwikiindblist /srv/mediawiki/dblist/all.dblist maintenance/checkLocalUser.php –verbose 1 –delete > ~/tmp-ca.log at mw1 to fix annoying “Could not find user data for” MWExceptions
02:06 PuppyKun: ran SQL query “UPDATE cw_wikis SET wiki_closed=1 WHERE wiki_dbname=‘quantixwiki’ OR wiki_dbname=‘catboxwiki’ or wiki_dbname=‘emptysetwiki’;” on mw1
02:05 PuppyKun: Manually restarted HHVM on mw1 ~10 mins ago
01:46 PuppyKun: manually ran update.php on adnovumwiki. failed the first time due to global blocking table already existing (this usually doesn’t cause it to fail?) running it again finished successfully in 0.7s