<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">2017-09-28 20:29 GMT+02:00 Maton, Brett <span dir="ltr">&lt;<a href="mailto:matonb@ltresources.co.uk" target="_blank">matonb@ltresources.co.uk</a>&gt;</span>:<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></blockquote><div><br></div><div>Didn&#39;t the setup rollback automatically? Can you please share the setup logs?</div><div><br></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"></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_7729489939784216401h5">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_7729489939784216401h5"><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><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><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><p style="color:rgb(0,0,0);font-family:overpass,sans-serif;font-weight:bold;margin:0px;padding:0px;font-size:14px;text-transform:uppercase"><span>SANDRO</span> <span>BONAZZOLA</span></p><p style="color:rgb(0,0,0);font-family:overpass,sans-serif;font-size:10px;margin:0px 0px 4px;text-transform:uppercase"><span>ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&amp;D</span></p><p style="font-family:overpass,sans-serif;margin:0px;font-size:10px;color:rgb(153,153,153)"><a href="https://www.redhat.com/" style="color:rgb(0,136,206);margin:0px" target="_blank">Red Hat <span>EMEA</span></a></p><table border="0" style="color:rgb(0,0,0);font-family:overpass,sans-serif;font-size:medium"><tbody><tr><td width="100px"><a href="https://red.ht/sig" target="_blank"><img src="https://www.redhat.com/profiles/rh/themes/redhatdotcom/img/logo-red-hat-black.png" width="90" height="auto"></a></td><td style="font-size:10px"><div><a href="https://redhat.com/trusted" style="color:rgb(204,0,0);font-weight:bold" target="_blank">TRIED. TESTED. TRUSTED.</a></div></td></tr></tbody></table><a href="http://www.teraplan.it/redhat-osd-2017/" target="_blank"><img src="http://images.engage.redhat.com/EloquaImages/clients/RedHat/%7Bce8ba915-16e1-4b66-8a16-dfaac06bd5c0%7D_RH_OSD_Generic_Banner_655x100.png" width="420" height="60"></a><span></span><a href="http:///" target="_blank"></a><span></span><br></div></div></div></div></div></div></div></div></div></div></div>
</div></div>