without first deleting operation history. I get the following error in
the server log:
2011-06-21 09:25:43,988 INFO
[org.rhq.enterprise.server.core.plugin.ProductPluginDeployer] Deploying
[1] new or updated agent plugins: [quoteserver]
2011-06-21 09:25:45,007 WARN [org.hibernate.util.JDBCExceptionReporter]
SQL Error: 0, SQLState: 23503
2011-06-21 09:25:45,007 ERROR [org.hibernate.util.JDBCExceptionReporter]
Batch entry 0 delete from RHQ_OPERATION_DEF where ID='10301' was
aborted. Call getNextException to see the cause.
2011-06-21 09:25:45,007 WARN [org.hibernate.util.JDBCExceptionReporter]
SQL Error: 0, SQLState: 23503
2011-06-21 09:25:45,007 ERROR [org.hibernate.util.JDBCExceptionReporter]
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"
Detail: Key (id)=(10301) is still referenced from table
"rhq_operation_history".
This makes updating plugins somewhat problematic. We are bundling our
service specific plugins into rpms for deployment and this behavior
would break updates via rpm. Is there any way around this?
Bala Nair
SeaChange International