Bug 1034936 - Changedbowner.sh is useless in case that only several tables have wrong permission
Summary: Changedbowner.sh is useless in case that only several tables have wrong permi...
Keywords:
Status: CLOSED DUPLICATE of bug 1034929
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-config
Version: 3.3.0
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ---
: ---
Assignee: Eli Mesika
QA Contact: Pavel Stehlik
URL:
Whiteboard: infra
Depends On:
Blocks: GSS_RHEV_33_BETA
TreeView+ depends on / blocked
 
Reported: 2013-11-26 17:54 UTC by Tomas Dosek
Modified: 2016-02-10 19:10 UTC (History)
9 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-11-27 10:04:24 UTC
oVirt Team: Infra
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Tomas Dosek 2013-11-26 17:54:16 UTC
Description of problem:
Please take a look at: 1034929

The mentioned script Alters only DB owner which in case we check all entities
in otopi setup has a hole.

The hole are for instance temporary tables created and owned by postgres as they do not get affected by alter db owner.

This causes the script to be useless in few scenarios of broken upgrade due to DB schema issues.

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

How reproducible:
100 %

Steps to Reproduce:
1. Have a table unde engine DB owned by postgres
2. Try to upgrade (upgrade fails)
3. Try changedbowner.sh
4. Try to upgrade again (it indeed does not work)

Actual results:
Doesn't work - entites are not affected

Expected results:
Should change all entities owneship as well, not only DB schema ownership

Additional info:
More detailed info in BZ: 1034929

Comment 3 Eli Mesika 2013-11-27 10:04:24 UTC
Reason for Close :

Please see https://bugzilla.redhat.com/show_bug.cgi?id=1034929 Comment #3

*** This bug has been marked as a duplicate of bug 1034929 ***


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