[cshepherd]

If I add that line and restart my zmlogswatchstl and swatch is no longer running and I can now see this in ~/log/zimbra.log which I'm pretty sure wasn't in there before.

I removed the added line and the error is now gone.

2006-10-07 16:29:49,266 WARN  [Timer-0] [] DbStats - An error occurred while getting current database stats
com.zimbra.cs.service.ServiceException: system failure: getting database connection
        at com.zimbra.cs.service.ServiceException.FAILURE(ServiceException.java:174)
        at com.zimbra.cs.db.DbPool.getConnection(DbPool.java:295)
        at com.zimbra.cs.db.DbUtil.executeQuery(DbUtil.java:168)
        at com.zimbra.cs.db.DbUtil.executeQuery(DbUtil.java:195)
        at com.zimbra.cs.db.DbStats.getStatus(DbStats.java:87)
        at com.zimbra.cs.db.DbStats.getStatData(DbStats.java:58)
        at com.zimbra.cs.stats.RealtimeStats.getData(RealtimeStats.java:73)
        at com.zimbra.cs.stats.ZimbraPerf$ZimbraStatsDumper.run(ZimbraPerf.java:539)
        at java.util.TimerThread.mainLoop(Timer.java:512)
        at java.util.TimerThread.run(Timer.java:462)
Caused by: java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.net.SocketException: java.net.ConnectException: Connection refused'.

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
        at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2680)
        at com.mysql.jdbc.Connection.(Connection.java:1485)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:97)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
        at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:171)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:193)
        at com.zimbra.cs.db.DbPool.getConnection(DbPool.java:286)
        at com.zimbra.cs.db.DbUtil.executeQuery(DbUtil.java:168)
        at com.zimbra.cs.db.DbUtil.executeQuery(DbUtil.java:195)
        at com.zimbra.cs.db.DbStats.getStatus(DbStats.java:87)
        at com.zimbra.cs.db.DbStats.getStatData(DbStats.java:58)
        at com.zimbra.cs.stats.RealtimeStats.getData(RealtimeStats.java:73)
        at com.zimbra.cs.stats.ZimbraPerf$ZimbraStatsDumper.run(ZimbraPerf.java:539)
        at java.util.TimerThread.mainLoop(Timer.java:512)
        at java.util.TimerThread.run(Timer.java:462)


** END NESTED EXCEPTION **