Bug 1174757

Summary: after `./install.pl --upgrade --managed-db`, some PostgreSQL 8.4 packages are left behind
Product: Red Hat Satellite 5 Reporter: Jan Hutař <jhutar>
Component: UpgradesAssignee: Tomáš Kašpárek <tkasparek>
Status: CLOSED CURRENTRELEASE QA Contact: Jan Hutař <jhutar>
Severity: low Docs Contact:
Priority: unspecified    
Version: 570CC: adujicek, tlestach
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: spacewalk-setup-postgresql-2.3.0-18-sat Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-01-22 09:10:52 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: 1128174    

Description Jan Hutař 2014-12-16 12:33:16 UTC
Description of problem:
After managed PostgreSQL system upgrade with `./install.pl --upgrade --managed-db` is done, some PostgreSQL 8.4 packages are left behind (and according to yum can be removed).


Version-Release number of selected component (if applicable):
Satellite-5.7.0-RHEL6-re20141212.0-x86_64


How reproducible:
1 of 1 attempt


Steps to Reproduce:
1. # ./install.pl --upgrade --managed-db
2. # rpm -qa | grep postgresql
3. # yum remove postgresql-libs postgresql


Actual results:
# /mnt/tmp/install.pl --managed-db --upgrade
* Starting Red Hat Satellite installer.
* Performing pre-install checks.
* Pre-install checks complete.  Beginning installation.
* RHN Registration.
** Registration: System is already registered with RHN.  Not re-registering.
* Upgrading managed DB packages.
*** Upgrading embedded database.
* Managed DB instance was successfully upgraded.
# rpm -qa | grep postgresql
postgresql92-postgresql-server-9.2.8-2.el6.x86_64
postgresql-libs-8.4.20-1.el6_5.x86_64
postgresql92-runtime-1.1-21.el6.x86_64
postgresql92-postgresql-9.2.8-2.el6.x86_64
postgresql92-postgresql-pltcl-9.2.8-2.el6.x86_64
spacewalk-setup-postgresql-2.3.0-13.el6sat.noarch
postgresql92-postgresql-libs-9.2.8-2.el6.x86_64
postgresql-8.4.20-1.el6_5.x86_64
postgresql92-postgresql-contrib-9.2.8-2.el6.x86_64
# yum remove postgresql-libs postgresql
Loaded plugins: product-id, rhnplugin, security, subscription-manager
This system is receiving updates from RHN Classic or RHN Satellite.
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package postgresql.x86_64 0:8.4.20-1.el6_5 will be erased
---> Package postgresql-libs.x86_64 0:8.4.20-1.el6_5 will be erased
--> Processing Dependency: libpq.so.5()(64bit) for package: perl-DBD-Pg-2.15.1-4.el6_3.x86_64
--> Running transaction check
---> Package perl-DBD-Pg.x86_64 0:2.15.1-4.el6_3 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================================================================================================================================================================
 Package                                                     Arch                                               Version                                                     Repository                                                  Size
=============================================================================================================================================================================================================================================
Removing:
 postgresql                                                  x86_64                                             8.4.20-1.el6_5                                              @beaker-Server                                              14 M
 postgresql-libs                                             x86_64                                             8.4.20-1.el6_5                                              @beaker-Server                                             625 k
Removing for dependencies:
 perl-DBD-Pg                                                 x86_64                                             2.15.1-4.el6_3                                              @beaker-Server                                             544 k

Transaction Summary
=============================================================================================================================================================================================================================================
Remove        3 Package(s)

Installed size: 15 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
  Erasing    : postgresql-8.4.20-1.el6_5.x86_64                                                                                                                                                                                          1/3 
  Erasing    : perl-DBD-Pg-2.15.1-4.el6_3.x86_64                                                                                                                                                                                         2/3 
  Erasing    : postgresql-libs-8.4.20-1.el6_5.x86_64                                                                                                                                                                                     3/3 
  Verifying  : postgresql-libs-8.4.20-1.el6_5.x86_64                                                                                                                                                                                     1/3 
  Verifying  : perl-DBD-Pg-2.15.1-4.el6_3.x86_64                                                                                                                                                                                         2/3 
  Verifying  : postgresql-8.4.20-1.el6_5.x86_64                                                                                                                                                                                          3/3 

Removed:
  postgresql.x86_64 0:8.4.20-1.el6_5                                                                                 postgresql-libs.x86_64 0:8.4.20-1.el6_5                                                                                

Dependency Removed:
  perl-DBD-Pg.x86_64 0:2.15.1-4.el6_3                                                                                                                                                                                                        

Complete!


Expected results:
No PostgreSQL 8.4 packages left on the system.

Comment 13 Clifford Perry 2015-01-13 11:06:47 UTC
NOTE: With the release of Red Hat Satellite 5.7 on January 12th 2015 this bug /
feature is resolved. This bug was not verified (moved to RELEASE_PENDING)
prior to release. As such, over the next week or so we plan to confirm the
valiation that this was indeed fixed as part of the release and then move to
Closed Current Release. 

The Satellite 5.7 GA Errata:
 - https://rhn.redhat.com/errata/RHSA-2015-0033.html 

Satellite 5.7 Release Notes:
 -
https://access.redhat.com/documentation/en-US/Red_Hat_Satellite/5.7/html-single/Release_Notes/index.html

Satellite Customer Portal Blog announcement for release:
 - https://access.redhat.com/blogs/1169563/posts/1315743 

Cliff