omeganon [http://community.zenoss.org/people/omeganon] created the discussion
"4.2 events db integrity error."
To view the discussion, visit: http://community.zenoss.org/message/68876#68876
--------------------------------------------------------------
Hey!
Something happened to my events db and I'm no longer able to ack or remove events. I'm fine with purging all events if that's what it takes. Error below. Any suggestions?
2012-10-04T13:45:23.965 [INDEXER_EVENT_SUMMARY] ERROR org.zenoss.zep.dao.impl.DaoCacheImpl - Database integrity error - id "9" not found in table "event_key". Manual table recovery required.
2012-10-04T13:45:23.967 [INDEXER_EVENT_SUMMARY] WARNÂ org.zenoss.zep.index.impl.EventIndexerImpl - General failure indexing events
org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0
   at org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:71) ~[spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]
   at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:729) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
   at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:748) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
   at org.zenoss.zep.dao.impl.DaoCacheImpl$DaoTableStringLruCache.findNameFromId(DaoCacheImpl.java:290) ~[zep-core-1.2-SNAPSHOT.jar:na]
   at org.zenoss.zep.dao.impl.DaoCacheImpl$DaoTableStringLruCache.findNameFromId(DaoCacheImpl.java:251) ~[zep-core-1.2-SNAPSHOT.jar:na]
   at org.zenoss.zep.dao.impl.DaoCacheImpl.getNameFromId(DaoCacheImpl.java:86) ~[zep-core-1.2-SNAPSHOT.jar:na]
   at org.zenoss.zep.dao.impl.DaoCacheImpl.getEventKeyFromId(DaoCacheImpl.java:173) ~[zep-core-1.2-SNAPSHOT.jar:na]
   at sun.reflect.GeneratedMethodAccessor90.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 $Proxy23.getEventKeyFromId(Unknown Source) ~[na:na]
   at org.zenoss.zep.dao.impl.EventDaoHelper.eventMapper(EventDaoHelper.java:421) ~[zep-core-1.2-SNAPSHOT.jar:na]
   at org.zenoss.zep.dao.impl.EventDaoHelper$$FastClassByCGLIB$$4022e757.invoke(<generated>) ~[cglib-nodep-2.2.jar:na]
   at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) ~[cglib-nodep-2.2.jar:na]
   at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617) ~[spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]
   at org.zenoss.zep.dao.impl.EventDaoHelper$$EnhancerByCGLIB$$df39da0f.eventMapper(<generated>) ~[cglib-nodep-2.2.jar:na]
   at org.zenoss.zep.dao.impl.EventSummaryRowMapper.mapRow(EventSummaryRowMapper.java:43) ~[zep-core-1.2-SNAPSHOT.jar:na]
   at org.zenoss.zep.dao.impl.EventIndexQueueDaoImpl$1.mapRow(EventIndexQueueDaoImpl.java:108) ~[zep-core-1.2-SNAPSHOT.jar:na]
   at org.zenoss.zep.dao.impl.EventIndexQueueDaoImpl$1.mapRow(EventIndexQueueDaoImpl.java:99) ~[zep-core-1.2-SNAPSHOT.jar:na]
   at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:92) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
   at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:1) ~[spring-jdbc-3.0.5.RELEASE.jar:3.0.5.RELEASE]
   at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648) ~[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]
   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:99) ~[zep-core-1.2-SNAPSHOT.jar:na]
   at sun.reflect.GeneratedMethodAccessor101.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 $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_31]
   at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) [na:1.6.0_31]
   at java.util.concurrent.FutureTask.run(Unknown Source) [na:1.6.0_31]
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) [na:1.6.0_31]
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.6.0_31]
   at java.lang.Thread.run(Unknown Source) [na:1.6.0_31]
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68876#68876]
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]