1. 11:15:42,216 WARN [AvailabilityManagerBean] Resource [Resource[id=10455, uuid=null, type=<null>, key=null, name=null, parent=<null>]] has no availability without an endtime [No entity found for query] - will attempt to create one
  2. AV:[jetengine][451][full]
  3. 11:15:42,225 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 23503
  4. 11:15:42,225 ERROR [JDBCExceptionReporter] Batch entry 0 insert into RHQ_AVAILABILITY (START_TIME, END_TIME, AVAILABILITY_TYPE, RESOURCE_ID, ID) values ('1336662941868', NULL, '0', '10455', '13488') was aborted. Call getNextException to see the cause.
  5. 11:15:42,225 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 23503
  6. 11:15:42,225 ERROR [JDBCExceptionReporter] ERROR: insert or update on table "rhq_availability" violates foreign key constraint "rhq_availability_resource_id_fkey"
  7. Detail: Key (resource_id)=(10455) is not present in table "rhq_resource".
  8. 11:15:42,227 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
  9. org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  10. at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
  11. at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  12. at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:254)
  13. at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
  14. at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
  15. at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
  16. at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
  17. at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)
  18. at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
  19. at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
  20. at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:80)
  21. at org.rhq.enterprise.server.resource.ResourceAvailabilityManagerBean.getLatestAvailability(ResourceAvailabilityManagerBean.java:169)
  22. at sun.reflect.GeneratedMethodAccessor352.invoke(Unknown Source)
  23. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  24. at java.lang.reflect.Method.invoke(Method.java:597)
  25. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
  26. at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
  27. at org.rhq.enterprise.server.common.PerformanceMonitorInterceptor.monitorHibernatePerformance(PerformanceMonitorInterceptor.java:32)
  28. at sun.reflect.GeneratedMethodAccessor139.invoke(Unknown Source)
  29. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  30. at java.lang.reflect.Method.invoke(Method.java:597)
  31. at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
  32. at org.rhq.enterprise.server.common.TransactionInterruptInterceptor.addCheckedActionToTransactionManager(TransactionInterruptInterceptor.java:77)
  33. at sun.reflect.GeneratedMethodAccessor138.invoke(Unknown Source)
  34. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  35. at java.lang.reflect.Method.invoke(Method.java:597)
  36. at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
  37. at org.rhq.enterprise.server.authz.RequiredPermissionsInterceptor.checkRequiredPermissions(RequiredPermissionsInterceptor.java:156)
  38. at sun.reflect.GeneratedMethodAccessor137.invoke(Unknown Source)
  39. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  40. at java.lang.reflect.Method.invoke(Method.java:597)
  41. at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
  42. at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
  43. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  44. at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
  45. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  46. at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
  47. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  48. at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
  49. at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
  50. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  51. at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
  52. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  53. at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
  54. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  55. at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
  56. at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
  57. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  58. at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
  59. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  60. at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
  61. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  62. at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:240)
  63. at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:210)
  64. at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:84)
  65. at $Proxy213.getLatestAvailability(Unknown Source)
  66. at org.rhq.enterprise.server.measurement.AvailabilityManagerBean.updateResourceAvailability(AvailabilityManagerBean.java:625)
  67. at org.rhq.enterprise.server.measurement.AvailabilityManagerBean.mergeAvailabilityReport(AvailabilityManagerBean.java:563)
  68. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  69. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  70. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  71. at java.lang.reflect.Method.invoke(Method.java:597)
  72. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
  73. at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
  74. at org.rhq.enterprise.server.common.PerformanceMonitorInterceptor.monitorHibernatePerformance(PerformanceMonitorInterceptor.java:32)
  75. at sun.reflect.GeneratedMethodAccessor139.invoke(Unknown Source)
  76. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  77. at java.lang.reflect.Method.invoke(Method.java:597)
  78. at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
  79. at org.rhq.enterprise.server.common.TransactionInterruptInterceptor.addCheckedActionToTransactionManager(TransactionInterruptInterceptor.java:77)
  80. at sun.reflect.GeneratedMethodAccessor138.invoke(Unknown Source)
  81. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  82. at java.lang.reflect.Method.invoke(Method.java:597)
  83. at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
  84. at org.rhq.enterprise.server.authz.RequiredPermissionsInterceptor.checkRequiredPermissions(RequiredPermissionsInterceptor.java:156)
  85. at sun.reflect.GeneratedMethodAccessor137.invoke(Unknown Source)
  86. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  87. at java.lang.reflect.Method.invoke(Method.java:597)
  88. at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
  89. at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
  90. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  91. at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
  92. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  93. at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
  94. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  95. at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
  96. at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)
  97. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  98. at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
  99. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  100. at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
  101. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  102. at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
  103. at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
  104. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  105. at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
  106. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  107. at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
  108. at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  109. at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:240)
  110. at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:210)
  111. at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:84)
  112. at $Proxy445.mergeAvailabilityReport(Unknown Source)
  113. at org.rhq.enterprise.server.discovery.DiscoveryServerServiceImpl.mergeAvailabilityReport(DiscoveryServerServiceImpl.java:116)
  114. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  115. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  116. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  117. at java.lang.reflect.Method.invoke(Method.java:597)
  118. at org.rhq.enterprise.communications.command.impl.remotepojo.server.RemotePojoInvocationCommandService.execute(RemotePojoInvocationCommandService.java:184)
  119. at sun.reflect.GeneratedMethodAccessor343.invoke(Unknown Source)
  120. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  121. at java.lang.reflect.Method.invoke(Method.java:597)
  122. at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
  123. at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
  124. at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
  125. at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
  126. at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
  127. at javax.management.MBeanServerInvocationHandler.invoke(MBeanServerInvocationHandler.java:288)
  128. at $Proxy719.execute(Unknown Source)
  129. at org.rhq.enterprise.communications.command.server.CommandProcessor.handleIncomingInvocationRequest(CommandProcessor.java:290)
  130. at org.rhq.enterprise.communications.command.server.CommandProcessor.invoke(CommandProcessor.java:184)
  131. at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:809)
  132. at org.jboss.remoting.transport.servlet.ServletServerInvoker.processRequest(ServletServerInvoker.java:232)
  133. at sun.reflect.GeneratedMethodAccessor338.invoke(Unknown Source)
  134. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  135. at java.lang.reflect.Method.invoke(Method.java:597)
  136. at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
  137. at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
  138. at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
  139. at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
  140. at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
  141. at javax.management.MBeanServerInvocationHandler.invoke(MBeanServerInvocationHandler.java:288)
  142. at $Proxy540.processRequest(Unknown Source)
  143. at org.jboss.remoting.transport.servlet.web.ServerInvokerServlet.processRequest(ServerInvokerServlet.java:128)
  144. at org.jboss.remoting.transport.servlet.web.ServerInvokerServlet.doPost(ServerInvokerServlet.java:157)
  145. at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
  146. at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  147. at sun.reflect.GeneratedMethodAccessor337.invoke(Unknown Source)
  148. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  149. at java.lang.reflect.Method.invoke(Method.java:597)
  150. at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:244)
  151. at java.security.AccessController.doPrivileged(Native Method)
  152. at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
  153. at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:276)
  154. at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
  155. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
  156. at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
  157. at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
  158. at java.security.AccessController.doPrivileged(Native Method)
  159. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
  160. at org.rhq.helpers.rtfilter.filter.RtFilter.doFilter(RtFilter.java:125)
  161. at sun.reflect.GeneratedMethodAccessor336.invoke(Unknown Source)
  162. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  163. at java.lang.reflect.Method.invoke(Method.java:597)
  164. at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:244)
  165. at java.security.AccessController.doPrivileged(Native Method)
  166. at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
  167. at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:276)
  168. at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:218)
  169. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
  170. at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
  171. at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
  172. at java.security.AccessController.doPrivileged(Native Method)
  173. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
  174. at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
  175. at sun.reflect.GeneratedMethodAccessor335.invoke(Unknown Source)
  176. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  177. at java.lang.reflect.Method.invoke(Method.java:597)
  178. at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:244)
  179. at java.security.AccessController.doPrivileged(Native Method)
  180. at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
  181. at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:276)
  182. at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:218)
  183. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
  184. at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
  185. at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
  186. at java.security.AccessController.doPrivileged(Native Method)
  187. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
  188. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
  189. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
  190. at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
  191. at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
  192. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  193. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  194. at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
  195. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  196. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
  197. at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
  198. at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
  199. at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
  200. at java.lang.Thread.run(Thread.java:662)
  201. Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into RHQ_AVAILABILITY (START_TIME, END_TIME, AVAILABILITY_TYPE, RESOURCE_ID, ID) values ('1336662941868', NULL, '0', '10455', '13488') was aborted. Call getNextException to see the cause.
  202. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2621)
  203. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1837)
  204. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
  205. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2754)
  206. at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source)
  207. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  208. at java.lang.reflect.Method.invoke(Method.java:597)
  209. at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
  210. at $Proxy51.executeBatch(Unknown Source)
  211. at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeBatch(CachedPreparedStatement.java:476)
  212. at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)
  213. at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
  214. at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:247)
  215. ... 188 more