Bug 1254639

can you detail the procedure you used?
Is the following correct?
 - yum install rhevm
 - engine-setup
 - engine-setup

2015-08-18 10:23:15 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.upgrade.dbvalidations plugin.execute:940 execute-output: ['/usr/share/ovirt-engine/setup/dbutils/validatedb.sh', '--user=engine', '--host=localhost', '--port=5432', '--database=engine', '--log=/etc/ovirt-engine/aaa/xxx'] stderr:
ERROR:  relation "group_attributes" does not exist
LINE 1: select  (group_id)  from group_attributes where  (group_id) ...
                                 ^
QUERY:  select  (group_id)  from group_attributes where  (group_id) IS NOT NULL and  (group_id)  not in (select group_id from groups);
CONTEXT:  PL/pgSQL function "fn_db_validate_fks" line 40 at EXECUTE statement

2015-08-18 10:23:15 DEBUG otopi.context context._executeMethod:155 method exception
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/otopi/context.py", line 145, in _executeMethod
    method['method']()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/upgrade/dbvalidations.py", line 128, in _validation
    violations, issues_found = self._checkDb()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/upgrade/dbvalidations.py", line 91, in _checkDb
    output=stdout,
RuntimeError: Failed checking Engine database:
[u'']

2015-08-18 10:23:15 ERROR otopi.context context._executeMethod:164 Failed to execute stage 'Setup validation': Failed checking Engine database:
[u'']

Eli, can you check?

You can call engine-setup without options or You can provide answers-file at second invocation.
 It fails with the same message:




    # engine-setup --config-append=/var/lib/ovirt-engine/setup/answers/20150818103946-setup.conf
    [ INFO  ] Stage: Initializing
    [ INFO  ] Stage: Environment setup
              Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-wsp.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf', '/var/lib/ovirt-engine/setup/answers/20150818103946-setup.conf']
              Log file: /var/log/ovirt-engine/setup/ovirt-engine-setup-20150819053357-s87bpr.log
              Version: otopi-1.4.0_master (otopi-1.4.0-0.0.1.master.el6ev)
    [ INFO  ] Stage: Environment packages setup
    [ INFO  ] Stage: Programs detection
    [ INFO  ] Stage: Environment setup
    [ INFO  ] Stage: Environment customization
             
              Welcome to the RHEV 3.6 setup/upgrade.
              Please read the RHEV 3.6 install guide
              https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.6/html/Installation_Guide/index.html.
              Please refer to the RHEV Upgrade Helper application
              https://access.redhat.com/labs/rhevupgradehelper/ which will guide you in the upgrading process.
              Would you like to proceed? (Yes, No) [Yes]: 
             
              --== PRODUCT OPTIONS ==--
             
    [WARNING] User ovirt-vmconsole does not exist.
    [WARNING] VM Console Proxy seems not installed on this host. Disabled configuration.
             
              --== PACKAGES ==--
             
    [ INFO  ] Checking for product updates...
    [ INFO  ] No product updates found
             
              --== ALL IN ONE CONFIGURATION ==--
             
             
              --== NETWORK CONFIGURATION ==--
             
    [ INFO  ] iptables will be configured as firewall manager.
             
              --== DATABASE CONFIGURATION ==--
             
             
              --== OVIRT ENGINE CONFIGURATION ==--
             
             
              --== STORAGE CONFIGURATION ==--
             
             
              --== PKI CONFIGURATION ==--
             
             
              --== APACHE CONFIGURATION ==--
             
             
              --== SYSTEM CONFIGURATION ==--
             
             
              --== MISC CONFIGURATION ==--
             
             
              --== END OF CONFIGURATION ==--
             
    [ INFO  ] Stage: Setup validation
              During execution engine service will be stopped (OK, Cancel) [OK]: 
    [WARNING] Less than 16384MB of memory is available
    [ INFO  ] Cleaning stale zombie tasks and commands
             
              --== CONFIGURATION PREVIEW ==--
             
              Application mode                        : virt
              Default SAN wipe after delete           : False
              Firewall manager                        : iptables
              Update Firewall                         : True
              Host FQDN                               : oe1.spice.brq.redhat.com
              Engine database secured connection      : False
              Engine database host                    : localhost
              Engine database user name               : engine
              Engine database name                    : engine
              Engine database port                    : 5432
              Engine database host name validation    : False
              Engine installation                     : True
              PKI organization                        : spice.brq.redhat.com
              Configure local Engine database         : True
              Set application as default page         : True
              Configure Apache SSL                    : True
              Configure WebSocket Proxy               : True
              Engine Host FQDN                        : oe1.spice.brq.redhat.com
    [ INFO  ] Cleaning async tasks and compensations
    [ INFO  ] Unlocking existing entities
    [ INFO  ] Checking the Engine database consistency
    [ ERROR ] Failed to execute stage 'Setup validation': Failed checking Engine database: [u''] 
    [ INFO  ] Stage: Clean up
              Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20150819053357-s87bpr.log
    [ INFO  ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20150819053427-setup.conf'
    [ INFO  ] Stage: Pre-termination
    [ INFO  ] Stage: Termination
    [ ERROR ] Execution of setup failed

*** Bug 1254218 has been marked as a duplicate of this bug. ***

The problem is that tables which are created by aaa-jdbc, has different schema,
you have to change fkvalidator_sp.sql to use schema.table_name , when running
commands.

(In reply to Ondra Machacek from comment #7)
> The problem is that tables which are created by aaa-jdbc, has different
> schema,
> you have to change fkvalidator_sp.sql to use schema.table_name , when running
> commands.

Ondra, can you push the change to fkvalidator_sp.sql?

btw, if you workaround this issue, you will hit another one [1]

[1] https://bugzilla.redhat.com/show_bug.cgi?id=1255393

Thanks Ondra, will wait for bug #1255393 for verifying the patch you sent.

Should this be MODIFIED?

*** Bug 1256214 has been marked as a duplicate of this bug. ***

Verified in rhevm-setup-3.6.0-0.13.master.el6.noarch (3.6.0-11)

Hi Sandro,
Is this patch merged also to PPC?

Can you please verify this on PPC setup as well?

Unfortunately I don't have PPC host yet. I have to wait until any ppc host is available for borrow.

(In reply to Nikolai Sednev from comment #14)
> Hi Sandro,
> Is this patch merged also to PPC?

There's no rhevm planned for PPC as far as I know.