Jump to content


Photo

The connection was reset


  • Please log in to reply
15 replies to this topic

#1 neylitalo

neylitalo
  • Staff Alumni
  • Advanced Member
  • 1,854 posts
  • LocationMichigan, USA

Posted 09 October 2006 - 03:27 PM

Lately I've been getting a lot of "The connection has been reset" errors in Firefox on this forum - has anybody encountered this little hindrance in other browsers or other operating systems than Linux? I'm sort of hesitant to think that it would be my browser, since I don't have any similar problems on other forums or websites.
http://nealylitalo.net - My personal website, and home of The Netizen's Journal.

#2 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 09 October 2006 - 03:46 PM

I've seen that once or twice, but not recently.  WindowsXP/Opera 9.

Did you happen to notice if it's during peak hours?  That could be a connection dump because of too many connections.

Info: PHP Manual


#3 neylitalo

neylitalo
  • Staff Alumni
  • Advanced Member
  • 1,854 posts
  • LocationMichigan, USA

Posted 09 October 2006 - 05:12 PM

That may very well have been the problem. Although, the only times I've noticed that we really aren't on "peak time" are 06:00 to 10:00 GMT, so it's not that hard to hit "peak time". :)

Thanks, ober, for letting me know that I'm not alone.
http://nealylitalo.net - My personal website, and home of The Netizen's Journal.

#4 Daniel0

Daniel0
  • Staff Alumni
  • Advanced Member
  • 11,956 posts

Posted 09 October 2006 - 05:14 PM

I often (like every second/third day) get a message saying that smf can't connect to the database. I don't know if that is related to this.

#5 Mutley

Mutley
  • Members
  • PipPipPip
  • Advanced Member
  • 765 posts

Posted 09 October 2006 - 05:48 PM

I often (like every second/third day) get a message saying that smf can't connect to the database. I don't know if that is related to this.


I am getting that today.
~ Mutley.

#6 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 09 October 2006 - 05:49 PM

I get that on occasion as well.  Mark it up to server overloading.  I did notice that the server was down the other day and phpfreak said MySQL had crashed.  He restarted it and I think the forums were down as a result of that for only a few minutes.  I guess it's possible that MySQL crashes could be the cause of some of the other issues we're seeing, but who knows.  

I'll bring it up with phpfreak the next time he's available.

Info: PHP Manual


#7 Daniel0

Daniel0
  • Staff Alumni
  • Advanced Member
  • 11,956 posts

Posted 09 October 2006 - 05:52 PM

If you don't already do this, then maybe using persistent connections could take a bit off the MySQL server load.

#8 Mutley

Mutley
  • Members
  • PipPipPip
  • Advanced Member
  • 765 posts

Posted 09 October 2006 - 06:02 PM

On the tutorials/article pages I just get loads of errors in the header:

Warning: mysql_query() [function.mysql-query]: Too many connections in /home/www.phpfreaks.com/public_html/includes/DatabaseObject.inc on line 68

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/www.phpfreaks.com/public_html/includes/DatabaseObject.inc on line 68
MySQL Error: Too many connections MySQL Query: INSERT INTO `user_track` set `user_track_id`="", `session_id`="8fdb8302c10caccd565e293e954961ac", `last_activity`="1160416923", `last_page`="", `member`="0", `ip_address`="172.143.160.22", `refurl`="http://www.phpfreaks.com/", `user_agent`="Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7" +===========================================================+ MySQL Query: INSERT INTO `user_track` set `user_track_id`="", `session_id`="8fdb8302c10caccd565e293e954961ac", `last_activity`="1160416923", `last_page`="", `member`="0", `ip_address`="172.143.160.22", `refurl`="http://www.phpfreaks.com/", `user_agent`="Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7"

Warning: mysql_insert_id() [function.mysql-insert-id]: A link to the server could not be established in /home/www.phpfreaks.com/public_html/includes/DatabaseObject.inc on line 357

Warning: mysql_query() [function.mysql-query]: Too many connections in /home/www.phpfreaks.com/public_html/includes/ManagerClass.inc on line 46

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/www.phpfreaks.com/public_html/includes/ManagerClass.inc on


Related?
~ Mutley.

#9 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 09 October 2006 - 06:22 PM

Possibly... I just got 2 errors saying "unable to connect" when I tried to get into this thread.

Info: PHP Manual


#10 Daniel0

Daniel0
  • Staff Alumni
  • Advanced Member
  • 11,956 posts

Posted 09 October 2006 - 06:37 PM

It is related. Each time I get that error on SMF I errors similar to the ones you showed on the main page.

#11 phpfreak

phpfreak
  • Members
  • PipPipPip
  • Advanced Member
  • 527 posts
  • LocationEverywhere!

Posted 09 October 2006 - 09:58 PM

A Connection Reset message means something in the content you were trying to post triggered our Intrusion Prevention System. There's a whole topic on this in the @phpfreaks forums.


Eric 'phpfreak' Rosebrock
Got LAMP?
http://www.Phpfreaks.com Founder

#12 neylitalo

neylitalo
  • Staff Alumni
  • Advanced Member
  • 1,854 posts
  • LocationMichigan, USA

Posted 09 October 2006 - 10:39 PM

That's what I thought it was at first, but I realized that I was getting them when I was just posting simple words, no script tags, no html, no PHP at all - and then a page refresh makes it go just fine. Sometimes it tells me "You already submitted this post, maybe you hit Refresh?" or something like that, and sometimes it didn't go through properly the first time, so it does the job proper the second time. To me, that's indication that a) It's not the IPS at all, or b) The IPS has a hole in it. :)
http://nealylitalo.net - My personal website, and home of The Netizen's Journal.

#13 Cep

Cep
  • Members
  • PipPipPip
  • Advanced Member
  • 539 posts
  • LocationOn a boat in the middle of nowhere

Posted 19 October 2006 - 10:44 AM

I have been seeing a lot of errors on the main phpfreaks page where I see my session information and a lot of MYSQL-SELECT errors popping up all over the place.

At the time this was happening I tried to post here about it but got an SWF too many connections error, this about 30 minutes ago from the time I post this message.


Thanks Cep

#14 Daniel0

Daniel0
  • Staff Alumni
  • Advanced Member
  • 11,956 posts

Posted 19 October 2006 - 11:16 AM

I believe they are working on it. It is because the database server can't handle the current amount of requests.

#15 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 19 October 2006 - 01:06 PM

Cep, if you're seeing errors on the main page, try logging out and then logging back in.  We've made some changes on the main site and for whatever reason, your SESSION needs to be refreshed.

I personally haven't seen as many issues lately with the connection problems.  I think we've worked some of that out.

Info: PHP Manual


#16 Daniel0

Daniel0
  • Staff Alumni
  • Advanced Member
  • 11,956 posts

Posted 19 October 2006 - 01:14 PM

I have had a lot of those connection problems today, but else there haven't been some for quite a while.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users