server error
5 watchers
Nov 2012
12:22pm, 30 Nov 2012
4,356 posts
|
sprouts, turkey and mash
The entire site was getting a server error for a minute or so just then.
|
|
Nov 2012
12:45pm, 30 Nov 2012
4,357 posts
|
sprouts, turkey and mash
Turned on logging in Firefox, and got a list of results. Moving the mouse up and down over the results worked for a few seconds, then started returning errors. I've copied the requests and timestamps along with the result (the ok's all had seem to have provided valid results) [12:36:49.261] GET http://www.fetcheveryone.com/races-ws-info.php?id=76704 [HTTP/1.1 200 OK 50ms] [12:36:50.306] GET http://www.fetcheveryone.com/races-ws-info.php?id=76704 [HTTP/1.1 200 OK 35ms] [12:36:50.896] GET http://www.fetcheveryone.com/races-ws-info.php?id=76704 [HTTP/1.1 200 OK 32ms] [12:36:50.898] GET http://www.fetcheveryone.com/races-ws-info.php?id=76743 [HTTP/1.1 200 OK 35ms] [12:36:52.389] GET http://www.fetcheveryone.com/races-ws-info.php?id=76743 [HTTP/1.1 200 OK 34ms] [12:36:52.393] GET http://www.fetcheveryone.com/races-ws-info.php?id=78992 [HTTP/1.1 200 OK 33ms] [12:36:52.396] GET http://www.fetcheveryone.com/races-ws-info.php?id=76589 [HTTP/1.1 200 OK 30ms] [12:36:52.768] GET http://www.fetcheveryone.com/races-ws-info.php?id=78992 [HTTP/1.1 200 OK 46ms] [12:36:53.062] GET http://www.fetcheveryone.com/races-ws-info.php?id=76589 [HTTP/1.1 200 OK 37ms] [12:36:53.515] GET http://www.fetcheveryone.com/races-ws-info.php?id=64706 [HTTP/1.1 200 OK 45ms] [12:36:53.976] GET http://www.fetcheveryone.com/races-ws-info.php?id=72098 [HTTP/1.1 200 OK 47ms] [12:36:53.978] GET http://www.fetcheveryone.com/races-ws-info.php?id=64706 [HTTP/1.1 200 OK 34ms] [12:36:54.828] GET http://www.fetcheveryone.com/races-ws-info.php?id=73209 [HTTP/1.1 200 OK 40ms] [12:36:54.830] GET http://www.fetcheveryone.com/races-ws-info.php?id=72098 [HTTP/1.1 200 OK 38ms] [12:36:54.831] GET http://www.fetcheveryone.com/races-ws-info.php?id=76706 [HTTP/1.1 200 OK 56ms] [12:36:55.445] GET http://www.fetcheveryone.com/races-ws-info.php?id=72098 [HTTP/1.1 200 OK 67ms] [12:36:55.450] GET http://www.fetcheveryone.com/races-ws-info.php?id=73209 [HTTP/1.1 200 OK 35ms] [12:36:55.453] GET http://www.fetcheveryone.com/races-ws-info.php?id=64706 [HTTP/1.1 200 OK 42ms] [12:36:55.456] GET http://www.fetcheveryone.com/races-ws-info.php?id=76589 [HTTP/1.1 200 OK 33ms] [12:36:55.732] GET http://www.fetcheveryone.com/races-ws-info.php?id=76081 [HTTP/1.1 200 OK 52ms] [12:36:55.734] GET http://www.fetcheveryone.com/races-ws-info.php?id=72098 [HTTP/1.1 403 Forbidden 50ms] [12:36:56.209] GET http://www.fetcheveryone.com/races-ws-info.php?id=75756 [HTTP/1.1 403 Forbidden 58ms] [12:36:56.211] GET http://www.fetcheveryone.com/races-ws-info.php?id=64706 [HTTP/1.1 403 Forbidden 60ms] [12:36:56.213] GET http://www.fetcheveryone.com/races-ws-info.php?id=76589 [HTTP/1.1 403 Forbidden 115ms] [12:36:56.216] GET http://www.fetcheveryone.com/races-ws-info.php?id=76081 [HTTP/1.1 403 Forbidden 44ms] [12:36:56.508] GET http://www.fetcheveryone.com/races-ws-info.php?id=73208 [HTTP/1.1 403 Forbidden 41ms] [12:36:56.510] GET http://www.fetcheveryone.com/races-ws-info.php?id=72097 [HTTP/1.1 403 Forbidden 45ms] [12:36:56.512] GET http://www.fetcheveryone.com/races-ws-info.php?id=75756 [HTTP/1.1 403 Forbidden 32ms] [12:36:56.664] GET http://www.fetcheveryone.com/races-ws-info.php?id=76589 [HTTP/1.1 403 Forbidden 31ms] [12:36:57.014] GET http://www.fetcheveryone.com/races-ws-info.php?id=64705 [HTTP/1.1 403 Forbidden 43ms] [12:36:57.017] GET http://www.fetcheveryone.com/races-ws-info.php?id=73208 [HTTP/1.1 403 Forbidden 47ms] [12:36:57.019] GET http://www.fetcheveryone.com/races-ws-info.php?id=72097 [HTTP/1.1 403 Forbidden 44ms] [12:36:57.021] GET http://www.fetcheveryone.com/races-ws-info.php?id=75756 [HTTP/1.1 403 Forbidden 46ms] [12:36:57.412] GET http://www.fetcheveryone.com/races-ws-info.php?id=73208 [HTTP/1.1 403 Forbidden 38ms] [12:36:57.415] GET http://www.fetcheveryone.com/races-ws-info.php?id=72097 [HTTP/1.1 403 Forbidden 45ms] [12:36:57.763] GET http://www.fetcheveryone.com/races-ws-info.php?id=73208 [HTTP/1.1 403 Forbidden 50ms] [12:36:57.766] GET http://www.fetcheveryone.com/races-ws-info.php?id=72097 [HTTP/1.1 403 Forbidden 39ms] [12:36:58.102] GET http://www.fetcheveryone.com/races-ws-info.php?id=72097 [HTTP/1.1 403 Forbidden 52ms] Don't know if it's any use, but figured it can't hurt. |
|
Nov 2012
12:47pm, 30 Nov 2012
4,358 posts
|
sprouts, turkey and mash
Ah, of course the urls have been forum'ified.
|
|
Nov 2012
2:09pm, 30 Nov 2012
4,359 posts
|
sprouts, turkey and mash
I seem to be able to consistently cause the site to return Server errors simply by going to the race finder and getting some results, and running the mouse up and down over the results a few times, reasonably quickly. Then if I try to go to any page (not just a race page), I'll get a server error. It's probably being associated with the race pages because people are presumably most likely to click on one of the results, or on the add race, or the next page of results after looking through the results, but it seems to affect any page (including the home page, by clicking on the fetch logo). That would suggest that the server is getting overwhelmed with the web service requests and crapping out, or that it's throttling requests from my ip due to the high load for a few moments. |
|
Nov 2012
2:18pm, 30 Nov 2012
4,360 posts
|
sprouts, turkey and mash
Looks like it's throttling it based on ip - I loaded the site on my phone, connected via 3g. Then I did the test above, and my desktop returned server error at the same time as the site was still usable from my phone. I did a bit of googling, and it could be that your hosting provider is trying to protect your server from a denial of service. (http://stackoverflow.com/questions/2569767/why-is-apache-giving-403 , seems like a similar situation) I'd suggest either returning race details in the main html, or at least caching them after looking them up to reduce the ability to hammer the server with web service requests in a short period of time. |
Nov 2012
2:21pm, 30 Nov 2012
14,279 posts
|
JohnnyO
It's been doing this for a while, you can usually retrieve a few results before it returns the server error message. Then for about five minutes any link returns the same message. Occasionally you have to close the window before this will resolve. How do I generate an error report? |
|
Nov 2012
3:00pm, 30 Nov 2012
4,361 posts
|
sprouts, turkey and mash
Right, I'll stop spamming the thread now, I figure you've got enough to go on  I did notice that moving from one row to the next results in 2 or 3 web service requests being generated, including one for the row you're leaving. This is probably making the Server Error much more frequent than it needs to be. It might be an idea to do the onmouseover / onmouseout for the table row, rather than for the single cell with the name and length. That said, all of the details that you get back from the web service (name, terrain, length, date and distance from me) have already been retrieved from the database and are already used in the html, so it probably shouldn't be that big a deal to use those details in the popups without the web service request at all. |
Dec 2012
6:03pm, 19 Dec 2012
12,192 posts
|
fetcheveryone
I had a quick chance to take a look at this - and it looks like about 23% of calls to the web service were getting rejected with a 403 by the server. It occurred to me that the little popup when you roll over the race list doesn't add a great deal - so I've switched it off. You can still get the popup if you actually click on the markers on the map, but moving your mouse down the list no longer triggers a spree of requests. That should help calm the server down. I was hesitant about putting all the information for all the races into javascript on the client, because it would open the race database up to being scraped in its entirety. I'll keep an eye on the logs, but this should hopefully make everything that little bit more reliable, if a little less exciting. |
|
Dec 2012
11:30am, 20 Dec 2012
4,420 posts
|
sprouts, turkey, peas and mash
You could also have scraped the entire race db by calling the web service with every possible race id - as long as you did it slowly enough to not get throttled
|
|
Dec 2012
11:31am, 20 Dec 2012
12,215 posts
|
fetcheveryone
True, but at least then I'd know that person would have worked for it.
|
Related Threads
-
New Features
Apr 2024
-
What constitutes a lurker?
Apr 2024
-
What is your fetch addiction position?
Apr 2024
-
Route Picture of the Day Appreciation Thread
Apr 2024
-
Chat Poll responses
Apr 2024
-
Fetch meetups
Apr 2024
-
Do we have a race report thread?
Apr 2024
-
Export Data
Mar 2024
-
Wonky elevation data
Mar 2024
-
SERIOUSLY LORD FETCH - SORT IT OUT!
Mar 2024
