<div dir="ltr"><div>Thanks Tomas,<br><br></div> I'm restoring backup at the moment, I'll let you know how it goes when on the next attempt.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On 28 September 2017 at 18:46, Tomas Jelinek <span dir="ltr"><<a href="mailto:tjelinek@redhat.com" target="_blank">tjelinek@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div>Hey Brett,<br></div><div><br></div><div>That is strange - it looks like you have some VM which has memory size larger than the max memory size.<br><br></div>You need to go over your VMs / templates to find which one has this wrong config and change it.<br></div>Alternatively, to find it faster if you have many vms/templates, you could run this SQL query against your engine database:<br>select vm_name from vm_static where mem_size_mb > max_memory_size_mb;<br><br></div>Tomas<br></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Thu, Sep 28, 2017 at 6:07 PM, Maton, Brett <span dir="ltr"><<a href="mailto:matonb@ltresources.co.uk" target="_blank">matonb@ltresources.co.uk</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr">Upgrading from oVirt 4.1.7<br><div><br></div><div>hosted-engine VM:</div><div>4GB RAM</div><div><br></div><div>hosted-engine setup failed, setup log shows this error:<br></div><div><br><span style="font-family:monospace,monospace">Running upgrade sql script '/usr/share/ovirt-engine/dbscr<wbr>ipts/upgrade/04_02_0140_add_<wbr>max_memory_constraint.sql'...<br><br>2017-09-28 16:56:22,951+0100 DEBUG otopi.plugins.ovirt_engine_set<wbr>up.ovirt_engine.db.schema plugin.execute:926 execute-output: ['/usr/share/ovirt-engine/dbsc<wbr>ripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', 'engine', '-d', 'engine', '-l', '/var/log/ovirt-engine/setup/o<wbr>virt-engine-setup-201709281643<wbr>38-0rkilb.log', '-c', 'apply'] stderr:<br>psql:/usr/share/ovirt-engine/d<wbr>bscripts/upgrade/04_02_0140_ad<wbr>d_max_memory_constraint.sql:2: ERROR: check constraint "vm_static_max_memory_size_low<wbr>er_bound" is violated by some row<br>FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine<wbr>/dbscripts/upgrade/04_02_0140_<wbr>add_max_memory_constraint.sql<br><br>2017-09-28 16:56:22,951+0100 ERROR otopi.plugins.ovirt_engine_set<wbr>up.ovirt_engine.db.schema schema._misc:374 schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine<wbr>/dbscripts/upgrade/04_02_0140_<wbr>add_max_memory_constraint.sql<br>2017-09-28 16:56:22,952+0100 DEBUG otopi.context context._executeMethod:143 method exception<br>Traceback (most recent call last):<br> File "/usr/lib/python2.7/site-packa<wbr>ges/otopi/context.py", line 133, in _executeMethod<br> method['method']()<br> File "/usr/share/ovirt-engine/setup<wbr>/bin/../plugins/ovirt-engine-<wbr>setup/ovirt-engine/db/schema.<wbr>py", line 376, in _misc<br> raise RuntimeError(_('Engine schema refresh failed'))<br>RuntimeError: Engine schema refresh failed</span></div><div><br></div><div><br></div><div><br><span style="font-family:monospace,monospace"></span></div><div><span style="font-family:monospace,monospace"></span>What's the minimum RAM required now ?</div><div><br></div><div>Regards,</div><div>Brett<br></div></div>
<br></div></div>______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
<br></blockquote></div><br></div>
</blockquote></div><br></div>