December 07, 2004

SportsFilter is unavailable...: What is the deal with Sportsfilter being down at all various times of the day? And in the past couple of days, its been unavailable more than it is available. I just get a blank page saying the site is not accepting something or other...its really annoying.

posted by StarFucker to bugs at 12:28 PM - 30 comments

I have no idea. Happened to me once.

posted by rcade at 03:15 PM on December 07, 2004

Its not just at home either so its not computer specific. The last couple of days i found that the site is accessible only 50% of the time. I'm using 3 different computers at 3 different locations. As soon as it happens again i'll post one of the messages i get.

posted by StarFucker at 03:23 PM on December 07, 2004

But how?

posted by Fat Buddha at 04:19 PM on December 07, 2004

This problem probably means we're outgrowing the shared hosting on CFDynamics again and have to either upgrade to a bigger account or move. We're already working on the latter.

posted by rcade at 04:47 PM on December 07, 2004

I have had intermittent problems connecting to SpoFi lately as well. Not as bad as SF has been experiencing though.

posted by NoMich at 04:55 PM on December 07, 2004

But how? When the website comes back up...silly.

posted by StarFucker at 05:14 PM on December 07, 2004

Update: I am currently able to connect to SpoFi.

posted by DrJohnEvans at 07:29 PM on December 07, 2004

Update: I am currently able to connect to SpoFi i'm not.

posted by goddam at 08:23 PM on December 07, 2004

I am currently able to SpoFi to connect.

posted by danostuporstar at 08:44 AM on December 08, 2004

So am I.

posted by dusted at 09:44 AM on December 08, 2004

I haven't checked.

posted by Mr Bismarck at 09:49 AM on December 08, 2004

Very funny...

posted by StarFucker at 10:02 AM on December 08, 2004

I've gotten the same problem that SF wrote about. It's happened to me many times, on different machines.

posted by blarp at 10:58 AM on December 08, 2004

I've gotten the same problem...It's happened to me many times, on different machines you've had problems with a robo-spanker as well? was it painful?

posted by garfield at 12:06 PM on December 08, 2004

At first, yeah. I've gotten used to it, though.

posted by blarp at 01:33 PM on December 08, 2004

me too.

posted by garfield at 01:59 PM on December 08, 2004

You know, if everyone hadn't piped up and said it was happening to them, we could have convinced SF it was a plot against him. That could have been good for some laughs. /feeling a bit evil today

posted by grum@work at 12:16 PM on December 09, 2004

The robo-spanker is a plot against society in general.

posted by DrJohnEvans at 03:43 PM on December 09, 2004

Of course, now that i wrote this up i haven't had the problem since...

posted by StarFucker at 04:55 PM on December 09, 2004

You haven't lived until you've been spanked -- properly -- by a robot. Um. I have yet to experience this problem (touch wood), though it has been much slower to load the last couple of weeks.

posted by chicobangs at 09:05 AM on December 10, 2004

Well it happened...while i was at home this morning. Now i am at work and it seems fine, but this is what i get when its down. Error Occurred While Processing Request Error Diagnostic Information Request timed out The time taken to process your request has exceeded the allowable limit of 60 seconds. Please notify the server administrator (using the mail link below) that this error has occurred. Note: You can override the request time limit by adding a 'RequestTimeout' parameter to the URL used to request the page (e.g. page.cfm?RequestTimeout=500). SQL = "SELECT users.user_name, L.link_ID, L.link_url, L.link_urldescription, DATEname(weekday, L.link_date) AS link_day, L.link_date, L.user_ID, L.hide, L.link_description, L.category_ID, (SELECT COUNT(C.comment_ID) AS totComments FROM comment AS C WHERE C.Link_ID = L.Link_ID AND C.hide = 0) AS totComments, categories.category_ID, categories.category_name , (SELECT COUNT(*) AS totNewComments FROM comment AS C2 WHERE C2.Link_ID = L.Link_ID AND C2.hide = 0 AND C2.Comment_date > {ts '2004-12-13 13:59:36'}) AS totNewComments , (SELECT TOP 1 comment_id AS firstNewComment FROM comment AS C WHERE C.Link_ID = L.Link_ID AND C.Comment_date > {ts '2004-12-13 13:59:36'} ORDER BY C.Comment_date ASC) AS firstNewComment FROM link AS L, users, categories WHERE L.link_date > {ts '2004-11-30 07:21:45'} AND users.user_ID = L.user_ID AND L.category_ID = categories.category_ID AND L.hide = 0 ORDER BY L.link_date DESC" Data Source = "SPORTSFILTER" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (70:1) to (70:49) in the template file D:Inetpubwwwrootsportsfiltersportsfilter.comwwwrootindex.cfm. Date/Time: 12/14/04 07:25:01 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322) Remote Address: 67.176.184.47

posted by StarFucker at 09:01 AM on December 14, 2004

Hello?

posted by StarFucker at 12:18 PM on December 14, 2004

I get the same error as SF every once in awhile, such as just before hitting the refresh button for this reading (it came up the second time, clearly).

posted by billsaysthis at 12:26 PM on December 14, 2004

It happens to me all the time

posted by allstar at 08:46 PM on December 15, 2004

Yeah, I get that error almost every day. I thought it was because I is European.

posted by squealy at 04:20 AM on December 16, 2004

Booyaakasha! Probably don't want to paste all the site's SQL laundry into the site, but that's just the developer in me.

posted by yerfatma at 06:24 AM on December 16, 2004

Sorry, i don't know shit about what i posted, i just thought it would help.

posted by StarFucker at 03:08 PM on December 16, 2004

The query appears to be a set of select statements that simply grabs the comment count for the threads, as well as the new comments (so it can have that parentheses number like 7 comments (4 new) to take you right to the direct link of the oldest comment in that thread since you last visited the site) It means more generally that the SQL server that hosts all the site data itself was either unreachable (server rebooting/SQL recycling, etc) or that the query was too "expensive" or the db to slow, and as a result the web page timed out on waiting to get the data back so it could format it for you, the user. Instead just presented an error page- one that gives the actual SQL query used, which is bad form on the coder's part as yerfatma noted. It means most directly that, as rcade said, the host for sportsfilter is probably running out of capacity or is otherwise throttling the site (or far simpler, is just is having server issues behind the scenes, since there's probably a handful of servers clustered that handle dozens of databases for dozens of sites).

posted by hincandenza at 04:31 AM on December 17, 2004

So does that mean it would just be down for a second and if i tried again it would be okay? Or that it would be down for a half hour up to 8 hours like it is for me sometimes? It happened again at 1pm...couldn't get on till now. Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 08001 (Unable to connect to data source) [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. SQL = "SELECT user_ID, user_name, last_visit FROM dbo.users WHERE users.user_id = 256" Data Source = "SPORTSFILTER" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (15:2) to (15:49) in the template file D:Inetpubwwwrootsportsfiltersportsfilter.comwwwrootindex.cfm. Date/Time: 12/20/04 12:52:11 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322) Remote Address: 67.94.127.3

posted by StarFucker at 03:24 PM on December 20, 2004

I got the same error, at about the same time.

posted by dusted at 06:20 PM on December 20, 2004

You're not logged in. Please log in or register.