Ed Reber
2013-09-23 19:42:25 UTC
Ed Reber [http://community.zenoss.org/people/sekreber] created the discussion
"Java Error in zeneventserver daemon log"
To view the discussion, visit: http://community.zenoss.org/message/74734#74734
--------------------------------------------------------------
We are running Zenoss 4.2.3. Recently, our Linux server's Java was updated from 1.6.0_39 to 1.7.0.22. Upon a reboot, the zeneventserver daemon and the zenjmx daemon will not start. Here is the sample of what is in the log file:
2013-09-20T11:43:44.632 [INDEXER_EVENT_SUMMARY] ERROR org.springframework.transaction.interceptor.TransactionInterceptor - Application exception overridden by rollback exception org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT iq.id AS iq_id, iq.uuid AS iq_uuid, iq.update_time AS iq_update_time,es.* FROM event_summary_index_queue AS iq LEFT JOIN event_summary es ON iq.uuid=es.uuid ORDER BY iq_id LIMIT ?]; SQL state [70100]; error code [1317]; Query execution was interrupted; nested exception is java.sql.SQLException: Query execution was interrupted at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) ~[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.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.EventIndexQueueDaoImpl.indexEvents(EventIndexQueueDaoImpl.java:109) ~[zep-core-1.2-SNAPSHOT.jar:na] at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source) ~[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_39] at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_39] 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 sun.proxy.$Proxy28.indexEvents(Unknown Source) [na:na] at org.zenoss.zep.index.impl.EventIndexerImpl.doIndex(EventIndexerImpl.java:216) [zep-core-1.2-SNAPSHOT.jar:na] at org.zenoss.zep.index.impl.EventIndexerImpl.index(EventIndexerImpl.java:162) [zep-core-1.2-SNAPSHOT.jar:na] at org.zenoss.zep.index.impl.EventIndexerImpl$1.run(EventIndexerImpl.java:108) [zep-core-1.2-SNAPSHOT.jar:na] at org.zenoss.zep.impl.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:43) [zep-core-1.2-SNAPSHOT.jar:na] at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [na:1.6.0_39] at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [na:1.6.0_39] at java.util.concurrent.FutureTask.run(Unknown Source) [na:1.6.0_39] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_39] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_39] at java.lang.Thread.run(Unknown Source) [na:1.6.0_39] Caused by: java.sql.SQLException: Query execution was interrupted at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281) ~[mysql-connector-java-5.1.15.jar:na] at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE] ... 27 common frames omitted
Is there a fix for Zenoss on Java 1.7.0.22?
Thanks,
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/74734#74734]
Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
"Java Error in zeneventserver daemon log"
To view the discussion, visit: http://community.zenoss.org/message/74734#74734
--------------------------------------------------------------
We are running Zenoss 4.2.3. Recently, our Linux server's Java was updated from 1.6.0_39 to 1.7.0.22. Upon a reboot, the zeneventserver daemon and the zenjmx daemon will not start. Here is the sample of what is in the log file:
2013-09-20T11:43:44.632 [INDEXER_EVENT_SUMMARY] ERROR org.springframework.transaction.interceptor.TransactionInterceptor - Application exception overridden by rollback exception org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT iq.id AS iq_id, iq.uuid AS iq_uuid, iq.update_time AS iq_update_time,es.* FROM event_summary_index_queue AS iq LEFT JOIN event_summary es ON iq.uuid=es.uuid ORDER BY iq_id LIMIT ?]; SQL state [70100]; error code [1317]; Query execution was interrupted; nested exception is java.sql.SQLException: Query execution was interrupted at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) ~[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.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.EventIndexQueueDaoImpl.indexEvents(EventIndexQueueDaoImpl.java:109) ~[zep-core-1.2-SNAPSHOT.jar:na] at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source) ~[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.6.0_39] at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.6.0_39] 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 sun.proxy.$Proxy28.indexEvents(Unknown Source) [na:na] at org.zenoss.zep.index.impl.EventIndexerImpl.doIndex(EventIndexerImpl.java:216) [zep-core-1.2-SNAPSHOT.jar:na] at org.zenoss.zep.index.impl.EventIndexerImpl.index(EventIndexerImpl.java:162) [zep-core-1.2-SNAPSHOT.jar:na] at org.zenoss.zep.index.impl.EventIndexerImpl$1.run(EventIndexerImpl.java:108) [zep-core-1.2-SNAPSHOT.jar:na] at org.zenoss.zep.impl.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:43) [zep-core-1.2-SNAPSHOT.jar:na] at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [na:1.6.0_39] at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [na:1.6.0_39] at java.util.concurrent.FutureTask.run(Unknown Source) [na:1.6.0_39] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_39] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_39] at java.lang.Thread.run(Unknown Source) [na:1.6.0_39] Caused by: java.sql.SQLException: Query execution was interrupted at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) ~[mysql-connector-java-5.1.15.jar:na] at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281) ~[mysql-connector-java-5.1.15.jar:na] at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE] ... 27 common frames omitted
Is there a fix for Zenoss on Java 1.7.0.22?
Thanks,
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/74734#74734]
Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]