Mysql 'max_User_Connections' Error

[rkysh]

Getting the following error

 

User rkysh already has more than 'max_user_connections' active connections

 

I have closed all the connections in the finally block, then too.

 

Domain : rkysh.heliohost.org

 

 

<%!
  Connection con;
  %>
  <%
  try {
java.util.Date now = new java.util.Date();  
 SimpleDateFormat sdf = new SimpleDateFormat("dd-M-yyyy HH:mm:ss");  
 String sdate=sdf.format(now).toString();
 String ip=request.getRemoteAddr();

  String query = "insert into ip(IP,DATEE) values ('"+ip+"','"+sdate+"')";
String url = "jdbc:mysql://localhost/rkysh_iplog";
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection (url, "*****", "******");

Statement stmt = con.createStatement();
int i = stmt.executeUpdate(query);
  }catch(SQLException e) {
out.println(e.getMessage());
}finally{
if (con != null) {
			  try {
				 con.close();
			  } catch (Exception e) {
			  }
			  }}
 
  %>

[Guest xaav]

Seems fine to me. Maybe your site was getting too many requests.

[xgenvn]

It's somehow a big problem to me. I'm trying to use MODx CMF, and I'm sure there's something misconfig or a limitation or a bug with mysql and PDO extension. If server admin can, please upgrade our MySQL server to more reliable version.

[Ice IT Support]

MySQL was recently updated, but I don't know to what version. The upgrade was done in an attempt to solve this problem. MySQL interaction through PHP functions fine, I'm not sure about other languages.

 

(null)

[Guest xaav]

MySQL was updated on Stevie. I don't know about the other admins, but I'm planning to wait until EasyApache 4 comes out before upgrading MySQL on Johnny.