Results 1 to 2 of 2

Thread: [SOLVED] Daily reports stopped sending - Mysql Too many connections

  1. #1
    preem is offline Active Member
    Join Date
    Jan 2007
    Location
    Slovenia
    Posts
    29
    Rep Power
    8

    Default [SOLVED] Daily reports stopped sending - Mysql Too many connections

    Hello,

    long time user, very satisfied costumer.

    Running OSE on Ubuntu Dapper, just upgraded from 4.5.7 to 4.5.9 and am experiencing some minor problem and couldn't find anything related. Actually the problem isn't associated with the upgrade, started happening a few days earlier.

    So, i stopped receiving Daily Reports and running it manually reveals the problem
    Code:
    $>zmdailyreport -m
    DBI connect('database=zimbra_logger;mysql_read_default_file=/opt/zimbra/conf/my.logger.cnf;mysql_socket=/opt/zimbra/logger/db/mysql.sock','zimbra',...) failed: Too many connections at ../libexec/zmdailyreport line 537
    I have tried changing the max_connections from 10 (default in 'my.logger.cnf') to up to 200 to no avail. In 'my.cnf', default value is 14.

    What else can i check?

    edit1:
    also checked active mysql connections with 'SHOW PROCESSLIST;' in mysql prompt and it shows only 2 active connections, which boggles me even more, how could it reach the limit then?

    edit2:
    log from /opt/zimbra/log/mailbox.log
    Code:
    2007-10-26 12:25:13,116 INFO  [http-7071-Processor49] [name=admin@izvedba.si;ip=212.103.134.130;] SoapEngine - handler exception
    com.zimbra.common.service.ServiceException: system failure: getting database logger connection
            at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:165)
            at com.zimbra.cs.db.DbPool.getLoggerConnection(DbPool.java:361)
            at com.zimbra.cs.service.admin.GetServiceStatus.handle(GetServiceStatus.java:70)
            at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEngine.java:266)
            at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:163)
            at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:85)
            at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:220)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
            at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:152)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
            at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
            at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
            at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
            at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
            at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
            at java.lang.Thread.run(Thread.java:619)
    Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
            at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
            at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
            at com.mysql.jdbc.Connection.createNewIO(Connection.java:2644)
            at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
            at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
            at java.sql.DriverManager.getConnection(DriverManager.java:582)
            at java.sql.DriverManager.getConnection(DriverManager.java:207)
            at com.zimbra.cs.db.DbPool.getLoggerConnection(DbPool.java:358)
            ... 23 more
    Any thoughts appreciated.

    Thanks,
    Primoz Jerse
    Last edited by preem; 10-26-2007 at 03:30 AM.

  2. #2
    preem is offline Active Member
    Join Date
    Jan 2007
    Location
    Slovenia
    Posts
    29
    Rep Power
    8

    Default

    After several restarts it got a hold of the 'max_connections' variable in the my.logger.cnf and it seems like its working again.

    sorry for trouble.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. Replies: 2
    Last Post: 02-29-2008, 02:08 PM
  3. Replies: 3
    Last Post: 07-19-2007, 02:00 AM
  4. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 06:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •