<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>FWIW we no longer upgrade mailbox servers; it's too risky as you saw and creates too much downtime for the users.</div><div><br data-mce-bogus="1"></div><div>Instead, we upgrade the LDAP, MTA and Proxy hosts to the new version of Zimbra, then we deploy new mailbox server(s) at that same newest version level, making one of them a logger host. We then move mailboxes from the old, un-upgraded mailbox server(s) to the newer mailbox server(s) and configure logging on all the remaining Zimbra servers to go to the new logger host (which has to be a mailbox server). A quick run of zmdedupe on the new mailbox server(s) after all the mailboxes are moved and then we run zmprov ds oldmailboxserver(s).domain.com. </div><div><br data-mce-bogus="1"></div><div>No end-user downtime, no elevated blood pressure.</div><div><br data-mce-bogus="1"></div><div>Life is good!</div><div><br data-mce-bogus="1"></div><div>Hope that helps,</div><div>Mark</div><div><br></div><div data-marker="__SIG_PRE__"><div>___________________________________________________________</div><div><strong>A Message From... L. Mark Stone, General Manager</strong></div><div><br></div><div><img src="cid:a4bea7e6817ec11f66fffd1fb27bb159536297c0@zimbra" data-mce-src="https://zmail.otelcotel.com/home/mark.stone@reliablenetworks.com/Briefcase/RelNet_Logo_300x60.png" doc="Briefcase/RelNet_Logo_300x60.png"></div><div><div><span size="2" style="font-size: small;" data-mce-style="font-size: small;"><em>"Uptime. All the time." </em><span size="3" style="font-size: medium;" data-mce-style="font-size: medium;">® <span color="#999999" size="2" style="color: #999999; font-size: small;" data-mce-style="color: #999999; font-size: small;"><a href="http://www.reliablenetworks.com" data-mce-href="http://www.reliablenetworks.com">www.reliablenetworks.com</a></span></span></span></div><p style="margin: 0px;" data-mce-style="margin: 0px;"><i style="color: #ff6600; background-color: #ffffff; font-size: small; text-decoration: underline;" data-mce-style="color: #ff6600; background-color: #ffffff; font-size: small; text-decoration: underline;"></i><br></p><p style="margin: 0px;" data-mce-style="margin: 0px;"><i style="color: #ff6600; background-color: #ffffff; font-size: small; text-decoration: underline;" data-mce-style="color: #ff6600; background-color: #ffffff; font-size: small; text-decoration: underline;">Fourteen Years In Business! 2003 - 2016!</i></p><p style="margin: 0px;" data-mce-style="margin: 0px;"><span size="2" style="font-size: small;" data-mce-style="font-size: small;"><br></span><span size="2" style="color: #333333; font-size: small;" data-mce-style="color: #333333; font-size: small;"><span size="2" style="font-size: small;" data-mce-style="font-size: small;">477 Congress Street, Suite 812</span> | Portland, ME 04101 | (<a onclick="window.top.Com_Zimbra_Phone.unsetOnbeforeunload()" href="callto:+1207%29%20772-5678" data-mce-href="callto:+1207%29%20772-5678">207) 772-5678</a></span></p><div><span size="2" style="font-size: small;" data-mce-style="font-size: small;"> </span></div><div><span size="2" style="font-size: small;" data-mce-style="font-size: small;"><span size="2" style="font-size: small;" data-mce-style="font-size: small;"><span color="#ff6600" style="color: #ff6600;" data-mce-style="color: #ff6600;">Citrix XenApp/XenDesktop Hosting</span> | <span color="#ff6600" style="color: #ff6600;" data-mce-style="color: #ff6600;">SOC 2 Type II Audit </span><br><span color="#ff6600" style="color: #ff6600;" data-mce-style="color: #ff6600;"><i>Zimbra</i></span><span color="#ff6600" style="color: #ff6600;" data-mce-style="color: #ff6600;"> Groupware</span> | <span color="#ff6600" style="color: #ff6600;" data-mce-style="color: #ff6600;">Mission-Critical Cl</span><span color="#ff6600" style="color: #ff6600;" data-mce-style="color: #ff6600;">oud Hosting </span><br></span></span></div><div><br></div><div><a data-mce-href="https://www.linkedin.com/pub/l-mark-stone/15/264/277" href="https://www.linkedin.com/pub/l-mark-stone/15/264/277" target="_blank" title="View L. Mark Stone's profile on LinkedIn"><img src="cid:498df3b220360067bae805a9f3fa903ddf309bb6@zimbra" data-mce-src="https://zmail.otelcotel.com/home/lmark.stone@reliablenetworks.com/Briefcase/btn_viewmy_160x33.png" doc="Briefcase/btn_viewmy_160x33.png"></a></div><div><br></div><div><span size="2" style="font-size: small;" data-mce-style="font-size: small;">This email may contain information that is privileged and confidential.<br>If you suspect that you were not intended to receive it, please delete<br>it and notify us as soon as possible. Thank you.</span></div></div></div><br><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><blockquote style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;" data-mce-style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><b>From: </b>"Steve Hillman" <hillman@sfu.ca><br><b>To: </b>users@lists.zetalliance.org<br><b>Sent: </b>Thursday, September 1, 2016 4:02:56 PM<br><b>Subject: </b>Re: [Users] 8.7.0 Upgrade Bugs<br></blockquote></div><div data-marker="__QUOTED_TEXT__"><blockquote style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;" data-mce-style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><div style="font-family: Verdana; font-size: 10pt; color: #000000;" data-mce-style="font-family: Verdana; font-size: 10pt; color: #000000;"><div>We also ran into an issue going directly from 8.0.7 to 8.7 on our Mailbox servers. The migration step that modifies the schema of the mail_items table would fail part way through, but not at exactly the same place on each mailbox server. Of course once it fails, your upgrade is toast. </div><br><div>The actual migration step that was failing though was introduced long before 8.7, and when we did a test upgrade to 8.6 last February, it worked. So to work around the issue, I upgraded each mailbox server first from 8.0.7 to 8.6, and then from 8.6 to 8.7. That seems to have worked</div><br><hr id="zwchr"><blockquote style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;" data-mce-style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000;" data-mce-style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000;"><div>On today's Zetalliance call, my blog post about caution when upgrading to 8.7.0 noted several upgrade bugs, and callers wanted to compose and track a more comprehensive list of such bugs which might cause an upgrade to 8.7.0 to fail.</div><br><div>My blog post may be found at https://www.reliablenetworks.com/zimbra-8-7-0-fine-new-installs-wait-little-longer-though-upgrade/</div><br><div>The specific bugs mentioned therein are:</div><br><div><p style="box-sizing: border-box; margin: 0px; color: #5c6b80; font-family: 'Source Sans Pro', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; line-height: 24px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff;" data-mce-style="box-sizing: border-box; margin: 0px; color: #5c6b80; font-family: 'Source Sans Pro', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; line-height: 24px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff;"><a href="https://bugzilla.zimbra.com/show_bug.cgi?id=105942" target="_blank" style="box-sizing: border-box; color: #ee600d; text-decoration: none; outline: none; background: transparent;" data-mce-style="box-sizing: border-box; color: #ee600d; text-decoration: none; outline: none; background: transparent;">https://bugzilla.zimbra.com/show_bug.cgi?id=105942</a> <= Older Zimbra installs will have MySQL errors<br style="box-sizing: border-box;" data-mce-style="box-sizing: border-box;"><a href="https://bugzilla.zimbra.com/show_bug.cgi?id=104451" target="_blank" style="box-sizing: border-box; color: #ee600d; text-decoration: none; outline: none; background: transparent;" data-mce-style="box-sizing: border-box; color: #ee600d; text-decoration: none; outline: none; background: transparent;">https://bugzilla.zimbra.com/show_bug.cgi?id=104451</a> <= One should maintain their own Zimbra repository<br style="box-sizing: border-box;" data-mce-style="box-sizing: border-box;"><a href="https://bugzilla.zimbra.com/show_bug.cgi?id=105945" target="_blank" style="box-sizing: border-box; color: #ee600d; text-decoration: none; outline: none; background: transparent;" data-mce-style="box-sizing: border-box; color: #ee600d; text-decoration: none; outline: none; background: transparent;">https://bugzilla.zimbra.com/show_bug.cgi?id=105945</a> <= Fallout from above<br style="box-sizing: border-box;" data-mce-style="box-sizing: border-box;"><a href="https://bugzilla.zimbra.com/show_bug.cgi?id=106204" target="_blank" style="box-sizing: border-box; color: #ee600d; text-decoration: none; outline: none; background: transparent;" data-mce-style="box-sizing: border-box; color: #ee600d; text-decoration: none; outline: none; background: transparent;">https://bugzilla.zimbra.com/show_bug.cgi?id=106204</a> <= Zimbra systems with Patches fail upgrade to 8.7</p></div><br><div>Hope that helps,</div><div>Mark</div><div><div>___________________________________________________________</div><div><strong>A Message From... L. Mark Stone, General Manager</strong></div><br><div><img src="cid:da0b30bcfe83e731a7c777a3a83c3fb0d2f7827c@zimbra"></div><div><div><span style="font-size: small;" data-mce-style="font-size: small;"><em>"Uptime. All the time." </em><span style="font-size: medium;" data-mce-style="font-size: medium;">® <span style="color: #999999; font-size: small;" data-mce-style="color: #999999; font-size: small;"><a href="http://www.reliablenetworks.com" target="_blank">www.reliablenetworks.com</a></span></span></span></div><p style="margin: 0px;" data-mce-style="margin: 0px;"><i style="color: #ff6600; background-color: #ffffff; font-size: small; text-decoration: underline;" data-mce-style="color: #ff6600; background-color: #ffffff; font-size: small; text-decoration: underline;"></i><br></p><p style="margin: 0px;" data-mce-style="margin: 0px;"><i style="color: #ff6600; background-color: #ffffff; font-size: small; text-decoration: underline;" data-mce-style="color: #ff6600; background-color: #ffffff; font-size: small; text-decoration: underline;">Fourteen Years In Business! 2003 - 2016!</i></p><p style="margin: 0px;" data-mce-style="margin: 0px;"><span style="font-size: small;" data-mce-style="font-size: small;"><br></span><span style="color: #333333; font-size: small;" data-mce-style="color: #333333; font-size: small;"><span style="font-size: small;" data-mce-style="font-size: small;">477 Congress Street, Suite 812</span> | Portland, ME 04101 | (<a href="callto:+1207%29%20772-5678" target="_blank">207) 772-5678</a></span></p><div><span style="font-size: small;" data-mce-style="font-size: small;"> </span></div><div><span style="font-size: small;" data-mce-style="font-size: small;"><span style="font-size: small;" data-mce-style="font-size: small;"><span style="color: #ff6600;" data-mce-style="color: #ff6600;">Citrix XenApp/XenDesktop Hosting</span> | <span style="color: #ff6600;" data-mce-style="color: #ff6600;">SOC 2 Type II Audit </span><br><span style="color: #ff6600;" data-mce-style="color: #ff6600;"><i>Zimbra</i></span><span style="color: #ff6600;" data-mce-style="color: #ff6600;"> Groupware</span> | <span style="color: #ff6600;" data-mce-style="color: #ff6600;">Mission-Critical Cl</span><span style="color: #ff6600;" data-mce-style="color: #ff6600;">oud Hosting </span><br></span></span></div><br><div><a href="https://www.linkedin.com/pub/l-mark-stone/15/264/277" target="_blank" title="View L. Mark Stone's profile on LinkedIn"><img src="cid:aa01ec0e057b100fb26a5146bea0ac14a8311175@zimbra"></a></div><br><div><span style="font-size: small;" data-mce-style="font-size: small;">This email may contain information that is privileged and confidential.<br>If you suspect that you were not intended to receive it, please delete<br>it and notify us as soon as possible. Thank you.</span></div></div></div></div></blockquote><div><br><br></div><br><div>-- <br></div><div><span></span>Steve Hillman IT Architect <br>hillman@sfu.ca IT Services <br>778-782-3960 Simon Fraser University <br><span></span></div></div><br></blockquote></div></div></body></html>