Welcome Guest ( Log In | Register )



2 Pages V   1 2 >  
Reply to this topicStart new topic
> Mysql Error Never Seen On My Site Before (too Many Connections).
Chesso
post Jul 29 2006, 07:34 AM
Post #1


Teh Coder
Group Icon

Group: Members
Posts: 1,053
Joined: 18-April 06
From: Australia
Member No.: 12,833



I just tried to visit my site to see if anything had changed on my forums and such and I got this message:

Warning: mysql_connect(): Too many connections in /xxxx/xxxxx/xxxxxx_xxxxx/xxx/xx_xxxx.php on line 7
Error! Could not connect: Too many connections.

I have never recieved this error before, does this mean someone is mucking with my site somehow???

The particular php file it mentions is the one that defines variables like db username etc and connection to the site's database that I include wherever it is needed in various file for the site.

EDIT:

I managed to get in and went to another page and again recieved another error message:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /xxxx/xxxxx/xxxxxx_xxxx/xxx/xx_xxxxx.php on line 7
Error! Could not connect: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

This post has been edited by Chesso: Jul 29 2006, 07:40 AM
Go to the top of the page
 
+Quote Post
pyost
post Jul 29 2006, 12:52 PM
Post #2


Nenad Bozidarevic
Group Icon

Group: [MODERATOR]
Posts: 998
Joined: 7-November 05
From: Belgrade, Serbia
Member No.: 9,500



It seems that MySQL was down at the time you posted that message. That's why your forum couldn't connect. I'm quite sure that it is working now. As for the first problem, I can only take a wild guess that too many people were trying to access your site and therefore the database, too. I believe that this can be a consequence of a DoS (denial of service) attack, when your site is "bombed" with numerous requests and connections.
Go to the top of the page
 
+Quote Post
cyborgxxi
post Jul 29 2006, 01:04 PM
Post #3


Premium Member
Group Icon

Group: Members
Posts: 342
Joined: 31-July 05
Member No.: 7,540



I had this problem like a thousand times on my website before. I mean, I thought it would be some sort of an uptime/downtime problem but I have no idea what the heck is going on!!

Please pardon me if I'm being very explosive but when it last happened and I posted a problematic thread/post on the hosted members' support page, I don't believe I got any help on it.

I saw other people's posts about the same thing / incident but I don't believe they got any help either.

What's going on?
Go to the top of the page
 
+Quote Post
Chesso
post Jul 29 2006, 03:10 PM
Post #4


Teh Coder
Group Icon

Group: Members
Posts: 1,053
Joined: 18-April 06
From: Australia
Member No.: 12,833



Ahh if it's a problem with AstaHost then I am relieved lol, I moderate over at slavehack.com (browser/text based hacking game) and some know of my site, I was hoping someone didn't get pissy and bugger around with my site.

*phew, whipes forhead*
Go to the top of the page
 
+Quote Post
vhortex
post Jul 29 2006, 03:35 PM
Post #5


Guilty Until Proven Innocent
Group Icon

Group: Members
Posts: 372
Joined: 13-April 05
Member No.: 3,937



most of the time. it merely means that the database server have reached its maximum connection setting..
on my personal machines, i have set the max connection to a very large numbers and that is not a big problem though since i have a bigger memory and cpu power.. besides my webserver, nothing is running on it..

--
in environments like asta, we cannot change the max connection of the database server since it will affect all users and may bog down the whole system in total..

--
the was one error more if the problem is database incapability to handle new connection, it will yank a port or socket connection error.. i believe that is apache or PHP engine that is yanking that error..

Go to the top of the page
 
+Quote Post
Quatrux
post Jul 29 2006, 05:18 PM
Post #6


the Q
Group Icon

Group: [HOSTED]
Posts: 1,017
Joined: 13-July 05
From: Lithuania, Vilnius
Member No.: 7,059



I saw this error too, more than 12 hours ago, but the error message "to many connections" says it all, of course it is bad for most of us, because a lot of whose content is in the database (I guess) so it is sort of downtown, I also couldn't access CPanel Mysql Databases and PHPMyAdmin, I understand why, now it seems that CPanel MySQL Databases and PHPMyAdmin works, but quite slow, but maybe this is just me. wink.gif
Go to the top of the page
 
+Quote Post
Chesso
post Jul 29 2006, 05:22 PM
Post #7


Teh Coder
Group Icon

Group: Members
Posts: 1,053
Joined: 18-April 06
From: Australia
Member No.: 12,833



Seems fine now. I had a couple of slips but other then that it's just fine.

P.S. Does anyone have any clue how you can have increased AdSense ad sizes? I use 728x90 but I need it atleast with 738 width... sad.gif

This post has been edited by Chesso: Jul 29 2006, 05:22 PM
Go to the top of the page
 
+Quote Post
pyost
post Jul 29 2006, 06:26 PM
Post #8


Nenad Bozidarevic
Group Icon

Group: [MODERATOR]
Posts: 998
Joined: 7-November 05
From: Belgrade, Serbia
Member No.: 9,500



Nope, you can use only those that are predefined in the AdSense control panel.
Go to the top of the page
 
+Quote Post
Chesso
post Jul 29 2006, 06:32 PM
Post #9


Teh Coder
Group Icon

Group: Members
Posts: 1,053
Joined: 18-April 06
From: Australia
Member No.: 12,833



Damn, that's pretty scabby.

Oh well, guess I'll have to deal with it looking weird.
Go to the top of the page
 
+Quote Post
nightfox
post Jul 29 2006, 07:23 PM
Post #10


NiGHTFoX - Hiding in the dark
Group Icon

Group: Members
Posts: 680
Joined: 3-April 05
Member No.: 3,584



Anyways, back on topic of MySQL connections...
That message is just a sort of "protection" for MySQL. if it allowed many connections, the MySQL server could crash due to a high amount of connections. It is sorta the server's "safety backup" kicking in. I guess a lot of people are using MySQL then.

This should be nothing to worry about.

[N]F
Go to the top of the page
 
+Quote Post

2 Pages V   1 2 >
Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Wrong Password/username - Fatal Error In Horde(4)
  2. Adsense Ad(1)
  3. MySQL - Can't Connect(1)
  4. Google Sitemaps Not Verifying My Site...(4)
  5. Problem With MySQL Not Being Able To Connect(9)
  6. Weird MySQL Message(4)
  7. Mail Delevery System Error(6)
  8. Problems With PHP/Joomla On Hosted Site(7)
  9. Help Me!(3)
  10. Site Unavailable!(7)
  11. Error Accessing Forum Topics(1)
  12. Something Odd On My Site......(9)
  13. Mysql Connect Error, Too Many Connections.(1)
  14. Php And Mysql Version.(7)
  15. Problems With cPanel(9)
  1. Problem With MySQL(5)
  2. What Is The MySQL Version @ Asta ?(16)
  3. Server Or Me?(5)
  4. My Site Is Suspended(8)
  5. Site Not Opeing ( Phpbb Forum) :: Can't Connect To Local Mysql(3)
  6. Strange Error (maybe Directoryindex Glitch?)(6)
  7. Site / Account Not Working(10)
  8. Mysql Server Not Stable After Hard Disk Swap On April 6th(2)
  9. Site Not Working(5)
  10. Connecting To Astahost's Mysql(8)
  11. Can't Access Any Site Hosted On The Server(4)
  12. Site Down Again, Help Or Suggestions?(6)
  13. Time Travel?(1)


 



- Lo-Fi Version Time is now: 30th August 2008 - 02:51 PM