Xibo Docker 3.1.0 The CMS is temporarily off-line as an upgrade is in progress

CMS Version

3.1.0

Installation Method

Docker

Operating System

Ubuntu 20.04.4 LTS

Issue

After upgrade from 3.0.5 → 3.1.0 Xibo login screen shows text like this:

“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.”

Here’s part of what I get from command: docker-compose logs cms-web

cms-web_1 | up 20210603114231 2022-03-21 10:14:47 2022-03-21 10:14:47 NewCalendarTypeMigration
cms-web_1 | up 20210608142925 2022-03-21 10:14:47 2022-03-21 10:14:47 AddOrientationToResolutionAndMediaMigration
cms-web_1 | up 20210611122809 2022-03-21 10:14:47 2022-03-21 10:14:47 AddPurgeListTableMigration
cms-web_1 | up 20210806122814 2022-03-21 10:14:47 2022-03-21 10:14:47 AddNumberOfItemsToPlaylistMigration
cms-web_1 | up 20210813094723 2022-03-21 10:14:47 2022-03-21 10:14:47 AddCycleBasedPlaybackOptionToCampaignMigration
cms-web_1 | up 20210817105702 2022-03-21 10:14:47 2022-03-21 10:14:47 AddCustomSeparatorToDatasetMigration
cms-web_1 | up 20210820100520 2022-03-21 10:14:47 2022-03-21 10:14:48 AddActionEventTypeMigration
cms-web_1 | up 20210901134913 2022-03-21 10:14:48 2022-03-21 10:14:49 AddIpAddressColumnToAuditLogMigration
cms-web_1 | up 20210901150615 2022-03-21 10:14:49 2022-03-21 10:14:49 AddTooltipAndIsRequiredColumnsMigration
cms-web_1 | up 20211109130951 2022-03-21 10:14:49 2022-03-21 10:14:49 FixOrphanedDisplayGroupsMigration
cms-web_1 | up 20211109134929 2022-03-21 10:14:49 2022-03-21 10:14:49 FixPlaylistManagerUserGroupMigration
cms-web_1 | up 20211109141925 2022-03-21 10:14:49 2022-03-21 10:14:49 DatasetAddOptionToTruncateOnNoNewDataMigration
cms-web_1 | up 20211116153103 2022-03-21 10:14:49 2022-03-21 10:14:49 ConnectorsMigration
cms-web_1 | up 20211231141457 2022-03-21 10:14:49 2022-03-21 10:14:49 AddMoreTagFilteringOptionsMigration
cms-web_1 | up 20211231153355 2022-03-21 10:14:49 2022-03-21 10:14:49 AddIsCustomToDisplayProfileMigration
cms-web_1 | up 20220117150212 2022-03-21 10:14:49 2022-03-21 10:14:49 AddLayoutExchangeConnectorMigration
cms-web_1 | up 20220119124436 2022-03-21 10:14:49 2022-03-21 10:14:49 AddCodeColumnToMenuBoardsMigration
cms-web_1 | up 20220131151346 2022-03-21 10:14:49 2022-03-21 10:14:49 AddDateFormatToDataSetColumnMigration
cms-web_1 | up 20220201163832 2022-03-21 10:14:49 2022-03-21 10:14:49 ReportLogoMigration
cms-web_1 | down 20220203145712 ApplicationsTweaksMigration
cms-web_1 | down 20220207160047 TidyCalendarModuleTypes
cms-web_1 | down 20220224130122 AddResolutionRoutesToDesignScopeMigration
cms-web_1 | down 20220225105237 MergeWeatherWidgets
cms-web_1 | down 20220302152503 LayoutRemoveOrientationMigration
cms-web_1 | down 20220307134554 AddWorldClockMigration
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

Here is full log
docker-compose logs cms-web
Attaching to xibo_cms-web_1
cms-web_1 | Waiting for MySQL to start - max 300 seconds
cms-web_1 | MySQL started
cms-web_1 | Configuring MySQL cnf file
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 2019-12-27 07:52:59 2019-12-27 07:52:59 InstallMigration
cms-web_1 | up 20180131113100 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep85Migration
cms-web_1 | up 20180131113853 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep86Migration
cms-web_1 | up 20180131113941 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep87Migration
cms-web_1 | up 20180131113948 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep88Migration
cms-web_1 | up 20180131113952 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep92Migration
cms-web_1 | up 20180131113957 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep120Migration
cms-web_1 | up 20180131114002 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep121Migration
cms-web_1 | up 20180131114007 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep122Migration
cms-web_1 | up 20180131114013 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep123Migration
cms-web_1 | up 20180131114017 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep124Migration
cms-web_1 | up 20180131114021 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep125Migration
cms-web_1 | up 20180131114025 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep126Migration
cms-web_1 | up 20180131114030 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep127Migration
cms-web_1 | up 20180131114050 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep128Migration
cms-web_1 | up 20180131114058 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep129Migration
cms-web_1 | up 20180131114103 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep130Migration
cms-web_1 | up 20180131114107 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep131Migration
cms-web_1 | up 20180131114110 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep132Migration
cms-web_1 | up 20180131114114 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep133Migration
cms-web_1 | up 20180131114118 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep134Migration
cms-web_1 | up 20180131114123 2019-12-27 07:52:59 2019-12-27 07:52:59 OldUpgradeStep135Migration
cms-web_1 | up 20180131122645 2019-12-27 07:52:59 2019-12-27 07:53:00 OneRegionPerPlaylistMigration
cms-web_1 | up 20180131123038 2019-12-27 07:53:00 2019-12-27 07:53:00 PlaylistTagsMigration
cms-web_1 | up 20180131123248 2019-12-27 07:53:00 2019-12-27 07:53:00 WidgetFromToDtMigration
cms-web_1 | up 20180212143336 2019-12-27 07:53:00 2019-12-27 07:53:00 DaypartSystemEntriesAsRecords
cms-web_1 | up 20180213173846 2019-12-27 07:53:00 2019-12-27 07:53:00 MailFromNameSettingMigration
cms-web_1 | up 20180219141257 2019-12-27 07:53:00 2019-12-27 07:53:00 DisplayGroupClosureIndexToNonUnique
cms-web_1 | up 20180223180534 2019-12-27 07:53:00 2019-12-27 07:53:00 DataSetColumnFilterAndSortOptionsMigration
cms-web_1 | up 20180302182421 2019-12-27 07:53:00 2019-12-27 07:53:00 WidgetCreatedAndModifiedDtMigration
cms-web_1 | up 20180313085749 2019-12-27 07:53:00 2019-12-27 07:53:00 MediaTableEditedIdIndexMigration
cms-web_1 | up 20180320154652 2019-12-27 07:53:00 2019-12-27 07:53:00 PlaylistAddDynamicFilterMigration
cms-web_1 | up 20180327153325 2019-12-27 07:53:00 2019-12-27 07:53:00 RemoveUserLoggedInMigration
cms-web_1 | up 20180514114415 2019-12-27 07:53:00 2019-12-27 07:53:01 FixCaseOnHelpTextFieldMigration
cms-web_1 | up 20180515123835 2019-12-27 07:53:01 2019-12-27 07:53:01 LayoutPublishDraftMigration
cms-web_1 | up 20180529065816 2019-12-27 07:53:01 2019-12-27 07:53:01 DataSetTruncateFixMigration
cms-web_1 | up 20180529073531 2019-12-27 07:53:01 2019-12-27 07:53:01 DisplayAsVncLinkMigration
cms-web_1 | up 20180621134013 2019-12-27 07:53:01 2019-12-27 07:53:01 AddWidgetSyncTaskMigration
cms-web_1 | up 20180621134250 2019-12-27 07:53:01 2019-12-27 07:53:01 EventLayoutPermissionSettingMigration
cms-web_1 | up 20180906115552 2019-12-27 07:53:01 2019-12-27 07:53:01 AddForeignKeysToTagsMigration
cms-web_1 | up 20180906115606 2019-12-27 07:53:01 2019-12-27 07:53:01 AddForeignKeysToPermissionsMigration
cms-web_1 | up 20180906115712 2019-12-27 07:53:01 2019-12-27 07:53:01 AddForeignKeysToWidgetMediaMigration
cms-web_1 | up 20180906131643 2019-12-27 07:53:01 2019-12-27 07:53:01 ForgottenPasswordReminderMigration
cms-web_1 | up 20180906131716 2019-12-27 07:53:01 2019-12-27 07:53:01 DataSetRssMigration
cms-web_1 | up 20181011160130 2019-12-27 07:53:01 2019-12-27 07:53:02 SimpleSettingsMigration
cms-web_1 | up 20181113173310 2019-12-27 07:53:02 2019-12-27 07:53:02 RemoveFinanceModuleMigration
cms-web_1 | up 20181113180337 2019-12-27 07:53:02 2019-12-27 07:53:02 SplitTickerModuleMigration
cms-web_1 | up 20181126113231 2019-12-27 07:53:02 2019-12-27 07:53:02 Release1812Migration
cms-web_1 | up 20181210092443 2019-12-27 07:53:02 2019-12-27 07:53:02 RemoveImageUriModuleMigration
cms-web_1 | up 20181212114400 2019-12-27 07:53:02 2019-12-27 07:53:02 CreatePlayerVersionsTableMigration
cms-web_1 | up 20181217135044 2019-12-27 07:53:02 2019-12-27 07:53:02 EventSyncMigration
cms-web_1 | up 20190121092556 2019-12-27 07:53:02 2019-12-27 07:53:02 PlayerUpgradeAndOverrideConfigMigration
cms-web_1 | up 20190125170130 2019-12-27 07:53:02 2019-12-27 07:53:02 PlayerSoftwareVersionFieldMigration
cms-web_1 | up 20190129103831 2019-12-27 07:53:02 2019-12-27 07:53:02 AddLinuxDisplayProfileMigration
cms-web_1 | up 20190212112534 2019-12-27 07:53:02 2019-12-27 07:53:02 AddProofOfPlayStatsDurationAndCountMigration
cms-web_1 | up 20190212115432 2019-12-27 07:53:02 2019-12-27 07:53:02 AddDefaultTransitionDurationSettingMigration
cms-web_1 | up 20190213160914 2019-12-27 07:53:02 2019-12-27 07:53:03 AddGlobalStatSettingMigration
cms-web_1 | up 20190213162212 2019-12-27 07:53:03 2019-12-27 07:53:03 AddHorizontalMenuSettingMigration
cms-web_1 | up 20190214102508 2019-12-27 07:53:03 2019-12-27 07:53:03 AddLayoutEnableStat
cms-web_1 | up 20190214102516 2019-12-27 07:53:03 2019-12-27 07:53:03 AddMediaEnableStat
cms-web_1 | up 20190220165703 2019-12-27 07:53:03 2019-12-27 07:53:03 AddScheduleRecurrenceMonthlyRepeatsOnMigration
cms-web_1 | up 20190227101705 2019-12-27 07:53:03 2019-12-27 07:53:03 MakeDisplayLicenseColumnUniqueMigration
cms-web_1 | up 20190228120603 2019-12-27 07:53:03 2019-12-27 07:53:03 AddDynamicCriteriaTagsMigration
cms-web_1 | up 20190301115046 2019-12-27 07:53:03 2019-12-27 07:53:03 AdjustGenericfileValidExtensionsMigration
cms-web_1 | up 20190315134628 2019-12-27 07:53:03 2019-12-27 07:53:03 AddBandwidthLimitColumnToDisplaygroupMigration
cms-web_1 | up 20190322162052 2019-12-27 07:53:03 2019-12-27 07:53:03 AddPublishedDateColumnMigration
cms-web_1 | up 20190326163016 2019-12-27 07:53:03 2019-12-27 07:53:04 CreateLayoutHistoryTableMigration
cms-web_1 | up 20190328111718 2019-12-27 07:53:04 2019-12-27 07:53:04 AddCampaignStatMigration
cms-web_1 | up 20190401150256 2019-12-27 07:53:04 2019-12-27 07:53:04 AddScheduleNowPageMigration
cms-web_1 | up 20190509101525 2019-12-27 07:53:04 2019-12-27 07:53:04 CreateReportScheduleTableMigration
cms-web_1 | up 20190509102648 2019-12-27 07:53:04 2019-12-27 07:53:04 CreateSavedReportTableMigration
cms-web_1 | up 20190509113001 2019-12-27 07:53:04 2019-12-27 07:53:04 AddReportPageMigration
cms-web_1 | up 20190510140126 2019-12-27 07:53:04 2019-12-27 07:53:04 TwoFactorAuthMigration
cms-web_1 | up 20190514134430 2019-12-27 07:53:04 2019-12-27 07:53:05 NullableTextFieldsMigration
cms-web_1 | up 20190515094133 2019-12-27 07:53:05 2019-12-27 07:53:05 AddHtmlDatatypeMigration
cms-web_1 | up 20190515105624 2019-12-27 07:53:05 2019-12-27 07:53:05 InstallAdditionalStandardModulesMigration
cms-web_1 | up 20190517080033 2019-12-27 07:53:05 2019-12-27 07:53:06 AddForeignKeysToLktagTablesMigration
cms-web_1 | up 20190521092700 2019-12-27 07:53:06 2019-12-27 07:53:06 AddReportScheduleTaskMigration
cms-web_1 | up 20190521092930 2019-12-27 07:53:06 2019-12-27 07:53:06 AddPreviousRunDateReportScheduleMigration
cms-web_1 | up 20190521102635 2019-12-27 07:53:06 2019-12-27 07:53:06 PlaylistDurationUpdateAtTimestamp
cms-web_1 | up 20190603083836 2019-12-27 07:53:06 2019-12-27 07:53:06 ChangeStatTableStartEndColumnMigration
cms-web_1 | up 20190610150331 2019-12-27 07:53:06 2019-12-27 07:53:07 TagsWithValuesMigration
cms-web_1 | up 20190611145607 2019-12-27 07:53:07 2019-12-27 07:53:07 RemoveOldVersionTableMigration
cms-web_1 | up 20190612140955 2019-12-27 07:53:07 2019-12-27 07:53:08 DisplayTableDatabaseSchemaAdjustmentsMigration
cms-web_1 | up 20190620112611 2019-12-27 07:53:08 2019-12-27 07:53:08 MoveTidyStatsToStatsArchiveTaskMigration
cms-web_1 | up 20190620142655 2019-12-27 07:53:08 2019-12-27 07:53:08 AddPlaylistEnableStatMigration
cms-web_1 | up 20190626091331 2019-12-27 07:53:08 2019-12-27 07:53:08 WidgetHistoryMigration
cms-web_1 | up 20190626110359 2019-12-27 07:53:08 2019-12-27 07:53:08 CreateStatTableMigration
cms-web_1 | up 20190628083649 2019-12-27 07:53:08 2019-12-27 07:53:08 AddStatsMigrationTaskMigration
cms-web_1 | up 20190710213414 2019-12-27 07:53:08 2019-12-27 07:53:08 AddIsActiveReportScheduleMigration
cms-web_1 | up 20190717101342 2019-12-27 07:53:08 2019-12-27 07:53:08 NullableCommandValidationStringMigration
cms-web_1 | up 20190719074601 2019-12-27 07:53:08 2019-12-27 07:53:08 MissingDefaultValueMigration
cms-web_1 | up 20190725115532 2019-12-27 07:53:09 2019-12-27 07:53:09 AddScheduleReminderTaskMigration
cms-web_1 | up 20190801102042 2019-12-27 07:53:09 2019-12-27 07:53:09 DisplayProfileCommandLinkFixMigration
cms-web_1 | up 20190801141737 2019-12-27 07:53:09 2019-12-27 07:53:09 DatasetAddCustomHeadersColumnMigration
cms-web_1 | up 20190801142302 2019-12-27 07:53:09 2019-12-27 07:53:09 AddDoohUserTypeMigration
cms-web_1 | up 20190802145636 2019-12-27 07:53:09 2019-12-27 07:53:09 CreateScheduleReminderTableMigration
cms-web_1 | up 20190806144729 2019-12-27 07:53:09 2019-12-27 07:53:09 AddShowContentFromMigration
cms-web_1 | up 20190823081448 2019-12-27 07:53:09 2019-12-27 07:53:09 AddImageProcessingTaskMigration
cms-web_1 | up 20190828123735 2019-12-27 07:53:09 2019-12-27 07:53:09 AddDefaultSettingResizeLimitResizeThresholdMigration
cms-web_1 | up 20190903083314 2019-12-27 07:53:09 2019-12-27 07:53:09 AddGlobalSettingForCascadePermissionsMigration
cms-web_1 | up 20190905084201 2019-12-27 07:53:09 2019-12-27 07:53:09 AddSettingForDefaultTransitionTypeMigration
cms-web_1 | up 20190905084642 2019-12-27 07:53:09 2019-12-27 07:53:09 AddSettingForAutoLayoutPublishMigration
cms-web_1 | up 20190910132520 2019-12-27 07:53:09 2019-12-27 07:53:09 DisplayMoveCmsMigration
cms-web_1 | up 20190917093141 2019-12-27 07:53:09 2019-12-27 07:53:09 InterruptLayoutMigration
cms-web_1 | up 20190918090608 2019-12-27 07:53:09 2019-12-27 07:53:09 AddDefaultSettingQuickChartMigration
cms-web_1 | up 20190919154513 2019-12-27 07:53:09 2019-12-27 07:53:10 AddNotificationAttachmentFilenameNonUsersMigration
cms-web_1 | up 20190926135518 2019-12-27 07:53:10 2019-12-27 07:53:10 AddSettingForTransitionAutoApplyToLayoutMigration
cms-web_1 | up 20190926140809 2019-12-27 07:53:10 2019-12-27 07:53:10 InstallSavedReportsAndSpacerModulesMigration
cms-web_1 | up 20191001092651 2019-12-27 07:53:10 2019-12-27 07:53:10 AddNotificationOriginalFilenameMigration
cms-web_1 | up 20191022101141 2020-03-25 06:37:17 2020-03-25 06:37:17 AddCommandEntityToPermissionEntityMigration
cms-web_1 | up 20191024152519 2020-03-25 06:37:17 2020-03-25 06:37:17 AddScheduleExclusionsTableMigration
cms-web_1 | up 20191122114104 2019-12-27 07:53:10 2019-12-27 07:53:10 FixDuplicateModuleFilesMigration
cms-web_1 | up 20191126103120 2020-03-25 06:37:17 2020-03-25 06:37:17 GeoScheduleMigration
cms-web_1 | up 20191126141140 2020-03-25 06:37:17 2020-03-25 06:37:18 RemoteDataSetCsvSourceMigration
cms-web_1 | up 20191205180116 2020-03-25 06:37:18 2020-03-25 06:37:18 AddPlaylistDashboardPageUserMigration
cms-web_1 | up 20200107082625 2020-03-25 06:37:18 2020-03-25 06:37:18 DisplayAddResolutionMigration
cms-web_1 | up 20200115115935 2020-03-25 06:37:18 2020-03-25 06:37:18 AddReportScheduleMessageMigration
cms-web_1 | up 20200122143630 2020-03-25 06:37:18 2020-03-25 06:37:18 AddReleasedRequiredFileMigration
cms-web_1 | up 20200122191232 2020-03-25 06:37:18 2020-03-25 06:37:18 AddCommercialLicenceColumnMigration
cms-web_1 | up 20200129104944 2020-03-25 06:37:18 2020-03-25 06:37:30 AddEngagementsStatsMigration
cms-web_1 | up 20200130165443 2020-03-25 06:37:30 2020-03-25 06:37:30 CountdownModuleAddMigration
cms-web_1 | up 20200311110512 2021-06-29 12:38:24 2021-06-29 12:38:24 AddIsDrawerColumnMigration
cms-web_1 | up 20200311110535 2021-06-29 12:38:24 2021-06-29 12:38:24 CreateActionTableMigration
cms-web_1 | up 20200319093235 2021-06-29 12:38:24 2021-06-29 12:38:24 ChangeInterruptLayoutMigration
cms-web_1 | up 20200401121544 2021-06-29 12:38:24 2021-06-29 12:38:24 AddSystemUserSettingMigration
cms-web_1 | up 20200407143200 2021-06-29 12:38:24 2021-06-29 12:38:24 AddCodeColumnToLayoutMigration
cms-web_1 | up 20200422101006 2021-06-29 12:38:24 2021-06-29 12:38:24 AddDataSetRowLimitMigration
cms-web_1 | up 20200427085958 2021-06-29 12:38:24 2021-06-29 12:38:24 AddReportScheduleStartEndMigration
cms-web_1 | up 20200530103029 2021-06-29 12:38:24 2021-06-29 12:38:24 DisplayRemoteLinksMigration
cms-web_1 | up 20200604103141 2021-06-29 12:38:24 2021-06-29 12:38:24 CommandImprovementsMigration
cms-web_1 | up 20200612141755 2021-06-29 12:38:24 2021-06-29 12:38:24 OauthUpgradeMigration
cms-web_1 | up 20200720092246 2021-06-29 12:38:24 2021-06-29 12:38:24 AddSavedReportSchemaVersionMigration
cms-web_1 | up 20200916134817 2021-06-29 12:38:24 2021-06-29 12:38:24 RemoveOldScreenshotsMigration
cms-web_1 | up 20200917140227 2021-06-29 12:38:24 2021-06-29 12:38:25 DisplayGroupCreatedModifiedDates
cms-web_1 | up 20201007080829 2021-06-29 12:38:25 2021-06-29 12:38:25 AddFoldersMigration
cms-web_1 | up 20201007093511 2021-06-29 12:38:25 2021-06-29 12:38:25 FeaturesMigration
cms-web_1 | up 20201025153753 2021-06-29 12:38:25 2021-06-29 12:38:25 RemoveOldPermissionSettingsMigration
cms-web_1 | up 20210105105646 2021-06-29 12:38:25 2021-06-29 12:38:26 AddMcaasScopeAndRouteMigration
cms-web_1 | up 20210113134628 2021-06-29 12:38:26 2021-06-29 12:38:26 EnableUserSharingFeatureOnUsersGroupMigration
cms-web_1 | up 20210128143602 2022-03-21 10:14:47 2022-03-21 10:14:47 MenuBoardsMigration
cms-web_1 | up 20210201150259 2021-06-29 12:38:26 2021-06-29 12:38:26 UserOnboardingMigration
cms-web_1 | up 20210305131937 2021-06-29 12:38:26 2021-06-29 12:38:26 FixDuplicateTagsMigration
cms-web_1 | up 20210407111756 2021-06-29 12:38:26 2021-06-29 12:38:26 RemoveReportNameColumnFromSavedReportMigration
cms-web_1 | up 20210421142731 2022-03-21 10:14:47 2022-03-21 10:14:47 RemoveMaintenanceKeyMigration
cms-web_1 | up 20210601104441 2021-06-29 12:38:26 2021-06-29 12:38:26 AddUserAgentToDataSetMigration
cms-web_1 | up 20210603114231 2022-03-21 10:14:47 2022-03-21 10:14:47 NewCalendarTypeMigration
cms-web_1 | up 20210608142925 2022-03-21 10:14:47 2022-03-21 10:14:47 AddOrientationToResolutionAndMediaMigration
cms-web_1 | up 20210611122809 2022-03-21 10:14:47 2022-03-21 10:14:47 AddPurgeListTableMigration
cms-web_1 | up 20210806122814 2022-03-21 10:14:47 2022-03-21 10:14:47 AddNumberOfItemsToPlaylistMigration
cms-web_1 | up 20210813094723 2022-03-21 10:14:47 2022-03-21 10:14:47 AddCycleBasedPlaybackOptionToCampaignMigration
cms-web_1 | up 20210817105702 2022-03-21 10:14:47 2022-03-21 10:14:47 AddCustomSeparatorToDatasetMigration
cms-web_1 | up 20210820100520 2022-03-21 10:14:47 2022-03-21 10:14:48 AddActionEventTypeMigration
cms-web_1 | up 20210901134913 2022-03-21 10:14:48 2022-03-21 10:14:49 AddIpAddressColumnToAuditLogMigration
cms-web_1 | up 20210901150615 2022-03-21 10:14:49 2022-03-21 10:14:49 AddTooltipAndIsRequiredColumnsMigration
cms-web_1 | up 20211109130951 2022-03-21 10:14:49 2022-03-21 10:14:49 FixOrphanedDisplayGroupsMigration
cms-web_1 | up 20211109134929 2022-03-21 10:14:49 2022-03-21 10:14:49 FixPlaylistManagerUserGroupMigration
cms-web_1 | up 20211109141925 2022-03-21 10:14:49 2022-03-21 10:14:49 DatasetAddOptionToTruncateOnNoNewDataMigration
cms-web_1 | up 20211116153103 2022-03-21 10:14:49 2022-03-21 10:14:49 ConnectorsMigration
cms-web_1 | up 20211231141457 2022-03-21 10:14:49 2022-03-21 10:14:49 AddMoreTagFilteringOptionsMigration
cms-web_1 | up 20211231153355 2022-03-21 10:14:49 2022-03-21 10:14:49 AddIsCustomToDisplayProfileMigration
cms-web_1 | up 20220117150212 2022-03-21 10:14:49 2022-03-21 10:14:49 AddLayoutExchangeConnectorMigration
cms-web_1 | up 20220119124436 2022-03-21 10:14:49 2022-03-21 10:14:49 AddCodeColumnToMenuBoardsMigration
cms-web_1 | up 20220131151346 2022-03-21 10:14:49 2022-03-21 10:14:49 AddDateFormatToDataSetColumnMigration
cms-web_1 | up 20220201163832 2022-03-21 10:14:49 2022-03-21 10:14:49 ReportLogoMigration
cms-web_1 | down 20220203145712 ApplicationsTweaksMigration
cms-web_1 | down 20220207160047 TidyCalendarModuleTypes
cms-web_1 | down 20220224130122 AddResolutionRoutesToDesignScopeMigration
cms-web_1 | down 20220225105237 MergeWeatherWidgets
cms-web_1 | down 20220302152503 LayoutRemoveOrientationMigration
cms-web_1 | down 20220307134554 AddWorldClockMigration
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 | == 20220203145712 ApplicationsTweaksMigration: migrating
cms-web_1 |
cms-web_1 | In PdoAdapter.php line 134:
cms-web_1 |
cms-web_1 | SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint
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

Is it possible to run those scripts with docker installation, like here?

Upgrading from 3.0.8 to 3.1 fails , "Foreign key constraint is incorrectly formed - Get Help / CMS Installation - Xibo Community

Yes - see How can I run a SQL command when using a Docker Install?

I’ll just get the same error:

In PdoAdapter.php line 134:

SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint

bash-5.1# /var/www/cms/vendor/bin/phinx migrate -c /var/www/cms/phinx.php
Phinx by CakePHP - https://phinx.org. 0.9.2

using config file ./cms/phinx.php
using config parser php
using migration paths

  • /var/www/cms/db/migrations
    warning no environment specified, defaulting to: production
    using adapter mysql
    using database cms

== 20220203145712 ApplicationsTweaksMigration: migrating

In PdoAdapter.php line 134:

SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint

migrate [-c|–configuration CONFIGURATION] [-p|–parser PARSER] [-e|–environment ENVIRONMENT] [-t|–target TARGET] [-d|–date DATE] [-x|–dry-run]

I’m getting this exact same error in my install. If there is no reply from @alex, please let me know if you come to a resolution of your own @RandomUser.

What you need to do is linked above.

Run the following SQL on your database:
ALTER TABLE `oauth_clients` CHARACTER SET utf8 COLLATE utf8_general_ci;

Also linked above are instructions on how to do that.

You may also need to do the columns in that table as setout here:

Then restart or down/up the cms-web container.

2 Likes

Thanks for the help

" For me it was also necessary to update the Collation of the Columns to utf8_general_ci"

This was the resolution for me, after that migration scripts executed correctly.

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.