Bug 1293748 - [RFE] Satellite 5.7: help customer make sure they have db backup before upgrade / help find backup by grepping history
Summary: [RFE] Satellite 5.7: help customer make sure they have db backup before upgra...
Keywords:
Status: CLOSED CANTFIX
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Upgrades
Version: 570
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ---
Assignee: Tomáš Kašpárek
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: 260381 sat570-triage
TreeView+ depends on / blocked
 
Reported: 2015-12-23 00:34 UTC by Xixi
Modified: 2017-02-20 10:05 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-02-20 10:05:48 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1293743 0 medium CLOSED [RFE] Satellite 5.7 installer check to make sure customer didn intend to upgrade to 5.6 instead, and upgrade RHEL OS as ... 2021-02-22 00:41:40 UTC
Red Hat Bugzilla 1293750 0 medium CLOSED [RFE] Satellite 5.7: help customer detect db space before upgrade and how to expand 2021-02-22 00:41:40 UTC

Internal Links: 1293743 1293750

Description Xixi 2015-12-23 00:34:48 UTC
Description of problem:
Oftentimes customer doesn't know they actually have a db backup: it's common to have multiple administrators for one Satellite server and one doesn't know the others have made backups of database, so the answer "we don't have a backup to restore to" in case of botched upgrades is actually not accurate.  A simple history grep helps clear this up.  Can this be built into the upgrade process to make sure customer has an available db backup in case need to restore?   

Version-Release number of selected component (if applicable):
Satellite 5.7

How reproducible:
always

Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 1 Tomas Lestach 2016-01-05 11:37:15 UTC
> Oftentimes customer doesn't know they actually have a db backup: it's common
> to have multiple administrators for one Satellite server and one doesn't
> know the others have made backups of database

DB backup is part of the upgrade instructions and shall be done as part of the RH Satellite upgrade. The upgrade process should be done by one admin and he simply cannot skip a step of the upgrade instructions. Upgrade is a sensitive process and all the documentation steps need to be followed.

Comment 2 Tomas Lestach 2016-01-05 11:43:28 UTC
The other problem of this RFE is, the backup of the DB is done via db-control in case of embedded DB. In case of external DB, it's up to the DBA to do the backup and no history search helps here.

Comment 3 Tomáš Kašpárek 2017-02-20 10:05:48 UTC
Hello,

there are so many variables which are unknown to Satellite - especially for Satellites with external database there's no way how we can determine that a backup was made.
E.g. backups may be created by a cron job, or via other way than just by running db-control or pg_dump_all, e.g. lvm snapshots so simple grepping history for a 'db-control backup' won't do the job because of sheer amount of unknown variables in customer infrastructure.

Therefore I am closing this bug as CANTFIX.


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