Topic on Talk:Quarry

Jump to navigation Jump to search
Mike Peel (talkcontribs)

I've been trying to run https://quarry.wmflabs.org/query/28096 for the last few days, but it keeps timing out. It normally works (or works after timing out once or twice). Are things running slow on the back-end? If so, would it be possible to increase the time-out from 30 minutes to 60 minutes or so? Thanks!

Zhuyifei1999 (talkcontribs)

It says it's executed in 894.39 seconds. Is this still an issue?

Mike Peel (talkcontribs)

I just reran it again today, and it worked first time with an execution time of 735.61 - so maybe this is resolved. However, let's see how it goes over the next week...

Framawiki (talkcontribs)

Note that Quarry is "simply" an interface for Wiki replicas databases. A timeout certainly comes from these DB.

Mike Peel (talkcontribs)

It's back to timing out again today. :-( It must somehow be linked to server loads, as I'm not changing the query between runs, and the amount of data to analyse and the number of results are roughly similar.

Mike Peel (talkcontribs)

It's still timing out. :-(

Mike Peel (talkcontribs)

... and today it completed in 484.18 seconds (~8 minutes). Very weird - the run time seems to be very random.

Mike Peel (talkcontribs)

It's been back to timing out for most of this last week.

Frietjes (talkcontribs)

I have been having the same problem with query/36685 :(

Mike Peel (talkcontribs)

The query has been timing out for the last fortnight now. :-(

Mike Peel (talkcontribs)
Ahecht (talkcontribs)

Same issue with quarry:quarry/36666 which had been taking about 15 minutes but is now timing out after 30.

Dvorapa (talkcontribs)

I experience the same thing. It seems analytics cluster is overloaded or there may be some other issue. All my simple queries now take 20+ minutes or timeout, a year ago they run under 2 minutes.

For Toolforge users the easy solution is to try the web cluster (sql --cluster=web enwiki), but the issue should be solved anyway.

Dvorapa (talkcontribs)

Per IRC thread everything should be back to normal soon

Mike Peel (talkcontribs)

IRC thread?

Frietjes (talkcontribs)

I was able to run quarry:query/36685 about 20 minutes ago, and it didn't timeout this time!

Mike Peel (talkcontribs)
Dvorapa (talkcontribs)

Error 500 should be fixed now based on what guys have said on IRC (#wikimedia-cloud)

Mike Peel (talkcontribs)

It seems to be working now, thanks! :-)

Reply to "Queries running slow?"