2017-09-28 21:38 GMT+02:00 Maton, Brett <matonb@ltresources.co.uk>:
oooo, it was the hosted engine itself.

  RAM     4096
  Max RAM 0

  I don't think I've touched the system settings on the hosted engine vm itself though.

This (testlab) cluster was originally installed with 4.0 (I think) and gets constantly upgraded with the pre-releases...

Thanks for running oVirt pre-releases in your testlab! Simone, Martin, can you please follow up on this?
 
 
After a bit of faffing around to clean up leftovers of the failed upgrade, I'm now running v4.2.0 and it's certianly different :)

Great to see you managed to upgrade to 4.2.0 alpha!
 

  I did have one firefox browser that refused to load the dashboard reporting 500 errors, but that appears to have been down to cached content (on OS X).

Greg. any clue? If I understood it correctly, you've been able to access the dashboard from some browser but failed on one firefox instance right?

 

  I look forward to playing with the new UI.



 

Thanks,
Brett

On 28 September 2017 at 19:29, Maton, Brett <matonb@ltresources.co.uk> wrote:
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@redhat.com> 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@ltresources.co.uk> 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/dbscripts/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-setup/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@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users





_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users




--

SANDRO BONAZZOLA

ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D

Red Hat EMEA