[ovirt-users] engine-setup fails with FATAL: Cannot execute sql command:
mad Engineer
themadengin33r at gmail.com
Tue Mar 31 18:13:03 EDT 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