[00:33:20] <BlankEclair>	 > [19/03/2025 11:30] <MirahezeLSBot> !log [blankeclair@mwtask151] sudo -u www-data /usr/local/bin/foreachwikiindblist /srv/mediawiki/cache/databases.php /srv/mediawiki/1.43/maintenance/run.php sql /srv/mediawiki/1.43/extensions/GlobalBlocking/sql/mysql/patch-global_block_whitelist-default-gbw_address.sql (START)
[00:33:25] <BlankEclair>	 this is taking foreeeeever
[00:33:44] <BlankEclair>	 i wonder if we can have some sort of script that connects to the database _once_ and runs sql statements across all the wikis in that db
[00:33:56] <BlankEclair>	 y'know, connection reuse
[00:45:50] <BlankEclair>	 so i did some calcs
[00:45:55] <BlankEclair>	 > `time { for i in {1..100}; do echo 'SELECT COUNT(*) FROM mhglobal.cw_wikis;' | sudo -u www-data php /srv/mediawiki/1.43/maintenance/run.php sql --wiki=metawiki > /dev/null; done; }`
[00:45:58] <BlankEclair>	 > `real    1m22.899s`
[00:46:08] <BlankEclair>	 > `time { for i in {1..100}; do echo 'SELECT COUNT(*) FROM mhglobal.cw_wikis;'; done | sudo -u www-data php /srv/mediawiki/1.43/maintenanc e/run.php sql --wiki=metawiki > /dev/null; }`
[00:46:13] <BlankEclair>	 > `real    0m1.437s`
[00:46:45] <BlankEclair>	 obviously that's a SELECT COUNT(*) query for one table, but still
[07:48:01] <MirahezeRelay>	 <robla> [1/8] okay, y'all know that all of the wikis are down (at least, for me in San Francisco):. To quote what I see on miraheze.org
[07:48:02] <MirahezeRelay>	 <robla> [2/8] > Something went wrong
[07:48:02] <MirahezeRelay>	 <robla> [3/8] > Give it a bit and try again.
[07:48:02] <MirahezeRelay>	 <robla> [4/8] > 
[07:48:03] <MirahezeRelay>	 <robla> [5/8] > When reporting this, please include the information below:
[07:48:03] <MirahezeRelay>	 <robla> [6/8] > 
[07:48:03] <MirahezeRelay>	 <robla> [7/8] > Error 503 Backend fetch failed via cp38 at Wed, 19 Mar 2025 07:44:52 GMT
[07:48:04] <MirahezeRelay>	 <robla> [8/8] > Varnish XID 177244889, serving 135.180.107.xxx
[07:57:14] <MirahezeRelay>	 <robla> All of my wikis are back now, as is miraheze.org, it seems.
[09:12:25] <MirahezeRelay>	 <aeywoo, replying to theoneandonlylegroom> Oh hey, another db181 error.
[09:14:35] <MirahezeRelay>	 <aeywoo, replying to aeywoo> @cosmicalpha is this something we should try?
[09:34:16] <MirahezeRelay>	 <rhinosf1, replying to aeywoo> i'm running mysqlcheck now
[09:34:21] <MirahezeRelay>	 <rhinosf1> but i think it's a sad db
[09:35:06] <MirahezeRelay>	 <aeywoo> We must sent chocolates and flowers to the db pronto!
[09:44:38] <MirahezeRelay>	 <rhinosf1, replying to aeywoo> please
[09:44:41] <MirahezeRelay>	 <rhinosf1> and to me
[09:51:44] <MirahezeRelay>	 <aeywoo, replying to rhinosf1> Time to rebuild it?
[09:54:05] <MirahezeRelay>	 <rhinosf1, replying to aeywoo> i'm doing that on the crying one
[09:54:19] <MirahezeRelay>	 <rhinosf1> which just exploded with mysqlcheck during user traffic
[09:54:30] <MirahezeRelay>	 <aeywoo> Yeah, that's not good.
[10:04:04] <MirahezeRelay>	 <rhinosf1, replying to aeywoo> db finally brought back to life
[10:04:07] <MirahezeRelay>	 <rhinosf1> and running mysqlcheck
[10:07:32] <MirahezeRelay>	 <aeywoo, replying to rhinosf1> The chocolates were successfully deployed.
[10:07:44] <MirahezeRelay>	 <aeywoo> We are now assigning the ticket to a license therapist.
[10:08:02] <MirahezeRelay>	 <rhinosf1, replying to aeywoo> i will need it
[21:49:07] <BlankEclair>	 i love php
[21:49:11] <BlankEclair>	 > gay::class
[21:49:12] <BlankEclair>	 = "gay"
[21:57:36] <MirahezeRelay>	 <angry_the_kidd4681> I keep running into the Lua error: callParserFunction: function "#translation" was not found. error.
[21:59:53] <MirahezeRelay>	 <rodejong, replying to angry_the_kidd4681> Link to your wikipage?
[22:01:01] <MirahezeRelay>	 <rodejong, replying to BlankEclair> _= Hetero_
[22:01:16] <MirahezeRelay>	 <rodejong> 🤷🏻‍♂️
[22:17:19] <MirahezeRelay>	 <angry_the_kidd4681> I got the link! https://fnafa.miraheze.org/wiki/Template:Infobox_video_game
[22:37:44] <MirahezeRelay>	 <rodejong, replying to angry_the_kidd4681> Okay.. Looking
[22:40:17] <MirahezeRelay>	 <rodejong> [1/2] Ah... Yeah, this doesn't work, as we can't pull the data from Wikidata like that. @.labster is better at explaining that. 
[22:40:17] <MirahezeRelay>	 <rodejong> [2/2] But basically, you'd need to query each instance yourself
[22:41:15] <MirahezeRelay>	 <rodejong> And unfortunately, there aren't many who understand LUA/Wikidata.
[23:02:57] <BlankEclair>	 does anyone database more than me?
[23:03:10] <BlankEclair>	 trying to do `ALTER TABLE pagelinks MODIFY pl_target_id BIGINT UNSIGNED NOT NULL;` on animebathswiki, got:
[23:03:14] <BlankEclair>	 Wikimedia\Rdbms\DBQueryError: Error 1265: Data truncated for column 'pl_target_id' at row 86406
[23:03:34] <BlankEclair>	 here's the column per DESCRIBE pagelinks:
[23:03:38] <BlankEclair>	 > stdClass Object
[23:03:43] <BlankEclair>	 > (
[23:03:43] <BlankEclair>	 >     [Field] => pl_target_id
[23:03:43] <BlankEclair>	 >     [Type] => bigint(20) unsigned
[23:03:44] <BlankEclair>	 >     [Null] => YES
[23:03:45] <BlankEclair>	 >     [Key] => MUL
[23:03:47] <BlankEclair>	 >     [Default] => 
[23:03:48] <BlankEclair>	 >     [Extra] => 
[23:03:50] <BlankEclair>	 > )
[23:04:21] <BlankEclair>	 i don't see why it would be truncated? it'd be an unsigned bigint to an unsigned bigint (and i tried `ALTER TABLE pagelinks MODIFY pl_target_id BIGINT(20) UNSIGNED NOT NULL` as well, same error)
[23:04:36] <BlankEclair>	 (this is all in a transaction of course)
[23:09:01] <BlankEclair>	 > SELECT pl_target_id FROM pagelinks ORDER BY pl_target_id DESC LIMIT 1;
[23:09:04] <BlankEclair>	 >     [pl_target_id] => 10937
[23:09:08] <BlankEclair>	 what kinda truncation would happen lmfao
[23:09:22] <BlankEclair>	 OH i think it's the nullable values?
[23:10:02] <BlankEclair>	 it's the um
[23:10:06] <BlankEclair>	 > [pl_target_id] => 
[23:10:08] <BlankEclair>	 the  value
[23:10:25] <BlankEclair>	 doing WHERE pl_target_id = NULL OR pl_target_id = '' didn't select them
[23:10:28] <BlankEclair>	 wtf lol
[23:12:57] <MirahezeRelay>	 <orduin> Gotta do NULL checks like Python: `WHERE pl_target_id IS NULL`
[23:14:53] <BlankEclair>	 huh! that worked! ty lol
[23:15:48] <BlankEclair>	 https://mariadb.com/kb/en/null-values/#comparison-operators
[23:15:50] <BlankEclair>	 ok gtg lol
[23:45:11] <MirahezeRelay>	 <pixldev, replying to BlankEclair> Anime Bath wiki MH is still used?