[12:54:41] jynus: hello [12:54:58] Glaisher, hello [12:55:41] could you do a select query for me on log_search.. it's not on _p db. [12:55:45] not the actual results [12:55:51] just whether there are some results when you run it [12:56:08] paste it somewhere [12:56:08] for https://phabricator.wikimedia.org/T113141 [12:56:57] PMd [13:05:01] yes, I can see exactly that on the production databases [13:05:09] ^Glaisher [13:05:29] You mean, there are no results? [13:06:00] no, I can see the linked results of the ticket [13:06:42] https://meta.wikimedia.org/w/index.php?title=Special%3ALog&type=gblrename&user=&page=&oldname=&year=2015&month=8&tagfilter= [13:07:01] hmm okay [13:07:11] That means there are no matching entries on log_search [13:08:01] jynus: Could you also do SELECT * from `log_search` where ls_log_id = '13203691' ? [13:08:24] to check whether it actually has a matching row on log_search [13:08:41] can confirm it is on all servers, not only in one [13:10:26] hmm [13:10:30] that confirms it [13:10:33] I have 1 result [13:11:39] https://phabricator.wikimedia.org/T113141#1655925 [13:14:28] sorry, do not know the background, but you may be having problems for having filters on WHERE instead of ON? [13:17:11] I think I found the issue [13:17:25] It's because we're doing the where even when it's not needed [13:21:08] jynus: Thanks. I think that will fix it. [13:22:03] :-) [16:09:45] jynus: Hi. Can you take a look at https://phabricator.wikimedia.org/T74525#1656127 if you have time? [16:11:52] cannot now [16:12:29] It's okay even if it's not now [16:24:23] Glaisher: I'm not sure what you're expecting that to do... [16:24:33] Oh.. [16:24:41] get all the field names having namespace [16:25:00] I'm not sure whether it works though [16:25:03] I wonder if we have any not called namespace :D [16:25:33] argh :-/ [16:26:00] But yes, that works for stuff called namespace, see my reply [16:26:33] logging_pre_1_10 looks like a candidate to drop [16:28:25] wtf.. is that a table used in mw1.10? [16:28:41] It was probably a backup tabled created in production [16:29:01] There's various like that around [16:29:05] Or were [16:33:57] * Reedy adds note to https://phabricator.wikimedia.org/T54932 [16:41:20] jynus: do you want https://phabricator.wikimedia.org/tag/database/ changes reported in here? Or is that just more noise? [16:47:33] Reedy, ideally, do not ping unless it is an emergency or I have not shown activity in a week and I am blocking you [16:48:08] for the tasks? Or specifically irc pings? [16:48:15] irc [16:48:24] ok, will make a note of that :) [16:48:34] sorry [16:48:46] as an op, I am "always" available, which means I may think there is an emergency ongoig [16:49:16] not cool if it can wait [16:49:54] it is very easy to see if I want to be pinged, check if I am away :-) [16:50:14] Unless things are changed, most of the other opsen aren't like that... You usually have to start sms-ing them to raise them in emergencies ;) [16:51:02] well, people like having lifes [16:51:44] sure, I didn't expect pinging you on irc to propogate a ping further than your irc client [16:52:23] I am temporarily the only DBA, which means a SPOF [16:52:37] hopefully we will fix it soon [16:53:57] comment here as much as you want (db related), I will read it when available