Bug Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96

[neounix]

FYI:

[15-Dec-2013 11:13:02] PHP Warning:  mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[15-Dec-2013 11:13:02] PHP Warning:  mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[15-Dec-2013 11:13:02] PHP Warning:  mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[15-Dec-2013 11:13:02] PHP Warning:  mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (HY000/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[15-Dec-2013 11:13:02] PHP Warning:  mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[15-Dec-2013 11:13:02] PHP Warning:  mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[15-Dec-2013 11:13:02] PHP Warning:  mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[15-Dec-2013 11:13:02] PHP Warning:  mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96

 

[Fillip H.]

What is the value of your max_connections variable? If it's not set, the default is 151.

 

[neounix]

Yep. I just set it to 200... let's see what happens.

 

[Fillip H.]

Can you SHOW PROCESSLIST; and confirm that there's not a lot of connections lingering in Sleep? If there is a lot of connections, then the __destruct function on our database class may not be working correctly in vB3.

We have approx. 4 connections in Sleep at any given time, our max_connections is set to 800.

 

[neounix]

OK. Just changed to 300... but can raise if needed.

Current process list is small because restarted mysqld for new max_connections setting.

Normally, it is bot activity which really pushes this up.

 

[neounix]

OK. Just changed to 300... but can raise if needed.

Current process list is small because restarted mysqld for new max_connections setting.

Normally, it is bot activity which really pushes this up.

EDIT: Let's see what happens over time after running for many hours.

 

[Fillip H.]

Well, connections shouldn't be lingering in Sleep regardless of how many users are viewing. DBSEO should close down its extra MySQL connection just like vB closes its own.

I've added a vB3 compatible version of the shutdown registration to b9 anyway.

 

[neounix]

Cool. Thanks!

It's still slow on the site (weekend)... let's see how it is around 10AM on Monday and Tuesday EST.

Traffic is "so down" after the problems caused by the death of VBSEO and all the 301 redirects in place before. It will take a few months to recover... but we should see a slow and steady increase after the holidays (we always slow down from Thanksgiving in the US to mid January due to business holidays).

 

[neounix]

Still getting this error. Only with DBSEO, not with apache2:

[17-Dec-2013 02:47:32] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[17-Dec-2013 02:47:32] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[17-Dec-2013 02:47:32] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[17-Dec-2013 02:47:32] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[17-Dec-2013 02:47:32] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[17-Dec-2013 02:47:32] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[17-Dec-2013 02:47:32] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[17-Dec-2013 02:47:32] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[17-Dec-2013 02:47:32] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96
[17-Dec-2013 02:47:32] PHP Warning: mysqli::mysqli() [<a href='mysqli.mysqli'>mysqli.mysqli</a>]: (08004/1040): Too many connections in /var/www/dbtech/dbseo/includes/class_db.php on line 96

mysql> SHOW PROCESSLIST;
+---------+------+-----------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+---------+------+-----------+------+---------+------+-------+------------------+
| 1407777 | root | localhost | NULL | Query | 0 | NULL | SHOW PROCESSLIST |
+---------+------+-----------+------+---------+------+-------+------------------+
1 row in set (0.00 sec)

EDIT: now increased max_connections to 400

 

[Fillip H.]

This makes little sense... If the connections are being closed as they should, as the processlist would indicate, then I don't understand why there's too many connections. It would mean at any given second, there was more than 300 people browsing your forum, which is implausible.

Can you try adding some debug code to

function __construct(&$config)

in class_db.php - log only hits from your IP address, and store the timestamp, then refresh your forum only once.

If everything is working, there should be only one entry in the log file.