Bug 1047117

Summary: [reports] upgrade backs up the database only after changing ownership of objects
Product: Red Hat Enterprise Virtualization Manager Reporter: Yedidyah Bar David <didi>
Component: ovirt-engine-reportsAssignee: Yedidyah Bar David <didi>
Status: CLOSED ERRATA QA Contact: Tareq Alayan <talayan>
Severity: high Docs Contact:
Priority: high    
Version: 3.3.0CC: acathrow, adahms, iheim, oschreib, pstehlik, Rhev-m-bugs, scohen, talayan, yeylon, ylavi
Target Milestone: ---Keywords: Triaged
Target Release: 3.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: integration
Fixed In Version: IS31 - rhevm-reports-3.3.0-28.el6ev.noarch.rpm Doc Type: Bug Fix
Doc Text:
Previously, upgrading from 3.2 to 3.3 with a local database only backed up the database after changing ownership of all objects. If a failure occurred before the ownership was updated, no backup would be created, or the restoration would be performed from a different backup. Now, the backup is performed before any changes are made to the database.
 Story Points: ---
Clone Of: 1046679 Environment:
Last Closed: 2014-01-21 14:57:16 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: 1056111    
Attachments:
Description Flags
logs none

Description Yedidyah Bar David 2013-12-29 08:18:45 UTC 
+++ This bug was initially created as a clone of Bug #1046679 +++

Description of problem:

Upgrade from 3.2 does:
1. create a database user 'engine_reports'
2. Update ownership of all objects to this user
3. backup
4. update the schema to 3.3

This means that if we fail during 1 or 2, we have no backup, and if we fail during 4 we restore from a backup that is different from what we started with.

We should backup as soon as possible, then start doing other things.
Comment 2 Tareq Alayan 2014-01-17 09:51:50 UTC 
verified on rhevm-reports-3.3.0-28.el6ev.noarch rhevm-dwh-3.3.0-28.el6ev.noarch
the backup is done before the upgrade see log attached
Comment 3 Tareq Alayan 2014-01-17 09:52:28 UTC 
Created attachment 851495 [details]
logs
Comment 5 errata-xmlrpc 2014-01-21 14:57:16 UTC 
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.

http://rhn.redhat.com/errata/RHBA-2014-0035.html