Bug 1069131
Summary: | 'engine-backup --mode=restore' fails after engine-cleanup on postgres 8 | |||
---|---|---|---|---|
Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Eli Mesika <emesika> | |
Component: | ovirt-engine | Assignee: | Yedidyah Bar David <didi> | |
Status: | CLOSED CURRENTRELEASE | QA Contact: | sefi litmanovich <slitmano> | |
Severity: | unspecified | Docs Contact: | ||
Priority: | unspecified | |||
Version: | 3.4.0 | CC: | acathrow, didi, emesika, gklein, iheim, lpeer, pstehlik, Rhev-m-bugs, sbonazzo, scohen, s.kieske, treydock, yeylon | |
Target Milestone: | --- | Keywords: | ZStream | |
Target Release: | 3.4.0 | |||
Hardware: | Unspecified | |||
OS: | Unspecified | |||
Whiteboard: | integration | |||
Fixed In Version: | av4 | Doc Type: | Bug Fix | |
Doc Text: | Story Points: | --- | ||
Clone Of: | 1066654 | |||
: | 1077079 (view as bug list) | Environment: | ||
Last Closed: | 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: | 1066654 | |||
Bug Blocks: | 1077079, 1084186 |
Description
Eli Mesika
2014-02-24 09:52:29 UTC
Moving this to didi since The databases are created by user postgres that gives ownership to user engine by su - postgres -c "psql -d template1 -c \"create database engine owner engine;\"" template1 has already plpgsql installed with postgres ownership therefor user engine can not drop this language since the owner remains postgres. Since the cleanup SP is running with user engine, it can not handle this and it must be handled in the context of the engine-backup utility Only way I see to resolve that in engine-backup when mode = restore : 1)manipulate the backup sql to remove the "create language" statement 2)run createlang and ignore errors to create the language if not exists 3)restore the database Please keep in mind that this should be tested in PG 8.4 and 9.2.x Verified on RHEL 6.5 with rhevm-3.4.0-0.10.beta2.el6ev.noarch, with PG8.4 according to steps in description. after engine-backup and engine-cleanup, ran engine-backup mode=restore with old db credentials. restore was successful. Closing as part of 3.4.0 |