Bug 1184225 - satellite-upgrade-estimates says "Upgrade of Red Hat Satellite database should take at least: 00:00" on a big DB
Summary: satellite-upgrade-estimates says "Upgrade of Red Hat Satellite database shoul...
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Upgrades
Version: 570
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Tomáš Kašpárek
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: sat570-triage
TreeView+ depends on / blocked
 
Reported: 2015-01-20 19:39 UTC by Jan Hutař
Modified: 2017-03-03 12:19 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-03-03 12:19:49 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Jan Hutař 2015-01-20 19:39:46 UTC
Description of problem:
Script satellite-upgrade-estimates says "Upgrade of Red Hat Satellite database should take at least: 00:00" on a very big DB (/var/lib/pgsql/data is 38GB)


Version-Release number of selected component (if applicable):
rhn-upgrade-5.7.0.22-1.el6sat.noarch


How reproducible:
1 of 1


Steps to Reproduce:
1. Have Satellite 5.6.0@RHEL6@EmbeddedPostgreSQL and attempt to upgrade to
   5.7.0@RHEL6@EmbeddedPostgreSQL (no OS upgrade)
2. # /etc/sysconfig/rhn/satellite-upgrade/scripts/satellite-upgrade-estimates


Actual results:
# /etc/sysconfig/rhn/satellite-upgrade/scripts/satellite-upgrade-estimates
Will you be installing Red Hat Satellite 5.7 on a different system and migrating to it? [N] N

Computing ...

satellite-upgrade-postgresql.txt, point 1:
* Command line part of Red Hat Satellite upgrade should take approximately: 00:45 (HH:MM)

satellite-upgrade-postgresql.txt, point 2:
* Upgrade of Red Hat Satellite database should take at least: 00:00 (HH:MM)

* Minimum free disk space required for schema upgrade is 1000 MB


Expected results:
I would expect some bigger number in "Upgrade of Red Hat Satellite database should take at least" and maybe in "Minimum free disk space required for schema upgrade" as well.


Additional info:
# du -hs /var/lib/pgsql/data/
38G	/var/lib/pgsql/data/
# db-control tablesizes | grep -v -e ' bytes' -e ' kB'
Tables                           Planner Size    Real Size  Real Size+Toasts+Idx
qrtz_fired_triggers                     10 MB        11 MB               79 MB
qrtz_triggers                           26 MB        26 MB               58 MB
rhnaction                              278 MB       278 MB              375 MB
rhnactionerrataupdate                   76 MB        76 MB              125 MB
rhnchannelnewestpackage                 52 MB        52 MB              127 MB
rhnchannelpackage                       32 MB        32 MB               64 MB
rhnchecksum                           1773 MB      1773 MB             3491 MB
rhnerrata                               62 MB        62 MB               82 MB
rhnerratabuglist                        23 MB        23 MB               27 MB
rhnerratafile                          198 MB       198 MB              436 MB
rhnerratafilechannel                   113 MB       113 MB              231 MB
rhnerratafilepackage                    16 MB        16 MB               31 MB
rhnerratanotificationqueue              37 MB        37 MB               74 MB
rhnerratapackage                        18 MB        18 MB               29 MB
rhnpackage                              87 MB        87 MB               99 MB
rhnpackagecapability                  5926 MB      5926 MB            10101 MB
rhnpackagechangelogdata                 92 MB        92 MB              135 MB
rhnpackagechangelogrec                1196 MB      1196 MB             2434 MB
rhnpackageevr                           11 MB        11 MB               18 MB
rhnpackagefile                        7577 MB      7577 MB               10 GB
rhnpackagenevra                         21 MB        21 MB               37 MB
rhnpackageprovides                     514 MB       514 MB             1068 MB
rhnpackagerepodata                     182 MB       182 MB             2134 MB
rhnpackagerequires                     203 MB       203 MB              356 MB
rhnprivatechannelfamily                 13 MB        13 MB               18 MB
rhnserver_log                           24 MB        24 MB               26 MB
rhnserveraction                        138 MB       138 MB              207 MB
rhnserverneededcache                  1047 MB      1047 MB             4392 MB
rhnserverpackage                       112 MB       114 MB              211 MB
rhnsnapshot                             17 MB        17 MB               18 MB
rhnsnapshotpackage                     181 MB       184 MB              353 MB
rhntaskorun                             41 MB        41 MB               46 MB
rhnvisibleobjects                      106 MB       106 MB              193 MB
test                                    59 MB        60 MB               60 MB

Comment 2 Tomáš Kašpárek 2017-03-03 12:19:49 UTC
From upgrade instructions:

4. Get the upgrade estimates.

This step applies if you're migrating from Oracle to PostgreSQL database.

Please run the following script from rhn-upgrade package as root:

    /etc/sysconfig/rhn/satellite-upgrade/scripts/satellite-upgrade-estimates


th DB is obviously PostgreSQL -> notabug


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