Re: [ovirt-users] oVirt 4.2 alpha upgrade failed

Thanks Tomas, I'm restoring backup at the moment, I'll let you know how it goes when on the next attempt. On 28 September 2017 at 18:46, Tomas Jelinek <tjelinek(a)redhat.com&gt; wrote: > Hey Brett, > > That is strange - it looks like you have some VM which has memory size > larger than the max memory size. > > You need to go over your VMs / templates to find which one has this wrong > config and change it. > Alternatively, to find it faster if you have many vms/templates, you > could run this SQL query against your engine database: > select vm_name from vm_static where mem_size_mb > max_memory_size_mb; > > Tomas > > On Thu, Sep 28, 2017 at 6:07 PM, Maton, Brett <matonb(a)ltresources.co.uk&gt; > wrote: > >> Upgrading from oVirt 4.1.7 >> >> hosted-engine VM: >> 4GB RAM >> >> hosted-engine setup failed, setup log shows this error: >> >> Running upgrade sql script '/usr/share/ovirt-engine/dbscr >> ipts/upgrade/04_02_0140_add_max_memory_constraint.sql'... >> >> 2017-09-28 16:56:22,951+0100 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema >> plugin.execute:926 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-20170928164338-0rkilb.log', >> '-c', 'apply'] stderr: >> psql:/usr/share/ovirt-engine/dbscripts/upgrade/04_02_0140_add_max_memory_constraint.sql:2: >> ERROR: check constraint "vm_static_max_memory_size_lower_bound" is >> violated by some row >> FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine >> /dbscripts/upgrade/04_02_0140_add_max_memory_constraint.sql >> >> 2017-09-28 16:56:22,951+0100 ERROR otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema >> schema._misc:374 schema.sh: FATAL: Cannot execute sql command: >> --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_02_0140_ >> add_max_memory_constraint.sql >> 2017-09-28 16:56:22,952+0100 DEBUG otopi.context >> context._executeMethod:143 method exception >> Traceback (most recent call last): >> File "/usr/lib/python2.7/site-packages/otopi/context.py", line 133, >> in _executeMethod >> method['method']() >> File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-s >> etup/ovirt-engine/db/schema.py", line 376, in _misc >> raise RuntimeError(_('Engine schema refresh failed')) >> RuntimeError: Engine schema refresh failed >> >> >> >> What's the minimum RAM required now ? >> >> Regards, >> Brett >> >> _______________________________________________ >> Users mailing list >> Users(a)ovirt.org >> http://lists.ovirt.org/mailman/listinfo/users >> >> >