PDA

View Full Version : too many connections?


nicklfire
12 Jun 2008, 15:05
Hey guys,

Getting the following error on my vbulletin

Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/ftp/xxxxxxx/html/common/db.php on line 28
Error connecting to server: Too many connections

This is the first time i've seen this error happen.

Forum is located at bcaquaria.com

any help would be apprecaited.

snakes1100
12 Jun 2008, 20:39
1st, post the entire db error message.

2nd, from what you posted, the max_connections limit is set to low in my.cnf, increase the limit and restart mysql/apache.

nicklfire
13 Jun 2008, 00:54
well got my site back up, now when i try to post a new thread i'm getting ...

Database error in vBulletin 3.6.2:

Invalid SQL:
INSERT INTO post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, parentid, threadid, dateline, ipaddress, attach)
VALUES
(1, 1, 'Nicklfire', 831, 'Re: Server Outage This Morning', 'testttttt', 0, 1, 0, 10364, 1213315564, '24.66.56.132', 0);

MySQL Error : Duplicate entry '98644' for key 1
Error Number : 1062
Date : Thursday, June 12th 2008 @ 05:06:04 PM
Script : http://bcaquaria.com/forum/newreply.php?do=postreply&t=10364
Referrer : http://bcaquaria.com/forum/showthread.php?t=10364
IP Address : 24.66.56.180
Username : Shawns
Classname : vb_database

snakes1100
13 Jun 2008, 01:17
Do a repair on the table in question that the duplicate key is coming from.

geevest.com
19 Jun 2008, 03:26
snakes1100 : how to repair the duplicate key table ? thx

Marco van Herwaarden
19 Jun 2008, 10:30
AdminCP -> Maintenance -> Repair / Optimize Tables -> Fix Unique Indexes

CarlitoBrigante
20 Jun 2008, 00:45
1st, post the entire db error message.

2nd, from what you posted, the max_connections limit is set to low in my.cnf, increase the limit and restart mysql/apache.

This is especially true in a lot of CPanel servers I had to work with recently.

geevest.com
24 Jun 2008, 20:59
maybe i must try this to fixed my problem : Fix Unique Indexes

Paul M
24 Jun 2008, 21:45
Just repairing the table will normally fix duplicate key issues, no need to use the other option as that rebuilds all indexes, a bit of overkill in most cases.