rkysh Posted December 19, 2011 Share Posted December 19, 2011 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) { } }} %> Quote Link to comment Share on other sites More sharing options...
Guest xaav Posted December 24, 2011 Share Posted December 24, 2011 Seems fine to me. Maybe your site was getting too many requests. Quote Link to comment Share on other sites More sharing options...
xgenvn Posted December 26, 2011 Share Posted December 26, 2011 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. Quote Link to comment Share on other sites More sharing options...
Ice IT Support Posted December 27, 2011 Share Posted December 27, 2011 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) Quote Link to comment Share on other sites More sharing options...
Guest xaav Posted December 27, 2011 Share Posted December 27, 2011 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.