<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 &gt; 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">&lt;<a href="mailto:matonb@ltresources.co.uk" target="_blank">matonb@ltresources.co.uk</a>&gt;</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 &#39;/usr/share/ovirt-engine/<wbr>dbscripts/upgrade/04_02_0140_<wbr>add_max_memory_constraint.sql&#39;<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: [&#39;/usr/share/ovirt-engine/<wbr>dbscripts/schema.sh&#39;, &#39;-s&#39;, &#39;localhost&#39;, &#39;-p&#39;, &#39;5432&#39;, &#39;-u&#39;, &#39;engine&#39;, &#39;-d&#39;, &#39;engine&#39;, &#39;-l&#39;, &#39;/var/log/ovirt-engine/setup/<wbr>ovirt-engine-setup-<wbr>20170928164338-0rkilb.log&#39;, &#39;-c&#39;, &#39;apply&#39;] stderr:<br>psql:/usr/share/ovirt-engine/<wbr>dbscripts/upgrade/04_02_0140_<wbr>add_max_memory_constraint.sql:<wbr>2: ERROR:  check constraint &quot;vm_static_max_memory_size_<wbr>lower_bound&quot; 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 &quot;/usr/lib/python2.7/site-<wbr>packages/otopi/context.py&quot;, line 133, in _executeMethod<br>    method[&#39;method&#39;]()<br>  File &quot;/usr/share/ovirt-engine/<wbr>setup/bin/../plugins/ovirt-<wbr>engine-setup/ovirt-engine/db/<wbr>schema.py&quot;, line 376, in _misc<br>    raise RuntimeError(_(&#39;Engine schema refresh failed&#39;))<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&#39;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>