Bug 536811

Summary: Cannot delete Repos
Product: [Other] RHQ Project Reporter: Corey Welton <cwelton>
Component: ContentAssignee: Sayli Karmarkar <skarmark>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: unspecifiedCC: cperry, skarmark
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: 2.4 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-08-12 16:51:01 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 538145    

Description Corey Welton 2009-11-11 13:46:46 UTC
Description of problem:
When user attempts to delete repos, a stack trace is returned.

Version-Release number of selected component (if applicable):


How reproducible:
Every time

Steps to Reproduce:
1. Create a repo
2. Navigate to Administration > Content > Repositories
3. Click the checkbox next to your repo and attempt to delete ("Delete Selected").
  
Actual results:

Failed to delete repositories. Cause: javax.ejb.EJBTransactionRolledbackException:org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update -> javax.persistence.PersistenceException:org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update -> org.hibernate.exception.SQLGrammarException:Could not execute JDBC batch update -> java.sql.BatchUpdateException:Batch entry 0 delete from RHQ_REPO_RHQ_TAG where RHQ_REPO_ID='10061' was aborted. Call getNextException to see the cause.[SQLException=Batch entry 0 delete from RHQ_REPO_RHQ_TAG where RHQ_REPO_ID='10061' was aborted. Call getNextException to see the cause. -> ERROR: relation "rhq_repo_rhq_tag" does not exist(error-code=0,sql-state=42P01)]

Expected results:
Can be deleted!

Additional info:

Found by automation.

Comment 1 Corey Welton 2009-11-12 15:14:25 UTC
This also breaks Content Providers - similar message occurs when trying to delete them.

Comment 2 Sayli Karmarkar 2009-11-12 18:23:10 UTC
Fixed. Dev sanity checking is done. I am able to delete repos and content providers without any errors or tracebacks. 

~SayliK

Comment 3 Corey Welton 2009-11-12 19:58:22 UTC
QA Verified.

Comment 4 Corey Welton 2010-08-12 16:51:01 UTC
Mass-closure of verified bugs against JON.