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

[Yedidyah Bar David]

----- Original Message -----
> From: "Yedidyah Bar David" <didi at redhat.com>
> To: "mad Engineer" <themadengin33r at gmail.com>
> Cc: "users" <users at ovirt.org>, devel at ovirt.org
> Sent: Wednesday, April 1, 2015 9:04:00 AM
> Subject: Re: [ovirt-users] engine-setup fails with FATAL: Cannot execute sql	command:
> 
> ----- Original Message -----
> > From: "mad Engineer" <themadengin33r at gmail.com>
> > To: "users" <users at ovirt.org>
> > Cc: devel at 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.

Now adding Eli :-)

Best,
-- 
Didi