Hello,

When we run Jmeter test case with 300 users, we are getting connection issue for few page. (PDOException: SQLSTATE[08004] [1040] Too many connections in lock_may_be_available())

There are related articles of it and we tried to apply the solution mentioned in (https://www.drupal.org/node/930876) #140 (https://www.drupal.org/node/930876#comment-8165481) but that is not helping us to fix that problem, That only bypassing message displaying in screen and logging it to log file.

We have debugged and identified that connections are remained in idle state and not getting closed automatically. Can you provide a solution of closing idle connection.?

Similar Issue: http://mydrupal.com/error-max-user-connections-active-connections-lock-m...

Thanks,
Amit

Comments

amitagar created an issue. See original summary.

stefan.r’s picture

stefan.r commented
Category: Bug report » Support request
Priority: Critical » Major
cilefen’s picture

cilefen commented

What are the maximum connections allowed by your database server?

vimalgoradiya’s picture

vimalgoradiya commented

I think this issue similar to https://www.drupal.org/node/930876 and answer is https://www.drupal.org/node/930876#comment-8165481 comment #140.

amitagar’s picture

amitagar commented

maximum connections allowed is 300 as of now. We are using Jmeter and checking with 200 users. Looks like connections are not released. Connection stayed in idle state only.

cilefen’s picture

cilefen commented
Title: Too many connections in lock_may_be_available() » Too many connections in lock_may_be_available() when running a Jmeter case with 300 users
Component: other » database system
Issue tags: -too many connection, -mysql connection issue +Performance

Are you testing plain Drupal or some configuration or custom code?
Are these authenticated sessions?

cilefen’s picture

cilefen commented

Also, have you made any tuning adjustments to your database server?

irfworld’s picture

irfworld commented

Try to change your semaphore table engine type to "Memory" instead of "InnoDB or MyIsam".

cilefen’s picture

cilefen commented
Priority: Major » Normal
Status: Active » Closed (cannot reproduce)

Support requests are never major priority. I am closing this because the original reporter has not replied.