<div dir="ltr"><div><div><div><div><div><div><div>oooo, it was the hosted engine itself.<br></div><div><br></div><div><span style="font-family:monospace,monospace">  RAM     4096</span></div><div><span style="font-family:monospace,monospace">  Max RAM 0</span></div><div><br></div>  I don&#39;t think I&#39;ve touched the system settings on the hosted engine vm itself though.<br><br></div>This (testlab) cluster was originally installed with 4.0 (I think) and gets constantly upgraded with the pre-releases...<br><br></div>After a bit of faffing around to clean up leftovers of the failed upgrade, I&#39;m now running v4.2.0 and it&#39;s certianly different :)<br><br></div>  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).<br><br></div>  I look forward to playing with the new UI.<br><br></div>Thanks,<br></div>Brett<br></div><div class="gmail_extra"><br><div class="gmail_quote">On 28 September 2017 at 19:29, 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"><div>Thanks Tomas,<br><br></div>  I&#39;m restoring backup at the moment, I&#39;ll let you know how it goes when on the next attempt.<br></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On 28 September 2017 at 18:46, Tomas Jelinek <span dir="ltr">&lt;<a href="mailto:tjelinek@redhat.com" target="_blank">tjelinek@redhat.com</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"><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"><div><div class="m_-1019416018458020545h5">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></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="m_-1019416018458020545h5"><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/dbscr<wbr>ipts/upgrade/04_02_0140_add_ma<wbr>x_memory_constraint.sql&#39;...<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: [&#39;/usr/share/ovirt-engine/dbsc<wbr>ripts/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/o<wbr>virt-engine-setup-201709281643<wbr>38-0rkilb.log&#39;, &#39;-c&#39;, &#39;apply&#39;] 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 &quot;vm_static_max_memory_size_low<wbr>er_bound&quot; 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 &quot;/usr/lib/python2.7/site-packa<wbr>ges/otopi/context.py&quot;, line 133, in _executeMethod<br>    method[&#39;method&#39;]()<br>  File &quot;/usr/share/ovirt-engine/setup<wbr>/bin/../plugins/ovirt-engine-s<wbr>etup/ovirt-engine/db/schema.py<wbr>&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></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>
</div></div></blockquote></div><br></div>