Bug 1500612
| Summary: | [5.7] DEADLOCK: reactivation-key, snapshot_server(), register/delete POSTGRESQL fix was not shipped complete | |||
|---|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | Tomáš Kašpárek <tkasparek> | |
| Component: | Server | Assignee: | Tomáš Kašpárek <tkasparek> | |
| Status: | CLOSED ERRATA | QA Contact: | Jan Hutař <jhutar> | |
| Severity: | unspecified | Docs Contact: | ||
| Priority: | unspecified | |||
| Version: | 570 | CC: | jhutar, mkorbel, tlestach | |
| Target Milestone: | --- | |||
| Target Release: | --- | |||
| Hardware: | Unspecified | |||
| OS: | Unspecified | |||
| Whiteboard: | ||||
| Fixed In Version: | satellite-schema-5.7.0.34-1-sat | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 1511563 (view as bug list) | Environment: | ||
| Last Closed: | 2017-10-31 12:25:12 UTC | Type: | Bug | |
| 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: | 1490375, 1509351, 1511563 | |||
VERIFIED on satellite-schema-5.7.0.34-1
spacewalk-sql -i <<< '\df+ rhn_server.snapshot_server' | grep lock_counts
: perform lock_counts(server_id_in);
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2017:3085 |
Description of problem: ll schema/satellite/upgrade/satellite-schema-5.7.0.27-to-satellite-schema-5.7.0.32/*postgres -rw-rw-r--. 1 tkasparek tkasparek 24904 Oct 11 08:45 ../satellite-schema-5.7.0.27-to-satellite-schema-5.7.0.32/001-rhn_server-snapshot_server_deadlock.sql.postgres 001-rhn_server-snapshot_server_deadlock.sql.postgres file is not added to the upgrade script as it does not macth *postgresql (missing l at the end) which causes following schema diff: --- procedure_rhn_server_snapshot_server_server_id_in_numeric_reason_in_character_varying_returns_void.1 2017-10-11 08:23:12.682066002 +0200 +++ procedure_rhn_server_snapshot_server_server_id_in_numeric_reason_in_character_varying_returns_void.2 2017-10-11 08:23:12.682066002 +0200 @@ -22,6 +22,7 @@ and cf.id = lookup_first_matching_cf(scc.server_id, cfn.path); locked integer; begin - perform lock_counts(server_id_in); select nextval('rhn_snapshot_id_seq') into snapshot_id_v; insert into rhnSnapshot (id, org_id, server_id, reason) ( Version-Release number of selected component (if applicable): satellite-schema-5.7.0.32-1.el6sat.noarch How reproducible: always Steps to Reproduce: 1. upgrade 5.7 to satellite-schema-5.7.0.32 2. spacewalk-sql -i <<< '\df+ rhn_server.snapshot_server' Actual results: lock_counts call is missing in rhn_server.snapshot_server Expected results: it's there Additional info: oracle works fine