[Spacewalk-list] Ok. Got a good one...SSL Key Delete Error

[Glen Collins]

Hi all. I have an issue where I'm trying to delete an SSL key and I'm getting the following error: 



2014-11-19 10:39:58,311 [TP-Processor3] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 23503 
2014-11-19 10:39:58,312 [TP-Processor3] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: update or delete on table "rhncryptokey" violates foreign key constraint "rhn_csssl_cacertid_fk" on table "rhncontentsourcessl" 
Detail: Key (id)=(3) is still referenced from table "rhncontentsourcessl". 
2014-11-19 10:39:58,312 [TP-Processor3] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session 




Looks like I have to go into the DB to get rid of this. But I don't want to go into it unless I know exactly what I need to delete. Just don't want to delete the wrong thing. 




Anyone run into this before and have a solution? 




Thanks! 




Glen Collins 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20141119/62b04407/attachment.htm>