JBoss ON server log continuously reports failed to purge resource types if resource type was a target of a group operation in a compatible or auto resource group
Issue
-
server.logcontinues to report integrity constraint violated every few minutes:WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-5) SQL Error: 2292, SQLState: 23000 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-5) ORA-02292: integrity constraint (RHQADMIN.SYS_C007902) violated - child record found ERROR [org.hibernate.engine.jdbc.batch.internal.BatchingBatch] (RHQScheduler_Worker-5) HHH000315: Exception executing batch [could not execute batch] ERROR [org.rhq.enterprise.server.scheduler.jobs.AbstractStatefulJob] (RHQScheduler_Worker-5) Failed to execute job [PurgeResourceTypesJob]: javax.ejb.EJBException: java.lang.RuntimeException: Failed to purge resource types -
PurgeResourceTypesJobfails due to database integrity or foreign key constraint violation when attempting to remove a resource type's operation definitionWARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-2) SQL Error: 0, SQLState: 23503 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-2) Batch entry 0 delete from RHQ_OPERATION_DEF where ID=10582 was aborted. Call getNextException to see the cause. WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-2) SQL Error: 0, SQLState: 23503 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-2) ERROR: update or delete on table "rhq_operation_def" violates foreign key constraint "rhq_operation_history_operation_def_id_fkey" on table "rhq_operation_history" (id)=(10582) is still referenced from table "rhq_operation_history".
Environment
- Red Hat JBoss Operations Network (ON) 3.3
- An agent plug-in has recently been deleted
- A resource operation had previously been invoked on a group of resources with the same resource type from the agent plug-in which is to be deleted
- This could be a compatible resource group or a resource type auto grouping
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
