[00:02:31] PROBLEM - cloud2 Current Load on cloud2 is CRITICAL: CRITICAL - load average: 37.43, 24.31, 15.76 [00:04:31] PROBLEM - cloud2 Current Load on cloud2 is WARNING: WARNING - load average: 19.43, 22.45, 16.16 [00:06:31] RECOVERY - cloud2 Current Load on cloud2 is OK: OK - load average: 10.11, 18.01, 15.30 [00:10:40] @hispano76 if you are around, maybe you can add `confirmed` and also patrol my edits? [00:26:38] ? [00:28:00] dmehus: not flag in wikis of Avengium [00:28:49] I am confused [00:55:39] @hispano76 Oh sorry, I assumed you were a `sysop` on that wiki. Nevermind then. :) [02:41:08] No problema dmehus [02:42:55] :) [09:03:40] PROBLEM - wiki.cdntennis.ca - LetsEncrypt on sslhost is WARNING: WARNING - Certificate 'wiki.cdntennis.ca' expires in 15 day(s) (Thu 29 Oct 2020 08:55:13 GMT +0000). [09:07:28] [02miraheze/ssl] 07MirahezeSSLBot pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTtwW [09:07:29] [02miraheze/ssl] 07MirahezeSSLBot 03a995985 - Bot: Update SSL cert for wiki.cdntennis.ca [09:08:40] PROBLEM - vault.aics.cf - LetsEncrypt on sslhost is WARNING: WARNING - Certificate 'vault.aics.cf' expires in 15 day(s) (Thu 29 Oct 2020 09:01:01 GMT +0000). [09:12:26] [02miraheze/ssl] 07MirahezeSSLBot pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTtrJ [09:12:28] [02miraheze/ssl] 07MirahezeSSLBot 0396a9730 - Bot: Update SSL cert for vault.aics.cf [09:16:58] RECOVERY - wiki.cdntennis.ca - LetsEncrypt on sslhost is OK: OK - Certificate 'wiki.cdntennis.ca' will expire on Mon 11 Jan 2021 08:07:21 GMT +0000. [09:22:12] RECOVERY - vault.aics.cf - LetsEncrypt on sslhost is OK: OK - Certificate 'vault.aics.cf' will expire on Mon 11 Jan 2021 08:12:20 GMT +0000. [10:21:23] Ok, i confirmed Dmehus on tuscriaturasWiki @dmehus, or @Doug [10:31:04] Hi [10:31:31] can i test on testwiki? i don't know that wiki but the name says is a wiki to test things [10:32:33] Are you talking about publictestwiki.com (or testwiki.miraheze.org)? [10:35:11] [02miraheze/services] 07MirahezeSSLBot pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTt1l [10:35:13] [02miraheze/services] 07MirahezeSSLBot 03c22bdb8 - BOT: Updating services config for wikis [10:41:00] I don't know, but testwiki perhaps [10:42:16] i want to test some CSS styling, without having to change my wiki [10:45:21] Yes, you can test stuff on testwiki. [10:45:30] ok, thanks [10:45:47] I am not sure if changing global CSS is allowed, however. [10:46:36] i can use User:Name/common.css then [10:50:53] @Reception123 , i have some issue that i think needs sysadmins. I uninstalled Extension:Wikibase (repository) on Tuscriaturas, but there were some wikibase items already. Because there is no repository, i can't delete that remaining items. Named: Q2 and Q3 on tuscriaturas. Should i install the extension again and delete the items, or wait for an admin that can delete that without install/uninstall?: [10:50:54] https://tuscriaturas.miraheze.org/wiki/Especial:Todas?from=&to=&namespace=860 [10:50:54] [ Todas las páginas (espacio de nombres Item) - Bestiario del Hypogripho ] - tuscriaturas.miraheze.org [12:46:21] PROBLEM - wiki.autocountsoft.com - reverse DNS on sslhost is WARNING: rDNS WARNING - reverse DNS entry for wiki.autocountsoft.com could not be found [12:46:23] PROBLEM - test1.miraheze.org - reverse DNS on sslhost is WARNING: rDNS WARNING - reverse DNS entry for test1.miraheze.org could not be found [12:46:27] PROBLEM - wiki.ripto.gq - reverse DNS on sslhost is WARNING: rDNS WARNING - reverse DNS entry for wiki.ripto.gq could not be found [12:46:35] PROBLEM - wiki.m.alirezaivaz.ir - reverse DNS on sslhost is WARNING: rDNS WARNING - reverse DNS entry for wiki.m.alirezaivaz.ir could not be found [12:46:35] PROBLEM - wiki.cloudytheology.com - reverse DNS on sslhost is WARNING: rDNS WARNING - reverse DNS entry for wiki.cloudytheology.com could not be found [12:53:07] RECOVERY - wiki.autocountsoft.com - reverse DNS on sslhost is OK: rDNS OK - wiki.autocountsoft.com reverse DNS resolves to cp6.miraheze.org [12:53:09] RECOVERY - test1.miraheze.org - reverse DNS on sslhost is OK: rDNS OK - test1.miraheze.org reverse DNS resolves to cp7.miraheze.org [12:53:14] RECOVERY - wiki.ripto.gq - reverse DNS on sslhost is OK: rDNS OK - wiki.ripto.gq reverse DNS resolves to cp6.miraheze.org [12:53:28] RECOVERY - wiki.m.alirezaivaz.ir - reverse DNS on sslhost is OK: rDNS OK - wiki.m.alirezaivaz.ir reverse DNS resolves to cp7.miraheze.org [12:53:32] RECOVERY - wiki.cloudytheology.com - reverse DNS on sslhost is OK: rDNS OK - wiki.cloudytheology.com reverse DNS resolves to cp6.miraheze.org [12:53:46] @paladox , I uninstalled Extension:Wikibase (repository) on Tuscriaturas, but there were some wikibase items already. Because there is no repository, i can't delete that remaining items. Named: Q2 and Q3 on tuscriaturas. Should i install the extension again and delete the items, or wait for an admin that can delete that without install/uninstall?: https://tuscriaturas.miraheze.org/wiki/Especial:Todas?from=&to=&namespace=860 [12:53:47] [ Todas las páginas (espacio de nombres Item) - Bestiario del Hypogripho ] - tuscriaturas.miraheze.org [12:54:08] you should install it again and delete [12:54:22] Ok, thanks [13:10:21] done [13:37:10] [02mw-config] 07paladox opened pull request 03#3290: test2wiki: Update sql location for 1.35 - 13https://git.io/JTqeq [13:37:25] [02miraheze/mw-config] 07paladox pushed 031 commit to 03paladox-patch-1 [+0/-0/±1] 13https://git.io/JTqeZ [13:37:26] [02miraheze/mw-config] 07paladox 0385330a6 - test2wiki: Update sql location for 1.35 [13:38:02] [02mw-config] 07paladox created branch 03paladox-patch-1 - 13https://git.io/vbvb3 [13:42:34] PROBLEM - cloud2 Current Load on cloud2 is CRITICAL: CRITICAL - load average: 24.64, 20.53, 16.86 [13:44:31] RECOVERY - cloud2 Current Load on cloud2 is OK: OK - load average: 13.14, 17.70, 16.27 [14:05:51] [02mw-config] 07paladox created branch 03paladox-patch-2 - 13https://git.io/vbvb3 [14:08:49] [02mw-config] 07paladox opened pull request 03#3291: Update path of sql files - 13https://git.io/JTqU7 [14:08:59] Morning JohnLewis [14:09:11] [02miraheze/mw-config] 07paladox pushed 031 commit to 03paladox-patch-2 [+0/-0/±1] 13https://git.io/JTqUF [14:09:12] [02miraheze/mw-config] 07paladox 034fc4d85 - Update path of sql files To be merged when we upgrade to 1.35. [14:09:17] hi [14:20:01] [02ssl] 07Reception123 closed pull request 03#365: Add arrowversewiki redirect to dcmultiversewiki - 13https://git.io/JTLiG [14:22:54] [02ssl] 07Reception123 commented on pull request 03#365: Add arrowversewiki redirect to dcmultiversewiki - 13https://git.io/JTqkh [14:25:06] [02miraheze/ssl] 07Reception123 pushed 032 commits to 03master [+0/-0/±2] 13https://git.io/JTqI0 [14:25:08] [02miraheze/ssl] 07Universal-Omega 0341636f5 - Add arowversewiki redirect to dcmultiversewiki After recently having arrowversewiki deleted I am now having it redirected to dcmultiversewiki. I will most likely have this redirect removed and the subdomain opened up again in a couple of months. [14:25:10] [02miraheze/ssl] 07Reception123 035f64a1e - Merge pull request #365 from Universal-Omega/patch-1 Add arrowversewiki redirect to dcmultiversewiki [14:33:51] PROBLEM - arrowverse.miraheze.org - LetsEncrypt on sslhost is WARNING: WARNING - Certificate '*.miraheze.org' expires in 9 day(s) (Thu 22 Oct 2020 23:59:59 GMT +0000). [14:41:17] Fun [14:41:53] paladox: when we deploying new? Tonight with maint? [14:42:15] new? [14:42:27] I think he's talking about 1.35 [14:42:57] oh, no, we're not deploing 1.35 yet. Only to test2. [14:43:35] paladox: ssl cert [14:43:42] I'm not talking about 1.3( [14:43:45] 1.35 [14:43:47] yes, new ssl certificate [14:43:51] You don't see icinga-miraheze on discord [14:44:28] Will that impact cookies? [14:44:32] paladox: I knew for mariadb. Will that clear icinga's alert? [14:44:38] Shouldn't [14:45:16] @paladox [14:45:41] no [14:46:39] Ok. Thanks. [14:47:07] [02miraheze/ssl] 07paladox pushed 031 commit to 03paladox-patch-1 [+0/-0/±1] 13https://git.io/JTqqw [14:47:08] [02miraheze/ssl] 07paladox 03b5b022f - Update wildcard.miraheze.org to wildcard.miraheze.org-2020 [14:47:10] [02ssl] 07paladox created branch 03paladox-patch-1 - 13https://git.io/vxP9L [14:47:11] [02ssl] 07paladox opened pull request 03#366: Update wildcard.miraheze.org to wildcard.miraheze.org-2020 - 13https://git.io/JTqqo [14:47:18] [02ssl] 07paladox edited pull request 03#366: rewrites: Update wildcard.miraheze.org to wildcard.miraheze.org-2020 - 13https://git.io/JTqqo [14:47:22] [02ssl] 07paladox edited pull request 03#366: redirects: Update wildcard.miraheze.org to wildcard.miraheze.org-2020 - 13https://git.io/JTqqo [14:47:27] [02ssl] 07paladox closed pull request 03#366: redirects: Update wildcard.miraheze.org to wildcard.miraheze.org-2020 - 13https://git.io/JTqqo [14:47:28] [02miraheze/ssl] 07paladox pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTqqP [14:47:30] [02miraheze/ssl] 07paladox 03df94e93 - Update wildcard.miraheze.org to wildcard.miraheze.org-2020 (#366) [14:47:31] [02ssl] 07paladox deleted branch 03paladox-patch-1 - 13https://git.io/vxP9L [14:47:33] [02miraheze/ssl] 07paladox deleted branch 03paladox-patch-1 [14:48:41] Ty paladox [14:48:48] RECOVERY - studynotekr.miraheze.org - Sectigo on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:50:24] RECOVERY - marthaspeaks.miraheze.org - Sectigo on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:50:35] RECOVERY - piwik.miraheze.org - Sectigo on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:50:39] RECOVERY - arrowverse.miraheze.org - LetsEncrypt on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:50:41] RECOVERY - dc.miraheze.org - LetsEncrypt on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:50:49] RECOVERY - dcmultiverse.miraheze.org - LetsEncrypt on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:50:52] RECOVERY - marvelcinematicuniverse.miraheze.org - LetsEncrypt on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:50:55] RECOVERY - intp.miraheze.org - Sectigo on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:50:58] RECOVERY - unmade.miraheze.org - Sectigo on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:50:58] RECOVERY - commonswiki.miraheze.org - Sectigo on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:51:00] RECOVERY - cnt.miraheze.org - Sectigo on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:51:02] RECOVERY - tallguysfree.miraheze.org - Sectigo on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:51:04] RECOVERY - sims.miraheze.org - Sectigo on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:51:06] RECOVERY - wiki.miraheze.org - Sectigo on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:51:11] RECOVERY - test1.miraheze.org - Sectigo on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:51:14] RECOVERY - uncyclopediakr.miraheze.org - Sectigo on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:51:24] RECOVERY - hellointernet.miraheze.org - Sectigo on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:55:19] paladox: why the mix of Sectigo and LE? [14:55:33] What do you mean mix? [14:56:10] paladox: look at the redirects file [14:56:15] yes? [14:56:20] Half the certs that just went ok are Sectigo [14:56:23] Half are LE [14:56:31] All *.miraheze.org [14:56:33] no, they all are Sectigo [14:56:45] well at least i don't see LE mentioned above [14:57:33] 15:50:52 RECOVERY - marvelcinematicuniverse.miraheze.org - LetsEncrypt on sslhost is OK: OK - Certificate '*.miraheze.org' will expire on Sat 23 Oct 2021 23:59:59 GMT +0000. [14:57:57] paladox: can you fix? [14:58:22] oh [14:59:31] [02miraheze/ssl] 07paladox pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTqYY [14:59:32] [02miraheze/ssl] 07paladox 038796fd6 - Fix CA for some domains [14:59:57] done [15:02:30] Ty [15:20:02] PROBLEM - duepedia.uk.to - LetsEncrypt on sslhost is WARNING: WARNING - Certificate 'duepedia.uk.to' expires in 15 day(s) (Thu 29 Oct 2020 15:16:46 GMT +0000). [15:22:00] [02miraheze/ssl] 07MirahezeSSLBot pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTqGL [15:22:02] [02miraheze/ssl] 07MirahezeSSLBot 03352cb39 - Bot: Update SSL cert for duepedia.uk.to [15:33:45] RECOVERY - duepedia.uk.to - LetsEncrypt on sslhost is OK: OK - Certificate 'duepedia.uk.to' will expire on Mon 11 Jan 2021 14:21:54 GMT +0000. [17:05:13] [02miraheze/services] 07MirahezeSSLBot pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTqzy [17:05:15] [02miraheze/services] 07MirahezeSSLBot 0340c0a77 - BOT: Updating services config for wikis [17:08:47] PROBLEM - ping6 on misc1 is CRITICAL: PING CRITICAL - Packet loss = 16%, RTA = 168.42 ms [17:09:18] * Spookreeeno here [17:10:16] paladox, SPF|Cloud: can we check misc1? [17:11:04] Or Reception123 / JohnLewis if you have access [17:12:04] RamNode has a history of IPv6 being poor, it's not a critical issue really because it doesn't have any impact on services [17:12:47] JohnLewis: misc1 is still RN? And yes icinga history says a lot [17:12:51] PROBLEM - ping6 on misc1 is WARNING: PING WARNING - Packet loss = 0%, RTA = 152.36 ms [17:13:05] misc1 has always been RN :) [17:13:28] Ye I must have just not realised we never moved it to an OVH VM [17:13:34] Is it worth us doing that? [17:14:12] It's been blocked on the whole LDAP thing until recently [17:15:12] Ok [17:16:52] PROBLEM - ping6 on misc1 is CRITICAL: PING CRITICAL - Packet loss = 16%, RTA = 125.52 ms [17:17:06] Yes icinga-miraheze we know [17:18:52] PROBLEM - ping6 on misc1 is WARNING: PING WARNING - Packet loss = 0%, RTA = 101.33 ms [17:22:51] RECOVERY - ping6 on misc1 is OK: PING OK - Packet loss = 0%, RTA = 19.81 ms [17:28:59] PROBLEM - ping6 on misc1 is WARNING: PING WARNING - Packet loss = 0%, RTA = 154.94 ms [17:31:00] RECOVERY - ping6 on misc1 is OK: PING OK - Packet loss = 0%, RTA = 35.10 ms [17:43:22] !log reception@jobrunner2:~$ sudo -u www-data php /srv/mediawiki/w/maintenance/importDump.php --report=1 --wiki minecraftathomewiki /home/reception/Wikipedia-20201013131148.xml [17:43:35] Logged the message at https://meta.miraheze.org/wiki/Tech:Server_admin_log [17:48:34] hi [17:50:24] hi [17:51:14] PROBLEM - ping6 on misc1 is CRITICAL: PING CRITICAL - Packet loss = 16%, RTA = 97.82 ms [17:53:14] RECOVERY - ping6 on misc1 is OK: PING OK - Packet loss = 0%, RTA = 92.71 ms [18:11:26] [02mw-config] 07paladox synchronize pull request 03#3291: Update path of sql files - 13https://git.io/JTqU7 [18:11:28] [02miraheze/mw-config] 07paladox pushed 031 commit to 03paladox-patch-2 [+0/-0/±1] 13https://git.io/JTq6e [18:11:29] [02miraheze/mw-config] 07paladox 033912f0a - Update ManageWikiExtensions.php [18:16:19] What kind of maintenance will you do? [18:17:31] [02miraheze/mediawiki] 07paladox pushed 031 commit to 03REL1_35 [+0/-1/±1] 13https://git.io/JTq6x [18:17:33] [02miraheze/mediawiki] 07paladox 0339ea8db - Remove Poll Was already removed via [1] [1] https://github.com/miraheze/mw-config/commit/614e8089760ccac737e85880530b810faeac8a9e [18:17:34] [ Remove Extension:Poll (#2707) · miraheze/mw-config@614e808 · GitHub ] - github.com [18:17:44] Database update and schema change hispano76 [18:37:13] [02miraheze/MirahezeMagic] 07paladox pushed 031 commit to 03paladox-patch-1 [+1/-0/±0] 13https://git.io/JTqPp [18:37:15] [02miraheze/MirahezeMagic] 07paladox 03e75f8f6 - Add script to mass run sql [18:37:16] [02MirahezeMagic] 07paladox created branch 03paladox-patch-1 - 13https://git.io/fQRGX [18:37:18] [02MirahezeMagic] 07paladox opened pull request 03#148: Add script to mass run sql - 13https://git.io/JTqPh [18:39:56] [02MirahezeMagic] 07paladox synchronize pull request 03#148: Add script to mass run sql - 13https://git.io/JTqPh [18:39:58] [02miraheze/MirahezeMagic] 07paladox pushed 031 commit to 03paladox-patch-1 [+0/-0/±1] 13https://git.io/JTqXY [18:39:59] [02miraheze/MirahezeMagic] 07paladox 03cac05e1 - Update massUpgradeSql.php [18:47:47] paladox: you plan to merge that? [18:47:54] Yeh [18:48:12] What's the difference between that and foreachwikiindblist? [18:48:14] useful in getting all the schema done rather than having to manaully start a sql.php my self. [18:48:36] Well the difference is all i have to do is copy and paste the schema into a text file [18:48:51] I'm happy to do it either way, just thought a text file would be better. [18:49:21] So, the answer is "no difference" then because you run foreachwikiindblist using a file [18:49:49] well i mean i would have to start foreachwikiindblist for each sql wouldn't i? [18:50:06] As opposed to adding it to a text file, then running the new script with foreachwikiindblist? [18:50:45] I'm confused, you're describing the same problem with two different fixes, except one fix has been a standard for years with us [18:50:53] What problem are you fixing here? [18:50:58] Either way, you could always have it in your homedir and run it from there [18:51:10] no problem [18:51:18] What does this script do, that foreachwikiindblist doesn't? [18:51:28] oh [18:51:33] Because as far as I can see, that script loops over a list of wikis and runs a script [18:52:15] in fact looking at it, that script on works on one wiki - so you'd need to run foreachwikiindblist anyway? [18:52:16] It takes a list of sql files doesn't it though [18:52:25] And iterates over that [18:52:30] ^ [18:52:34] Yes for each wiki would be needed [18:52:46] well i mean i would use the new script with foreachwikiindblist [18:53:06] the new script iterates over sql files to apply. [18:53:13] so all i have to do is: [18:53:25] Why not create one SQL file with the SQL in it? Problem would be solved and be less resource intensive [18:53:39] oh [18:54:14] and at the same time, you're reviewing the SQL, so it solves two problems at once [18:54:33] ok [18:54:40] [02MirahezeMagic] 07paladox closed pull request 03#148: Add script to mass run sql - 13https://git.io/JTqPh [18:54:42] [02MirahezeMagic] 07paladox deleted branch 03paladox-patch-1 - 13https://git.io/fQRGX [18:54:44] [02miraheze/MirahezeMagic] 07paladox deleted branch 03paladox-patch-1 [18:55:38] i've got a list of the schema anyways now. [18:55:44] (gone through each extension & core) [18:55:53] plus don't we run update.php at upgrades? [18:56:03] We didn't last time [18:56:19] No [18:56:25] https://meta.miraheze.org/wiki/Tech:Upgrading_MediaWiki docs are wrong then [18:56:26] [ Tech:Upgrading MediaWiki - Miraheze Meta ] - meta.miraheze.org [18:56:51] Most of our docs are wrong [18:57:19] removing that step [18:57:27] since the one above it is basically the one we should follow [18:57:34] gathering the schema and running sql.php [18:58:21] So then you'll need a list of wikis to run extension specific schema updates on then I presume? [19:00:19] [02miraheze/services] 07MirahezeSSLBot pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTqMz [19:00:21] [02miraheze/services] 07MirahezeSSLBot 034e2b60f - BOT: Updating services config for wikis [19:00:42] yeh [19:01:58] suppose i should just build a script for that [19:03:23] or just do it a quick way pending it being added to ManageWiki? [19:03:42] what do you mean by the quick way? [19:04:05] querying DB by use of a hack script on test2 [19:05:07] i was thinking of doing something similar to https://github.com/miraheze/MirahezeMagic/blob/master/maintenance/addWikiToServices.php JohnLewis (on test2 ofc) [19:05:08] [ MirahezeMagic/addWikiToServices.php at master · miraheze/MirahezeMagic · GitHub ] - github.com [19:05:53] That's a resource intensive way but a way [19:08:07] what is this hack script that is non intensive? Is it on test2 or is it i have to build it? JohnLewis [19:08:40] You have to build it because it's a LIKE query on the mw_settings table [19:08:45] *but its a [19:09:32] not using php? using shell right? [19:09:42] No, PHP [19:10:03] oh [19:11:07] then running exec via php? [19:13:15] JohnLewis ^ [19:13:54] hm? [19:14:10] then running exec() via the script (running sql.php) [19:15:08] I mean, you could but generating an appropriate database.json list to run foreachwikiindblist at a later time sounds more appropriate and consistent [19:15:27] oh [19:18:43] JohnLewis that seems like something complicated. I only say that because then we'll need a dblist file per extension. [19:19:30] Complicated or good practise [19:20:17] so i just copy https://github.com/miraheze/CreateWiki/blob/master/includes/CreateWikiJson.php#L91 [19:20:18] [ CreateWiki/CreateWikiJson.php at master · miraheze/CreateWiki · GitHub ] - github.com [19:26:47] databases.json only needs to be a flat array for foreachwikiindblist [19:28:48] Take a look at the bash script for more details in the form it requires [19:31:52] [02miraheze/dns] 07Reception123 pushed 031 commit to 03master [+1/-0/±0] 13https://git.io/JTqSM [19:31:54] [02miraheze/dns] 07Reception123 0302ecf9a - add bharatwiki.online zone [19:32:07] oh! so $list[] = $wiki->wiki_dbname; [19:33:08] Yeah [19:44:07] [02miraheze/mw-config] 07paladox pushed 031 commit to 03paladox-patch-3 [+0/-0/±1] 13https://git.io/JTq97 [19:44:09] [02miraheze/mw-config] 07paladox 037a6631a - Install babel sql when installing extension [19:44:11] [02mw-config] 07paladox created branch 03paladox-patch-3 - 13https://git.io/vbvb3 [19:44:12] [02mw-config] 07paladox opened pull request 03#3292: Install babel sql when installing extension - 13https://git.io/JTq95 [19:44:45] [02mw-config] 07paladox closed pull request 03#3292: Install babel sql when installing extension - 13https://git.io/JTq95 [19:44:47] [02miraheze/mw-config] 07paladox pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTq9N [19:44:49] [02miraheze/mw-config] 07paladox 03307c4e5 - Install babel sql when installing extension (#3292) [19:44:50] [02mw-config] 07paladox deleted branch 03paladox-patch-3 - 13https://git.io/vbvb3 [19:44:51] [02miraheze/mw-config] 07paladox deleted branch 03paladox-patch-3 [19:46:26] miraheze/mw-config/paladox-patch-3/7a6631a - paladox The build has errored. https://travis-ci.org/miraheze/mw-config/builds/735511279 [19:53:36] [02miraheze/mw-config] 07paladox pushed 031 commit to 03paladox-patch-3 [+0/-0/±1] 13https://git.io/JTqHS [19:53:38] [02miraheze/mw-config] 07paladox 03119c2ce - Set wikis into read only [19:53:39] [02mw-config] 07paladox created branch 03paladox-patch-3 - 13https://git.io/vbvb3 [19:53:41] [02mw-config] 07paladox opened pull request 03#3293: Set wikis into read only - 13https://git.io/JTqH9 [19:53:55] 7 mins paladox [19:54:00] yup [19:54:34] [02puppet] 07paladox closed pull request 03#1506: mariadb: Update ssl certificate - 13https://git.io/JTL2A [19:54:35] [02miraheze/puppet] 07paladox pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTqHb [19:54:37] [02miraheze/puppet] 07paladox 03cfa500a - mariadb: Update ssl certificate (#1506) [19:54:38] [02puppet] 07paladox deleted branch 03paladox-patch-3 - 13https://git.io/vbiAS [19:54:40] [02miraheze/puppet] 07paladox deleted branch 03paladox-patch-3 [19:57:01] .op [19:57:01] Attempting to OP... [19:59:09] !log downtimed db* & sslhost in icinga [19:59:12] Logged the message at https://meta.miraheze.org/wiki/Tech:Server_admin_log [19:59:52] [02mw-config] 07paladox closed pull request 03#3293: Set wikis into read only - 13https://git.io/JTqH9 [19:59:54] [02miraheze/mw-config] 07paladox pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTqQl [19:59:55] [02miraheze/mw-config] 07paladox 03822019f - Set wikis into read only (#3293) [19:59:57] [02miraheze/mw-config] 07paladox deleted branch 03paladox-patch-3 [19:59:58] [02mw-config] 07paladox deleted branch 03paladox-patch-3 - 13https://git.io/vbvb3 [20:00:01] paladox: Let's go! [20:00:07] yup! [20:00:22] !log starting database maintenance on db[11-13] & db7 [20:00:25] Logged the message at https://meta.miraheze.org/wiki/Tech:Server_admin_log [20:00:36] (It's also a song) [20:00:46] !log stop mysql replication on db7 [20:00:49] Logged the message at https://meta.miraheze.org/wiki/Tech:Server_admin_log [20:01:26] Edits have definitely stopped [20:02:18] !log stop mysql on db11 & upgrade [20:04:37] PROBLEM - test2 MediaWiki Rendering on test2 is CRITICAL: HTTP CRITICAL: HTTP/1.1 500 Internal Server Error - 1000 bytes in 0.030 second response time [20:04:39] PROBLEM - mw5 MediaWiki Rendering on mw5 is CRITICAL: HTTP CRITICAL: HTTP/1.1 500 Internal Server Error - 1000 bytes in 0.030 second response time [20:04:43] oh [20:04:45] i forgot mw* [20:04:55] Expected [20:04:58] PROBLEM - cp6 Varnish Backends on cp6 is CRITICAL: 4 backends are down. mw4 mw5 mw6 mw7 [20:05:27] !log stop mysql on db12 & upgrade [20:05:31] PROBLEM - ns1 GDNSD Datacenters on ns1 is CRITICAL: CRITICAL - 5 datacenters are down: 128.199.139.216/cpweb, 2400:6180:0:d0::403:f001/cpweb, 51.89.160.142/cpweb, 2001:41d0:800:1056::2/cpweb, 51.222.27.129/cpweb [20:06:37] RECOVERY - test2 MediaWiki Rendering on test2 is OK: HTTP OK: HTTP/1.1 200 OK - 17241 bytes in 0.123 second response time [20:06:39] RECOVERY - mw5 MediaWiki Rendering on mw5 is OK: HTTP OK: HTTP/1.1 200 OK - 18096 bytes in 0.120 second response time [20:06:57] RECOVERY - cp6 Varnish Backends on cp6 is OK: All 7 backends are healthy [20:07:29] RECOVERY - ns1 GDNSD Datacenters on ns1 is OK: OK - all datacenters are online [20:08:22] !log stop mysql on db13 & upgrade [20:10:56] [02miraheze/mw-config] 07paladox pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTq7O [20:10:58] [02miraheze/mw-config] 07paladox 03a76011f - Revert "Set wikis into read only (#3293)" This reverts commit 822019f1fa0a458cbe6f1fe27a338c371f3f1a66. [20:11:31] [02miraheze/mw-config] 07paladox pushed 031 commit to 03paladox-patch-3 [+0/-0/±1] 13https://git.io/JTq7Z [20:11:33] [02miraheze/mw-config] 07paladox 03a9c9f8d - Remove site notice Maintenance over. [20:11:34] [02mw-config] 07paladox created branch 03paladox-patch-3 - 13https://git.io/vbvb3 [20:11:36] [02mw-config] 07paladox opened pull request 03#3294: Remove site notice - 13https://git.io/JTq7n [20:11:43] [02mw-config] 07paladox closed pull request 03#3294: Remove site notice - 13https://git.io/JTq7n [20:11:45] [02miraheze/mw-config] 07paladox pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTq7c [20:11:46] [02miraheze/mw-config] 07paladox 0328cc13f - Remove site notice (#3294) Maintenance over. [20:12:14] !log stop mysql on db7 & upgrade [20:12:21] !log [21:02:18] <+paladox> !log stop mysql on db11 & upgrade [20:12:25] Logged the message at https://meta.miraheze.org/wiki/Tech:Server_admin_log [20:12:30] !log [21:05:27] <+paladox> !log stop mysql on db12 & upgrade [20:12:35] !log [21:08:22] <+paladox> !log stop mysql on db13 & upgrade [20:12:36] Logged the message at https://meta.miraheze.org/wiki/Tech:Server_admin_log [20:12:39] Logged the message at https://meta.miraheze.org/wiki/Tech:Server_admin_log [20:14:10] * Spookreeeno passes paladox a soft drink of choice over irc [20:14:19] heh [20:14:53] paladox: I would say a drink but you don't drink as far as I remember [20:15:00] yeh :D [20:15:43] [02miraheze/mw-config] 07paladox deleted branch 03paladox-patch-3 [20:15:44] [02mw-config] 07paladox deleted branch 03paladox-patch-3 - 13https://git.io/vbvb3 [20:15:53] I barely drink anything [20:18:54] !log start replication on db7 [20:18:57] Logged the message at https://meta.miraheze.org/wiki/Tech:Server_admin_log [20:22:06] PROBLEM - cloud2 Current Load on cloud2 is CRITICAL: CRITICAL - load average: 26.74, 20.03, 14.44 [20:22:41] That was... fast [20:22:52] It was [20:22:59] Remember last year paladox [20:23:12] You mean earlier this year? [20:24:06] RECOVERY - cloud2 Current Load on cloud2 is OK: OK - load average: 19.19, 20.26, 15.27 [20:24:20] paladox: whenever last renewal was [20:24:34] ah yeh, last october [20:25:36] That definately wasn't so fun [20:26:19] yeh [20:26:47] :) [21:04:35] Fun fact the "extra" is cut because of username limit I originally want "CircleyDoesExtracter" [21:06:44] Oh, neat. [21:07:55] @NDKilla Circley seems to be authenticated on IRC now. Just wondering if have requested a Miraheze IRC cloak for him [22:00:25] PROBLEM - vsfan.net - reverse DNS on sslhost is WARNING: rDNS WARNING - reverse DNS entry for vsfan.net could not be found [22:00:25] PROBLEM - shkilev.online - reverse DNS on sslhost is WARNING: rDNS WARNING - reverse DNS entry for shkilev.online could not be found [22:00:25] PROBLEM - wiki.8b8t.com - reverse DNS on sslhost is WARNING: rDNS WARNING - reverse DNS entry for wiki.8b8t.com could not be found [22:00:25] PROBLEM - drag.lgbt - LetsEncrypt on sslhost is CRITICAL: CRITICAL - Cannot make SSL connection. [22:00:25] PROBLEM - drag.lgbt - reverse DNS on sslhost is CRITICAL: rDNS CRITICAL - drag.lgbt reverse DNS resolves to 30.99.98.34.bc.googleusercontent.com [22:00:26] PROBLEM - wiki.insideearth.info - reverse DNS on sslhost is WARNING: rDNS WARNING - reverse DNS entry for wiki.insideearth.info could not be found [22:00:26] PROBLEM - wiki.lbcomms.co.za - reverse DNS on sslhost is CRITICAL: rDNS CRITICAL - wiki.lbcomms.co.za All nameservers failed to answer the query. [22:00:27] PROBLEM - wiki.opendominion.net - reverse DNS on sslhost is WARNING: rDNS WARNING - reverse DNS entry for wiki.opendominion.net could not be found [22:00:27] PROBLEM - museummiddelland.nl - reverse DNS on sslhost is WARNING: rDNS WARNING - reverse DNS entry for museummiddelland.nl could not be found [22:25:32] PROBLEM - thelonsdalebattalion.co.uk - LetsEncrypt on sslhost is WARNING: WARNING - Certificate 'thelonsdalebattalion.co.uk' expires in 15 day(s) (Thu 29 Oct 2020 22:19:06 GMT +0000). [22:32:28] [02miraheze/ssl] 07MirahezeSSLBot pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTmvN [22:32:29] [02miraheze/ssl] 07MirahezeSSLBot 039003df8 - Bot: Update SSL cert for thelonsdalebattalion.co.uk [22:45:29] RECOVERY - thelonsdalebattalion.co.uk - LetsEncrypt on sslhost is OK: OK - Certificate 'thelonsdalebattalion.co.uk' will expire on Mon 11 Jan 2021 21:32:21 GMT +0000. [23:10:20] [02miraheze/services] 07MirahezeSSLBot pushed 031 commit to 03master [+0/-0/±1] 13https://git.io/JTmUS [23:10:22] [02miraheze/services] 07MirahezeSSLBot 0338b786e - BOT: Updating services config for wikis [23:30:30] PROBLEM - db7 Check MariaDB Replication on db7 is CRITICAL: MariaDB replication - both - CRITICAL - Slave_IO_Running state : Yes, Slave_SQL_Running state : Yes, Seconds_Behind_Master : 140s [23:36:29] RECOVERY - db7 Check MariaDB Replication on db7 is OK: MariaDB replication - both - OK - Slave_IO_Running state : Yes, Slave_SQL_Running state : Yes, Seconds_Behind_Master : 0s [23:57:57] Hello barrierswillatta! If you have any questions, feel free to ask and someone should answer soon.