Bug 536811 - Cannot delete Repos
Summary: Cannot delete Repos
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: RHQ Project
Classification: Other
Component: Content
Version: unspecified
Hardware: All
OS: Linux
high
high
Target Milestone: ---
: ---
Assignee: Sayli Karmarkar
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks: RHQ_CONT_REPO
TreeView+ depends on / blocked
 
Reported: 2009-11-11 13:46 UTC by Corey Welton
Modified: 2015-03-23 01:10 UTC (History)
2 users (show)

Fixed In Version: 2.4
Clone Of:
Environment:
Last Closed: 2010-08-12 16:51:01 UTC
Embargoed:


Attachments (Terms of Use)

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.


Note You need to log in before you can comment on or make changes to this bug.