Results 1 to 2 of 2

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

Threaded View

  1. #1
    Join Date
    Jan 2007
    Rep Power

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


    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
    $>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?

    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?

    log from /opt/zimbra/log/mailbox.log
    2007-10-26 12:25:13,116 INFO  [http-7071-Processor49] [;ip=;] SoapEngine - handler exception
    com.zimbra.common.service.ServiceException: system failure: getting database logger connection
            at com.zimbra.common.service.ServiceException.FAILURE(
            at com.zimbra.cs.db.DbPool.getLoggerConnection(
            at com.zimbra.cs.service.admin.GetServiceStatus.handle(
            at com.zimbra.soap.SoapEngine.dispatchRequest(
            at com.zimbra.soap.SoapEngine.dispatch(
            at com.zimbra.soap.SoapEngine.dispatch(
            at com.zimbra.soap.SoapServlet.doPost(
            at javax.servlet.http.HttpServlet.service(
            at com.zimbra.cs.servlet.ZimbraServlet.service(
            at javax.servlet.http.HttpServlet.service(
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(
            at org.apache.catalina.core.StandardWrapperValve.invoke(
            at org.apache.catalina.core.StandardContextValve.invoke(
            at org.apache.catalina.core.StandardHostValve.invoke(
            at org.apache.catalina.valves.ErrorReportValve.invoke(
            at org.apache.catalina.core.StandardEngineValve.invoke(
            at org.apache.catalina.valves.AccessLogValve.invoke(
            at org.apache.catalina.connector.CoyoteAdapter.service(
            at org.apache.coyote.http11.Http11Processor.process(
            at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(
            at org.apache.tomcat.util.threads.ThreadPool$
    Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections
            at com.mysql.jdbc.SQLError.createSQLException(
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(
            at com.mysql.jdbc.MysqlIO.secureAuth411(
            at com.mysql.jdbc.MysqlIO.doHandshake(
            at com.mysql.jdbc.Connection.createNewIO(
            at com.mysql.jdbc.Connection.<init>(
            at com.mysql.jdbc.NonRegisteringDriver.connect(
            at java.sql.DriverManager.getConnection(
            at java.sql.DriverManager.getConnection(
            at com.zimbra.cs.db.DbPool.getLoggerConnection(
            ... 23 more
    Any thoughts appreciated.

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

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, 01:08 PM
  3. Replies: 3
    Last Post: 07-19-2007, 02:00 AM
  4. Replies: 18
    Last Post: 03-20-2006, 01: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