Bug 1099132

Summary: [RHEVM-SETUP] - Upgarde DWH fails from 3.3.3 to 3.4.0 due to readonly permissions
Product: Red Hat Enterprise Virtualization Manager Reporter: Barak Dagan <bdagan>
Component: ovirt-engine-dwhAssignee: Yedidyah Bar David <didi>
Status: CLOSED DUPLICATE QA Contact: Barak Dagan <bdagan>
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 3.4.0CC: aberezin, acathrow, bazulay, dfediuck, gklein, iheim, pstehlik, Rhev-m-bugs, sbonazzo, sherold, talayan, yeylon, ylavi
Target Milestone: ---   
Target Release: 3.4.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: integration
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-05-20 14:03:47 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: 1078129    
Bug Blocks:    
Attachments:
Description Flags
setup log none

Description Barak Dagan 2014-05-19 14:17:34 UTC
Created attachment 897177 [details]
setup log

Description of problem:
during upgarde from 3.3.3 (is46.3) to 3.4.0 (av9.1) afils due to :

...skipping...
ERROR:  relation "rhev_reports_input_control_cluster" does not exist
FATAL: Cannot execute sql command: --command=GRANT USAGE ON SCHEMA public TO readonly;
...

GRANT SELECT ON TABLE v3_0_host_interface_daily_history_view TO readonly;
...skipping...
2014-05-19 14:27:46 ERROR otopi.context context._executeMethod:161 Failed to execute stage 'Misc configuration': Command '/usr/share/ovirt-engine-dwh/dbscripts/schema.sh' failed to execute
2014-05-19 14:27:46 DEBUG otopi.transaction transaction.abort:131 aborting 'Yum Transaction'
2014-05-19 14:27:46 INFO otopi.plugins.otopi.packagers.yumpackager yumpackager.info:92 Yum Performing yum transaction rollback
Version-Release number of selected component (if applicable):


How reproducible:
is26.3 -> av9.1

Steps to Reproduce:
1. install engine, dwh & reports 3.3.3 (local db)
2. upgarde to 3.4.0:
  yum update rhevm-setup 
  yum install rhevm-dwh-setup, rhevm-reports-setup
  rhevm-setup 
3.

Actual results:
upgrade fails duering dwh phase

Expected results:


Additional info:

Comment 3 Yaniv Lavi 2014-05-20 14:03:47 UTC

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