migratePreWidenSizeColumns.pl

[adebnar]

Can you run migratePreWidenSizeColumns.pl weeks before actually upgrading the server to 5.0.8 or does it need to be done at the same time of upgrade? What is the rule of thumb on how long it takes to run?

Any help would be appreciated.

Thanks

[brian]

Yes the intent of the script is to reduce upgrade time by running it before you upgrade.

The relevant section from the release notes is below.

Upgrading from 5.0.2 or earlier
To shorten the time it takes to upgrade from 5.0.2 or earlier to 5.0.3 or later,
you may want to run the migratePreWidenSizeColumns.pl script against all or a
subset of mailbox groups in order to reduce the amount of downtime needed
to perform the full upgrade. Schema version 50 introduced in 5.0.3 GA widens
the column size of the revision table in the ZCS database. This script can take
a significant amount of time on large systems.
If you do not run this script before you upgrade, the column size of the revision
table is widened as part of the ZCS upgrade, but this can increase the time it
takes to upgrade.
Run this script on all Zimbra mailbox servers.
1. Before you begin, stop all ZCS processes except mysql
2. Go to the directory where migratePreWidenSizeColumns.pl is located, /opt/
zimbra/libexc/scripts/.
3. Run migratePreWidenSizeColumns.pl -g
If you run this without options, you will see how many mailbox groups need
to be upgraded and you can set the number of accounts to be processed at
a time.