Re: [ovirt-users] engine-setup fails with FATAL: Cannot execute sql command:
- Original Message - > From: "Yedidyah Bar David" > To: "mad Engineer" > Cc: "users" , de...@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" > > To: "users" > > Cc: de...@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 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] engine-setup fails with FATAL: Cannot execute sql command:
- Original Message - > From: "mad Engineer" > To: "users" > Cc: de...@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 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[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" 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 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users