Upgrade from 2.3.17 to 3.3.7 fails

Get Help CMS Installation
1

To be completed by the original poster:

CMS Version

2.3.17

Installation Method

Docker

Operating System

Ubuntu 20.04.6 LTS

Issue

I replaced the values in the docker-compose.yaml with the values provided with version 3.3.7 and launched the containers. But it hangs since 24 hours at the OauthUpgradeMigration stage with error message SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'cms.oauth_session_scopes'
Please help, I’d like to go to version 4 <3

docker-compose.yaml:

version: "2.1"

services:
  cms-db:
    image: mysql:5.7
    volumes:
      - "./shared/db:/var/lib/mysql:Z"
    restart: always
    environment:
      - MYSQL_DATABASE=cms
      - MYSQL_USER=cms
      - MYSQL_RANDOM_ROOT_PASSWORD=yes
    mem_limit: 16g
    env_file: config.env
  cms-xmr:
    image: ghcr.io/xibosignage/xibo-xmr:0.9
    ports:
      - "9508:9505"
    restart: always
    mem_limit: 4g
    env_file: config.env
  cms-web:
    image: ghcr.io/xibosignage/xibo-cms:release-3.3.7
    volumes:
      - "./shared/cms/custom:/var/www/cms/custom:Z"
      - "./shared/backup:/var/www/backup:Z"
      - "./shared/cms/web/theme/custom:/var/www/cms/web/theme/custom:Z"
      - "./shared/cms/library:/var/www/cms/library:Z"
      - "./shared/cms/web/userscripts:/var/www/cms/web/userscripts:Z"
      - "./shared/cms/ca-certs:/var/www/cms/ca-certs:Z"
    restart: always
    links:
      - cms-db:mysql
      - cms-xmr:50001
    environment:
      - XMR_HOST=cms-xmr
    env_file: config.env
    ports:
      - "127.0.0.1:8088:80"
    mem_limit: 16g
  cms-memcached:
    image: memcached:alpine
    command: memcached -m 15
    restart: always
    mem_limit: 1G
  cms-quickchart:
    image: ianw/quickchart
    restart: always

docker-compose logs cms-web

Attaching to directcaretest_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         | Generating RSA private key, 2048 bit long modulus (2 primes)
cms-web_1         | .........+++++
cms-web_1         | .................................................................................................................+++++
cms-web_1         | e is 65537 (0x010001)
cms-web_1         | writing RSA key
cms-web_1         | settingId
cms-web_1         | 1
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  2020-03-05 13:38:02  2020-03-05 13:38:02  InstallMigration
cms-web_1         |      up  20180131113100  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep85Migration
cms-web_1         |      up  20180131113853  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep86Migration
cms-web_1         |      up  20180131113941  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep87Migration
cms-web_1         |      up  20180131113948  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep88Migration
cms-web_1         |      up  20180131113952  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep92Migration
cms-web_1         |      up  20180131113957  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep120Migration
cms-web_1         |      up  20180131114002  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep121Migration
cms-web_1         |      up  20180131114007  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep122Migration
cms-web_1         |      up  20180131114013  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep123Migration
cms-web_1         |      up  20180131114017  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep124Migration
cms-web_1         |      up  20180131114021  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep125Migration
cms-web_1         |      up  20180131114025  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep126Migration
cms-web_1         |      up  20180131114030  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep127Migration
cms-web_1         |      up  20180131114050  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep128Migration
cms-web_1         |      up  20180131114058  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep129Migration
cms-web_1         |      up  20180131114103  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep130Migration
cms-web_1         |      up  20180131114107  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep131Migration
cms-web_1         |      up  20180131114110  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep132Migration
cms-web_1         |      up  20180131114114  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep133Migration
cms-web_1         |      up  20180131114118  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep134Migration
cms-web_1         |      up  20180131114123  2020-03-05 13:38:02  2020-03-05 13:38:02  OldUpgradeStep135Migration
cms-web_1         |      up  20180131122645  2020-03-05 13:38:02  2020-03-05 13:38:03  OneRegionPerPlaylistMigration
cms-web_1         |      up  20180131123038  2020-03-05 13:38:03  2020-03-05 13:38:03  PlaylistTagsMigration
cms-web_1         |      up  20180131123248  2020-03-05 13:38:03  2020-03-05 13:38:03  WidgetFromToDtMigration
cms-web_1         |      up  20180212143336  2020-03-05 13:38:03  2020-03-05 13:38:03  DaypartSystemEntriesAsRecords
cms-web_1         |      up  20180213173846  2020-03-05 13:38:03  2020-03-05 13:38:03  MailFromNameSettingMigration
cms-web_1         |      up  20180219141257  2020-03-05 13:38:03  2020-03-05 13:38:03  DisplayGroupClosureIndexToNonUnique
cms-web_1         |      up  20180223180534  2020-03-05 13:38:03  2020-03-05 13:38:03  DataSetColumnFilterAndSortOptionsMigration
cms-web_1         |      up  20180302182421  2020-03-05 13:38:03  2020-03-05 13:38:03  WidgetCreatedAndModifiedDtMigration
cms-web_1         |      up  20180313085749  2020-03-05 13:38:03  2020-03-05 13:38:03  MediaTableEditedIdIndexMigration
cms-web_1         |      up  20180320154652  2020-03-05 13:38:03  2020-03-05 13:38:03  PlaylistAddDynamicFilterMigration
cms-web_1         |      up  20180327153325  2020-03-05 13:38:03  2020-03-05 13:38:03  RemoveUserLoggedInMigration
cms-web_1         |      up  20180514114415  2020-03-05 13:38:03  2020-03-05 13:38:03  FixCaseOnHelpTextFieldMigration
cms-web_1         |      up  20180515123835  2020-03-05 13:38:03  2020-03-05 13:38:04  LayoutPublishDraftMigration
cms-web_1         |      up  20180529065816  2020-03-05 13:38:04  2020-03-05 13:38:04  DataSetTruncateFixMigration
cms-web_1         |      up  20180529073531  2020-03-05 13:38:04  2020-03-05 13:38:04  DisplayAsVncLinkMigration
cms-web_1         |      up  20180621134013  2020-03-05 13:38:04  2020-03-05 13:38:04  AddWidgetSyncTaskMigration
cms-web_1         |      up  20180621134250  2020-03-05 13:38:04  2020-03-05 13:38:04  EventLayoutPermissionSettingMigration
cms-web_1         |      up  20180906115552  2020-03-05 13:38:04  2020-03-05 13:38:04  AddForeignKeysToTagsMigration
cms-web_1         |      up  20180906115606  2020-03-05 13:38:04  2020-03-05 13:38:04  AddForeignKeysToPermissionsMigration
cms-web_1         |      up  20180906115712  2020-03-05 13:38:04  2020-03-05 13:38:04  AddForeignKeysToWidgetMediaMigration
cms-web_1         |      up  20180906131643  2020-03-05 13:38:04  2020-03-05 13:38:04  ForgottenPasswordReminderMigration
cms-web_1         |      up  20180906131716  2020-03-05 13:38:04  2020-03-05 13:38:04  DataSetRssMigration
cms-web_1         |      up  20181011160130  2020-03-05 13:38:04  2020-03-05 13:38:05  SimpleSettingsMigration
cms-web_1         |      up  20181113173310  2020-03-05 13:38:05  2020-03-05 13:38:05  RemoveFinanceModuleMigration
cms-web_1         |      up  20181113180337  2020-03-05 13:38:05  2020-03-05 13:38:05  SplitTickerModuleMigration
cms-web_1         |      up  20181126113231  2020-03-05 13:38:05  2020-03-05 13:38:05  Release1812Migration
cms-web_1         |      up  20181210092443  2020-03-05 13:38:05  2020-03-05 13:38:05  RemoveImageUriModuleMigration
cms-web_1         |      up  20181212114400  2020-03-05 13:38:05  2020-03-05 13:38:05  CreatePlayerVersionsTableMigration
cms-web_1         |      up  20181217135044  2020-03-05 13:38:05  2020-03-05 13:38:05  EventSyncMigration
cms-web_1         |      up  20190121092556  2020-03-05 13:38:05  2020-03-05 13:38:05  PlayerUpgradeAndOverrideConfigMigration
cms-web_1         |      up  20190125170130  2020-03-05 13:38:05  2020-03-05 13:38:05  PlayerSoftwareVersionFieldMigration
cms-web_1         |      up  20190129103831  2020-03-05 13:38:05  2020-03-05 13:38:05  AddLinuxDisplayProfileMigration
cms-web_1         |      up  20190212112534  2020-03-05 13:43:33  2020-03-05 13:43:33  AddProofOfPlayStatsDurationAndCountMigration
cms-web_1         |      up  20190212115432  2020-03-05 13:38:05  2020-03-05 13:38:05  AddDefaultTransitionDurationSettingMigration
cms-web_1         |      up  20190213160914  2020-03-05 13:43:33  2020-03-05 13:43:33  AddGlobalStatSettingMigration
cms-web_1         |      up  20190213162212  2020-03-05 13:38:05  2020-03-05 13:38:05  AddHorizontalMenuSettingMigration
cms-web_1         |      up  20190214102508  2020-03-05 13:43:33  2020-03-05 13:43:33  AddLayoutEnableStat
cms-web_1         |      up  20190214102516  2020-03-05 13:43:33  2020-03-05 13:43:33  AddMediaEnableStat
cms-web_1         |      up  20190220165703  2020-03-05 13:38:05  2020-03-05 13:38:05  AddScheduleRecurrenceMonthlyRepeatsOnMigration
cms-web_1         |      up  20190227101705  2020-03-05 13:38:05  2020-03-05 13:38:05  MakeDisplayLicenseColumnUniqueMigration
cms-web_1         |      up  20190228120603  2020-03-05 13:38:05  2020-03-05 13:38:05  AddDynamicCriteriaTagsMigration
cms-web_1         |      up  20190301115046  2020-03-05 13:38:05  2020-03-05 13:38:05  AdjustGenericfileValidExtensionsMigration
cms-web_1         |      up  20190315134628  2020-03-05 13:43:33  2020-03-05 13:43:33  AddBandwidthLimitColumnToDisplaygroupMigration
cms-web_1         |      up  20190322162052  2020-03-05 13:43:33  2020-03-05 13:43:33  AddPublishedDateColumnMigration
cms-web_1         |      up  20190326163016  2020-03-05 13:43:33  2020-03-05 13:43:33  CreateLayoutHistoryTableMigration
cms-web_1         |      up  20190328111718  2020-03-05 13:43:33  2020-03-05 13:43:33  AddCampaignStatMigration
cms-web_1         |      up  20190401150256  2020-03-05 13:43:33  2020-03-05 13:43:33  AddScheduleNowPageMigration
cms-web_1         |      up  20190509101525  2020-03-05 13:43:33  2020-03-05 13:43:33  CreateReportScheduleTableMigration
cms-web_1         |      up  20190509102648  2020-03-05 13:43:33  2020-03-05 13:43:33  CreateSavedReportTableMigration
cms-web_1         |      up  20190509113001  2020-03-05 13:43:33  2020-03-05 13:43:33  AddReportPageMigration
cms-web_1         |      up  20190510140126  2020-03-05 13:43:33  2020-03-05 13:43:34  TwoFactorAuthMigration
cms-web_1         |      up  20190514134430  2020-03-05 13:43:34  2020-03-05 13:43:34  NullableTextFieldsMigration
cms-web_1         |      up  20190515094133  2020-03-05 13:43:34  2020-03-05 13:43:34  AddHtmlDatatypeMigration
cms-web_1         |      up  20190515105624  2020-03-05 13:43:34  2020-03-05 13:43:34  InstallAdditionalStandardModulesMigration
cms-web_1         |      up  20190517080033  2020-03-05 13:43:34  2020-03-05 13:43:35  AddForeignKeysToLktagTablesMigration
cms-web_1         |      up  20190521092700  2020-03-05 13:43:35  2020-03-05 13:43:35  AddReportScheduleTaskMigration
cms-web_1         |      up  20190521092930  2020-03-05 13:43:35  2020-03-05 13:43:35  AddPreviousRunDateReportScheduleMigration
cms-web_1         |      up  20190521102635  2020-03-05 13:43:35  2020-03-05 13:43:35  PlaylistDurationUpdateAtTimestamp
cms-web_1         |      up  20190603083836  2020-03-05 13:43:35  2020-03-05 13:43:35  ChangeStatTableStartEndColumnMigration
cms-web_1         |      up  20190610150331  2020-03-05 13:43:35  2020-03-05 13:43:36  TagsWithValuesMigration
cms-web_1         |      up  20190611145607  2020-03-05 13:43:36  2020-03-05 13:43:36  RemoveOldVersionTableMigration
cms-web_1         |      up  20190612140955  2020-03-05 13:43:36  2020-03-05 13:43:36  DisplayTableDatabaseSchemaAdjustmentsMigration
cms-web_1         |      up  20190620112611  2020-03-05 13:43:36  2020-03-05 13:43:36  MoveTidyStatsToStatsArchiveTaskMigration
cms-web_1         |      up  20190620142655  2020-03-05 13:43:36  2020-03-05 13:43:37  AddPlaylistEnableStatMigration
cms-web_1         |      up  20190626091331  2020-03-05 13:43:37  2020-03-05 13:43:37  WidgetHistoryMigration
cms-web_1         |      up  20190626110359  2020-03-05 13:43:37  2020-03-05 13:43:37  CreateStatTableMigration
cms-web_1         |      up  20190628083649  2020-03-05 13:43:37  2020-03-05 13:43:37  AddStatsMigrationTaskMigration
cms-web_1         |      up  20190710213414  2020-03-05 13:43:37  2020-03-05 13:43:37  AddIsActiveReportScheduleMigration
cms-web_1         |      up  20190717101342  2020-03-05 13:43:37  2020-03-05 13:43:37  NullableCommandValidationStringMigration
cms-web_1         |      up  20190719074601  2020-03-05 13:43:37  2020-03-05 13:43:37  MissingDefaultValueMigration
cms-web_1         |      up  20190725115532  2020-03-05 13:47:56  2020-03-05 13:47:56  AddScheduleReminderTaskMigration
cms-web_1         |      up  20190801102042  2020-03-05 13:43:37  2020-03-05 13:43:37  DisplayProfileCommandLinkFixMigration
cms-web_1         |      up  20190801141737  2020-03-05 13:47:56  2020-03-05 13:47:56  DatasetAddCustomHeadersColumnMigration
cms-web_1         |      up  20190801142302  2020-03-05 13:47:56  2020-03-05 13:47:56  AddDoohUserTypeMigration
cms-web_1         |      up  20190802145636  2020-03-05 13:47:56  2020-03-05 13:47:56  CreateScheduleReminderTableMigration
cms-web_1         |      up  20190806144729  2020-03-05 13:47:56  2020-03-05 13:47:56  AddShowContentFromMigration
cms-web_1         |      up  20190823081448  2020-03-05 13:47:56  2020-03-05 13:47:56  AddImageProcessingTaskMigration
cms-web_1         |      up  20190828123735  2020-03-05 13:47:56  2020-03-05 13:47:56  AddDefaultSettingResizeLimitResizeThresholdMigration
cms-web_1         |      up  20190903083314  2020-03-05 13:47:56  2020-03-05 13:47:56  AddGlobalSettingForCascadePermissionsMigration
cms-web_1         |      up  20190905084201  2020-03-05 13:47:56  2020-03-05 13:47:56  AddSettingForDefaultTransitionTypeMigration
cms-web_1         |      up  20190905084642  2020-03-05 13:47:56  2020-03-05 13:47:56  AddSettingForAutoLayoutPublishMigration
cms-web_1         |      up  20190910132520  2020-03-05 13:47:56  2020-03-05 13:47:56  DisplayMoveCmsMigration
cms-web_1         |      up  20190917093141  2020-03-05 13:47:56  2020-03-05 13:47:56  InterruptLayoutMigration
cms-web_1         |      up  20190918090608  2020-03-05 13:47:56  2020-03-05 13:47:56  AddDefaultSettingQuickChartMigration
cms-web_1         |      up  20190919154513  2020-03-05 13:47:56  2020-03-05 13:47:56  AddNotificationAttachmentFilenameNonUsersMigration
cms-web_1         |      up  20190926135518  2020-03-05 13:47:56  2020-03-05 13:47:56  AddSettingForTransitionAutoApplyToLayoutMigration
cms-web_1         |      up  20190926140809  2020-03-05 13:47:56  2020-03-05 13:47:56  InstallSavedReportsAndSpacerModulesMigration
cms-web_1         |      up  20191001092651  2020-03-05 13:47:56  2020-03-05 13:47:57  AddNotificationOriginalFilenameMigration
cms-web_1         |      up  20191022101141  2020-03-05 13:52:57  2020-03-05 13:52:57  AddCommandEntityToPermissionEntityMigration
cms-web_1         |      up  20191024152519  2020-03-05 13:52:57  2020-03-05 13:52:57  AddScheduleExclusionsTableMigration
cms-web_1         |      up  20191122114104  2020-03-05 13:47:57  2020-03-05 13:47:57  FixDuplicateModuleFilesMigration
cms-web_1         |      up  20191126103120  2020-03-05 13:52:57  2020-03-05 13:52:57  GeoScheduleMigration
cms-web_1         |      up  20191126141140  2020-03-05 13:52:57  2020-03-05 13:52:58  RemoteDataSetCsvSourceMigration
cms-web_1         |      up  20191205180116  2020-03-05 13:52:58  2020-03-05 13:52:58  AddPlaylistDashboardPageUserMigration
cms-web_1         |      up  20200107082625  2020-03-05 13:52:58  2020-03-05 13:52:58  DisplayAddResolutionMigration
cms-web_1         |      up  20200115115935  2020-03-05 13:52:58  2020-03-05 13:52:58  AddReportScheduleMessageMigration
cms-web_1         |      up  20200122143630  2020-03-05 13:52:58  2020-03-05 13:52:58  AddReleasedRequiredFileMigration
cms-web_1         |      up  20200122191232  2020-03-05 13:52:58  2020-03-05 13:52:58  AddCommercialLicenceColumnMigration
cms-web_1         |      up  20200129104944  2020-03-05 13:52:58  2020-03-05 13:52:59  AddEngagementsStatsMigration
cms-web_1         |      up  20200130165443  2020-03-05 13:52:59  2020-03-05 13:52:59  CountdownModuleAddMigration
cms-web_1         |    down  20200311110512                                            AddIsDrawerColumnMigration
cms-web_1         |    down  20200311110535                                            CreateActionTableMigration
cms-web_1         |    down  20200319093235                                            ChangeInterruptLayoutMigration
cms-web_1         |    down  20200401121544                                            AddSystemUserSettingMigration
cms-web_1         |    down  20200407143200                                            AddCodeColumnToLayoutMigration
cms-web_1         |    down  20200422101006                                            AddDataSetRowLimitMigration
cms-web_1         |    down  20200427085958                                            AddReportScheduleStartEndMigration
cms-web_1         |    down  20200530103029                                            DisplayRemoteLinksMigration
cms-web_1         |    down  20200604103141                                            CommandImprovementsMigration
cms-web_1         |    down  20200612141755                                            OauthUpgradeMigration
cms-web_1         |    down  20200720092246                                            AddSavedReportSchemaVersionMigration
cms-web_1         |    down  20200916134817                                            RemoveOldScreenshotsMigration
cms-web_1         |    down  20200917140227                                            DisplayGroupCreatedModifiedDates
cms-web_1         |    down  20201007080829                                            AddFoldersMigration
cms-web_1         |    down  20201007093511                                            FeaturesMigration
cms-web_1         |    down  20201025153753                                            RemoveOldPermissionSettingsMigration
cms-web_1         |    down  20210105105646                                            AddMcaasScopeAndRouteMigration
cms-web_1         |    down  20210113134628                                            EnableUserSharingFeatureOnUsersGroupMigration
cms-web_1         |    down  20210128143602                                            MenuBoardsMigration
cms-web_1         |    down  20210201150259                                            UserOnboardingMigration
cms-web_1         |    down  20210305131937                                            FixDuplicateTagsMigration
cms-web_1         |    down  20210407111756                                            RemoveReportNameColumnFromSavedReportMigration
cms-web_1         |    down  20210421142731                                            RemoveMaintenanceKeyMigration
cms-web_1         |    down  20210601104441                                            AddUserAgentToDataSetMigration
cms-web_1         |    down  20210603114231                                            NewCalendarTypeMigration
cms-web_1         |    down  20210608142925                                            AddOrientationToResolutionAndMediaMigration
cms-web_1         |    down  20210611122809                                            AddPurgeListTableMigration
cms-web_1         |    down  20210806122814                                            AddNumberOfItemsToPlaylistMigration
cms-web_1         |    down  20210813094723                                            AddCycleBasedPlaybackOptionToCampaignMigration
cms-web_1         |    down  20210817105702                                            AddCustomSeparatorToDatasetMigration
cms-web_1         |    down  20210820100520                                            AddActionEventTypeMigration
cms-web_1         |    down  20210901134913                                            AddIpAddressColumnToAuditLogMigration
cms-web_1         |    down  20210901150615                                            AddTooltipAndIsRequiredColumnsMigration
cms-web_1         |    down  20211109130951                                            FixOrphanedDisplayGroupsMigration
cms-web_1         |    down  20211109134929                                            FixPlaylistManagerUserGroupMigration
cms-web_1         |    down  20211109141925                                            DatasetAddOptionToTruncateOnNoNewDataMigration
cms-web_1         |    down  20211116153103                                            ConnectorsMigration
cms-web_1         |    down  20211231141457                                            AddMoreTagFilteringOptionsMigration
cms-web_1         |    down  20211231153355                                            AddIsCustomToDisplayProfileMigration
cms-web_1         |    down  20220117150212                                            AddLayoutExchangeConnectorMigration
cms-web_1         |    down  20220119124436                                            AddCodeColumnToMenuBoardsMigration
cms-web_1         |    down  20220131151346                                            AddDateFormatToDataSetColumnMigration
cms-web_1         |    down  20220201163832                                            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         |    down  20220906085300                                            ThreeTwoZeroMigration
cms-web_1         |    down  20220907135653                                            AddLogicalOperatorNameMigration
cms-web_1         |    down  20220907143500                                            UserHomeFolderMigration
cms-web_1         |    down  20221013103000                                            AdvertisingConnectorsMigration
cms-web_1         |    down  20221024082400                                            AdCampaignMigration
cms-web_1         |    down  20221101090337                                            CreateDisplayTypeTableMigration
cms-web_1         |    down  20221101130018                                            AddDisplayMetaDataMigration
cms-web_1         |    down  20221104095722                                            CreateDisplayLocationTypeTableMigration
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         |  == 20200311110512 AddIsDrawerColumnMigration: migrating
cms-web_1         |  == 20200311110512 AddIsDrawerColumnMigration: migrated 0.2013s
cms-web_1         |
cms-web_1         |  == 20200311110535 CreateActionTableMigration: migrating
cms-web_1         |  == 20200311110535 CreateActionTableMigration: migrated 0.0596s
cms-web_1         |
cms-web_1         |  == 20200319093235 ChangeInterruptLayoutMigration: migrating
cms-web_1         |  == 20200319093235 ChangeInterruptLayoutMigration: migrated 0.4652s
cms-web_1         |
cms-web_1         |  == 20200401121544 AddSystemUserSettingMigration: migrating
cms-web_1         |  == 20200401121544 AddSystemUserSettingMigration: migrated 0.1712s
cms-web_1         |
cms-web_1         |  == 20200407143200 AddCodeColumnToLayoutMigration: migrating
cms-web_1         |  == 20200407143200 AddCodeColumnToLayoutMigration: migrated 0.4215s
cms-web_1         |
cms-web_1         |  == 20200422101006 AddDataSetRowLimitMigration: migrating
cms-web_1         |  == 20200422101006 AddDataSetRowLimitMigration: migrated 0.2130s
cms-web_1         |
cms-web_1         |  == 20200427085958 AddReportScheduleStartEndMigration: migrating
cms-web_1         |  == 20200427085958 AddReportScheduleStartEndMigration: migrated 0.3091s
cms-web_1         |
cms-web_1         |  == 20200530103029 DisplayRemoteLinksMigration: migrating
cms-web_1         |  == 20200530103029 DisplayRemoteLinksMigration: migrated 0.6403s
cms-web_1         |
cms-web_1         |  == 20200604103141 CommandImprovementsMigration: migrating
cms-web_1         |  == 20200604103141 CommandImprovementsMigration: migrated 0.3924s
cms-web_1         |
cms-web_1         |  == 20200612141755 OauthUpgradeMigration: migrating
cms-web_1         |
cms-web_1         | In PdoAdapter.php line 134:
cms-web_1         |
cms-web_1         |   SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'cms.oaut
cms-web_1         |   h_session_scopes'
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         | 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.20.0.6. Set the 'ServerName' directive globally to suppress this message
2

Hi philippeganz, please excuse the delayed reply.

The error being reported suggests there could have been an issue during the upgrade process. Please can we start troubleshooting this issue by rolling back to the previous CMS version, then attempting a fresh upgrade?

When you attempt the CMS upgrade again, please can you make sure to allow plenty of time for the process to complete before making any changes to your containers/setup, for example stopping any containers?

The reason I mention this is that your logs show that the migrations were in progress and completing without issue, but the OauthUpgradeMigration is not completed just before the error is returned:

3

Hey Dan,

Thanks for your answer. I’ve tried several time with a fresh copy from version 2 environment but the result is always the same.
Just to be clear. I’m stopping version 2, I’m taking a copy and then launch the containers with version 3 on the copy. I’m not touching any of the containers, nor trying to access the CMS through the web GUI during the upgrade process.

Here is also the logs of the DB container, just in case that might be useful. I’m seeing a lot of errors that are probably not related to version 3, so that might also be a reason for the failed upgrade.

cms-db_1          | 2023-11-19 20:48:43+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started.
cms-db_1          | 2023-11-19 20:48:43+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
cms-db_1          | 2023-11-19 20:48:43+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started.
cms-db_1          | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
cms-db_1          | 2023-11-19T20:48:44.277199Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
cms-db_1          | 2023-11-19T20:48:44.278712Z 0 [Note] mysqld (mysqld 5.7.44) starting as process 1 ...
cms-db_1          | 2023-11-19T20:48:44.283159Z 0 [Note] InnoDB: PUNCH HOLE support available
cms-db_1          | 2023-11-19T20:48:44.283202Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1          | 2023-11-19T20:48:44.283206Z 0 [Note] InnoDB: Uses event mutexes
cms-db_1          | 2023-11-19T20:48:44.283211Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
cms-db_1          | 2023-11-19T20:48:44.283215Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
cms-db_1          | 2023-11-19T20:48:44.283219Z 0 [Note] InnoDB: Using Linux native AIO
cms-db_1          | 2023-11-19T20:48:44.283590Z 0 [Note] InnoDB: Number of pools: 1
cms-db_1          | 2023-11-19T20:48:44.283733Z 0 [Note] InnoDB: Using CPU crc32 instructions
cms-db_1          | 2023-11-19T20:48:44.285298Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
cms-db_1          | 2023-11-19T20:48:44.298921Z 0 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1          | 2023-11-19T20:48:44.300897Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
cms-db_1          | 2023-11-19T20:48:44.320027Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1          | 2023-11-19T20:48:44.381016Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
cms-db_1          | 2023-11-19T20:48:44.381071Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
cms-db_1          | 2023-11-19T20:48:44.435362Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
cms-db_1          | 2023-11-19T20:48:44.436090Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
cms-db_1          | 2023-11-19T20:48:44.436109Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
cms-db_1          | 2023-11-19T20:48:44.436623Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 80858649502
cms-db_1          | 2023-11-19T20:48:44.436782Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
cms-db_1          | 2023-11-19T20:48:44.436860Z 0 [Note] Plugin 'FEDERATED' is disabled.
cms-db_1          | 2023-11-19T20:48:44.439929Z 0 [Warning] System table 'plugin' is expected to be transactional.
cms-db_1          | 2023-11-19T20:48:44.441174Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
cms-db_1          | 2023-11-19T20:48:44.442406Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
cms-db_1          | 2023-11-19T20:48:44.442422Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
cms-db_1          | 2023-11-19T20:48:44.442427Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
cms-db_1          | 2023-11-19T20:48:44.442430Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
cms-db_1          | 2023-11-19T20:48:44.443723Z 0 [Warning] CA certificate ca.pem is self signed.
cms-db_1          | 2023-11-19T20:48:44.443777Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
cms-db_1          | 2023-11-19T20:48:44.444341Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
cms-db_1          | 2023-11-19T20:48:44.444416Z 0 [Note] IPv6 is available.
cms-db_1          | 2023-11-19T20:48:44.444430Z 0 [Note]   - '::' resolves to '::';
cms-db_1          | 2023-11-19T20:48:44.444452Z 0 [Note] Server socket created on IP: '::'.
cms-db_1          | 2023-11-19T20:48:44.457719Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
cms-db_1          | 2023-11-19T20:48:44.457858Z 0 [Warning] Failed to open optimizer cost constant tables
cms-db_1          |
cms-db_1          | 2023-11-19T20:48:44.460256Z 0 [Warning] 'proxies_priv' entry '@ root@fb43da19bbaa' ignored in --skip-name-resolve mode.
cms-db_1          | 2023-11-19T20:48:44.463250Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional.
cms-db_1          | 2023-11-19T20:48:44.463262Z 0 [Warning] System table 'time_zone_name' is expected to be transactional.
cms-db_1          | 2023-11-19T20:48:44.463265Z 0 [Warning] System table 'time_zone' is expected to be transactional.
cms-db_1          | 2023-11-19T20:48:44.463267Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional.
cms-db_1          | 2023-11-19T20:48:44.463269Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional.
cms-db_1          | 2023-11-19T20:48:44.465125Z 0 [Warning] System table 'servers' is expected to be transactional.
cms-db_1          | 2023-11-19T20:48:44.466134Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'NESTING_EVENT_TYPE' at position 15 to have type enum('TRANSACTION','STATEMENT','STAGE','WAIT', found type enum('STATEMENT','STAGE','WAIT').
cms-db_1          | 2023-11-19T20:48:44.466425Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'NESTING_EVENT_TYPE' at position 15 to have type enum('TRANSACTION','STATEMENT','STAGE','WAIT', found type enum('STATEMENT','STAGE','WAIT').
cms-db_1          | 2023-11-19T20:48:44.466537Z 0 [Note] InnoDB: Buffer pool(s) load completed at 231119 20:48:44
cms-db_1          | 2023-11-19T20:48:44.466662Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'NESTING_EVENT_TYPE' at position 15 to have type enum('TRANSACTION','STATEMENT','STAGE','WAIT', found type enum('STATEMENT','STAGE','WAIT').
cms-db_1          | 2023-11-19T20:48:44.467487Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_user_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
cms-db_1          | 2023-11-19T20:48:44.467693Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
cms-db_1          | 2023-11-19T20:48:44.469397Z 0 [ERROR] Column count of performance_schema.setup_actors is wrong. Expected 5, found 3. Created with MySQL 50648, now running 50744. Please use mysql_upgrade to fix this error.
cms-db_1          | 2023-11-19T20:48:44.469801Z 0 [ERROR] Incorrect definition of table performance_schema.setup_objects: expected column 'OBJECT_TYPE' at position 0 to have type enum('EVENT','FUNCTION','PROCEDURE','TABLE','TRIGGER', found type enum('TABLE').
cms-db_1          | 2023-11-19T20:48:44.470458Z 0 [ERROR] Column count of performance_schema.table_lock_waits_summary_by_table is wrong. Expected 68, found 73. Created with MySQL 50648, now running 50744. Please use mysql_upgrade to fix this error.
cms-db_1          | 2023-11-19T20:48:44.470663Z 0 [ERROR] Column count of performance_schema.threads is wrong. Expected 17, found 14. Created with MySQL 50648, now running 50744. Please use mysql_upgrade to fix this error.
cms-db_1          | 2023-11-19T20:48:44.470882Z 0 [ERROR] Column count of performance_schema.events_stages_current is wrong. Expected 12, found 10. Created with MySQL 50648, now running 50744. Please use mysql_upgrade to fix this error.
cms-db_1          | 2023-11-19T20:48:44.471070Z 0 [ERROR] Column count of performance_schema.events_stages_history is wrong. Expected 12, found 10. Created with MySQL 50648, now running 50744. Please use mysql_upgrade to fix this error.
cms-db_1          | 2023-11-19T20:48:44.471262Z 0 [ERROR] Column count of performance_schema.events_stages_history_long is wrong. Expected 12, found 10. Created with MySQL 50648, now running 50744. Please use mysql_upgrade to fix this error.
cms-db_1          | 2023-11-19T20:48:44.471629Z 0 [ERROR] Incorrect definition of table performance_schema.events_stages_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
cms-db_1          | 2023-11-19T20:48:44.471830Z 0 [ERROR] Incorrect definition of table performance_schema.events_stages_summary_by_user_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
cms-db_1          | 2023-11-19T20:48:44.472385Z 0 [ERROR] Column count of performance_schema.events_statements_current is wrong. Expected 41, found 40. Created with MySQL 50648, now running 50744. Please use mysql_upgrade to fix this error.
cms-db_1          | 2023-11-19T20:48:44.472594Z 0 [ERROR] Column count of performance_schema.events_statements_history is wrong. Expected 41, found 40. Created with MySQL 50648, now running 50744. Please use mysql_upgrade to fix this error.
cms-db_1          | 2023-11-19T20:48:44.472803Z 0 [ERROR] Column count of performance_schema.events_statements_history_long is wrong. Expected 41, found 40. Created with MySQL 50648, now running 50744. Please use mysql_upgrade to fix this error.
cms-db_1          | 2023-11-19T20:48:44.473132Z 0 [ERROR] Incorrect definition of table performance_schema.events_statements_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
cms-db_1          | 2023-11-19T20:48:44.473328Z 0 [ERROR] Incorrect definition of table performance_schema.events_statements_summary_by_user_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
cms-db_1          | 2023-11-19T20:48:44.473924Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.473946Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.473966Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.473991Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history_long' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.474025Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.474053Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_account_by_event_name' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.474084Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_user_by_event_name' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.474110Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_host_by_event_name' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.474139Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_global_by_event_name' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.474326Z 0 [ERROR] Incorrect definition of table performance_schema.users: expected column 'USER' at position 0 to have type char(32), found type char(16).
cms-db_1          | 2023-11-19T20:48:44.474517Z 0 [ERROR] Incorrect definition of table performance_schema.accounts: expected column 'USER' at position 0 to have type char(32), found type char(16).
cms-db_1          | 2023-11-19T20:48:44.475612Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_global_by_event_name' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475634Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475664Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475691Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475710Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475728Z 0 [ERROR] Native table 'performance_schema'.'table_handles' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475744Z 0 [ERROR] Native table 'performance_schema'.'metadata_locks' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475760Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_configuration' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475777Z 0 [ERROR] Native table 'performance_schema'.'replication_group_members' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475800Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_status' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475821Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_configuration' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475838Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475858Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_coordinator' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475876Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_worker' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475893Z 0 [ERROR] Native table 'performance_schema'.'replication_group_member_stats' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475909Z 0 [ERROR] Native table 'performance_schema'.'prepared_statements_instances' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475926Z 0 [ERROR] Native table 'performance_schema'.'user_variables_by_thread' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475942Z 0 [ERROR] Native table 'performance_schema'.'status_by_account' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475959Z 0 [ERROR] Native table 'performance_schema'.'status_by_host' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475975Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.475992Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.476009Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.476026Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.476044Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.476062Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.476078Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure
cms-db_1          | 2023-11-19T20:48:44.476095Z 0 [Warning] Optional native table 'performance_schema'.'processlist' has the wrong structure or is missing.
cms-db_1          | 2023-11-19T20:48:44.476174Z 0 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(32), found type char(16).
cms-db_1          | 2023-11-19T20:48:44.476190Z 0 [ERROR] mysql.user has no `Event_priv` column at position 28
cms-db_1          | 2023-11-19T20:48:44.476585Z 0 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
cms-db_1          | 2023-11-19T20:48:44.476729Z 0 [Note] mysqld: ready for connections.
cms-db_1          | Version: '5.7.44'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
cms-db_1          | 2023-11-19T20:48:44.476905Z 2 [Note] Got an error reading communication packets
cms-db_1          | 2023-11-19T20:48:46.714322Z 3 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
cms-db_1          | 2023-11-19T20:48:46.714373Z 3 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
cms-db_1          | 2023-11-19T20:48:46.836221Z 4 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
cms-db_1          | 2023-11-19T20:48:46.836239Z 4 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade```
4

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