problem while updating oVirt from 3.6 to 4.0
<div>I'm guessing this is an "exotic situation" which shouldn't exist... i= n theory ;)<br data-mce-bogus=3D"1"></div><div><br></div><div>Anyway, I'm f= airly sure that the solution for this problem would be to patch the followi= ng file 'ovirt-engine/packaging/dbscripts/upgrade/04_00_0910_do_not_allow_n=
------=_Part_37643342_929927371.1494519067933 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hello,=20 Not sure if I should post here, or on the dev mailling list.=20 I had a serious problem when upgrading an oVirt cluster from 3.6 to 4.0 (be= fore updating to 4.1)=20 The error on engine-setup log was :=20 "schema.sh: FATAL: Cannot execute sql command: --file=3D/usr/share/ovirt-en= gine/dbscripts/upgrade/04_00_0930_disallow_boot_protocol_to_be_null.sql"=20 After long hours of debuguing and analysing I found out the problem. On dat= abase, some entries on table network_attachements had a NULL value which we= re incompatible with the sql file above.=20 I'm guessing this is an "exotic situation" which shouldn't exist... in theo= ry ;)=20 Anyway, I'm fairly sure that the solution for this problem would be to patc= h the following file 'ovirt-engine/packaging/dbscripts/upgrade/04_00_0910_d= o_not_allow_null_boot_protocol.sql'=20 by adding the following line " update network_attachments set boot_protocol= =3D ' NONE ' where boot_protocol is null ;"=20 If a dev want to discuss it further, I'll be happy to explain my thoughts o= n this matter.=20 cordialement, regards,=20 =09Nelson LAMEIRAS=20 Ing=C3=A9nieur Syst=C3=A8mes et R=C3=A9seaux / Systems and Networks enginee= r=20 Tel: +33 5 32 09 09 70=20 nelson.lameiras@lyra-network.com=20 www.lyra-network.com | www.payzen.eu=20 =09 =09 =09 Lyra Network, 109 rue de l'innovation, 31670 Lab=C3=A8ge, FRANCE=20 ------=_Part_37643342_929927371.1494519067933 Content-Type: multipart/related; boundary="----=_Part_37643343_1124091921.1494519067933" ------=_Part_37643343_1124091921.1494519067933 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html><body><div style=3D"font-family: arial, helvetica, sans-serif; font-s= ize: 12pt; color: #000000"><div>Hello,<br></div><div><br data-mce-bogus=3D"= 1"></div><div>Not sure if I should post here, or on the dev mailling list.<= br data-mce-bogus=3D"1"></div><div><br data-mce-bogus=3D"1"></div><div>I ha= d a serious problem when upgrading an oVirt cluster from 3.6 to 4.0 (before= updating to 4.1)<br data-mce-bogus=3D"1"></div><div><br data-mce-bogus=3D"= 1"></div><div>The error on engine-setup log was : <br data-mce-bogus=3D"1">= </div><div>"schema.sh: FATAL: Cannot execute sql command: --file=3D/usr/sha= re/ovirt-engine/dbscripts/upgrade/04_00_0930_disallow_boot_protocol_to_be_n= ull.sql"<br data-mce-bogus=3D"1"></div><div><br data-mce-bogus=3D"1"></div>= <div>After long hours of debuguing and analysing I found out the problem. O= n database, some entries on table network_attachements had a NULL value whi= ch were incompatible with the sql file above.<br data-mce-bogus=3D"1"></div= ull_boot_protocol.sql' </div><div>by adding the following line "<span class= =3D"pl-k">update</span> network_attachments <span class=3D"pl-k">set</span>= boot_protocol<span class=3D"pl-k">=3D</span><span class=3D"pl-s"><span cla= ss=3D"pl-pds">'</span>NONE<span class=3D"pl-pds">'</span></span> <span clas= s=3D"pl-k">where</span> boot_protocol is <span class=3D"pl-k">null</span>;"= <br data-mce-bogus=3D"1"></div><div><br data-mce-bogus=3D"1"></div><div>If = a dev want to discuss it further, I'll be happy to explain my thoughts on t= his matter. <br data-mce-bogus=3D"1"></div><div><br data-mce-bogus=3D"1"></= div><div data-marker=3D"__SIG_PRE__"><div>cordialement, regards,</div><div>= <br data-mce-bogus=3D"1"></div><table style=3D"margin: 0px; table-layout: f= ixed; border: none; width: 345pt; padding: 0px;" data-mce-style=3D"margin: = 0px; table-layout: fixed; border: none; width: 345pt; padding: 0px;" width= =3D"460" cellspacing=3D"0" cellpadding=3D"0" border=3D"0"><tbody><tr><td st= yle=3D"margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2= b3c7a; line-height: 16px; width: 86.25pt; text-align: left;" data-mce-style= =3D"margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c= 7a; line-height: 16px; width: 86.25pt; text-align: left;" width=3D"115" val= ign=3D"top"><a href=3D"https://www.lyra-network.com/" style=3D"border: none= ; text-decoration: none; width: 100%; display: block; clear: both;" data-mc= e-href=3D"https://www.lyra-network.com/" data-mce-style=3D"border: none; te= xt-decoration: none; width: 100%; display: block; clear: both;"><img src=3D= "cid:1db6da5091d14a0982ffcf8c4fef8a46b32a3417@zimbra" alt=3D"" data-mce-src= =3D"/home/admin@lyra-network.com/corporate-documents/element-signature_logo= _lyra_115x94.jpg" doc=3D"corporate-documents/element-signature_logo_lyra_11= 5x94.jpg" height=3D"94" width=3D"115" border=3D"0"></a><br data-mce-bogus= =3D"1"></td><td style=3D"margin: 0; font-size: 11px; font-family: Arial,san= s-serif; color: #2b3c7a; line-height: 16px; width: 258.75pt;" data-mce-styl= e=3D"margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3= c7a; line-height: 16px; width: 258.75pt;" width=3D"345" valign=3D"top"><tab= le style=3D"margin: 0; width: 258.75pt; table-layout: fixed; border: none;"= data-mce-style=3D"margin: 0; width: 258.75pt; table-layout: fixed; border:= none;" width=3D"345" cellspacing=3D"0" cellpadding=3D"0" border=3D"0"><tbo= dy><tr><td style=3D"font-size: 16px; font-family: Arial,sans-serif; color: = #2b3c7a; line-height: 18px; font-weight: bold;" data-mce-style=3D"font-size= : 16px; font-family: Arial,sans-serif; color: #2b3c7a; line-height: 18px; f= ont-weight: bold;">Nelson LAMEIRAS</td></tr><tr><td style=3D"font-family: A= rial,sans-serif; color: #2b3c7a; font-size: 11px; line-height: 16px;" data-= mce-style=3D"font-family: Arial,sans-serif; color: #2b3c7a; font-size: 11px= ; line-height: 16px;">Ing=C3=A9nieur Syst=C3=A8mes et R=C3=A9seaux<span sty= le=3D"font-family: Arial,sans-serif; color: #337ab7; font-size: 11px;" data= -mce-style=3D"font-family: Arial,sans-serif; color: #337ab7; font-size: 11p= x;"> / Systems and Networks engineer</span></td></tr><tr><td style=3D"line-= height: 16px; font-family: 'Arial',sans-serif; color: #2b3c7a; font-size: 1= 1px;" data-mce-style=3D"line-height: 16px; font-family: 'Arial',sans-serif;= color: #2b3c7a; font-size: 11px;"><span style=3D"font-family: Arial,sans-s= erif; color: #2b3c7a; font-size: 11px;" data-mce-style=3D"font-family: Aria= l,sans-serif; color: #2b3c7a; font-size: 11px;">Tel: +33 5 32 09 09 70</spa= n></td></tr><tr><td style=3D"line-height: 16px; font-family: 'Arial',sans-s= erif; color: #2b3c7a; font-size: 11px;" data-mce-style=3D"line-height: 16px= ; font-family: 'Arial',sans-serif; color: #2b3c7a; font-size: 11px;"><a hre= f=3D"mailto:nelson.lameiras@lyra-network.com" style=3D"font-size: 11px; fon= t-family: Arial,sans-serif; line-height: 16px; text-decoration: none;" data= -mce-href=3D"mailto:nelson.lameiras@lyra-network.com" data-mce-style=3D"fon= t-size: 11px; font-family: Arial,sans-serif; line-height: 16px; text-decora= tion: none;">nelson.lameiras@lyra-network.com</a><br data-mce-bogus=3D"1"><= /td></tr><tr><td style=3D"line-height: 16px; font-family: 'Arial',sans-seri= f; color: #2b3c7a; font-size: 11px;" data-mce-style=3D"line-height: 16px; f= ont-family: 'Arial',sans-serif; color: #2b3c7a; font-size: 11px;"><a href= =3D"https://www.lyra-network.com/" style=3D"font-size: 11px; font-family: A= rial,sans-serif; line-height: 16px; border: none; text-decoration: none;" d= ata-mce-href=3D"https://www.lyra-network.com/" data-mce-style=3D"font-size:= 11px; font-family: Arial,sans-serif; line-height: 16px; border: none; text= -decoration: none;">www.lyra-network.com</a> <a href=3D"https://payzen.eu" = style=3D"font-size: 11px; font-family: Arial,sans-serif; line-height: 16px;= border: none; text-decoration: none;" data-mce-href=3D"https://payzen.eu" = data-mce-style=3D"font-size: 11px; font-family: Arial,sans-serif; line-heig= ht: 16px; border: none; text-decoration: none;"> | www.payzen.eu</a><br dat= a-mce-bogus=3D"1"></td></tr></tbody></table></td></tr></tbody></table><tabl= e style=3D"margin: 0; table-layout: fixed; border: none; width: 345pt;" dat= a-mce-style=3D"margin: 0; table-layout: fixed; border: none; width: 345pt;"= width=3D"460" cellspacing=3D"0" cellpadding=3D"0"><tbody><tr><td style=3D"= margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; = line-height: 16px; width: 24pt; text-align: left;" data-mce-style=3D"margin= : 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b3c7a; line-h= eight: 16px; width: 24pt; text-align: left;" width=3D"32" valign=3D"top"><a= href=3D"https://www.youtube.com/channel/UCrVl1CO_Jlu3KbiRH-tQ_vA" style=3D= "border: none; text-decoration: none; margin: 0; float: left; display: inli= ne-block; width: 32px;" data-mce-href=3D"https://www.youtube.com/channel/UC= rVl1CO_Jlu3KbiRH-tQ_vA" data-mce-style=3D"border: none; text-decoration: no= ne; margin: 0; float: left; display: inline-block; width: 32px;"><img src= =3D"cid:99ac6520e8e3715f40f650ce0d5f88a03a9bd713@zimbra" alt=3D"" data-mce-= src=3D"/home/admin@lyra-network.com/corporate-documents/element-signature_l= ogo_YouTube_32x28.jpg" doc=3D"corporate-documents/element-signature_logo_Yo= uTube_32x28.jpg" height=3D"28" width=3D"32" border=3D"0"></a><br data-mce-b= ogus=3D"1"></td><td style=3D"margin: 0; font-size: 11px; font-family: Arial= ,sans-serif; color: #2b3c7a; line-height: 16px; width: 30.75pt; text-align:= left;" data-mce-style=3D"margin: 0; font-size: 11px; font-family: Arial,sa= ns-serif; color: #2b3c7a; line-height: 16px; width: 30.75pt; text-align: le= ft;" width=3D"41" valign=3D"top"><a href=3D"https://www.linkedin.com/compan= y/lyra-network_2" style=3D"border: none; text-decoration: none; margin: 0; = float: left; display: inline-block; width: 41px;" data-mce-href=3D"https://= www.linkedin.com/company/lyra-network_2" data-mce-style=3D"border: none; te= xt-decoration: none; margin: 0; float: left; display: inline-block; width: = 41px;"><img src=3D"cid:a70d2dafceb98e64513f5a16b7d3ea0ab5a0f1f5@zimbra" dat= a-mce-src=3D"/home/admin@lyra-network.com/corporate-documents/element-signa= ture_logo_LinkedIn_41x28.jpg" doc=3D"corporate-documents/element-signature_= logo_LinkedIn_41x28.jpg" height=3D"28" width=3D"41" border=3D"0"></a><br da= ta-mce-bogus=3D"1"></td><td style=3D"margin: 0; font-size: 11px; font-famil= y: Arial,sans-serif; color: #2b3c7a; line-height: 16px; width: 31.5pt; text= -align: left;" data-mce-style=3D"margin: 0; font-size: 11px; font-family: A= rial,sans-serif; color: #2b3c7a; line-height: 16px; width: 31.5pt; text-ali= gn: left;" width=3D"42" valign=3D"top"><a href=3D"https://twitter.com/LyraN= etwork" style=3D"border: none; text-decoration: none; margin: 0; float: lef= t; display: inline-block; width: 42px;" data-mce-href=3D"https://twitter.co= m/LyraNetwork" data-mce-style=3D"border: none; text-decoration: none; margi= n: 0; float: left; display: inline-block; width: 42px;"><img src=3D"cid:a99= 4fe545de6341d6b369e33bbb18605bbbcef66@zimbra" alt=3D"" data-mce-src=3D"/hom= e/admin@lyra-network.com/corporate-documents/element-signature_logo_Twitter= _42x28.jpg" doc=3D"corporate-documents/element-signature_logo_Twitter_42x28= .jpg" height=3D"28" width=3D"42" border=3D"0"></a><br data-mce-bogus=3D"1">= </td><td style=3D"margin: 0; font-size: 11px; font-family: Arial,sans-serif= ; color: #2b3c7a; line-height: 16px; width: 258.75pt; text-align: left;" da= ta-mce-style=3D"margin: 0; font-size: 11px; font-family: Arial,sans-serif; = color: #2b3c7a; line-height: 16px; width: 258.75pt; text-align: left;" widt= h=3D"345" valign=3D"top"><a href=3D"https://payzen.eu" style=3D"border: non= e; text-decoration: none; margin: 0; float: left; display: inline-block; wi= dth: 61px;" data-mce-href=3D"https://payzen.eu" data-mce-style=3D"border: n= one; text-decoration: none; margin: 0; float: left; display: inline-block; = width: 61px;"><img src=3D"cid:86ad24eaa2a146e1b7ee93db04f055468345dc13@zimb= ra" alt=3D"" data-mce-src=3D"/home/admin@lyra-network.com/corporate-documen= ts/element-signature_payzen_61x28.jpg" doc=3D"corporate-documents/element-s= ignature_payzen_61x28.jpg" height=3D"28" width=3D"61" border=3D"0"></a><br = data-mce-bogus=3D"1"></td></tr></tbody></table><table style=3D"margin: 0; t= able-layout: fixed; border: none; width: 345pt;" data-mce-style=3D"margin: = 0; table-layout: fixed; border: none; width: 345pt;" width=3D"460" cellspac= ing=3D"0" cellpadding=3D"0"><tbody><tr><td><hr style=3D"background: #293b79= none repeat scroll 0% 0%; width: 100%; height: 4px; color: #293b79; margin= : 0px;" data-mce-style=3D"background: #293b79 none repeat scroll 0% 0%; wid= th: 100%; height: 4px; color: #293b79; margin: 0px;"></td></tr></tbody></ta= ble><table style=3D"margin: 0; table-layout: fixed; border: none; width: 34= 5pt;" data-mce-style=3D"margin: 0; table-layout: fixed; border: none; width= : 345pt;" width=3D"460" cellspacing=3D"0" cellpadding=3D"0"><tbody><tr><td = style=3D"margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: = #2b3c7a; line-height: 16px; width: 30.75pt; text-align: left;" data-mce-sty= le=3D"margin: 0; font-size: 11px; font-family: Arial,sans-serif; color: #2b= 3c7a; line-height: 16px; width: 30.75pt; text-align: left;"><div>Lyra Netwo= rk, 109 rue de l'innovation, 31670 Lab=C3=A8ge, FRANCE</div></td></tr></tbo= dy></table><div><br></div></div></div></body></html> ------=_Part_37643343_1124091921.1494519067933 Content-Type: image/jpeg; name=element-signature_logo_lyra_115x94.jpg Content-Disposition: attachment; filename=element-signature_logo_lyra_115x94.jpg Content-Transfer-Encoding: base64 Content-ID: <1db6da5091d14a0982ffcf8c4fef8a46b32a3417@zimbra> /9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QOBaHR0cDov L25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1TTBNcENl aGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4 OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzEzMiA3OS4xNTkyODQsIDIwMTYvMDQvMTktMTM6 MTM6NDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5 OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiIHht bG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0i aHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1sbnM6eG1w PSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bXBNTTpPcmlnaW5hbERvY3VtZW50SUQ9 InhtcC5kaWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1LTgxYmQtMTYwMTFjZjk5YWVjIiB4bXBNTTpEb2N1 bWVudElEPSJ4bXAuZGlkOkU1QUU4Nzk1OEExMzExRTZBNTFCRjVENEYyNDYxNTQ1IiB4bXBNTTpJ bnN0YW5jZUlEPSJ4bXAuaWlkOkU1QUU4Nzk0OEExMzExRTZBNTFCRjVENEYyNDYxNTQ1IiB4bXA6 Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDQyAyMDE1LjUgKFdpbmRvd3MpIj4gPHhtcE1N OkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1 LTgxYmQtMTYwMTFjZjk5YWVjIiBzdFJlZjpkb2N1bWVudElEPSJ4bXAuZGlkOmRkMGY5MmM1LTc4 YWYtY2U0NS04MWJkLTE2MDExY2Y5OWFlYyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRG PiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pv/uAA5BZG9iZQBkwAAAAAH/2wCEAAYE BAQFBAYFBQYJBgUGCQsIBgYICwwKCgsKCgwQDAwMDAwMEAwODxAPDgwTExQUExMcGxsbHB8fHx8f Hx8fHx8BBwcHDQwNGBAQGBoVERUaHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f Hx8fHx8fHx8fHx8fH//AABEIAF4AcwMBEQACEQEDEQH/xACdAAEBAAIDAQEAAAAAAAAAAAAACAUH AgMGBAEBAQADAQEAAAAAAAAAAAAAAAACBAUBAxAAAAUDAgAHDQcCBwAAAAAAAAECAwQRBQYSByFR E7RWFzcxQSKS0nOT03RVlQgYYXEyQiMUFYEzsVJicmODOBEAAgECAwcEAgIDAAAAAAAAAAECEQNR EwQhgbESMlIzMUGhFHEVwQUiQzT/2gAMAwEAAhEDEQA/AKpAE9b/AGQZdF3FtNpsd4l29M2DHSll iS6w0bzsp5slqJCiLvERnTuENTRQg7bckntK15vmojj1WfMP0rc+Jy/JD7Fjt+EMueJ6bbnBN4bR lkWdkt+XPtDaHSfjKnSHyUpTZkg+TcLSdFGRjyv3rUo0iqP8EoQkntZ7fcOy5VdrXGYxuccGW2+S 3nCecYq3oUWnU2RmfhGXAPPSXLcJNzVVT8kNVbnKKUHRmppW1/zBOSXVtZS4lpSjNtP8nLKhfcSR alqdPXp+ERhauKKTe38nX1WfMP0qc+Jy/JHPsWO34RPLniOqz5h+lTnxOX5IfYsdvwhlzxHVZ8w/ Spz4nL8kPsWO34Qy54jqs+YfpU58Tl+SH2LHb8IZc8R1WfMP0qc+Jy/JD7Fjt+EMueJ2bCX3MH9y LxZr7eJdxKBCkoW0/JdfaJ5mUy2a0EszL/MRHTuGGshDLTiqVf8AAst81GUGMssgAAAAE5b89s+L +zwefPDV0fhlv4FW71oo0ZRaAAAAAAAAAAAAACdtj+3DLfNXDn7I1dX4Y7uBWtdbKJGUWQAAAACc t+e2fF/Z4PPnhq6Pwy38Crd60UaMotAAAAAAAAAAAAABO2x/bhlvmrhz9kaur8Md3ArWutlEjKLI AAAABOW/PbPi/s8Hnzw1dH4Zb+BVu9aKNGUWjAKzrGk5cnEjkq/nVo5RMbk3NOnkzd/uU0fgKvdH rky5eb2I86rQz48iQAAAAAAAAABO2x/bhlvmrhz9kaur8Md3ArWutlEjKLIAAAABOW/PbPi/s8Hn zw1dH4Zb+BVu9aKNGUWjSD//AKkj+xnzJQ0V/wA2/wDkr/7D3e7GX5DiOMfzlniMTEMPIRORIJfg tOeCladCk/nNJH94raa1GcuVnpck4qqOrJdz4dr2yazKOhDjkxhlUGMszop98i/TOlD/AE/CNX+0 x23p27nIJXKRqeeyjdnLMd27sGSzLdEO4Xd4uWifqkhDDiFut0qrUSzQlNa9wz7g9bemjK44puiI yuNRTOzGs53hud+gvzsYjwMVnqNfLuqUTrEck69bitZmStPc1NJIz4hy5ZtKLpKskIzk36bDHRt2 9yMsuMw9v8ejybNBc5M5s5Rp5Uy4aEZuMJSai4dPCZFStBN6a3BLne1nMyT6Uffgu8GQ5DnysXuN mbtZx461TG1ms3kyGiLWRHXToMz8Hg7nfMQvaWMYcydTsLjcqG2BSPYnbY/twy3zVw5+yNXV+GO7 gVrXWyiRlFkAAAAAnLfntnxf2eDz54auj8Mt/Aq3etFGjKLROmdZbAxL5g/5yey6/GjREJW2wSTc M3YpoKms0F3VcY1bNpzscqKs5UnU9pad4cG3Fefw1UWXFO7x3mULkpaJJnoM6JNC10WREak/aXGK 8tLO1/ns2HorilsNTYzar/kOQWTa+5tmmBjk+W9cKGqimkrJS68RcCkoV/yC7clGMXcXrJI8Yptq OBsj5oEpTiNmSRESSuKSJJFwUJlzgoKv9f1P8Hrf9Db1wh/vbVJh6tH7lhbOvi5RBpr/AEqKMXR1 PZrYaC2x3Jgbawp+IZjBkwpkWS480603rSslkRU7qTOuiqFlUlEfepw6WosO61ODK9ufLsZ27f36 RkG/8q9OwXbe3PgKciMPp0uHHS22hpxRf60o1f4VC9DlsUrWjEHWdSghllknbY/twy3zVw5+yNXV +GO7gVrXWyiRlFkAAAAAnLfntnxf2eDz54auj8Mt/Aq3etFGjKLRxU00o6qQlR8ZkRhUGMyO7W7H 7FOvUpCSZgMrfMqERqNJeCgj41qokvtMTtxcpJL3OSdFU1n8vFimPwbrnF18O55DIXybhlw8ihZm s08RLdqVOJJC5rZqqgvSJ42V7v3MpM3dTBnyWbtBQmHFnXFpLzdXOWjW9tWo2irwPpd0pWhVPBPU R0qILTVWx+y+STuYmQj7sxHH1Kctb7NuahnMflKW2akk3J/bvGlojqtpv8ZuJP8ACR8Ag9M8dtTu YdErdfEJTCZKrY/L5JSySbrbCdKmicdWRLeWlJK/bs8skq+ElSacJ8HVppr3OZiP2RuxFK4W5xi3 LK2T5D8NmY8baHHnWySSeTSa6to1K8JTumn3gtM6PbtQzDYYqnqTtsf24Zb5q4c/ZGrq/DHdwK1r rZRIyiyAAAAATlvz2z4v7PB588NXR+GW/gVbvWijRlFoADGZHjVmyO2Ltd4YOTAcUlbjJLcbJRoO qam2pCuA+GlROFxwdV6nJRT2M+q226DbLfHt8BkmIcRtLMdlNaJQgqEVTqZ/eYjKTbqwlQ5Hb4Bp Uk4zRpUpa1FoTQ1uEaVqPg7qiUZGffDmYodSbNZ0toaTBjk02hbTaCaQSUtu/wBxCSpQkr/MXfHe d4iiP12z2h5k2XYMdxlSkuKbW0hSTW2kkIUZGVKpSkiI+8RApPEURydtltdQpDsRlxCtepKm0mR8 qdXKkZfn/NxjnMxQ+kcOk7bH9uGW+auHP2Rq6vwx3cCta62USMosgAAAAE5b89s+L+zwefPDV0fh lv4FW71oo0ZRaAAAAAAAAAAAAACdtj+3DLfNXDn7I1dX4Y7uBWtdbKJGUWQAAAACb9/3mWN4cbff WTTLUWEt1xX4UpTNeNSj+wiGtolW1LfwKt7qRuTrY226RwfSkKH1rnaz3zI4jrZ226RwfSkH1rna xmRxHWztt0jg+lIPrXO1jMjiOtnbbpHB9KQfWudrGZHEdbO23SOD6Ug+tc7WMyOJ+o3W24WtKE5F CUpR0SknCqZmH1rnazjuxW2pnbTfbPeGnHbXMamNtK0OLaVqJKjKtDELlqUNklQ7C5GfS6mOu+f4 XZpy4F0vMWHMbJKlsOrJKyJRVTUvtIdjZnJVSOuaXqfF1sbbdI4PpSEvrXO1nMyOJp7YiQxJ3oyi RHcS9Hejz3GXUcKVoVOZNKi+wyOovaxUsx3cDwtdbKNGUWgAAAADX+4GzGPZveWbtcpsuO+xGTFS iObRINCFrcIz1oWdaun3xas6qVtUSR5ztKTqeZ+lrCvely8Zj1Q9f2M8EQyEPpawr3pcvGY9UH7G eCGQh9LWFe9Ll4zHqg/YzwQyEPpawr3pcvGY9UH7GeCGQh9LWFe9Ll4zHqg/YzwQyEc2flfwxl5t 1NzuJqbUSiI1MUqX/UOr+xmn6I5LTRaaxNg4XhNuxOHIiwX3n0SXCdWb5pMyMk6eDSlPEPDU6mV5 pteg0+nVpNI8zm+xeNZfkDt7nzprEl5Dbam2FNEgibTpKmttR97jErWslCNEkTlaUnUwP0tYV70u XjMeqHp+xngiOQj023+zGPYReXrtbZsuQ+/GVFUiQbRoJC1ocMy0IQdatF3x5XtVK4qNInC0oups AVT0AAAAAAAAAAAAAAAAAAAAAAAAAAAAD//Z ------=_Part_37643343_1124091921.1494519067933 Content-Type: image/jpeg; name=element-signature_logo_YouTube_32x28.jpg Content-Disposition: attachment; filename=element-signature_logo_YouTube_32x28.jpg Content-Transfer-Encoding: base64 Content-ID: <99ac6520e8e3715f40f650ce0d5f88a03a9bd713@zimbra> /9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QOBaHR0cDov L25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1TTBNcENl aGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4 OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzEzMiA3OS4xNTkyODQsIDIwMTYvMDQvMTktMTM6 MTM6NDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5 OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiIHht bG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0i aHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1sbnM6eG1w PSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bXBNTTpPcmlnaW5hbERvY3VtZW50SUQ9 InhtcC5kaWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1LTgxYmQtMTYwMTFjZjk5YWVjIiB4bXBNTTpEb2N1 bWVudElEPSJ4bXAuZGlkOjQ1REY5Njk1OEExNzExRTY5OUVDOTI1QTU3QzAwNzI0IiB4bXBNTTpJ bnN0YW5jZUlEPSJ4bXAuaWlkOjQ1REY5Njk0OEExNzExRTY5OUVDOTI1QTU3QzAwNzI0IiB4bXA6 Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDQyAyMDE1LjUgKFdpbmRvd3MpIj4gPHhtcE1N OkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1 LTgxYmQtMTYwMTFjZjk5YWVjIiBzdFJlZjpkb2N1bWVudElEPSJ4bXAuZGlkOmRkMGY5MmM1LTc4 YWYtY2U0NS04MWJkLTE2MDExY2Y5OWFlYyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRG PiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pv/uAA5BZG9iZQBkwAAAAAH/2wCEAAYE BAQFBAYFBQYJBgUGCQsIBgYICwwKCgsKCgwQDAwMDAwMEAwODxAPDgwTExQUExMcGxsbHB8fHx8f Hx8fHx8BBwcHDQwNGBAQGBoVERUaHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f Hx8fHx8fHx8fHx8fH//AABEIABwAIAMBEQACEQEDEQH/xAB5AAADAQEAAAAAAAAAAAAAAAAABwgF BgEAAgMBAAAAAAAAAAAAAAAAAAQCAwUBEAABBAECBAUFAAAAAAAAAAABAgMEBQARBiESEwcxUdIU CEEik1UYEQACAQMCBQUAAAAAAAAAAAAAAQIRAwQhMVFhEiITQaHBYhX/2gAMAwEAAhEDEQA/AKpw AnD5Hbg3JA35XxKqxmxUPVrJEaI862FuqkPp4IbI5lHQDNXBhFwbaW4tebqcMIvfYjURtz6eesv1 YzWz9fYh38zR7eX2+mu5lHV3VhaNOe8aTJgTHnweVXEBba1cQRkb8IeNtJbHYN9WpW+YY2T53inQ 4HfzZk6a4lmHGaiOSHl8EoT7mSOZR+gBIzUxU3Yklz+Be4+9DRl30N3dMOxjbyro9EzHW3MqupHc L7qlaoX1SsFvlHl44moPpa6XXiW113FPuu3qrT5I7dfrJLUxllMRl15hQWjqBbiuXmTqCQlQx23F rHdSqTrNFFZlDAou7vZa43xuSNaw7CPFZZhIiKbeSsqKkOuuE/aCNNHcexspW40a9Sm5bcmcH/J1 5+0rvxOenGf0o8GQ8DN7ZXxzv9vbpqrhy0huMQJCHlstocBKU+ITqANcru50ZRao9SUbLTqPvMwv DAAwAMAP/9k= ------=_Part_37643343_1124091921.1494519067933 Content-Type: image/jpeg; name=element-signature_logo_LinkedIn_41x28.jpg Content-Disposition: attachment; filename=element-signature_logo_LinkedIn_41x28.jpg Content-Transfer-Encoding: base64 Content-ID: <a70d2dafceb98e64513f5a16b7d3ea0ab5a0f1f5@zimbra> /9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QOBaHR0cDov L25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1TTBNcENl aGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4 OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzEzMiA3OS4xNTkyODQsIDIwMTYvMDQvMTktMTM6 MTM6NDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5 OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiIHht bG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0i aHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1sbnM6eG1w PSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bXBNTTpPcmlnaW5hbERvY3VtZW50SUQ9 InhtcC5kaWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1LTgxYmQtMTYwMTFjZjk5YWVjIiB4bXBNTTpEb2N1 bWVudElEPSJ4bXAuZGlkOjY2MEYzRTFGOEExNzExRTY5QzI5OUNGQkY1MzM2MUQ1IiB4bXBNTTpJ bnN0YW5jZUlEPSJ4bXAuaWlkOjY2MEYzRTFFOEExNzExRTY5QzI5OUNGQkY1MzM2MUQ1IiB4bXA6 Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDQyAyMDE1LjUgKFdpbmRvd3MpIj4gPHhtcE1N OkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1 LTgxYmQtMTYwMTFjZjk5YWVjIiBzdFJlZjpkb2N1bWVudElEPSJ4bXAuZGlkOmRkMGY5MmM1LTc4 YWYtY2U0NS04MWJkLTE2MDExY2Y5OWFlYyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRG PiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pv/uAA5BZG9iZQBkwAAAAAH/2wCEAAYE BAQFBAYFBQYJBgUGCQsIBgYICwwKCgsKCgwQDAwMDAwMEAwODxAPDgwTExQUExMcGxsbHB8fHx8f Hx8fHx8BBwcHDQwNGBAQGBoVERUaHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f Hx8fHx8fHx8fHx8fH//AABEIABwAKQMBEQACEQEDEQH/xAB2AAEBAQEAAAAAAAAAAAAAAAAABggH AQEAAwEAAAAAAAAAAAAAAAAAAwQFAhAAAQMEAgICAgMBAAAAAAAAAQIDBAARBQYhEjEHMghBE1Fh IhcRAAICAQIDCQAAAAAAAAAAAAABAgMREgQxkTIhQVGhscETMxX/2gAMAwEAAhEDEQA/ANU0Bl33 zsuzQfZcmHj8tMiMKaihDLMl1psKcQkXslSUjk8mtjZ1xdeWkVbW9RDZ/ZN8wOXkYnI7LKMuL1Lq o+RddaIWkLHVwLAPCuf4NWYVwksqPkcNtd5V+ldr2ef7MwkaZmJsqK6p/uy9JdcbUBGcULpUog8i 9Q7uuKreEjquT1GsKxC2KAUBk37B2/6y72t1tB7X8dbIvf8Aq3mtvZfVzKlvUWWw7Dr+Dfy8rCt4 d153Z8ew0FNx3kohuxmUyFtAfFPyBUOBz+arwhKWE89L9SRtLmTuns4xj7LLaxYaGNE6SYojlJZ6 rhLUf19f89eyj4qa1t7ft449ziPWairGLQoBQHFvZ/onObht0jNxclFjMPNtNpZdS4Vj9aAk36gj mtDb7yMIaWiGdTbySSfqnsKbdctAFh1Fm3Bwfx8fFT/ox8GcfAyk9dfX7OapuGNzj+SiPRoJcKmG kuBRDjS2x1uAPK71DfvYzg444nUKmnk7lWcTigFAKAUAoBQCgP/Z ------=_Part_37643343_1124091921.1494519067933 Content-Type: image/jpeg; name=element-signature_logo_Twitter_42x28.jpg Content-Disposition: attachment; filename=element-signature_logo_Twitter_42x28.jpg Content-Transfer-Encoding: base64 Content-ID: <a994fe545de6341d6b369e33bbb18605bbbcef66@zimbra> /9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QOBaHR0cDov L25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1TTBNcENl aGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4 OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzEzMiA3OS4xNTkyODQsIDIwMTYvMDQvMTktMTM6 MTM6NDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5 OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiIHht bG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0i aHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1sbnM6eG1w PSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bXBNTTpPcmlnaW5hbERvY3VtZW50SUQ9 InhtcC5kaWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1LTgxYmQtMTYwMTFjZjk5YWVjIiB4bXBNTTpEb2N1 bWVudElEPSJ4bXAuZGlkOjdDMkI3MjMyOEExNzExRTY5MDUyRTk1NEIyREUwNjVCIiB4bXBNTTpJ bnN0YW5jZUlEPSJ4bXAuaWlkOjdDMkI3MjMxOEExNzExRTY5MDUyRTk1NEIyREUwNjVCIiB4bXA6 Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDQyAyMDE1LjUgKFdpbmRvd3MpIj4gPHhtcE1N OkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1 LTgxYmQtMTYwMTFjZjk5YWVjIiBzdFJlZjpkb2N1bWVudElEPSJ4bXAuZGlkOmRkMGY5MmM1LTc4 YWYtY2U0NS04MWJkLTE2MDExY2Y5OWFlYyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRG PiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pv/uAA5BZG9iZQBkwAAAAAH/2wCEAAYE BAQFBAYFBQYJBgUGCQsIBgYICwwKCgsKCgwQDAwMDAwMEAwODxAPDgwTExQUExMcGxsbHB8fHx8f Hx8fHx8BBwcHDQwNGBAQGBoVERUaHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f Hx8fHx8fHx8fHx8fH//AABEIABwAKgMBEQACEQEDEQH/xAB3AAEBAQEBAAAAAAAAAAAAAAAABwUI BgEBAAMBAQAAAAAAAAAAAAAAAAMEBQIBEAABAwIEBwEBAQAAAAAAAAABAgMEAAUREhMGITFBFBUH CIEiFhEAAgIBAgQHAAAAAAAAAAAAAAERAgMxBCHBEgVBUWGBQhMV/9oADAMBAAIRAxEAPwDC9g7u 3dH33uJiNeri2wxcJQQ01JfCUNodVwCUqwSlI/AK3sGKropS0Kd7OWZMXcPsyZDdnQ7he5UFhQQ/ LZelOMoURiEqWlRAOFdumNOGqyeTYtPzFfL1df8ASm5XCTP0ey0e5eceyZu4zZc5VhjlGOFZ/cKJ dMKNeRNhbclzrOJxQCgOSW7o5a/oKXMRFXNT5iYw/EaAUtbL61tOBKTwXglWOXrW30zgj0RUmLlb 9p3rZ/r/ANd3GxWJtm3XC8B1EO2RsEqDkng88pAP8JSnEk8ugqlt6Xy5Fa3FImyNVUI8z8nJCU7o SOSRAA/O5qbuXx9+Rxg8ToGsssCgFAc/7q+b9xXrc11u7V3iNN3CW/JbQUuhaUuuFYBIHMA9K08e +rWqUPgivbC25MofK25Qoq81DKjwKlJeUT+kE13+jXyZ59DKX6a9WXPYfmO+msTPJdtp6AWMuhq4 5swHPVFVN1uFkiFoS46dJSqqEgoBQCgFAKAUAoBQH//Z ------=_Part_37643343_1124091921.1494519067933 Content-Type: image/jpeg; name=element-signature_payzen_61x28.jpg Content-Disposition: attachment; filename=element-signature_payzen_61x28.jpg Content-Transfer-Encoding: base64 Content-ID: <86ad24eaa2a146e1b7ee93db04f055468345dc13@zimbra> /9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QOBaHR0cDov L25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1TTBNcENl aGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIiB4 OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzEzMiA3OS4xNTkyODQsIDIwMTYvMDQvMTktMTM6 MTM6NDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5 OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSIiIHht bG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0i aHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1sbnM6eG1w PSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bXBNTTpPcmlnaW5hbERvY3VtZW50SUQ9 InhtcC5kaWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1LTgxYmQtMTYwMTFjZjk5YWVjIiB4bXBNTTpEb2N1 bWVudElEPSJ4bXAuZGlkOkU1NjczQjM2OEEzNDExRTZCOEJBQ0Y4Mzg3RTEzODkyIiB4bXBNTTpJ bnN0YW5jZUlEPSJ4bXAuaWlkOkU1NjczQjM1OEEzNDExRTZCOEJBQ0Y4Mzg3RTEzODkyIiB4bXA6 Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDQyAyMDE1LjUgKFdpbmRvd3MpIj4gPHhtcE1N OkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6ZGQwZjkyYzUtNzhhZi1jZTQ1 LTgxYmQtMTYwMTFjZjk5YWVjIiBzdFJlZjpkb2N1bWVudElEPSJ4bXAuZGlkOmRkMGY5MmM1LTc4 YWYtY2U0NS04MWJkLTE2MDExY2Y5OWFlYyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRG PiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pv/uAA5BZG9iZQBkwAAAAAH/2wCEAAYE BAQFBAYFBQYJBgUGCQsIBgYICwwKCgsKCgwQDAwMDAwMEAwODxAPDgwTExQUExMcGxsbHB8fHx8f Hx8fHx8BBwcHDQwNGBAQGBoVERUaHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f Hx8fHx8fHx8fHx8fH//AABEIABwAPQMBEQACEQEDEQH/xABvAAABBAMAAAAAAAAAAAAAAAAAAQUG BwIDBAEBAAAAAAAAAAAAAAAAAAAAABAAAQQABAQEAgsBAAAAAAAAAQIDBAUAERIGITETFEEiFQfS I1FhcYGhMlIkRMQWhhEBAAAAAAAAAAAAAAAAAAAAAP/aAAwDAQACEQMRAD8AvqZ7q7OhzZMSS9IQ Yjy2JT/avqZbW2rSvU6lBSACOeeAljLzTzSHmVhxpxIW24k5pUlQzBBHgRgM8BBJ9fKuvcGwr3La wgxIlfGeaagyVsJ1uOOBRUBmOSRgI0bnZgfQwdx7qDrroYZSVzBrcJ0hKM2xq+7AWBU7PTXTEShc 2svRx6MuWp5o5gjigj68BombFRKmPyTfXTPXWpzoszloaRqOelCQPKkeAwEP6lp6f6V6vYaP9Z6b 3fcr7ntuhno6vPnxwGyohb2ntbpr6Y17NdKt7Bp5+YHlPJLitKyltI0KGk+XPANVgzV1Eyyqbe3s IMmnhsMbVaYcebDraY+XVbQ15XXFOghQVnkMBkbjcVPTUs6M5IkPbnpWa1hKlrWG7QZBp0hROnUh xRUfHTgJDWuwtsbptVTpC1xaqhgJfkuFTji9DjoKiTmpSlq/HAcO2d11d/cuXUySJG4C0+NvbfCH CmK2hClHUop0GQ6E+dWfAeUYBi2lY2E+zgW7twhVlHDk+7AkzFO9u2lRdjORFIEZrTmAkA+GYwDl TwLJhjZFouxsF3NzN6r7Lj7imExHUOSHWi0TpyCdORIzzwHT/J/7n+vgLVAA5YBChBUlRSCpOelR HEZ88sA2WG3YVhb1lnJW4VVJcXFjAgM9VxOjqKTlmVJTnp48M8Ax2+3N3J3TJu6KVAbRKisxnWpr brh+SpasxoKf14BBD91hxE2kB+nt5Px4AEL3VGoiZSAr4qyjyOP2+fAL2nuvw/e0vDl8iT8eAbv8 Lur0vPvYXrPrfrfU6bvb59Lp6NOev83HngLBwBgDAGAMAYAwBgP/2Q== ------=_Part_37643343_1124091921.1494519067933-- ------=_Part_37643342_929927371.1494519067933--
On Thu, May 11, 2017 at 7:11 PM, Nelson Lameiras < nelson.lameiras@lyra-network.com> wrote:
Hello,
Not sure if I should post here, or on the dev mailling list.
I had a serious problem when upgrading an oVirt cluster from 3.6 to 4.0 (before updating to 4.1)
The error on engine-setup log was : "schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt- engine/dbscripts/upgrade/04_00_0930_disallow_boot_protocol_to_be_null.sql"
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. I'm guessing this is an "exotic situation" which shouldn't exist... in theory ;)
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' by adding the following line "update network_attachments set boot_protocol ='NONE' where boot_protocol is null;"
If a dev want to discuss it further, I'll be happy to explain my thoughts on this matter.
Doing the above might be enough for engine-setup to finish, but it might introduce a risk. Ideally we should find the root cause leading to this state and: 1. Make sure it can't happen anymore 2. Fully fix the data - might require more than just the above update. 3. Alternatively, add a check earlier and notify the user to fix this manually. Adding Dan for further analysis. Thanks for the report! Best,
cordialement, regards,
<https://www.lyra-network.com/> Nelson LAMEIRAS Ingénieur Systèmes et Réseaux / Systems and Networks engineer Tel: +33 5 32 09 09 70 <+33%205%2032%2009%2009%2070> nelson.lameiras@lyra-network.com www.lyra-network.com | www.payzen.eu <https://payzen.eu> <https://www.youtube.com/channel/UCrVl1CO_Jlu3KbiRH-tQ_vA> <https://www.linkedin.com/company/lyra-network_2> <https://twitter.com/LyraNetwork> <https://payzen.eu> ------------------------------ Lyra Network, 109 rue de l'innovation, 31670 Labège, FRANCE
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Didi
participants (2)
-
Nelson Lameiras -
Yedidyah Bar David