After upgrading Xibo for Docker v3.0.0-rc1 to 3.0.0-rc2 (on Ubuntu 20.04.1 LTS), the login page keeps showing “The CMS is temporarily off-line as an upgrade is in progress. Please check with your system administrator for updates or refresh your page in a few minutes.”, no login possible.
The Logs of the cms-web container are as follows:
cms-web_1 | Waiting for MySQL to start - max 300 seconds
cms-web_1 | MySQL started
cms-web_1 | Updating settings.php
cms-web_1 | settingId
cms-web_1 | 3
cms-web_1 | Existing Database, checking if we need to upgrade it
cms-web_1 | Phinx by CakePHP - https://phinx.org. 0.9.2
cms-web_1 |
cms-web_1 | using config file .varwwwcmsphinx.php
cms-web_1 | using config parser php
cms-web_1 | using migration paths
cms-web_1 | - /var/www/cms/db/migrations
cms-web_1 | warning no environment specified, defaulting to: production
cms-web_1 | ordering by creation time
cms-web_1 |
cms-web_1 | Status [Migration ID] Started Finished Migration Name
cms-web_1 | ----------------------------------------------------------------------------------
cms-web_1 | up 20180130073838 2021-01-08 22:57:15 2021-01-08 22:57:21 InstallMigration
cms-web_1 | up 20180131113100 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep85Migration
cms-web_1 | up 20180131113853 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep86Migration
cms-web_1 | up 20180131113941 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep87Migration
cms-web_1 | up 20180131113948 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep88Migration
cms-web_1 | up 20180131113952 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep92Migration
cms-web_1 | up 20180131113957 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep120Migration
cms-web_1 | up 20180131114002 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep121Migration
cms-web_1 | up 20180131114007 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep122Migration
cms-web_1 | up 20180131114013 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep123Migration
cms-web_1 | up 20180131114017 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep124Migration
cms-web_1 | up 20180131114021 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep125Migration
cms-web_1 | up 20180131114025 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep126Migration
cms-web_1 | up 20180131114030 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep127Migration
cms-web_1 | up 20180131114050 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep128Migration
cms-web_1 | up 20180131114058 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep129Migration
cms-web_1 | up 20180131114103 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep130Migration
cms-web_1 | up 20180131114107 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep131Migration
cms-web_1 | up 20180131114110 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep132Migration
cms-web_1 | up 20180131114114 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep133Migration
cms-web_1 | up 20180131114118 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep134Migration
cms-web_1 | up 20180131114123 2021-01-08 22:57:21 2021-01-08 22:57:21 OldUpgradeStep135Migration
cms-web_1 | up 20180131122645 2021-01-08 22:57:21 2021-01-08 22:57:22 OneRegionPerPlaylistMigration
cms-web_1 | up 20180131123038 2021-01-08 22:57:22 2021-01-08 22:57:22 PlaylistTagsMigration
cms-web_1 | up 20180131123248 2021-01-08 22:57:22 2021-01-08 22:57:22 WidgetFromToDtMigration
cms-web_1 | up 20180212143336 2021-01-08 22:57:22 2021-01-08 22:57:22 DaypartSystemEntriesAsRecords
cms-web_1 | up 20180213173846 2021-01-08 22:57:22 2021-01-08 22:57:22 MailFromNameSettingMigration
cms-web_1 | up 20180219141257 2021-01-08 22:57:22 2021-01-08 22:57:23 DisplayGroupClosureIndexToNonUnique
cms-web_1 | up 20180223180534 2021-01-08 22:57:23 2021-01-08 22:57:23 DataSetColumnFilterAndSortOptionsMigration
cms-web_1 | up 20180302182421 2021-01-08 22:57:23 2021-01-08 22:57:23 WidgetCreatedAndModifiedDtMigration
cms-web_1 | up 20180313085749 2021-01-08 22:57:23 2021-01-08 22:57:23 MediaTableEditedIdIndexMigration
cms-web_1 | up 20180320154652 2021-01-08 22:57:23 2021-01-08 22:57:24 PlaylistAddDynamicFilterMigration
cms-web_1 | up 20180327153325 2021-01-08 22:57:24 2021-01-08 22:57:24 RemoveUserLoggedInMigration
cms-web_1 | up 20180514114415 2021-01-08 22:57:24 2021-01-08 22:57:24 FixCaseOnHelpTextFieldMigration
cms-web_1 | up 20180515123835 2021-01-08 22:57:24 2021-01-08 22:57:24 LayoutPublishDraftMigration
cms-web_1 | up 20180529065816 2021-01-08 22:57:24 2021-01-08 22:57:25 DataSetTruncateFixMigration
cms-web_1 | up 20180529073531 2021-01-08 22:57:25 2021-01-08 22:57:25 DisplayAsVncLinkMigration
cms-web_1 | up 20180621134013 2021-01-08 22:57:25 2021-01-08 22:57:25 AddWidgetSyncTaskMigration
cms-web_1 | up 20180621134250 2021-01-08 22:57:25 2021-01-08 22:57:25 EventLayoutPermissionSettingMigration
cms-web_1 | up 20180906115552 2021-01-08 22:57:25 2021-01-08 22:57:25 AddForeignKeysToTagsMigration
cms-web_1 | up 20180906115606 2021-01-08 22:57:25 2021-01-08 22:57:25 AddForeignKeysToPermissionsMigration
cms-web_1 | up 20180906115712 2021-01-08 22:57:25 2021-01-08 22:57:25 AddForeignKeysToWidgetMediaMigration
cms-web_1 | up 20180906131643 2021-01-08 22:57:25 2021-01-08 22:57:25 ForgottenPasswordReminderMigration
cms-web_1 | up 20180906131716 2021-01-08 22:57:25 2021-01-08 22:57:25 DataSetRssMigration
cms-web_1 | up 20181011160130 2021-01-08 22:57:25 2021-01-08 22:57:26 SimpleSettingsMigration
cms-web_1 | up 20181113173310 2021-01-08 22:57:26 2021-01-08 22:57:26 RemoveFinanceModuleMigration
cms-web_1 | up 20181113180337 2021-01-08 22:57:27 2021-01-08 22:57:27 SplitTickerModuleMigration
cms-web_1 | up 20181126113231 2021-01-08 22:57:27 2021-01-08 22:57:27 Release1812Migration
cms-web_1 | up 20181210092443 2021-01-08 22:57:27 2021-01-08 22:57:27 RemoveImageUriModuleMigration
cms-web_1 | up 20181212114400 2021-01-08 22:57:27 2021-01-08 22:57:27 CreatePlayerVersionsTableMigration
cms-web_1 | up 20181217135044 2021-01-08 22:57:27 2021-01-08 22:57:27 EventSyncMigration
cms-web_1 | up 20190121092556 2021-01-08 22:57:27 2021-01-08 22:57:27 PlayerUpgradeAndOverrideConfigMigration
cms-web_1 | up 20190125170130 2021-01-08 22:57:27 2021-01-08 22:57:28 PlayerSoftwareVersionFieldMigration
cms-web_1 | up 20190129103831 2021-01-08 22:57:28 2021-01-08 22:57:28 AddLinuxDisplayProfileMigration
cms-web_1 | up 20190212112534 2021-01-08 22:57:28 2021-01-08 22:57:28 AddProofOfPlayStatsDurationAndCountMigration
cms-web_1 | up 20190212115432 2021-01-08 22:57:28 2021-01-08 22:57:28 AddDefaultTransitionDurationSettingMigration
cms-web_1 | up 20190213160914 2021-01-08 22:57:28 2021-01-08 22:57:28 AddGlobalStatSettingMigration
cms-web_1 | up 20190213162212 2021-01-08 22:57:28 2021-01-08 22:57:28 AddHorizontalMenuSettingMigration
cms-web_1 | up 20190214102508 2021-01-08 22:57:28 2021-01-08 22:57:28 AddLayoutEnableStat
cms-web_1 | up 20190214102516 2021-01-08 22:57:28 2021-01-08 22:57:28 AddMediaEnableStat
cms-web_1 | up 20190220165703 2021-01-08 22:57:28 2021-01-08 22:57:28 AddScheduleRecurrenceMonthlyRepeatsOnMigration
cms-web_1 | up 20190227101705 2021-01-08 22:57:28 2021-01-08 22:57:28 MakeDisplayLicenseColumnUniqueMigration
cms-web_1 | up 20190228120603 2021-01-08 22:57:28 2021-01-08 22:57:28 AddDynamicCriteriaTagsMigration
cms-web_1 | up 20190301115046 2021-01-08 22:57:28 2021-01-08 22:57:28 AdjustGenericfileValidExtensionsMigration
cms-web_1 | up 20190315134628 2021-01-08 22:57:28 2021-01-08 22:57:28 AddBandwidthLimitColumnToDisplaygroupMigration
cms-web_1 | up 20190322162052 2021-01-08 22:57:28 2021-01-08 22:57:28 AddPublishedDateColumnMigration
cms-web_1 | up 20190326163016 2021-01-08 22:57:28 2021-01-08 22:57:29 CreateLayoutHistoryTableMigration
cms-web_1 | up 20190328111718 2021-01-08 22:57:29 2021-01-08 22:57:29 AddCampaignStatMigration
cms-web_1 | up 20190401150256 2021-01-08 22:57:29 2021-01-08 22:57:29 AddScheduleNowPageMigration
cms-web_1 | up 20190509101525 2021-01-08 22:57:29 2021-01-08 22:57:29 CreateReportScheduleTableMigration
cms-web_1 | up 20190509102648 2021-01-08 22:57:29 2021-01-08 22:57:29 CreateSavedReportTableMigration
cms-web_1 | up 20190509113001 2021-01-08 22:57:29 2021-01-08 22:57:29 AddReportPageMigration
cms-web_1 | up 20190510140126 2021-01-08 22:57:29 2021-01-08 22:57:29 TwoFactorAuthMigration
cms-web_1 | up 20190514134430 2021-01-08 22:57:29 2021-01-08 22:57:30 NullableTextFieldsMigration
cms-web_1 | up 20190515094133 2021-01-08 22:57:30 2021-01-08 22:57:30 AddHtmlDatatypeMigration
cms-web_1 | up 20190515105624 2021-01-08 22:57:30 2021-01-08 22:57:30 InstallAdditionalStandardModulesMigration
cms-web_1 | up 20190517080033 2021-01-08 22:57:30 2021-01-08 22:57:30 AddForeignKeysToLktagTablesMigration
cms-web_1 | up 20190521092700 2021-01-08 22:57:30 2021-01-08 22:57:30 AddReportScheduleTaskMigration
cms-web_1 | up 20190521092930 2021-01-08 22:57:30 2021-01-08 22:57:30 AddPreviousRunDateReportScheduleMigration
cms-web_1 | up 20190521102635 2021-01-08 22:57:30 2021-01-08 22:57:30 PlaylistDurationUpdateAtTimestamp
cms-web_1 | up 20190603083836 2021-01-08 22:57:30 2021-01-08 22:57:30 ChangeStatTableStartEndColumnMigration
cms-web_1 | up 20190610150331 2021-01-08 22:57:30 2021-01-08 22:57:31 TagsWithValuesMigration
cms-web_1 | up 20190611145607 2021-01-08 22:57:31 2021-01-08 22:57:31 RemoveOldVersionTableMigration
cms-web_1 | up 20190612140955 2021-01-08 22:57:31 2021-01-08 22:57:32 DisplayTableDatabaseSchemaAdjustmentsMigration
cms-web_1 | up 20190620112611 2021-01-08 22:57:32 2021-01-08 22:57:32 MoveTidyStatsToStatsArchiveTaskMigration
cms-web_1 | up 20190620142655 2021-01-08 22:57:32 2021-01-08 22:57:32 AddPlaylistEnableStatMigration
cms-web_1 | up 20190626091331 2021-01-08 22:57:32 2021-01-08 22:57:32 WidgetHistoryMigration
cms-web_1 | up 20190626110359 2021-01-08 22:57:32 2021-01-08 22:57:33 CreateStatTableMigration
cms-web_1 | up 20190628083649 2021-01-08 22:57:33 2021-01-08 22:57:33 AddStatsMigrationTaskMigration
cms-web_1 | up 20190710213414 2021-01-08 22:57:33 2021-01-08 22:57:33 AddIsActiveReportScheduleMigration
cms-web_1 | up 20190717101342 2021-01-08 22:57:33 2021-01-08 22:57:33 NullableCommandValidationStringMigration
cms-web_1 | up 20190719074601 2021-01-08 22:57:33 2021-01-08 22:57:33 MissingDefaultValueMigration
cms-web_1 | up 20190725115532 2021-01-08 22:57:33 2021-01-08 22:57:33 AddScheduleReminderTaskMigration
cms-web_1 | up 20190801102042 2021-01-08 22:57:33 2021-01-08 22:57:33 DisplayProfileCommandLinkFixMigration
cms-web_1 | up 20190801141737 2021-01-08 22:57:33 2021-01-08 22:57:33 DatasetAddCustomHeadersColumnMigration
cms-web_1 | up 20190801142302 2021-01-08 22:57:33 2021-01-08 22:57:33 AddDoohUserTypeMigration
cms-web_1 | up 20190802145636 2021-01-08 22:57:33 2021-01-08 22:57:33 CreateScheduleReminderTableMigration
cms-web_1 | up 20190806144729 2021-01-08 22:57:33 2021-01-08 22:57:33 AddShowContentFromMigration
cms-web_1 | up 20190823081448 2021-01-08 22:57:33 2021-01-08 22:57:33 AddImageProcessingTaskMigration
cms-web_1 | up 20190828123735 2021-01-08 22:57:33 2021-01-08 22:57:33 AddDefaultSettingResizeLimitResizeThresholdMigration
cms-web_1 | up 20190903083314 2021-01-08 22:57:33 2021-01-08 22:57:33 AddGlobalSettingForCascadePermissionsMigration
cms-web_1 | up 20190905084201 2021-01-08 22:57:33 2021-01-08 22:57:33 AddSettingForDefaultTransitionTypeMigration
cms-web_1 | up 20190905084642 2021-01-08 22:57:33 2021-01-08 22:57:33 AddSettingForAutoLayoutPublishMigration
cms-web_1 | up 20190910132520 2021-01-08 22:57:33 2021-01-08 22:57:34 DisplayMoveCmsMigration
cms-web_1 | up 20190917093141 2021-01-08 22:57:34 2021-01-08 22:57:34 InterruptLayoutMigration
cms-web_1 | up 20190918090608 2021-01-08 22:57:34 2021-01-08 22:57:34 AddDefaultSettingQuickChartMigration
cms-web_1 | up 20190919154513 2021-01-08 22:57:34 2021-01-08 22:57:34 AddNotificationAttachmentFilenameNonUsersMigration
cms-web_1 | up 20190926135518 2021-01-08 22:57:34 2021-01-08 22:57:34 AddSettingForTransitionAutoApplyToLayoutMigration
cms-web_1 | up 20190926140809 2021-01-08 22:57:34 2021-01-08 22:57:34 InstallSavedReportsAndSpacerModulesMigration
cms-web_1 | up 20191001092651 2021-01-08 22:57:34 2021-01-08 22:57:34 AddNotificationOriginalFilenameMigration
cms-web_1 | up 20191022101141 2021-01-08 22:57:34 2021-01-08 22:57:34 AddCommandEntityToPermissionEntityMigration
cms-web_1 | up 20191024152519 2021-01-08 22:57:34 2021-01-08 22:57:34 AddScheduleExclusionsTableMigration
cms-web_1 | up 20191122114104 2021-01-08 22:57:34 2021-01-08 22:57:34 FixDuplicateModuleFilesMigration
cms-web_1 | up 20191126103120 2021-01-08 22:57:34 2021-01-08 22:57:35 GeoScheduleMigration
cms-web_1 | up 20191126141140 2021-01-08 22:57:35 2021-01-08 22:57:35 RemoteDataSetCsvSourceMigration
cms-web_1 | up 20191205180116 2021-01-08 22:57:35 2021-01-08 22:57:35 AddPlaylistDashboardPageUserMigration
cms-web_1 | up 20200107082625 2021-01-08 22:57:35 2021-01-08 22:57:36 DisplayAddResolutionMigration
cms-web_1 | up 20200115115935 2021-01-08 22:57:36 2021-01-08 22:57:36 AddReportScheduleMessageMigration
cms-web_1 | up 20200122143630 2021-01-08 22:57:36 2021-01-08 22:57:36 AddReleasedRequiredFileMigration
cms-web_1 | up 20200122191232 2021-01-08 22:57:36 2021-01-08 22:57:36 AddCommercialLicenceColumnMigration
cms-web_1 | up 20200129104944 2021-01-08 22:57:36 2021-01-08 22:57:36 AddEngagementsStatsMigration
cms-web_1 | up 20200130165443 2021-01-08 22:57:36 2021-01-08 22:57:36 CountdownModuleAddMigration
cms-web_1 | up 20200311110512 2021-01-08 22:57:36 2021-01-08 22:57:36 AddIsDrawerColumnMigration
cms-web_1 | up 20200311110535 2021-01-08 22:57:36 2021-01-08 22:57:36 CreateActionTableMigration
cms-web_1 | up 20200319093235 2021-01-08 22:57:36 2021-01-08 22:57:36 ChangeInterruptLayoutMigration
cms-web_1 | up 20200401121544 2021-01-08 22:57:36 2021-01-08 22:57:36 AddSystemUserSettingMigration
cms-web_1 | up 20200407143200 2021-01-08 22:57:36 2021-01-08 22:57:37 AddCodeColumnToLayoutMigration
cms-web_1 | up 20200422101006 2021-01-08 22:57:37 2021-01-08 22:57:37 AddDataSetRowLimitMigration
cms-web_1 | up 20200427085958 2021-01-08 22:57:37 2021-01-08 22:57:37 AddReportScheduleStartEndMigration
cms-web_1 | up 20200530103029 2021-01-08 22:57:37 2021-01-08 22:57:37 DisplayRemoteLinksMigration
cms-web_1 | up 20200604103141 2021-01-08 22:57:37 2021-01-08 22:57:38 CommandImprovementsMigration
cms-web_1 | up 20200612141755 2021-01-08 22:57:38 2021-01-08 22:57:38 OauthUpgradeMigration
cms-web_1 | up 20200720092246 2021-01-08 22:57:38 2021-01-08 22:57:38 AddSavedReportSchemaVersionMigration
cms-web_1 | up 20200916134817 2021-02-11 14:18:25 2021-02-11 14:18:25 RemoveOldScreenshotsMigration
cms-web_1 | up 20200917140227 2021-02-11 14:18:25 2021-02-11 14:18:26 DisplayGroupCreatedModifiedDates
cms-web_1 | up 20201007080829 2021-02-11 14:18:26 2021-02-11 14:18:28 AddFoldersMigration
cms-web_1 | up 20201007093511 2021-02-11 14:18:28 2021-02-11 14:18:28 FeaturesMigration
cms-web_1 | up 20201025153753 2021-02-11 14:18:28 2021-02-11 14:18:28 RemoveOldPermissionSettingsMigration
cms-web_1 | up 20210105105646 2021-02-11 14:18:28 2021-02-11 14:18:28 AddMcaasScopeAndRouteMigration
cms-web_1 | up 20210113134628 2021-02-11 14:18:28 2021-02-11 14:18:28 EnableUserSharingFeatureOnUsersGroupMigration
cms-web_1 | up 20210201150259 2021-02-11 14:18:28 2021-02-11 14:18:28 UserOnboardingMigration
cms-web_1 | down 20210305131937 FixDuplicateTagsMigration
cms-web_1 |
cms-web_1 | We will upgrade it, take a backup
cms-web_1 | mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
cms-web_1 | Running database migrations
cms-web_1 | Phinx by CakePHP - https://phinx.org. 0.9.2
cms-web_1 |
cms-web_1 | using config file .varwwwcmsphinx.php
cms-web_1 | using config parser php
cms-web_1 | using migration paths
cms-web_1 | - /var/www/cms/db/migrations
cms-web_1 | warning no environment specified, defaulting to: production
cms-web_1 | using adapter mysql
cms-web_1 | using database cms
cms-web_1 |
cms-web_1 | == 20210305131937 FixDuplicateTagsMigration: migrating
cms-web_1 |
cms-web_1 | In PdoAdapter.php line 134:
cms-web_1 |
cms-web_1 | SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or upda
cms-web_1 | te a parent row: a foreign key constraint fails (`cms`.`lktaglayout`, CONST
cms-web_1 | RAINT `lktaglayout_ibfk_1` FOREIGN KEY (`tagId`) REFERENCES `tag` (`tagId`)
cms-web_1 | )
cms-web_1 |
cms-web_1 |
cms-web_1 | migrate [-c|--configuration CONFIGURATION] [-p|--parser PARSER] [-e|--environment ENVIRONMENT] [-t|--target TARGET] [-d|--date DATE] [-x|--dry-run]
cms-web_1 |
cms-web_1 | Importing ca-certs
cms-web_1 | cp: can't stat '/var/www/cms/ca-certs/*.pem': No such file or directory
cms-web_1 | cp: can't stat '/var/www/cms/ca-certs/*.crt': No such file or directory
cms-web_1 | WARNING: ca-certificates.crt does not contain exactly one certificate or CRL: skipping
cms-web_1 | Setting up Quickchart
cms-web_1 | Configuring Maintenance
cms-web_1 | Removing web/install/index.php from production container
cms-web_1 | Starting cron
cms-web_1 | Starting webserver
cms-web_1 | AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 172.22.0.5. Set the 'ServerName' directive globally to suppress this message
Not sure if this is a general bug in database migration or instance specific?