Bug 484988
| Summary: | ISE when attempting to delete a package in a custom channel | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | John Matthews <jmatthew> | ||||
| Component: | Server | Assignee: | Jay Dobies <jason.dobies> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | John Matthews <jmatthew> | ||||
| Severity: | medium | Docs Contact: | |||||
| Priority: | low | ||||||
| Version: | 530 | CC: | jason.dobies, jesusr, mmraka | ||||
| Target Milestone: | --- | Keywords: | Regression | ||||
| Target Release: | --- | ||||||
| Hardware: | All | ||||||
| OS: | Linux | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | sat530 | Doc Type: | Bug Fix | ||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2009-09-10 18:14:46 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: | 456985, 486216 | ||||||
| Attachments: |
|
||||||
|
Description
John Matthews
2009-02-10 23:46:44 UTC
I think this might be happening because the Satellite ran out of room on the filesystem. Will re-try on a fresh install and update BZ tomorrow. I free'd up some room on the Sat and tried to delete the package, still failing with the ISE. Will try a fresh install and update BZ later. Commit: f3002fc42752a1456b7e7e4bb21f746fb9067595 Package_queries.cleanup_needed_package_cache ------------------- Query was missed in the conversion of rhnServerNeededPackageCache from table to view It looks like more problems still exist.
I saw package deletion of a custom package work for me, it looks like the first problem was addressed and fixed, yet something is still not right.
I enabled nvrea, ran sat-sync to import 2 custom channels each with a package with same nvrea. I saw the packages were not imported successfully, i.e. only 1 package was imported, yet it was linked to both channels. i.e. instead of having one customrhel channel with a rhel package and a customcentos channel with a centos package, I had 2 channels both displaying the centos package.
I attempted to clean up this setup and I got an ISE.
2009-02-24 19:30:18,661 [TP-Processor7] WARN org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class com.redhat.rhn.common.db.ConstraintViolationException
2009-02-24 19:30:18,662 [TP-Processor7] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back
javax.servlet.ServletException: ORA-00001: unique constraint (RHNSAT.RHN_PFDQUEUE_PATH_UQ) violated
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651)
at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:137)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:454)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:431)
at com.redhat.rhn.common.db.datasource.CachedStatement.executeUpdate(CachedStatement.java:269)
at com.redhat.rhn.common.db.datasource.WriteMode.executeUpdate(WriteMode.java:33)
at com.redhat.rhn.manager.rhnpackage.PackageManager.schedulePackageFileForDeletion(PackageManager.java:735)
at com.redhat.rhn.manager.rhnpackage.PackageManager.deletePackages(PackageManager.java:1036)
at com.redhat.rhn.frontend.action.rhnpackage.CustomPackagesDeleteConfirmAction.deletePackages(CustomPackagesDeleteConfirmAction.java:103)
at com.redhat.rhn.frontend.action.rhnpackage.CustomPackagesDeleteConfirmAction.execute(CustomPackagesDeleteConfirmAction.java:80)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
... 40 more
Caused by:
java.sql.SQLException: ORA-00001: unique constraint (RHNSAT.RHN_PFDQUEUE_PATH_UQ) violated
... 60 more
2009-02-24 19:30:18,769 [TP-Processor7] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[action] - Servlet.service() for servlet action threw exception
java.sql.SQLException: ORA-00001: unique constraint (RHNSAT.RHN_PFDQUEUE_PATH_UQ) violated
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651)
at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:137)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:454)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:431)
at com.redhat.rhn.common.db.datasource.CachedStatement.executeUpdate(CachedStatement.java:269)
at com.redhat.rhn.common.db.datasource.WriteMode.executeUpdate(WriteMode.java:33)
at com.redhat.rhn.manager.rhnpackage.PackageManager.schedulePackageFileForDeletion(PackageManager.java:735)
at com.redhat.rhn.manager.rhnpackage.PackageManager.deletePackages(PackageManager.java:1036)
at com.redhat.rhn.frontend.action.rhnpackage.CustomPackagesDeleteConfirmAction.deletePackages(CustomPackagesDeleteConfirmAction.java:103)
at com.redhat.rhn.frontend.action.rhnpackage.CustomPackagesDeleteConfirmAction.execute(CustomPackagesDeleteConfirmAction.java:80)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
Created attachment 333110 [details]
stacktrace showing 2 runs
bug 487412 was opened up to address comment #4 An advisory has been issued which should help the problem described in this bug report. This report is therefore being closed with a resolution of ERRATA. For more information on therefore solution and/or where to find the updated files, please follow the link below. You may reopen this bug report if the solution does not work for you. http://rhn.redhat.com/errata/RHEA-2009-1434.html |