<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>Hello,<br></div><div><br data-mce-bogus="1"></div><div>Not sure if I should post here, or on the dev mailling list.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>I had a serious problem when upgrading an oVirt cluster from 3.6 to 4.0 (before updating to 4.1)<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>The error on engine-setup log was : <br data-mce-bogus="1"></div><div>"schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_00_0930_disallow_boot_protocol_to_be_null.sql"<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></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 data-mce-bogus="1"></div><div>I'm guessing this is an "exotic situation" which shouldn't exist... in theory ;)<br data-mce-bogus="1"></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/dbscripts/upgrade/04_00_0910_do_not_allow_null_boot_protocol.sql' </div><div>by adding the following line "<span class="pl-k">update</span> network_attachments <span class="pl-k">set</span> boot_protocol<span class="pl-k">=</span><span class="pl-s"><span class="pl-pds">'</span>NONE<span class="pl-pds">'</span></span> <span class="pl-k">where</span> boot_protocol is <span class="pl-k">null</span>;"<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>If a dev want to discuss it further, I'll be happy to explain my thoughts on this matter. <br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div data-marker="__SIG_PRE__"><div>cordialement, regards,</div><div><br data-mce-bogus="1"></div><table style="margin: 0px; table-layout: fixed; border: none; width: 345pt; padding: 0px;" data-mce-style="margin: 0px; table-layout: fixed; border: none; width: 345pt; padding: 0px;" width="460" cellspacing="0" cellpadding="0" border="0"><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;" data-mce-style="margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 16px; width: 86.25pt; text-align: left;" width="115" valign="top"><a href="https://www.lyra-network.com/" style="border: none; text-decoration: none; width: 100%; display: block; clear: both;" data-mce-href="https://www.lyra-network.com/" data-mce-style="border: none; text-decoration: none; width: 100%; display: block; clear: both;"><img src="cid:1db6da5091d14a0982ffcf8c4fef8a46b32a3417@zimbra" alt="" data-mce-src="/home/admin@lyra-network.com/corporate-documents/element-signature_logo_lyra_115x94.jpg" doc="corporate-documents/element-signature_logo_lyra_115x94.jpg" height="94" width="115" border="0"></a><br data-mce-bogus="1"></td><td style="margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 16px; width: 258.75pt;" data-mce-style="margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 16px; width: 258.75pt;" width="345" valign="top"><table style="margin: 0; width: 258.75pt; table-layout: fixed; border: none;" data-mce-style="margin: 0; width: 258.75pt; table-layout: fixed; border: none;" width="345" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="font-size: 16px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 18px; font-weight: bold;" data-mce-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;" data-mce-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;" data-mce-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;" data-mce-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;" data-mce-style="font-family: Arial,sans-serif; color: #2b3c7a; font-size: 11px;">Tel: +33 5 32 09 09 70</span></td></tr><tr><td style="line-height: 16px; font-family: 'Arial',sans-serif; color: #2b3c7a; font-size: 11px;" data-mce-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;" data-mce-href="mailto:nelson.lameiras@lyra-network.com" data-mce-style="font-size: 11px; font-family: Arial,sans-serif; line-height: 16px; text-decoration: none;">nelson.lameiras@lyra-network.com</a><br data-mce-bogus="1"></td></tr><tr><td style="line-height: 16px; font-family: 'Arial',sans-serif; color: #2b3c7a; font-size: 11px;" data-mce-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;" data-mce-href="https://www.lyra-network.com/" data-mce-style="font-size: 11px; font-family: Arial,sans-serif; line-height: 16px; border: none; text-decoration: none;">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;" data-mce-href="https://payzen.eu" data-mce-style="font-size: 11px; font-family: Arial,sans-serif; line-height: 16px; border: none; text-decoration: none;"> | www.payzen.eu</a><br data-mce-bogus="1"></td></tr></tbody></table></td></tr></tbody></table><table style="margin: 0; table-layout: fixed; border: none; width: 345pt;" data-mce-style="margin: 0; table-layout: fixed; border: none; width: 345pt;" width="460" cellspacing="0" cellpadding="0"><tbody><tr><td style="margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 16px; width: 24pt; text-align: left;" data-mce-style="margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 16px; width: 24pt; text-align: left;" width="32" valign="top"><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;" data-mce-href="https://www.youtube.com/channel/UCrVl1CO_Jlu3KbiRH-tQ_vA" data-mce-style="border: none; text-decoration: none; margin: 0; float: left; display: inline-block; width: 32px;"><img src="cid:99ac6520e8e3715f40f650ce0d5f88a03a9bd713@zimbra" alt="" data-mce-src="/home/admin@lyra-network.com/corporate-documents/element-signature_logo_YouTube_32x28.jpg" doc="corporate-documents/element-signature_logo_YouTube_32x28.jpg" height="28" width="32" border="0"></a><br data-mce-bogus="1"></td><td style="margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 16px; width: 30.75pt; text-align: left;" data-mce-style="margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 16px; width: 30.75pt; text-align: left;" width="41" valign="top"><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;" data-mce-href="https://www.linkedin.com/company/lyra-network_2" data-mce-style="border: none; text-decoration: none; margin: 0; float: left; display: inline-block; width: 41px;"><img src="cid:a70d2dafceb98e64513f5a16b7d3ea0ab5a0f1f5@zimbra" data-mce-src="/home/admin@lyra-network.com/corporate-documents/element-signature_logo_LinkedIn_41x28.jpg" doc="corporate-documents/element-signature_logo_LinkedIn_41x28.jpg" height="28" width="41" border="0"></a><br data-mce-bogus="1"></td><td style="margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 16px; width: 31.5pt; text-align: left;" data-mce-style="margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 16px; width: 31.5pt; text-align: left;" width="42" valign="top"><a href="https://twitter.com/LyraNetwork" style="border: none; text-decoration: none; margin: 0; float: left; display: inline-block; width: 42px;" data-mce-href="https://twitter.com/LyraNetwork" data-mce-style="border: none; text-decoration: none; margin: 0; float: left; display: inline-block; width: 42px;"><img src="cid:a994fe545de6341d6b369e33bbb18605bbbcef66@zimbra" alt="" data-mce-src="/home/admin@lyra-network.com/corporate-documents/element-signature_logo_Twitter_42x28.jpg" doc="corporate-documents/element-signature_logo_Twitter_42x28.jpg" height="28" width="42" border="0"></a><br data-mce-bogus="1"></td><td style="margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 16px; width: 258.75pt; text-align: left;" data-mce-style="margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 16px; width: 258.75pt; text-align: left;" width="345" valign="top"><a href="https://payzen.eu" style="border: none; text-decoration: none; margin: 0; float: left; display: inline-block; width: 61px;" data-mce-href="https://payzen.eu" data-mce-style="border: none; text-decoration: none; margin: 0; float: left; display: inline-block; width: 61px;"><img src="cid:86ad24eaa2a146e1b7ee93db04f055468345dc13@zimbra" alt="" data-mce-src="/home/admin@lyra-network.com/corporate-documents/element-signature_payzen_61x28.jpg" doc="corporate-documents/element-signature_payzen_61x28.jpg" height="28" width="61" border="0"></a><br data-mce-bogus="1"></td></tr></tbody></table><table style="margin: 0; table-layout: fixed; border: none; width: 345pt;" data-mce-style="margin: 0; table-layout: fixed; border: none; width: 345pt;" width="460" cellspacing="0" cellpadding="0"><tbody><tr><td><hr style="background: #293b79 none repeat scroll 0% 0%; width: 100%; height: 4px; color: #293b79; margin: 0px;" data-mce-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;" data-mce-style="margin: 0; table-layout: fixed; border: none; width: 345pt;" width="460" cellspacing="0" cellpadding="0"><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;" data-mce-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></body></html>