Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
SQL-error: "more than 'max_user_connections' active"
Hey!
I've been building a site on vanilla now for a couple of months (Yep, v2, I know I'm stupid)
I have been developing on a local machine but now as I push up to server I get:
SQLSTATE[42000] [1203] User [MYUSERNAME] already has more than 'max_user_connections' active connections
I know this might be limited by the host but is there any chance that vanilla2 is not closing connections or something like that? Something that vanilla does that contributes to the connections?
Thanks in advance, it's suuuuch a pleasure developing apps for vanilla with the m-v-c pattern, great job guys!
//The Sheriff
I've been building a site on vanilla now for a couple of months (Yep, v2, I know I'm stupid)
I have been developing on a local machine but now as I push up to server I get:
SQLSTATE[42000] [1203] User [MYUSERNAME] already has more than 'max_user_connections' active connections
I know this might be limited by the host but is there any chance that vanilla2 is not closing connections or something like that? Something that vanilla does that contributes to the connections?
Thanks in advance, it's suuuuch a pleasure developing apps for vanilla with the m-v-c pattern, great job guys!
//The Sheriff
0
Comments
Here is the complete errorpage: Is there some kind of garbage collection that has to be done? Cause even though they close it seems that alot of old connections are floating aroung somehow. Please help, I'm getting sick and tired of this problem!
I recently encountered the same problem. I noticed that it only occurred when there where two or more users logged into my site. adding PDO::ATTR_PERSISTENT => TRUE fixed it right up.
So thanks for sharing that.
Hello,
Could you tell me where (on which file) can I change this ? : FALSE to TRUE ?
Thank you very much
Edit the file /conf/config-defaults.php
Line: 16
Change
12 => FLASE, //PDO::ATTR_PERSISTENT => FALSE,
to:
12 => TRUE, //PDO::ATTR_PERSISTENT => FALSE,
Huuuuge improvement
Also check mysql config param: max_user_connections
DOH.... thought the title said "max_connections". Ignore previous post
Well, I recommend x10hosting.com
Free, and it has never given me problems with MySQL