Re: [ovirt-devel] [ovirt-users] engine-setup fails with FATAL: Cannot execute sql command:
----- Original Message -----
From: "mad Engineer" <themadengin33r(a)gmail.com>
To: "users" <users(a)ovirt.org>
Cc: devel(a)ovirt.org
Sent: Wednesday, April 1, 2015 1:13:03 AM
Subject: [ovirt-users] engine-setup fails with FATAL: Cannot execute sql command:
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"
Any chance this was caused by a system issue? Not enough memory/disk space/
whatever? Please check other logs, 'free', 'df', 'df -i', etc.
Was this a clean install or an upgrade? How much disk space was allocated
(to '/', any other relevant file systems if different, such as /tmp, /var)?
How much ram?
If it's an upgrade, perhaps you have many users and/or many groups?
what's the output of (in psql):
select count(*) from users;
Adding Eli.
Best,
--
Didi