[ovirt-users] engine-setup fails with FATAL: Cannot execute sql command:

mad Engineer themadengin33r at gmail.com
Tue Mar 31 22:13:03 UTC 2015


Hello All,
                   Trying ovirt on centos 6.5 but fails at PostgreSQL
configuration
with error

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

Inside log it shows this

2015-03-31 17:47:15 DEBUG
otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
plugin.execute:866 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-20150331174256-pehvs7.log',
'-c', 'apply'] stderr:
psql:/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0210_change_group_ids.sql:59:
ERROR:  could not open relation with OID 32878
CONTEXT:  SQL statement "CREATE temp TABLE tmp_users_groups ON COMMIT
DROP AS SELECT fnsplitteruuid(group_ids) AS group_id, user_id FROM
users"
PL/pgSQL function "__temp_change_group_ids_03_05_0210" line 35 at SQL statement
FATAL: Cannot execute sql command:
--file=/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0210_change_group_ids.sql

2015-03-31 17:47:15 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/db/schema.py",
line 291, in _misc
    oenginecons.EngineDBEnv.PGPASS_FILE
  File "/usr/lib/python2.6/site-packages/otopi/plugin.py", line 871, in execute
    command=args[0],
RuntimeError: Command '/usr/share/ovirt-engine/dbscripts/schema.sh'
failed to execute
2015-03-31 17:47:15 ERROR otopi.context context._executeMethod:161
Failed to execute stage 'Misc configuration': Command
'/usr/share/ovirt-engine/dbscripts/schema.sh' failed to execute


Can some one please help me with this please



More information about the Users mailing list