Missing migrate20210506-BriefcaseApi.pl

[ochm]

While upgrading from 8.8.15_GA_3869 to 9.0.0_ZEXTRAS_20231104 the process endings with:
Stopping zimbra services...done.
This appears to be 8.8.15_GA
Starting mysql...done.
Checking ldap status...not running.
Checking ldap status...not running.
Starting ldap...done.
Running mysql_upgrade...done.
Schema upgrade required from version 111 to 112.
Can't run /opt/zimbra/libexec/scripts/migrate20210506-BriefcaseApi.pl - not executable!
UPGRADE FAILED - exiting.
The mentioned file really does not exist. After reboot of zimbra server everything seems to be OK, and runs at version 9:
$ zmcontrol -v
Release 9.0.0_ZEXTRAS_20231104.RHEL8_64_20231124123142 RHEL8_64 FOSS edition.

but i'm not sure about the error above.

Any idea what to check or is there something to repair?

Sincerely

--
Martin

[yogesh.dasi]

Is the file /opt/zimbra/libexec/scripts/migrate20210506-BriefcaseApi.pl missing or its not executable? This file should have executable permission, could you share the output of
ls -la /opt/zimbra/libexec/scripts/migrate20210506-BriefcaseApi.pl

[ArchanfelHUN]

Same here. But those files are exsist in a fresh installation.
My workaround is:
Install zimbra 9 with install.sh -s to a different server.
Copy everything from the /opt/zimbra/libexec/scripts folder what is missing from the production server.
Redo the upgrade.
Profit.

[Klug]

Here's the (missing) files list:

Code: Select all

root@server:/opt/zimbra/libexec/scripts# ll
total 640
drwxr-xr-x 2 root root 12288 Apr  5  2023 ./
drwxrwxr-x 4 root root  4096 Dec 19 10:45 ../
-rwxrwxr-x 1 root root  2920 Nov 12  2021 clearArchivedFlag.pl*
-rwxrwxr-x 1 root root  1436 Nov 12  2021 fixConversationCounts.pl*
-rwxrwxr-x 1 root root  2115 Nov 12  2021 fixup20080410-SetRsvpTrue.pl*
-rwxrwxr-x 1 root root  1277 Nov 12  2021 fixZeroChangeIdItems.pl*
-rwxrwxr-x 1 root root  3061 Nov 12  2021 migrate20050517-AddUnreadColumn.pl*
-rwxrwxr-x 1 root root  2783 Nov 12  2021 migrate20050531-RemoveCascadingDeletes.pl*
-rwxrwxr-x 1 root root  2698 Nov 12  2021 migrate20050609-AddDateIndex.pl*
-rwxrwxr-x 1 root root  5139 Nov 12  2021 migrate20050628-ShrinkSyncColumns.pl*
-rwxrwxr-x 1 root root  5233 Nov 12  2021 migrate20050701-SchemaCleanup.pl*
-rwxrwxr-x 1 root root  3129 Nov 12  2021 migrate20050721-MailItemIndexes.pl*
-rwxrwxr-x 1 root root  3356 Nov 12  2021 migrate20050727a-Volume.pl*
-rwxrwxr-x 1 root root  3103 Nov 12  2021 migrate20050727-RemoveTypeInvite.pl*
-rwxrwxr-x 1 root root  2322 Nov 12  2021 migrate20050804-SpamToJunk.pl*
-rwxrwxr-x 1 root root  1114 Nov 12  2021 migrate20050809-AddConfig.pl*
-rwxrwxr-x 1 root root  3108 Nov 12  2021 migrate20050811-WipeAppointments.pl*
-rwxrwxr-x 1 root root  1237 Nov 12  2021 migrate20050818-TagsFlagsIndexes.pl*
-rwxrwxr-x 1 root root  1379 Nov 12  2021 migrate20050822-TrackChangeDate.pl*
-rwxrwxr-x 1 root root  1066 Nov 12  2021 migrate20050824-AddMailTransport.sh*
-rwxrwxr-x 1 root root  1741 Nov 12  2021 migrate20050824a-Volume.pl*
-rwxrwxr-x 1 root root  1767 Nov 12  2021 migrate20050831-SecondaryMsgVolume.pl*
-rwxrwxr-x 1 root root  4390 Nov 12  2021 migrate20050916-Volume.pl*
-rwxrwxr-x 1 root root  1220 Nov 12  2021 migrate20050920-CompressionThreshold.pl*
-rwxrwxr-x 1 root root  1056 Nov 12  2021 migrate20050927-DropRedologSequence.pl*
-rwxrwxr-x 1 root root  1093 Nov 12  2021 migrate20051021-UniqueVolume.pl*
-rwxrwxr-x 1 root root  1258 Nov 12  2021 migrate20060120-Appointment.pl*
-rwxrwxr-x 1 root root  1946 Nov 12  2021 migrate20060412-NotebookFolder.pl*
-rwxrwxr-x 1 root root  1826 Nov 12  2021 migrate20060515-AddImapId.pl*
-rwxrwxr-x 1 root root  2192 Nov 12  2021 migrate20060518-EmailedContactsFolder.pl*
-rwxrwxr-x 1 root root  1420 Nov 12  2021 migrate20060708-FlagCalendarFolder.pl*
-rwxrwxr-x 1 root root  1723 Nov 12  2021 migrate20060803-CreateMailboxMetadata.pl*
-rwxrwxr-x 1 root root   823 Nov 12  2021 migrate20060807-WikiDigestFixup.sh*
-rwxrwxr-x 1 root root  1594 Nov 12  2021 migrate20060810-PersistFolderCounts.pl*
-rwxrwxr-x 1 root root 10787 Nov 12  2021 migrate20060911-MailboxGroup.pl*
-rwxrwxr-x 1 root root  1273 Nov 12  2021 migrate20060929-TypedTombstones.pl*
-rwxrwxr-x 1 root root  4294 Nov 12  2021 migrate20061101-IMFolder.pl*
-rwxrwxr-x 1 root root  4209 Nov 12  2021 migrate20061117-TasksFolder.pl*
-rwxrwxr-x 1 root root  2518 Nov 12  2021 migrate20061120-AddNameColumn.pl*
-rwxrwxr-x 1 root root  1591 Nov 12  2021 migrate20061204-CreatePop3MessageTable.pl*
-rwxrwxr-x 1 root root  2264 Nov 12  2021 migrate20061205-UniqueAppointmentIndex.pl*
-rwxrwxr-x 1 root root  1368 Nov 12  2021 migrate20061212-RepairMutableIndexIds.pl*
-rwxrwxr-x 1 root root  1111 Nov 12  2021 migrate20061221-RecalculateFolderSizes.pl*
-rwxrwxr-x 1 root root  1133 Nov 12  2021 migrate20070302-NullContactVolumeId.pl*
-rwxrwxr-x 1 root root  1237 Nov 12  2021 migrate20070306-Pop3MessageUid.pl*
-rwxrwxr-x 1 root root  1382 Nov 12  2021 migrate20070606-WidenMetadata.pl*
-rwxrwxr-x 1 root root  4486 Nov 12  2021 migrate20070614-BriefcaseFolder.pl*
-rwxrwxr-x 1 root root  1153 Nov 12  2021 migrate20070627-BackupTime.pl*
-rwxrwxr-x 1 root root 10883 Nov 12  2021 migrate20070629-IMTables.pl*
-rwxrwxr-x 1 root root  1137 Nov 12  2021 migrate20070630-LastSoapAccess.pl*
-rwxrwxr-x 1 root root  1372 Nov 12  2021 migrate20070703-ScheduledTask.pl*
-rwxrwxr-x 1 root root  1188 Nov 12  2021 migrate20070706-DeletedAccount.pl*
-rwxrwxr-x 1 root root  1106 Nov 12  2021 migrate20070713-NullContactBlobDigest.pl*
-rwxrwxr-x 1 root root  2295 Nov 12  2021 migrate20070725-CreateRevisionTable.pl*
-rwxrwxr-x 1 root root  2213 Nov 12  2021 migrate20070726-ImapDataSource.pl*
-rwxrwxr-x 1 root root  3166 Nov 12  2021 migrate20070809-Signatures.pl*
-rwxrwxr-x 1 root root  1591 Nov 12  2021 migrate20070921-ImapDataSourceUidValidity.pl*
-rwxrwxr-x 1 root root   972 Nov 12  2021 migrate20070928-ScheduledTaskIndex.pl*
-rwxrwxr-x 1 root root  1071 Nov 12  2021 migrate20071128-AccountId.pl*
-rwxrwxr-x 1 root root  2578 Nov 12  2021 migrate20071202-DeleteSignatures.pl*
-rwxrwxr-x 1 root root  1788 Nov 12  2021 migrate20071204-deleteOldLDAPUsers.pl*
-rwxrwxr-x 1 root root  2012 Nov 12  2021 migrate20071206-WidenSizeColumns.pl*
-rwxrwxr-x 1 root root  1467 Nov 12  2021 migrate20080130-ImapFlags.pl*
-rwxrwxr-x 1 root root  1227 Nov 12  2021 migrate20080213-IndexDeferredColumn.pl*
-rwxrwxr-x 1 root root  1731 Nov 12  2021 migrate20080909-DataSourceItemTable.pl*
-rwxrwxr-x 1 root root  3829 Nov 12  2021 migrate20080930-MucService.pl*
-rwxrwxr-x 1 root root  1882 Nov 12  2021 migrate20090315-MobileDevices.pl*
-rwxrwxr-x 1 root root  1826 Nov 12  2021 migrate20090406-DataSourceItemTable.pl*
-rwxrwxr-x 1 root root  1198 Nov 12  2021 migrate20090430-highestindexed.pl*
-rwxrwxr-x 1 root root  1209 Nov 12  2021 migrate20100106-MobileDevices.pl*
-rwxrwxr-x 1 root root  1958 Nov 12  2021 migrate20100913-Mysql51.pl*
-rwxrwxr-x 1 root root  5871 Nov 12  2021 migrate20100926-Dumpster.pl*
-rwxrwxr-x 1 root root  1404 Nov 12  2021 migrate20101123-MobileDevices.pl*
-rwxrwxr-x 1 root root  1521 Nov 12  2021 migrate20110314-MobileDevices.pl*
-rwxrwxr-x 1 root root  1688 Nov 12  2021 migrate20110330-RecipientsColumn.pl*
-rwxrwxr-x 1 root root  7533 Nov 12  2021 migrate20110615-AddDynlist.pl*
-rwxrwxr-x 1 root root  1283 Nov 12  2021 migrate20110705-PendingAclPush.pl*
-rwxrwxr-x 1 root root  2744 Nov 12  2021 migrate20110721-AddUnique.pl*
-rwxrwxr-x 1 root root  3534 Nov 12  2021 migrate20110810-TagTable.pl*
-rwxrwxr-x 1 root root  1305 Nov 12  2021 migrate20110928-MobileDevices.pl*
-rwxrwxr-x 1 root root  1155 Nov 12  2021 migrate20110929-VersionColumn.pl*
-rwxrwxr-x 1 root root  2122 Nov 12  2021 migrate20111005-ItemIdCheckpoint.pl*
-rwxrwxr-x 1 root root  2498 Nov 12  2021 migrate20111019-UniqueZimbraId.pl*
-rwxrwxr-x 1 root root  1855 Nov 12  2021 migrate20120125-uuidAndDigest.pl*
-rwxrwxr-x 1 root root  2647 Nov 12  2021 migrate20120210-AddSearchNoOp.pl*
-rwxrwxr-x 1 root root  1198 Nov 12  2021 migrate20120222-LastPurgeAtColumn.pl*
-rwxrwxr-x 1 root root  1704 Nov 12  2021 migrate20120229-DropIMTables.pl*
-rwxrwxr-x 1 root root  1608 Nov 12  2021 migrate20120319-Name255Chars.pl*
-rwxrwxr-x 1 root root  5206 Nov 12  2021 migrate20120410-BlobLocator.pl*
-rwxrwxr-x 1 root root  2497 Nov 12  2021 migrate20120507-UniqueDKIMSelector.pl*
-rwxrwxr-x 1 root root  7105 Nov 12  2021 migrate20120611_7to8_bundle.pl*
-rwxrwxr-x 1 root root  1924 Nov 12  2021 migrate20121009-VolumeBlobs.pl*
-rwxrwxr-x 1 root root  1738 Nov 12  2021 migrate20130226_alwayson.pl*
-rw-rw-r-- 1 root root  2259 Nov 12  2021 migrate20130227-UpgradeCBPolicyDSchema.sql
-rw-rw-r-- 1 root root  5869 Nov 12  2021 migrate20130606-UpdateCBPolicydSchema.sql
-rw-rw-r-- 1 root root  2401 Nov 12  2021 migrate20130819-UpgradeQuotasTable.sql
-rwxrwxr-x 1 root root  6736 Nov 12  2021 migrate20131014-removezca.pl*
-rwxrwxr-x 1 root root  1933 Nov 12  2021 migrate20140319-MailItemPrevFolders.pl*
-rwxrwxr-x 1 root root  1681 Nov 12  2021 migrate20140328-EnforceTableCharset.pl*
-rwxrwxr-x 1 root root  2624 Nov 12  2021 migrate20140624-DropMysqlIndexes.pl*
-rwxrwxr-x 1 root root  1766 Nov 12  2021 migrate20140728-AddSSHA512.pl*
-rwxrwxr-x 1 root root  1692 Nov 12  2021 migrate20141022-AddTLSBits.pl*
-rwxrwxr-x 1 root root   860 Nov 12  2021 migrate20150401-ZmgDevices.pl*
-rwxrwxr-x 1 root root  2115 Nov 12  2021 migrate20150515-DataSourcePurgeTables.pl*
-rwxrwxr-x 1 root root   863 Nov 12  2021 migrate20150623-ZmgDevices.pl*
-rwxrwxr-x 1 root root  1628 Nov 12  2021 migrate20150702-ZmgDevices.pl*
-rwxrwxr-x 1 root root  2722 Nov 12  2021 migrate20150930-AddSyncpovSessionlog.pl*
-rwxrwxr-x 1 root root  1653 Nov 12  2021 migrate20170301-ZimbraChat.pl*
-rwxrwxr-x 1 root root  4469 Nov 12  2021 migrate20180301-ZimbraChat.pl*
-rwxrwxr-x 1 root root  1172 Nov 12  2021 migrate20190401-ZimbraChat.pl*
-rwxrwxr-x 1 root root  3501 Nov 12  2021 migrate20190611-ZimbraChat.pl*
-rwxr-xr-x 1 root root  3258 Dec  1 15:05 migrate20210809-UnsubscribeFolder.pl*
-rwxr-xr-x 1 root root  3564 Apr  3  2023 migrate20220729-FilesShareWithMeFolder.pl*
-rwxrwxr-x 1 root root  1044 Nov 12  2021 migrateAmavisLdap20050810.pl*
-rwxrwxr-x 1 root root  2662 Nov 12  2021 migrateClearSpamFlag.pl*
-rwxrwxr-x 1 root root  6620 Nov 12  2021 migrate-ComboUpdater.pl*
-rwxrwxr-x 1 root root  2437 Nov 12  2021 migrateLargeMetadata.pl*
-rwxrwxr-x 1 root root  1592 Nov 12  2021 migrateLogger1-index.pl*
-rwxrwxr-x 1 root root  1422 Nov 12  2021 migrateLogger2-config.pl*
-rwxrwxr-x 1 root root  1297 Nov 12  2021 migrateLogger3-diskindex.pl*
-rwxrwxr-x 1 root root  1142 Nov 12  2021 migrateLogger4-loghostname.pl*
-rwxrwxr-x 1 root root  1108 Nov 12  2021 migrateLogger5-qid.pl*
-rwxrwxr-x 1 root root  1148 Nov 12  2021 migrateLogger6-qid.pl*
-rwxrwxr-x 1 root root  3144 Nov 12  2021 migrateMailItemTimestamps.pl*
-rw-rw-r-- 1 root root 12451 Nov 12  2021 Migrate.pm
-rwxrwxr-x 1 root root  3122 Nov 12  2021 migratePreWidenSizeColumns.pl*
-rw-rw-r-- 1 root root  4448 Nov 12  2021 migrateRemoveMailboxId.pl
-rwxrwxr-x 1 root root  2132 Nov 12  2021 migrateRemoveTagIndexes.pl*
-rwxrwxr-x 1 root root  4438 Nov 12  2021 migrateRenameIdentifiers.pl*
-rwxrwxr-x 1 root root  5830 Nov 12  2021 migrateSyncSequence.pl*
-rw-rw-r-- 1 root root  6451 Nov 12  2021 migrateToSplitTables.pl
-rwxrwxr-x 1 root root  2888 Nov 12  2021 migrateUpdateAppointment.pl*
-rwxrwxr-x 1 root root  1504 Nov 12  2021 optimizeMboxgroups.pl*

Most of them can get found here: https://github.com/Zimbra/zm-db-conf/tr ... /migration

[liverpoolfcfan]

Here's the (missing) files list:

Most of them can get found here: https://github.com/Zimbra/zm-db-conf/tr ... /migration

The list quoted does not include the file the OP had issues with so, it looks to be incomplete. The OP's missing script is available at the GitHub link you provided, however. Maybe you get a different list downloaded based on what version you are coming from? Perhaps someone from Synacor can confirm if the file list from GitHub is correct.

Is there a possiblilty that if you do not answer "Y" to Use Zimbra Repos that you do not get all the correct scripts downloaded?

[Klug]

Hi.

Well, I went too fast and missed. You are right.

The "missing files list" is from a ZCS NE 9.0.lastpatch server that was installed as 9.0 (no upgrade) on Ubuntu 20.04 LTS (using Synacor's repo).
I re-checked and migrate20210506-BriefcaseApi.pl is not in /opt/zimbra on this server.

The file is also not on a ZCS NE 8.8.15-lastpatch that was installed as 8.8.15 (no upgrade) on Ubuntu 18.04 LTS (using Synacor's repo).
Neither on a ZCS 8.8.15-lastpatch that was installed as 8.8.12 on CentOS 7 (using Synacor's repo and upgraded using the repos too).

Could not find it either on an OSE 8.8.15-lastpatch installed as 8.8.15 on Ubuntu 20.04 LTS (using Synacor's repo).

[umashankar.avagadda]

File migrate20210506-BriefcaseApi.pl is part of ZCS 10.0.0 GA. https://github.com/Zimbra/zm-db-conf/co ... .10.0.0-GA and you are trying to upgrade from 8.8.15_GA_3869 to 9.0.0_ZEXTRAS_20231104 so you shouldn't get this error. There seems to be something wrong with the creation of the build.