[06:49:04] <_joe_> majavah: the network won't kick anyone off for pasting 8 lines of text, and I don't think people need the IRC police, FWIW [14:09:29] you know things have gone horribly wrong when you're reading the mariadb source code to figure something out [14:12:50] kormat: that's gonna be a fun rabbit hole [14:21:31] `char escape= 0; /* symbol is protected by escape chagacter */` 😬 [17:12:09] welcome to the "reading source code of things-you'd-rather-not-read" club. we have members in it for php source, python source, nfs source and of course mariadb source [17:20:30] apergos: it's much worse than i thought [17:21:02] uh oh [17:21:13] <_joe_> kormat: tell me one time you read some source code for $important_piece_of_software and you didn't feel that way [17:21:49] <_joe_> when I read the code for mod_proxy_fcgi the first time I was actually amazed that bowl of spaghetti has so few bugs [17:22:13] <_joe_> same with almost all source code I read, especially if it has a long history [17:23:00] <_joe_> there are exceptions, but I didn't expect mariadb to fall in the category [17:25:02] oh look, I have apache source and docker in my git clone list too (meaning I've dug around in their bowels as well) [17:25:34] this is why I don't look at the top level of my source directory tree very often. too depressing [18:33:26] kormat: per https://blog.sesse.net/blog/tech/2021-12-05-16-41_leaving_mysql it sounds that's just the tip of the iceberg :-) [18:42:57] moritzm: 'yaay' :) [19:23:24] kormat: Im poking around the x2 databases a bit to see where we are today. I'm seeing no databases and no tables (other than sys/heartbeat/info dbs) from the wikiadmin user. Is that expected? [19:23:50] using mysql --defaults-extra-file=x.ini --user=wikiadmin --host=db1151.eqiad.wmnet, from mwmaint1002 [19:25:21] Krinkle: last i heard x2 is not in use yet [19:25:48] kormat: yep, I'm just checking for the year end to write down what's next. [19:26:09] I guess we never wrote down explicitly which dbs/table schema we need. [19:27:30] I mentally was in teh state where it was not in use, but ready to go any time. [19:27:48] which I guess is true from the mysql and hardware perspectice :) [19:27:54] yeah :) [19:28:24] MW auto-creates objectcache tables for pc and mainstash as-needed [19:28:32] but it does not auto-create the DB [19:29:18] it's actually non-obvious which DB name that would be. there is no default, and we've never wired mainstash to something that has a named db as such (unlike memc or redis). [19:29:33] alright, I'll start with that next year then. Thanks. [19:30:21] 👍 [19:34:31] on x1 the database is called "wikishared" iirc [21:33:52] yep. see https://phabricator.wikimedia.org/T212129#7586500 [21:34:55] * Krinkle updated also https://wikitech.wikimedia.org/wiki/MariaDB#x1