Problem with updating from version 2.3.2 to version 2.3.17

CMS Version

Upgrade 2.3.2 >> 2.3.17

Installation Method

Docker Compose - YES

Operating System

Ubuntu 22.04

#Problem
Good day. I used version 2.3.2 in Docker for a long time, I decided to update to the latest version for branch 2. Until 2.3.17
I updated my docker yml, migrated the database as indicated here - to version 5.7

The problem is that now my playlists are stuck in the counting state (they are long, some are 20 or more hours long)
Because of this, playlists do not automatically enter the publish state when the playlist is changed. You have to manually publish them again (this didn’t happen before)

The “delete file by date” function also stopped working. Previously, I set the date for deleting a file, and it disappeared from the database, now it remains “hanging”.

Where and what can/should I look to fix this?

My docker log

Blockquote
root@asoundpartner-xibo:/opt/xibo# docker-compose -f cms_custom-ports.yml up
Starting xibo_cms-db_1 … done
Starting xibo_cms-quickchart_1 … done
Starting xibo_cms-xmr_1 … done
Starting xibo_cms-web_1 … done
Attaching to xibo_cms-db_1, xibo_cms-quickchart_1, xibo_cms-xmr_1, xibo_cms-web_1
cms-db_1 | 2024-04-24 11:13:45+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started.
cms-db_1 | 2024-04-24 11:13:45+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-web_1 | Waiting for MySQL to start - max 300 seconds
cms-db_1 | 2024-04-24 11:13:45+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-quickchart_1 | {“name”:“quickchart”,“hostname”:“dc3c449f572b”,“pid”:1,“level”:30,“msg”:“Telemetry is enabled”,“time”:“2024-04-24T11:13:45.976Z”,“v”:0}
cms-quickchart_1 | Wed, 24 Apr 2024 11:13:46 GMT body-parser deprecated undefined extended: provide extended option at index.js:38:17
cms-db_1 | 2024-04-24T11:13:46.409967Z 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 | 2024-04-24T11:13:46.411904Z 0 [Note] mysqld (mysqld 5.7.44) starting as process 1 …
cms-db_1 | 2024-04-24T11:13:46.416716Z 0 [Note] InnoDB: PUNCH HOLE support available
cms-db_1 | 2024-04-24T11:13:46.416747Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2024-04-24T11:13:46.416753Z 0 [Note] InnoDB: Uses event mutexes
cms-db_1 | 2024-04-24T11:13:46.416758Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
cms-db_1 | 2024-04-24T11:13:46.416763Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“dc3c449f572b”,“pid”:1,“level”:30,“msg”:“Setting request timeout: 5000 ms”,“time”:“2024-04-24T11:13:46.435Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“dc3c449f572b”,“pid”:1,“level”:30,“msg”:“NODE_ENV: production”,“time”:“2024-04-24T11:13:46.435Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“dc3c449f572b”,“pid”:1,“level”:30,“msg”:“Listening on port 3400”,“time”:“2024-04-24T11:13:46.435Z”,“v”:0}
cms-db_1 | 2024-04-24T11:13:46.416767Z 0 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2024-04-24T11:13:46.417110Z 0 [Note] InnoDB: Number of pools: 1
cms-db_1 | 2024-04-24T11:13:46.417241Z 0 [Note] InnoDB: Using CPU crc32 instructions
cms-db_1 | 2024-04-24T11:13:46.419242Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
cms-db_1 | 2024-04-24T11:13:46.434033Z 0 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2024-04-24T11:13:46.436504Z 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 | 2024-04-24T11:13:46.447981Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2024-04-24T11:13:46.568735Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
cms-db_1 | 2024-04-24T11:13:46.568855Z 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
cms-db_1 | 2024-04-24T11:13:46.724543Z 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
cms-db_1 | 2024-04-24T11:13:46.728638Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
cms-db_1 | 2024-04-24T11:13:46.728692Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
cms-db_1 | 2024-04-24T11:13:46.730040Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 100724105594
cms-db_1 | 2024-04-24T11:13:46.730962Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
cms-db_1 | 2024-04-24T11:13:46.731213Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
cms-db_1 | 2024-04-24T11:13:46.739011Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240424 11:13:46
cms-db_1 | 2024-04-24T11:13:46.753930Z 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 | 2024-04-24T11:13:46.753957Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
cms-db_1 | 2024-04-24T11:13:46.753968Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
cms-db_1 | 2024-04-24T11:13:46.753975Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
cms-db_1 | 2024-04-24T11:13:46.755558Z 0 [Warning] CA certificate ca.pem is self signed.
cms-db_1 | 2024-04-24T11:13:46.755640Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
cms-db_1 | 2024-04-24T11:13:46.756402Z 0 [Note] Server hostname (bind-address): ‘'; port: 3306
cms-db_1 | 2024-04-24T11:13:46.756791Z 0 [Note] IPv6 is available.
cms-db_1 | 2024-04-24T11:13:46.756823Z 0 [Note] - ‘::’ resolves to ‘::’;
cms-db_1 | 2024-04-24T11:13:46.756855Z 0 [Note] Server socket created on IP: ‘::’.
cms-db_1 | 2024-04-24T11:13:46.791796Z 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 | 2024-04-24T11:13:46.795044Z 0 [Warning] ‘proxies_priv’ entry ‘@ root@c9c7c29a357e’ ignored in --skip-name-resolve mode.
cms-db_1 | 2024-04-24T11:13:46.820661Z 0 [Note] Event Scheduler: Loaded 0 events
cms-db_1 | 2024-04-24T11:13:46.821080Z 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 | 2024-04-24T11:13:47.488209Z 2 [Note] Got an error reading communication packets
cms-web_1 | MySQL started
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-21 12:41:35 2020-03-21 12:42:14 InstallMigration
cms-web_1 | up 20180131113100 2020-03-21 12:42:15 2020-03-21 12:42:15 OldUpgradeStep85Migration
cms-web_1 | up 20180131113853 2020-03-21 12:42:15 2020-03-21 12:42:15 OldUpgradeStep86Migration
cms-web_1 | up 20180131113941 2020-03-21 12:42:15 2020-03-21 12:42:15 OldUpgradeStep87Migration
cms-web_1 | up 20180131113948 2020-03-21 12:42:15 2020-03-21 12:42:15 OldUpgradeStep88Migration
cms-web_1 | up 20180131113952 2020-03-21 12:42:15 2020-03-21 12:42:15 OldUpgradeStep92Migration
cms-web_1 | up 20180131113957 2020-03-21 12:42:15 2020-03-21 12:42:15 OldUpgradeStep120Migration
cms-web_1 | up 20180131114002 2020-03-21 12:42:15 2020-03-21 12:42:15 OldUpgradeStep121Migration
cms-web_1 | up 20180131114007 2020-03-21 12:42:15 2020-03-21 12:42:15 OldUpgradeStep122Migration
cms-web_1 | up 20180131114013 2020-03-21 12:42:15 2020-03-21 12:42:15 OldUpgradeStep123Migration
cms-web_1 | up 20180131114017 2020-03-21 12:42:15 2020-03-21 12:42:15 OldUpgradeStep124Migration
cms-web_1 | up 20180131114021 2020-03-21 12:42:15 2020-03-21 12:42:15 OldUpgradeStep125Migration
cms-web_1 | up 20180131114025 2020-03-21 12:42:15 2020-03-21 12:42:15 OldUpgradeStep126Migration
cms-web_1 | up 20180131114030 2020-03-21 12:42:16 2020-03-21 12:42:16 OldUpgradeStep127Migration
cms-web_1 | up 20180131114050 2020-03-21 12:42:16 2020-03-21 12:42:16 OldUpgradeStep128Migration
cms-web_1 | up 20180131114058 2020-03-21 12:42:16 2020-03-21 12:42:16 OldUpgradeStep129Migration
cms-web_1 | up 20180131114103 2020-03-21 12:42:16 2020-03-21 12:42:16 OldUpgradeStep130Migration
cms-web_1 | up 20180131114107 2020-03-21 12:42:16 2020-03-21 12:42:16 OldUpgradeStep131Migration
cms-web_1 | up 20180131114110 2020-03-21 12:42:16 2020-03-21 12:42:16 OldUpgradeStep132Migration
cms-web_1 | up 20180131114114 2020-03-21 12:42:16 2020-03-21 12:42:16 OldUpgradeStep133Migration
cms-web_1 | up 20180131114118 2020-03-21 12:42:16 2020-03-21 12:42:16 OldUpgradeStep134Migration
cms-web_1 | up 20180131114123 2020-03-21 12:42:16 2020-03-21 12:42:16 OldUpgradeStep135Migration
cms-web_1 | up 20180131122645 2020-03-21 12:42:16 2020-03-21 12:42:21 OneRegionPerPlaylistMigration
cms-web_1 | up 20180131123038 2020-03-21 12:42:21 2020-03-21 12:42:22 PlaylistTagsMigration
cms-web_1 | up 20180131123248 2020-03-21 12:42:22 2020-03-21 12:42:23 WidgetFromToDtMigration
cms-web_1 | up 20180212143336 2020-03-21 12:42:23 2020-03-21 12:42:24 DaypartSystemEntriesAsRecords
cms-web_1 | up 20180213173846 2020-03-21 12:42:24 2020-03-21 12:42:24 MailFromNameSettingMigration
cms-web_1 | up 20180219141257 2020-03-21 12:42:24 2020-03-21 12:42:26 DisplayGroupClosureIndexToNonUnique
cms-web_1 | up 20180223180534 2020-03-21 12:42:26 2020-03-21 12:42:27 DataSetColumnFilterAndSortOptionsMigration
cms-web_1 | up 20180302182421 2020-03-21 12:42:28 2020-03-21 12:42:29 WidgetCreatedAndModifiedDtMigration
cms-web_1 | up 20180313085749 2020-03-21 12:42:29 2020-03-21 12:42:29 MediaTableEditedIdIndexMigration
cms-web_1 | up 20180320154652 2020-03-21 12:42:29 2020-03-21 12:42:33 PlaylistAddDynamicFilterMigration
cms-web_1 | up 20180327153325 2020-03-21 12:42:33 2020-03-21 12:42:36 RemoveUserLoggedInMigration
cms-web_1 | up 20180514114415 2020-03-21 12:42:36 2020-03-21 12:42:36 FixCaseOnHelpTextFieldMigration
cms-web_1 | up 20180515123835 2020-03-21 12:42:36 2020-03-21 12:42:38 LayoutPublishDraftMigration
cms-web_1 | up 20180529065816 2020-03-21 12:42:38 2020-03-21 12:42:40 DataSetTruncateFixMigration
cms-web_1 | up 20180529073531 2020-03-21 12:42:40 2020-03-21 12:42:40 DisplayAsVncLinkMigration
cms-web_1 | up 20180621134013 2020-03-21 12:42:40 2020-03-21 12:42:40 AddWidgetSyncTaskMigration
cms-web_1 | up 20180621134250 2020-03-21 12:42:40 2020-03-21 12:42:40 EventLayoutPermissionSettingMigration
cms-web_1 | up 20180906115552 2020-03-21 12:42:40 2020-03-21 12:42:40 AddForeignKeysToTagsMigration
cms-web_1 | up 20180906115606 2020-03-21 12:42:40 2020-03-21 12:42:43 AddForeignKeysToPermissionsMigration
cms-web_1 | up 20180906115712 2020-03-21 12:42:43 2020-03-21 12:42:43 AddForeignKeysToWidgetMediaMigration
cms-web_1 | up 20180906131643 2020-03-21 12:42:43 2020-03-21 12:42:44 ForgottenPasswordReminderMigration
cms-web_1 | up 20180906131716 2020-03-21 12:42:44 2020-03-21 12:42:44 DataSetRssMigration
cms-web_1 | up 20181011160130 2020-03-21 12:42:44 2020-03-21 12:42:54 SimpleSettingsMigration
cms-web_1 | up 20181113173310 2020-03-21 12:42:54 2020-03-21 12:42:54 RemoveFinanceModuleMigration
cms-web_1 | up 20181113180337 2020-03-21 12:42:54 2020-03-21 12:42:54 SplitTickerModuleMigration
cms-web_1 | up 20181126113231 2020-03-21 12:42:54 2020-03-21 12:42:54 Release1812Migration
cms-web_1 | up 20181210092443 2020-03-21 12:42:54 2020-03-21 12:42:54 RemoveImageUriModuleMigration
cms-web_1 | up 20181212114400 2020-03-21 12:42:54 2020-03-21 12:42:55 CreatePlayerVersionsTableMigration
cms-web_1 | up 20181217135044 2020-03-21 12:42:55 2020-03-21 12:42:56 EventSyncMigration
cms-web_1 | up 20190121092556 2020-03-21 12:42:56 2020-03-21 12:42:58 PlayerUpgradeAndOverrideConfigMigration
cms-web_1 | up 20190125170130 2020-03-21 12:42:58 2020-03-21 12:42:59 PlayerSoftwareVersionFieldMigration
cms-web_1 | up 20190129103831 2020-03-21 12:42:59 2020-03-21 12:42:59 AddLinuxDisplayProfileMigration
cms-web_1 | up 20190212112534 2020-03-21 12:42:59 2020-03-21 12:42:59 AddProofOfPlayStatsDurationAndCountMigration
cms-web_1 | up 20190212115432 2020-03-21 12:42:59 2020-03-21 12:42:59 AddDefaultTransitionDurationSettingMigration
cms-web_1 | up 20190213160914 2020-03-21 12:42:59 2020-03-21 12:42:59 AddGlobalStatSettingMigration
cms-web_1 | up 20190213162212 2020-03-21 12:42:59 2020-03-21 12:42:59 AddHorizontalMenuSettingMigration
cms-web_1 | up 20190214102508 2020-03-21 12:42:59 2020-03-21 12:43:00 AddLayoutEnableStat
cms-web_1 | up 20190214102516 2020-03-21 12:43:00 2020-03-21 12:43:01 AddMediaEnableStat
cms-web_1 | up 20190220165703 2020-03-21 12:43:01 2020-03-21 12:43:03 AddScheduleRecurrenceMonthlyRepeatsOnMigration
cms-web_1 | up 20190227101705 2020-03-21 12:43:03 2020-03-21 12:43:03 MakeDisplayLicenseColumnUniqueMigration
cms-web_1 | up 20190228120603 2020-03-21 12:43:04 2020-03-21 12:43:05 AddDynamicCriteriaTagsMigration
cms-web_1 | up 20190301115046 2020-03-21 12:43:05 2020-03-21 12:43:05 AdjustGenericfileValidExtensionsMigration
cms-web_1 | up 20190315134628 2020-03-21 12:43:05 2020-03-21 12:43:06 AddBandwidthLimitColumnToDisplaygroupMigration
cms-web_1 | up 20190322162052 2020-03-21 12:43:06 2020-03-21 12:43:06 AddPublishedDateColumnMigration
cms-web_1 | up 20190326163016 2020-03-21 12:43:06 2020-03-21 12:43:07 CreateLayoutHistoryTableMigration
cms-web_1 | up 20190328111718 2020-03-21 12:43:07 2020-03-21 12:43:07 AddCampaignStatMigration
cms-web_1 | up 20190401150256 2020-03-21 12:43:07 2020-03-21 12:43:07 AddScheduleNowPageMigration
cms-web_1 | up 20190509101525 2020-03-21 12:43:07 2020-03-21 12:43:08 CreateReportScheduleTableMigration
cms-web_1 | up 20190509102648 2020-03-21 12:43:08 2020-03-21 12:43:08 CreateSavedReportTableMigration
cms-web_1 | up 20190509113001 2020-03-21 12:43:08 2020-03-21 12:43:08 AddReportPageMigration
cms-web_1 | up 20190510140126 2020-03-21 12:43:08 2020-03-21 12:43:10 TwoFactorAuthMigration
cms-web_1 | up 20190514134430 2020-03-21 12:43:10 2020-03-21 12:43:13 NullableTextFieldsMigration
cms-web_1 | up 20190515094133 2020-03-21 12:43:13 2020-03-21 12:43:13 AddHtmlDatatypeMigration
cms-web_1 | up 20190515105624 2020-03-21 12:43:13 2020-03-21 12:43:13 InstallAdditionalStandardModulesMigration
cms-web_1 | up 20190517080033 2020-03-21 12:43:13 2020-03-21 12:43:15 AddForeignKeysToLktagTablesMigration
cms-web_1 | up 20190521092700 2020-03-21 12:43:15 2020-03-21 12:43:15 AddReportScheduleTaskMigration
cms-web_1 | up 20190521092930 2020-03-21 12:43:15 2020-03-21 12:43:17 AddPreviousRunDateReportScheduleMigration
cms-web_1 | up 20190521102635 2020-03-21 12:43:17 2020-03-21 12:43:18 PlaylistDurationUpdateAtTimestamp
cms-web_1 | up 20190603083836 2020-03-21 12:43:18 2020-03-21 12:43:18 ChangeStatTableStartEndColumnMigration
cms-web_1 | up 20190610150331 2020-03-21 12:43:19 2020-03-21 12:43:24 TagsWithValuesMigration
cms-web_1 | up 20190611145607 2020-03-21 12:43:24 2020-03-21 12:43:24 RemoveOldVersionTableMigration
cms-web_1 | up 20190612140955 2020-03-21 12:43:24 2020-03-21 12:43:27 DisplayTableDatabaseSchemaAdjustmentsMigration
cms-web_1 | up 20190620112611 2020-03-21 12:43:27 2020-03-21 12:43:27 MoveTidyStatsToStatsArchiveTaskMigration
cms-web_1 | up 20190620142655 2020-03-21 12:43:27 2020-03-21 12:43:27 AddPlaylistEnableStatMigration
cms-web_1 | up 20190626091331 2020-03-21 12:43:28 2020-03-21 12:43:28 WidgetHistoryMigration
cms-web_1 | up 20190626110359 2020-03-21 12:43:28 2020-03-21 12:43:29 CreateStatTableMigration
cms-web_1 | up 20190628083649 2020-03-21 12:43:29 2020-03-21 12:43:29 AddStatsMigrationTaskMigration
cms-web_1 | up 20190710213414 2020-03-21 12:43:29 2020-03-21 12:43:30 AddIsActiveReportScheduleMigration
cms-web_1 | up 20190717101342 2020-03-21 12:43:30 2020-03-21 12:43:30 NullableCommandValidationStringMigration
cms-web_1 | up 20190719074601 2020-03-21 12:43:30 2020-03-21 12:43:30 MissingDefaultValueMigration
cms-web_1 | up 20190725115532 2020-03-21 12:43:30 2020-03-21 12:43:30 AddScheduleReminderTaskMigration
cms-web_1 | up 20190801102042 2020-03-21 12:43:30 2020-03-21 12:43:30 DisplayProfileCommandLinkFixMigration
cms-web_1 | up 20190801141737 2020-03-21 12:43:30 2020-03-21 12:43:31 DatasetAddCustomHeadersColumnMigration
cms-web_1 | up 20190801142302 2020-03-21 12:43:31 2020-03-21 12:43:31 AddDoohUserTypeMigration
cms-web_1 | up 20190802145636 2020-03-21 12:43:31 2020-03-21 12:43:32 CreateScheduleReminderTableMigration
cms-web_1 | up 20190806144729 2020-03-21 12:43:33 2020-03-21 12:43:34 AddShowContentFromMigration
cms-web_1 | up 20190823081448 2020-03-21 12:43:34 2020-03-21 12:43:34 AddImageProcessingTaskMigration
cms-web_1 | up 20190828123735 2020-03-21 12:43:35 2020-03-21 12:43:35 AddDefaultSettingResizeLimitResizeThresholdMigration
cms-web_1 | up 20190903083314 2020-03-21 12:43:35 2020-03-21 12:43:35 AddGlobalSettingForCascadePermissionsMigration
cms-web_1 | up 20190905084201 2020-03-21 12:43:35 2020-03-21 12:43:35 AddSettingForDefaultTransitionTypeMigration
cms-web_1 | up 20190905084642 2020-03-21 12:43:35 2020-03-21 12:43:35 AddSettingForAutoLayoutPublishMigration
cms-web_1 | up 20190910132520 2020-03-21 12:43:35 2020-03-21 12:43:37 DisplayMoveCmsMigration
cms-web_1 | up 20190917093141 2020-03-21 12:43:37 2020-03-21 12:43:38 InterruptLayoutMigration
cms-web_1 | up 20190918090608 2020-03-21 12:43:38 2020-03-21 12:43:38 AddDefaultSettingQuickChartMigration
cms-web_1 | up 20190919154513 2020-03-21 12:43:38 2020-03-21 12:43:39 AddNotificationAttachmentFilenameNonUsersMigration
cms-web_1 | up 20190926135518 2020-03-21 12:43:39 2020-03-21 12:43:40 AddSettingForTransitionAutoApplyToLayoutMigration
cms-web_1 | up 20190926140809 2020-03-21 12:43:40 2020-03-21 12:43:40 InstallSavedReportsAndSpacerModulesMigration
cms-web_1 | up 20191001092651 2020-03-21 12:43:40 2020-03-21 12:43:41 AddNotificationOriginalFilenameMigration
cms-web_1 | up 20191022101141 2020-03-21 12:43:41 2020-03-21 12:43:41 AddCommandEntityToPermissionEntityMigration
cms-web_1 | up 20191024152519 2020-03-21 12:43:41 2020-03-21 12:43:42 AddScheduleExclusionsTableMigration
cms-web_1 | up 20191122114104 2020-03-21 12:43:42 2020-03-21 12:43:42 FixDuplicateModuleFilesMigration
cms-web_1 | up 20191126103120 2020-03-21 12:43:42 2020-03-21 12:43:44 GeoScheduleMigration
cms-web_1 | up 20191126141140 2020-03-21 12:43:44 2020-03-21 12:43:45 RemoteDataSetCsvSourceMigration
cms-web_1 | up 20191205180116 2020-03-21 12:43:45 2020-03-21 12:43:45 AddPlaylistDashboardPageUserMigration
cms-web_1 | up 20200107082625 2020-03-21 12:43:45 2020-03-21 12:43:47 DisplayAddResolutionMigration
cms-web_1 | up 20200115115935 2020-03-21 12:43:47 2020-03-21 12:43:48 AddReportScheduleMessageMigration
cms-web_1 | up 20200122143630 2020-03-21 12:43:48 2020-03-21 12:43:49 AddReleasedRequiredFileMigration
cms-web_1 | up 20200122191232 2020-03-21 12:43:49 2020-03-21 12:43:50 AddCommercialLicenceColumnMigration
cms-web_1 | up 20200129104944 2020-03-21 12:43:50 2020-03-21 12:43:51 AddEngagementsStatsMigration
cms-web_1 | up 20200130165443 2020-03-21 12:43:51 2020-03-21 12:43:51 CountdownModuleAddMigration
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 | crontab: can’t open ‘/etc/crontabs/apache’: Permission denied
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.18.0.5. Set the ‘ServerName’ directive globally to suppress this message

Perhaps this has something to do with Apache’s crontab?

I updated the version of Xibo CMS to version 3.3.7
Unfortunately the problem continues. It does not count the time of playlists, the files themselves are not deleted after…

I understand that this is an error somewhere in the crontab or so, but I don’t understand where and what needs to be corrected. Please tell me.

Playlist building is never completed.
Because of this, the construction of layouts is not completed.
But if the layout is check >> save. Then he is immediately considered normal

Well, files with an expired date are not deleted.


The issue was resolved as follows.

went into the cms container and set the correct permissions to the /etc/crontab/apache file

In the xibo interface - tasks - deleted Regular Maintenance and created a new task