[01:05:41] I added the lockdown-notice on sv.wp's Village Pump https://sv.wikipedia.org/wiki/Wikipedia:Bybrunnen#Wikipedia_kommer_under_en_kortare_tidsperiod_vara_m.C3.B6jliga_att_l.C3.A4sa_men_inte_att_redigera [02:54:48] happy belated birthday James_F :D [19:28:27] Is it normals that quarry needs more then an hour for its querys? [19:29:18] Depends what the query is [19:29:39] Something like that: http://quarry.wmflabs.org/query/8769 [19:30:04] it's not, it should kill your query after ten minutes or so [19:30:12] hmm. that one is not executing though, but queued? weird [19:31:53] I have two or three queries in wikidata_p and dewiki_p that behave the same way [19:32:04] MGC_: that is probably not a super-performant query though, there's no index on log_action. if you specified log_type too, it'd be better [19:32:28] (there is an index on (log_type, log_action, log_timestamp)) [19:34:20] I try again with log_type specified [19:35:33] MGC_: the result is 20130214181344 :) [19:36:02] https://phabricator.wikimedia.org/P2847 [19:36:33] interesting how long it took. [19:37:25] MGC_: https://phabricator.wikimedia.org/P2847 [19:37:31] Thank you :) [19:37:37] that still took pretty long. weird. [19:39:01] And my query is still queued. Strange. I do some research about the log_actions of newusers. The format apparently changed since the log was introduced [19:40:41] But I couldn't find any documentation about that [20:08:40] Is it also possible to start querys in databases of beta cluster? [21:33:02] MGC_: sometimes "queued" is a misnomer for "never acknowledged" in my experience, click "submit" again :) [21:38:39] Ah [21:39:46] Nemo_bis: I got some really strange results in the time until now, sometimes wikidata_p isn't existing for esample, but if I submit the query again, it works... [22:01:00] How can such querys actually have results: http://quarry.wmflabs.org/query/8779 ?