<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">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><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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/<wbr>dbscripts/upgrade/04_02_0140_<wbr>add_max_memory_constraint.sql'<wbr>...<br><br>2017-09-28 16:56:22,951+0100 DEBUG otopi.plugins.ovirt_engine_<wbr>setup.ovirt_engine.db.schema plugin.execute:926 execute-output: ['/usr/share/ovirt-engine/<wbr>dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', 'engine', '-d', 'engine', '-l', '/var/log/ovirt-engine/setup/<wbr>ovirt-engine-setup-<wbr>20170928164338-0rkilb.log', '-c', 'apply'] stderr:<br>psql:/usr/share/ovirt-engine/<wbr>dbscripts/upgrade/04_02_0140_<wbr>add_max_memory_constraint.sql:<wbr>2: ERROR: check constraint "vm_static_max_memory_size_<wbr>lower_bound" is violated by some row<br>FATAL: Cannot execute sql command: --file=/usr/share/ovirt-<wbr>engine/dbscripts/upgrade/04_<wbr>02_0140_add_max_memory_<wbr>constraint.sql<br><br>2017-09-28 16:56:22,951+0100 ERROR otopi.plugins.ovirt_engine_<wbr>setup.ovirt_engine.db.schema schema._misc:374 schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-<wbr>engine/dbscripts/upgrade/04_<wbr>02_0140_add_max_memory_<wbr>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-<wbr>packages/otopi/context.py", line 133, in _executeMethod<br> method['method']()<br> File "/usr/share/ovirt-engine/<wbr>setup/bin/../plugins/ovirt-<wbr>engine-setup/ovirt-engine/db/<wbr>schema.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>______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>