Error User already has more than 'max_user_connections' active connections

Posted by ojchris37 on November 8, 2012 at 2:09pm

All you see when you view is the error.

here it sis:
"The website encountered an unexpected error. Please try again later.
Error message
PDOException: SQLSTATE[42000] [1203] User vesanige_badman already has more than 'max_user_connections' active connections in lock_may_be_available() (line 167 of /home2/mydir/public_html/sitefolder/includes/lock.inc)."

This happened yesterday but today the site came back up. But when I clicked the user's "My Account" like the error returned. I remeeber it was when I clicked on that same link yesterday that the error came up.

When tried site.com/install.php I get this:

PDOException: SQLSTATE[42000] [1203] User vesanige_badman already has more than 'max_user_connections' active connections in drupal_get_installed_schema_version() (line 150 of /home2/mydir/public_html/sitefolder/includes/install.inc).

THis clearly shows it's not coming from a specific file, the error must be as a result of a DB setting or Drupal insertion.

Here is my host's MySQL setting:

mysql

MySQL Support	enabled
Active Persistent Links	0
Active Links	0
Client API version	5.1.65
MYSQL_MODULE_TYPE	external
MYSQL_SOCKET	/var/lib/mysql/mysql.sock
MYSQL_INCLUDE	-I/usr/include/mysql
MYSQL_LIBS	-L/usr/lib64 -lmysqlclient

Directive	Local Value	Master Value
mysql.allow_persistent	On	On
mysql.connect_timeout	60	60
mysql.default_host	no value	no value
mysql.default_password	no value	no value
mysql.default_port	no value	no value
mysql.default_socket	no value	no value
mysql.default_user	no value	no value
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off

I will appreciate. Thank you.

Comments

Same here

Posted by mmtahir on December 2, 2012 at 5:26pm

I have same error with same settings as above. I see this message more frequently now when accessing admin pages.

Has your error removed or what did you do for this.

Is there anyway to manually tweak through phpmyadmin, as I am almost unable to access admin options. OR is there any thread that address this issue in more detail. I didn't see any one helping specifically.

Malik Mohammad Tahir Saeed

Error max_user_connections

Posted by shannoninman on April 2, 2013 at 7:03pm

Error
The website encountered an unexpected error. Please try again later.
Error message

PDOException: SQLSTATE[42000] [1203] User ***_*** already has more than 'max_user_connections' active connections in lock_may_be_available() (line 167 of /home/my-db/public_html/includes/lock.inc).

Prior to this error the site was down all morning with:
500Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

I fixed the 500 Internal Error by making sure all of my permissions were set to 644 for files and 755 for folders and in uncommenting RewriteBase In .htaccess:

# If your site is running in a VirtualDocumentRoot at http://example.com/,
# uncomment the following line:
# RewriteBase /

I was confused by the 500 Internal Error because NOTHING on the site changed from yesterday to today. The site has just started to get better traffic from google, bing and yahoo and now I'm getting error after error. This site is shared hosted with Rochen. Any ideas how to fix the new error ? was it a result of changing the RewriteBase? I appreciate any help.

Rochen Tech Support Fixed but will happen again?

Posted by shannoninman on April 2, 2013 at 7:37pm

Rochen Tech Support Response:
That error indicates your script is keeping open an excessive number of MySQL connections (enough to exceed our limit of 30). Normally you should never be using more than one or two connection at a time. No, that wouldn't be directly related to a 500 error, but if you scripts are causing one problem like this, they are surely causing other issues that can lead to a generic 500 error. I have attached a list of the active MySQL processes under your "site" account. Please note that the oldest connections are over 28 hours old (the longest permitted process execution time we permit on a shared plan is 30 seconds).

Please let us know if you're ready for us to kill these processes, as it's clear they are not going to complete in a reasonable amount of time, thanks.

Only your script developer would be able to advise you further on that after reviewing the process list provided

Here is what the list looks like:

Any script developers recognize the issue or have any suggestions for me? I recognize the dr_search_api_db_nindex as the API Search index I have running on my site. I use this index for Faceted Filters without Apachesolr (because my hosting acct does not allow access to run Apachesolr)

Drupal 7 Views with Faceted Filters, without ApacheSolr