<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Thu, May 11, 2017 at 7:11 PM, Nelson Lameiras <span dir="ltr"><<a href="mailto:nelson.lameiras@lyra-network.com" target="_blank">nelson.lameiras@lyra-network.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-family:arial,helvetica,sans-serif;font-size:12pt;color:#000000"><div>Hello,<br></div><div><br></div><div>Not sure if I should post here, or on the dev mailling list.<br></div><div><br></div><div>I had a serious problem when upgrading an oVirt cluster from 3.6 to 4.0 (before updating to 4.1)<br></div><div><br></div><div>The error on engine-setup log was : <br></div><div>"schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-<wbr>engine/dbscripts/upgrade/04_<wbr>00_0930_disallow_boot_<wbr>protocol_to_be_null.sql"<br></div><div><br></div><div>After long hours of debuguing and analysing I found out the problem. On database, some entries on table network_attachements had a NULL value which were incompatible with the sql file above.<br></div><div>I'm guessing this is an "exotic situation" which shouldn't exist... in theory ;)<br></div><div><br></div><div>Anyway, I'm fairly sure that the solution for this problem would be to patch the following file 'ovirt-engine/packaging/<wbr>dbscripts/upgrade/04_00_0910_<wbr>do_not_allow_null_boot_<wbr>protocol.sql' </div><div>by adding the following line "<span class="m_-3655718754444483455pl-k">update</span> network_attachments <span class="m_-3655718754444483455pl-k">set</span> boot_protocol<span class="m_-3655718754444483455pl-k">=</span><span class="m_-3655718754444483455pl-s"><span class="m_-3655718754444483455pl-pds">'</span>NONE<span class="m_-3655718754444483455pl-pds">'</span></span> <span class="m_-3655718754444483455pl-k">where</span> boot_protocol is <span class="m_-3655718754444483455pl-k">null</span>;"<br></div><div><br></div><div>If a dev want to discuss it further, I'll be happy to explain my thoughts on this matter. <br></div></div></div></blockquote><div><br></div><div>Doing the above might be enough for engine-setup to finish, but it might introduce a risk.<br></div><div>Ideally we should find the root cause leading to this state and:<br></div><div>1. Make sure it can't happen anymore<br></div><div>2. Fully fix the data - might require more than just the above update.<br></div><div>3. Alternatively, add a check earlier and notify the user to fix this manually.<br></div><div>Adding Dan for further analysis.<br><br></div><div>Thanks for the report!<br><br></div><div>Best,<br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-family:arial,helvetica,sans-serif;font-size:12pt;color:#000000"><div></div><div><br></div><div><div>cordialement, regards,</div><div><br></div><table style="margin:0px;table-layout:fixed;border:none;width:345pt;padding:0px" border="0" cellspacing="0" cellpadding="0" width="460"><tbody><tr><td style="margin:0;font-size:11px;font-family:Arial,sans-serif;color:#2b3c7a;line-height:16px;width:86.25pt;text-align:left" valign="top" width="115"><a href="https://www.lyra-network.com/" style="border:none;text-decoration:none;width:100%;display:block;clear:both" target="_blank"><img src="cid:1db6da5091d14a0982ffcf8c4fef8a46b32a3417@zimbra" alt="" border="0" width="115" height="94"></a><br></td><td style="margin:0;font-size:11px;font-family:Arial,sans-serif;color:#2b3c7a;line-height:16px;width:258.75pt" valign="top" width="345"><table style="margin:0;width:258.75pt;table-layout:fixed;border:none" border="0" cellspacing="0" cellpadding="0" width="345"><tbody><tr><td style="font-size:16px;font-family:Arial,sans-serif;color:#2b3c7a;line-height:18px;font-weight:bold">Nelson LAMEIRAS</td></tr><tr><td style="font-family:Arial,sans-serif;color:#2b3c7a;font-size:11px;line-height:16px">Ingénieur Systèmes et Réseaux<span style="font-family:Arial,sans-serif;color:#337ab7;font-size:11px"> / Systems and Networks engineer</span></td></tr><tr><td style="line-height:16px;font-family:'Arial',sans-serif;color:#2b3c7a;font-size:11px"><span style="font-family:Arial,sans-serif;color:#2b3c7a;font-size:11px">Tel: <a href="tel:+33%205%2032%2009%2009%2070" value="+33532090970" target="_blank">+33 5 32 09 09 70</a></span></td></tr><tr><td style="line-height:16px;font-family:'Arial',sans-serif;color:#2b3c7a;font-size:11px"><a href="mailto:nelson.lameiras@lyra-network.com" style="font-size:11px;font-family:Arial,sans-serif;line-height:16px;text-decoration:none" target="_blank">nelson.lameiras@lyra-network.<wbr>com</a><br></td></tr><tr><td style="line-height:16px;font-family:'Arial',sans-serif;color:#2b3c7a;font-size:11px"><a href="https://www.lyra-network.com/" style="font-size:11px;font-family:Arial,sans-serif;line-height:16px;border:none;text-decoration:none" target="_blank">www.lyra-network.com</a> <a href="https://payzen.eu" style="font-size:11px;font-family:Arial,sans-serif;line-height:16px;border:none;text-decoration:none" target="_blank"> | www.payzen.eu</a><br></td></tr></tbody></table></td></tr></tbody></table><table style="margin:0;table-layout:fixed;border:none;width:345pt" cellspacing="0" cellpadding="0" width="460"><tbody><tr><td style="margin:0;font-size:11px;font-family:Arial,sans-serif;color:#2b3c7a;line-height:16px;width:24pt;text-align:left" valign="top" width="32"><a href="https://www.youtube.com/channel/UCrVl1CO_Jlu3KbiRH-tQ_vA" style="border:none;text-decoration:none;margin:0;float:left;display:inline-block;width:32px" target="_blank"><img src="cid:99ac6520e8e3715f40f650ce0d5f88a03a9bd713@zimbra" alt="" border="0" width="32" height="28"></a><br></td><td style="margin:0;font-size:11px;font-family:Arial,sans-serif;color:#2b3c7a;line-height:16px;width:30.75pt;text-align:left" valign="top" width="41"><a href="https://www.linkedin.com/company/lyra-network_2" style="border:none;text-decoration:none;margin:0;float:left;display:inline-block;width:41px" target="_blank"><img src="cid:a70d2dafceb98e64513f5a16b7d3ea0ab5a0f1f5@zimbra" border="0" width="41" height="28"></a><br></td><td style="margin:0;font-size:11px;font-family:Arial,sans-serif;color:#2b3c7a;line-height:16px;width:31.5pt;text-align:left" valign="top" width="42"><a href="https://twitter.com/LyraNetwork" style="border:none;text-decoration:none;margin:0;float:left;display:inline-block;width:42px" target="_blank"><img src="cid:a994fe545de6341d6b369e33bbb18605bbbcef66@zimbra" alt="" border="0" width="42" height="28"></a><br></td><td style="margin:0;font-size:11px;font-family:Arial,sans-serif;color:#2b3c7a;line-height:16px;width:258.75pt;text-align:left" valign="top" width="345"><a href="https://payzen.eu" style="border:none;text-decoration:none;margin:0;float:left;display:inline-block;width:61px" target="_blank"><img src="cid:86ad24eaa2a146e1b7ee93db04f055468345dc13@zimbra" alt="" border="0" width="61" height="28"></a><br></td></tr></tbody></table><table style="margin:0;table-layout:fixed;border:none;width:345pt" cellspacing="0" cellpadding="0" width="460"><tbody><tr><td><hr style="background:#293b79 none repeat scroll 0% 0%;width:100%;height:4px;color:#293b79;margin:0px"></td></tr></tbody></table><table style="margin:0;table-layout:fixed;border:none;width:345pt" cellspacing="0" cellpadding="0" width="460"><tbody><tr><td style="margin:0;font-size:11px;font-family:Arial,sans-serif;color:#2b3c7a;line-height:16px;width:30.75pt;text-align:left"><div>Lyra Network, 109 rue de l'innovation, 31670 Labège, FRANCE</div></td></tr></tbody></table><div><br></div></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"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Didi<br></div>
</div></div>