reset password
Author Message
jpascua
Posts: 197
Posted 17:52 Jun 11, 2015 |

User cs320stu24 already has more than 'max_user_connections' active connections

I wasn't having problems earlier but now I'm getting this output on the console. I can't log onto phpmyadmin anymore either. Is there a way to resolve this? :/

Last edited by jpascua at 17:52 Jun 11, 2015.
willielf
Posts: 23
Posted 17:53 Jun 11, 2015 |

Did you forget to have the code connection.close(); in your program? Our professor mentioned this last time, and that he can't do anything about this. You'll just have to wait till it clears.

disrael
Posts: 44
Posted 17:53 Jun 11, 2015 |

I'm having the same issue right now too. It won't let me get into myphpadmin. Its just continuously loading. 

disrael
Posts: 44
Posted 17:55 Jun 11, 2015 |

It finally loaded for me and said internal server error: error code 500 

jpascua
Posts: 197
Posted 17:55 Jun 11, 2015 |

Yep, I added connection.close(); at the end of the try block. :(

acervantes
Posts: 28
Posted 17:57 Jun 11, 2015 |

You must close all connections that you open.  If your servlet errors out before your connection is closed, you will have an orphan connection.  

This orphan will only be closed when the Server decides to close it.  

There is a maximum number of connections that can be open at one time.  If you exceed that, the server will actively reject new connection requests.

jpascua
Posts: 197
Posted 18:04 Jun 11, 2015 |

I restarted my computer and this fixed the error.

disrael
Posts: 44
Posted 18:21 Jun 11, 2015 |

Is anyone having issues loading phpmyadmin still? It was working, but not is not again.