search

TravelMapping / Web

Web-facing tool/page development
8 stars 26 forks source link

Problematic query in HB code? #288

Closed jteresco closed 4 years ago

jteresco commented 6 years ago

https://github.com/TravelMapping/Web/blob/de7414554b81358df43a1b0af4a9255eed93ec19/hb/index.php#L350

For some reason this query tends to lead to "User sleep" processes in the mysql process list, and their existence causes trouble for the site update process.

See https://github.com/TravelMapping/DataProcessing/issues/111

jteresco commented 5 years ago

A different query accumulated a lot of "User Sleep" SQL processes today that I had to kill to get tonight's site update to proceed:

SELECT traveler, SUM(mileage) as clinchedMileage

(also noted in the original issue https://github.com/TravelMapping/DataProcessing/issues/111)

jteresco commented 4 years ago

I hope I'm not speaking too soon, but I have not had to kill any "User Sleep" processes since showroute replaced the old HB route display functionality. So I'll close this with the understanding I might need to reopen if the problems creep back in.