• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Database Connection

Daniel Hood

Well-known member
#1
I went to look at my database process list and it has a few processes with the command "Sleep". The only thing installed using that database is xF? Any ideas what the issue is? I've also been getting
"An exception occurred: User xF already has more than 'max_user_connections' active connections in" error off and on all day?
 

MattW

Well-known member
#2
I went to look at my database process list and it has a few processes with the command "Sleep". The only thing installed using that database is xF? Any ideas what the issue is? I've also been getting
"An exception occurred: User xF already has more than 'max_user_connections' active connections in" error off and on all day?
That error is due to you going over the max_connections variable setting in your my.cnf file

You will need to increase that and restart MySQL to stop that from happening.
 

Daniel Hood

Well-known member
#3
It says the max user connections is like 109, I haven't put the site live so it was just me on it. I was setting things up and stuff. I probably loaded like 100 pages in my session. I'm testing on a cheap server so I understand if that was somewhat the issue. I just want to make sure that xF closes all connections and everything. I'm mostly interested in the sleep processes.
 

Daniel Hood

Well-known member
#4
I figured this out. My problem was that I was using sleep to wait and compare results after a set amount of time. The page was timing out before it got to the end (where the connection is closed).