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

[preem]

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

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

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

[preem]

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.