Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1455033

Summary: engine-setup failed with due to vds_dynamic pretty names changes.
Product: Red Hat Enterprise Virtualization Manager Reporter: Michael Burman <mburman>
Component: ovirt-engineAssignee: Eli Mesika <emesika>
Status: CLOSED ERRATA QA Contact: Lucie Leistnerova <lleistne>
Severity: urgent Docs Contact:
Priority: urgent    
Version: 3.6.10CC: emesika, lsurette, mburman, mgoldboi, mperina, oourfali, pstehlik, rbalakri, Rhev-m-bugs, srevivo, ykaul
Target Milestone: ovirt-3.6.11-1Keywords: Regression, ZStream
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-05-30 13:50:06 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
engine logs
none
engine setup log none

Description Michael Burman 2017-05-24 06:18:00 UTC 
Created attachment 1281832 [details]
engine logs

Description of problem:
engine-setup failed with 'Misc configuration': Command '/usr/share/ovirt-engine/dbscripts/schema.sh' failed to execute. 

An upgrade from 3.6.10 to latest 3.6.11.2 has failed on engine-setup 

[ ERROR ] Failed to execute stage 'Misc configuration': Command '/usr/share/ovirt-engine/dbscripts/schema.sh' failed to execute

2017-05-24 05:13:13,229 ERROR [org.ovirt.engine.core.bll.InitBackendServicesOnStartupBean] (ServerService Thread Pool -- 66) [] Failed to initialize backend: org.jboss.weld.exceptions.WeldException: WELD-000049 Un
able to invoke [method] @PostConstruct private org.ovirt.engine.core.bll.pm.PmHealthCheckManager.initialize() on org.ovirt.engine.core.bll.pm.PmHealthCheckManager@5b8372e1
        at org.jboss.weld.bean.AbstractClassBean.defaultPostConstruct(AbstractClassBean.java:365) [weld-core.jar:1.1.34.Final-redhat-1]
        at org.jboss.weld.bean.ManagedBean$ManagedBeanInjectionTarget.postConstruct(ManagedBean.java:178) [weld-core.jar:1.1.34.Final-redhat-1]

aused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from  getallfromvds(?, ?)]; nested exception is org.postgresql.util.PSQLException: The column name pretty_name was not found in this ResultSet.

pretty_name column is missing, seems to caused by the fix for BZ 1446182

Version-Release number of selected component (if applicable):
rhevm-3.6.11.2-0.1.el6.noarch

How reproducible:
Seems to be 100% on upgrade flow, from 3.6.10.2 > 3.6.11.2

Steps to Reproduce:
1. Upgrade engine from 3.6.10.2 > 3.6.11.2

Actual results:
engine-setup has failed. 
pretty_name column is missing.

Expected results:
Should work

Additional info:
Possible related to BZ 1446182
Comment 1 Martin Perina 2017-05-24 08:07:04 UTC 
Could you please provide logs from upgrade?
Comment 2 Martin Perina 2017-05-24 08:07:37 UTC 
(In reply to Martin Perina from comment #1)
> Could you please provide logs from upgrade?

Please ignore, I'm blind :-(
Comment 3 Michael Burman 2017-05-24 08:12:12 UTC 
I attached only engine and server logs.
Attaching the engine setup log as well
Comment 4 Michael Burman 2017-05-24 08:12:49 UTC 
Created attachment 1281887 [details]
engine setup log
Comment 5 Yaniv Kaul 2017-05-24 08:32:58 UTC 
The issue is:
2017-05-24 04:47:45 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:941 execute-output: ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', 'engine', '-d', 'engine', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20170524044508-p9gw09.log', '-c', 'apply'] stderr:
psql:/usr/share/ovirt-engine/dbscripts/create_views.sql:1524: ERROR:  column vds_dynamic.pretty_name does not exist
LINE 40:     vds_dynamic.pretty_name AS pretty_name,
             ^
FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/create_views.sql

2017-05-24 04:47:45 DEBUG otopi.context context._executeMethod:156 method exception
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/otopi/context.py", line 146, in _executeMethod
    method['method']()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py", line 291, in _misc
    oenginecons.EngineDBEnv.PGPASS_FILE
  File "/usr/lib/python2.6/site-packages/otopi/plugin.py", line 946, in execute
    command=args[0],
RuntimeError: Command '/usr/share/ovirt-engine/dbscripts/schema.sh' failed to execute
2017-05-24 04:47:45 ERROR otopi.context context._executeMethod:165 Failed to execute stage 'Misc configuration': Command '/usr/share/ovirt-engine/dbscripts/schema.sh' failed to execute
2017-05-24 04:47:45 DEBUG otopi.transaction transaction.abort:134 aborting 'Yum Transaction'
Comment 8 Lucie Leistnerova 2017-05-29 14:13:36 UTC 
Upgrade from rhevm-3.6.11.1-0.1.el6.noarch (is live latest and has no pretty_name column) to rhevm-3.6.11.3-0.1.el6.noarch was successful and pretty_name column was added.

verified in rhevm-3.6.11.3-0.1.el6.noarch
Comment 10 errata-xmlrpc 2017-05-30 13:50:06 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2017:1371