Bug 1064962

Summary: [engine-setup] dwh/reports - engine-setup fails: Failed to execute stage 'Misc configuration': language "plpgsql" does not exist HINT...
Product: [Retired] oVirt Reporter: Jiri Belka <jbelka>
Component: ovirt-engine-installerAssignee: Alon Bar-Lev <alonbl>
Status: CLOSED DUPLICATE QA Contact: Barak Dagan <bdagan>
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 3.4CC: acathrow, bdagan, didi, gklein, iheim, jbelka, pbenas, pstehlik, 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-02-19 09:31:11 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: 1037667, 1054226    
Attachments:
Description Flags
setup log
none
ovirt-engine-setup-20140218183245.log.gz none

Description Jiri Belka 2014-02-13 15:59:12 UTC 
Created attachment 862865 [details]
setup log

Description of problem:

dwh/reports are installed, engine-setup fails.

...
[ INFO  ] Creating CA
[ INFO  ] Creating DWH database schema
[ ERROR ] Failed to execute stage 'Misc configuration': language "plpgsql" does not exist HINT:  Use CREATE LANGUAGE to load the language into the database. 
[ INFO  ] Yum Performing yum transaction rollback
[ INFO  ] Rolling back database schema
[ INFO  ] Clearing Engine database engine
[ INFO  ] Rolling back DWH database schema
[ INFO  ] Clearing DWH database ovirt_engine_history
[ INFO  ] Rolling back Reports database schema
[ INFO  ] Clearing Reports database ovirt_engine_reports
[ ERROR ] Reports database rollback failed: language "plpgsql" does not exist HINT:  Use CREATE LANGUAGE to load the language into the database. 
[ INFO  ] Rolling back Reports files
[ INFO  ] Stage: Clean up
          Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140213154653.log
[ INFO  ] Stage: Pre-termination
[ INFO  ] Stage: Termination
[ ERROR ] Execution of setup failed


...
2014-02-13 15:50:11 DEBUG otopi.transaction transaction._prepare:82 exception during prepare phase
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/otopi/transaction.py", line 78, in _prepare
    element.prepare()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine-reports/jasper/deploy.py", line 142, in prepare
    self._dbovirtutils.clearDatabase()
  File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/database.py", line 490, in clearDatabase
    transaction=False,
  File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/database.py", line 164, in execute
    args,
ProgrammingError: language "plpgsql" does not exist
HINT:  Use CREATE LANGUAGE to load the language into the database.

2014-02-13 15:50:11 DEBUG otopi.context context._executeMethod:152 method exception
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/otopi/context.py", line 142, in _executeMethod
    method['method']()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine-reports/jasper/deploy.py", line 616, in _deploy
    parent=self,
  File "/usr/lib/python2.6/site-packages/otopi/transaction.py", line 118, in append
    self._prepare(element=element)
  File "/usr/lib/python2.6/site-packages/otopi/transaction.py", line 78, in _prepare
    element.prepare()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine-reports/jasper/deploy.py", line 142, in prepare
    self._dbovirtutils.clearDatabase()
  File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/database.py", line 490, in clearDatabase
    transaction=False,
  File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/database.py", line 164, in execute
    args,
ProgrammingError: language "plpgsql" does not exist
HINT:  Use CREATE LANGUAGE to load the language into the database.
2014-02-13 15:50:11 ERROR otopi.context context._executeMethod:161 Failed to execute stage 'Misc configuration': language "plpgsql" does not exist
HINT:  Use CREATE LANGUAGE to load the language into the database.

2014-02-13 15:50:11 DEBUG otopi.transaction transaction.abort:131 aborting 'Yum Transaction'
...

Version-Release number of selected component (if applicable):
ovirt-engine-setup-plugin-ovirt-engine-3.4.0-0.7.beta2.el6.noarch
ovirt-engine-setup-plugin-ovirt-engine-common-3.4.0-0.7.beta2.el6.noarch
ovirt-engine-setup-plugin-websocket-proxy-3.4.0-0.7.beta2.el6.noarch

How reproducible:
100%

Steps to Reproduce:
1. install ovirt-engine, ovirt-engine-{dwh,reports}
2. engine-setup
3.

Actual results:
fail

Expected results:
pass

Additional info:
Comment 1 Itamar Heim 2014-02-16 08:23:34 UTC 
Setting target release to current version for consideration and review. please
do not push non-RFE bugs to an undefined target release to make sure bugs are
reviewed for relevancy, fix, closure, etc.
Comment 2 Yaniv Lavi 2014-02-16 11:35:42 UTC 
What is the request here?



Yaniv
Comment 3 Yedidyah Bar David 2014-02-17 14:26:30 UTC 
Please try to reproduce with http://gerrit.ovirt.org/24566 . It will not solve, just give more info in the log.
Comment 4 Jiri Belka 2014-02-18 17:39:35 UTC 
Created attachment 864655 [details]
ovirt-engine-setup-20140218183245.log.gz

i applied diff and here's new log
Comment 5 Barak Dagan 2014-02-19 09:31:11 UTC 

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