OneLoveAmaru
2012-10-08 15:28:42 UTC
OneLoveAmaru [http://community.zenoss.org/people/OneLoveAmaru] created the discussion
"zeneventserver losing connecting with mysql"
To view the discussion, visit: http://community.zenoss.org/message/68890#68890
--------------------------------------------------------------
Hi Guys, I'm having a problem with Zenoss 4.2.0 SP1. It seems zeneventserver keeps blowing up and losing connection to mysql.
Here is a snitip of the logs. Any help would really be appreciated.
2012-09-27T02:36:53.620 [ZEP_EVENT_TIME_PURGER] INFOÂ org.zenoss.utils.dao.impl.MySqlRangePartitioner - Pruning table event_time partition p20120926_060000: prune timestamp 2012-09-26 02:36:53.62
2012-09-27T02:36:53.863 [ZEP_EVENT_TIME_PURGER] INFOÂ org.zenoss.utils.dao.impl.MySqlRangePartitioner - Adding partition p20120927_080000 to table event_time
2012-09-27T02:44:27.572 [ZEP2] ERROR org.springframework.transaction.interceptor.TransactionInterceptor - Application exception overridden by rollback exception
org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [SELECT uuid FROM event_summary WHERE last_seen <= ? AND clear_fingerprint_hash IN (?) AND status_id NOT IN (?, ?, ?) FOR UPDATE]; The last packet successfully received from the server was 37,601,700 milliseconds ago. The last packet sent successfully to the server was 37,601,701 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 37,601,700 milliseconds ago. The last packet sent successfully to the server was 37,601,701 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
       at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:98) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:661) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:701) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:165) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:171) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:178) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.zenoss.zep.dao.impl.EventSummaryDaoImpl.clearEvents(EventSummaryDaoImpl.java:341) ~[zep-core-1.2-SNAPSHOT.jar:na]
       at org.zenoss.zep.dao.impl.EventSummaryDaoImpl.create(EventSummaryDaoImpl.java:165) ~[zep-core-1.2-SNAPSHOT.jar:na]
       at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source) ~[na:na]
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_31]
       at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_31]
       at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) ~[spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) ~[spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at $Proxy24.create(Unknown Source) [na:na]
       at org.zenoss.zep.impl.EventProcessorImpl.processEvent(EventProcessorImpl.java:113) [zep-core-1.2-SNAPSHOT.jar:na]
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68890#68890]
Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
"zeneventserver losing connecting with mysql"
To view the discussion, visit: http://community.zenoss.org/message/68890#68890
--------------------------------------------------------------
Hi Guys, I'm having a problem with Zenoss 4.2.0 SP1. It seems zeneventserver keeps blowing up and losing connection to mysql.
Here is a snitip of the logs. Any help would really be appreciated.
2012-09-27T02:36:53.620 [ZEP_EVENT_TIME_PURGER] INFOÂ org.zenoss.utils.dao.impl.MySqlRangePartitioner - Pruning table event_time partition p20120926_060000: prune timestamp 2012-09-26 02:36:53.62
2012-09-27T02:36:53.863 [ZEP_EVENT_TIME_PURGER] INFOÂ org.zenoss.utils.dao.impl.MySqlRangePartitioner - Adding partition p20120927_080000 to table event_time
2012-09-27T02:44:27.572 [ZEP2] ERROR org.springframework.transaction.interceptor.TransactionInterceptor - Application exception overridden by rollback exception
org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [SELECT uuid FROM event_summary WHERE last_seen <= ? AND clear_fingerprint_hash IN (?) AND status_id NOT IN (?, ?, ?) FOR UPDATE]; The last packet successfully received from the server was 37,601,700 milliseconds ago. The last packet sent successfully to the server was 37,601,701 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 37,601,700 milliseconds ago. The last packet sent successfully to the server was 37,601,701 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
       at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:98) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:661) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:701) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:165) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:171) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:178) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.zenoss.zep.dao.impl.EventSummaryDaoImpl.clearEvents(EventSummaryDaoImpl.java:341) ~[zep-core-1.2-SNAPSHOT.jar:na]
       at org.zenoss.zep.dao.impl.EventSummaryDaoImpl.create(EventSummaryDaoImpl.java:165) ~[zep-core-1.2-SNAPSHOT.jar:na]
       at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source) ~[na:na]
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_31]
       at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_31]
       at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) ~[spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) ~[spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
       at $Proxy24.create(Unknown Source) [na:na]
       at org.zenoss.zep.impl.EventProcessorImpl.processEvent(EventProcessorImpl.java:113) [zep-core-1.2-SNAPSHOT.jar:na]
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68890#68890]
Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]