Bug 1064962 - [engine-setup] dwh/reports - engine-setup fails: Failed to execute stage 'Misc configuration': language "plpgsql" does not exist HINT...
Summary: [engine-setup] dwh/reports - engine-setup fails: Failed to execute stage 'Mis...
Keywords:
Status: CLOSED DUPLICATE of bug 1066459
Alias: None
Product: oVirt
Classification: Retired
Component: ovirt-engine-installer
Version: 3.4
Hardware: Unspecified
OS: Unspecified
unspecified
urgent
Target Milestone: ---
: 3.4.0
Assignee: Alon Bar-Lev
QA Contact: Barak Dagan
URL:
Whiteboard: integration
Depends On:
Blocks: 1037667 1054226
TreeView+ depends on / blocked
 
Reported: 2014-02-13 15:59 UTC by Jiri Belka
Modified: 2014-07-13 23:20 UTC (History)
10 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-02-19 09:31:11 UTC
oVirt Team: ---
Embargoed:


Attachments (Terms of Use)
setup log (2.86 MB, text/x-log)
2014-02-13 15:59 UTC, Jiri Belka
no flags Details
ovirt-engine-setup-20140218183245.log.gz (240.14 KB, application/x-gzip)
2014-02-18 17:39 UTC, Jiri Belka
no flags Details

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 ***


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