Good morning.
I have had this problem for 2 days now.
When I try to access the dashboard it takes ages (almost 30 seconds or sometimes even more) to load up. When going to the marketplace after loading for ages it shows the error: Oops… bla bla bla.
Here is my system check:
### Mandatory checks
#### Versione PHP >= 7.2.5:
✔ 8.4.5
#### PDO estensione:
✔
#### PDO\MYSQL estensione:
✔
#### MYSQLI estensione:
✔
#### Altre estensioni Richieste:
✔ zlib ✔ json ✔ filter ✔ hash ✔ session
#### Funzioni richieste:
✔ debug_backtrace ✔ eval ✔ hash ✔ gzcompress ✔ gzuncompress ✔ pack
#### Richiesta configurazione PHP (php.ini):
✔ session.auto_start = 0 ✔ max_execution_time = 0 OR = -1 OR >= 30
#### Directories con permessi di scrittura:
✔ $DOC_ROOT/tmp ✔ $DOC_ROOT/tmp/assets ✔ $DOC_ROOT/tmp/cache ✔ $DOC_ROOT/tmp/climulti ✔ $DOC_ROOT/tmp/latest ✔ $DOC_ROOT/tmp/logs ✔ $DOC_ROOT/tmp/sessions ✔ $DOC_ROOT/tmp/tcpdf ✔ $DOC_ROOT/tmp/templates_c
#### Directory con diritti di scrittura per Gestione Tag:
✔ $DOC_ROOT/js
### Optional checks
#### Directory private richieste:
✔ Tutte le directory private sono accessibili da Internet.
#### Directory private consigliate:
✔ Tutte le directory private sono accessibili da Internet.
#### Integrità dei file:
✔
#### Binario PHP a 64 bit:
✔
#### Stato del tracker:
✔
#### Memoria massima:
✔ 768M
#### Fuso orario:
✔
#### Apri URL:
✔ curl
#### PageSpeed disabilitato:
✔
#### GD > 2.x + FreeType (grafica):
✔
#### Altre estensioni:
✔ json ✔ libxml ✔ dom ✔ SimpleXML ✔ openssl
#### Altre funzioni:
✔ shell_exec ✔ set_time_limit ✔ mail ✔ parse_ini_file ✔ glob ✔ gzopen ✔ md5_file ✔ hash_file
#### Filesystem:
✔
#### Impostazione Cron Job (caricamento report più rapido):
⚠ Warning: Per delle prestazioni ottimali e un Matomo veloce, è altamente raccomandato di impostare un crontab per archiviare automaticamente i tuoi report, e di disabilitare l'attivazione dal browser nelle impostazioni di Matomo. Leggi altro.
#### Impostazione Cron Job - Gestione processi tramite CLI:
non supportato (opzionale) (Ragioni: shell_exec(ps wwx" 2> /dev/null") did not return a success code, awk is not available or did not run as we would expect it to) impara di più
#### Capacità del database:
✔ UTF8mb4 charset ✔ Connection collation ⚠ Warning: LOAD DATA INFILE<br/>Suggerimento: l'utilizzo di LOAD DATA INFILE aggiornando i tuoi PHP e MySQL e assicurandoti che il tuo utente database abbia i privilegi FILE accelera notevolmente il processo di archiviazione di Matomo.<br/>Dovresti risolvere questo problema se il tuo server Matomo traccia dei siti web ad alto traffico (ad esempio oltre 100.000 pagine al mese).<br/><strong>Errore:</strong> LOAD DATA INFILE failed... Error was: <br/> Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'azieoj_admin'@'%' (using password: YES)[28000],<br/> Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 3948 Loading local data is disabled; this must be enabled on both the client and server sides[42000]<br/>Troubleshooting: FAQ on matomo.org ✔ CREATE TEMPORARY TABLES ✔ Changing transaction isolation level
#### Dimensione Massima Pacchetto:
✔
#### Connessione SSL Forzata:
✔
#### Geolocalizzazione:
✔ geoip2php (continent_code, continent_name, country_code, country_name, region_name, city_name, lat, long)
#### Aggiorna tramite HTTPS:
✔
#### Mobile Messaging SMS Provider:
not configured
#### JavaScript Tracker scrivibile ("/matomo.js"):
✔
### Informational results
#### Matomo Version:
5.3.1
#### Matomo Update History:
5.3.1,
#### Matomo Install Version:
5.3.1
#### Latest Available Version:
5.3.1
#### Is Git Deployment:
0
#### PHP_OS:
Linux
#### PHP_BINARY:
/usr/local/php-8.4/sbin/php-fpm
#### PHP SAPI:
fpm-fcgi
#### Timezone Version:
2025.1
#### PHP Timezone:
UTC
#### PHP Time:
1743662719
#### PHP Datetime:
2025-04-03 06:45:19
#### PHP INI max_execution_time:
300
#### PHP INI post_max_size:
256M
#### PHP INI max_input_vars:
20000
#### PHP INI zlib.output_compression:
#### Curl Version:
7.74.0, OpenSSL/1.1.1w
#### Suhosin Installed:
0
#### DB Prefix:
matomo_
#### DB Charset:
utf8mb4
#### DB Collation:
utf8mb4_0900_ai_ci
#### DB Adapter:
PDO\MYSQL
#### MySQL Version:
8.0.36-28
#### Num Tables:
43
#### Browser Segment Archiving Enabled:
1
#### Development Mode Enabled:
0
#### Internet Enabled:
1
#### Multi Server Environment:
0
#### Auto Update Enabled:
1
#### Custom User Path:
0
#### Custom Include Path:
0
#### Release Channel:
latest_stable
#### Plugins Activated:
API, Actions, Annotations, BulkTracking, Contents, CoreAdminHome, CoreConsole, CoreHome, CorePluginsAdmin, CoreUpdater, CoreVisualizations, CoreVue, CustomDimensions, CustomJsTracker, Dashboard, DevicePlugins, DevicesDetection, Diagnostics, Ecommerce, Events, FeatureFlags, Feedback, GeoIp2, Goals, GoogleTheme 5.0.12, Heartbeat, ImageGraph, Insights, Installation, Intl, IntranetMeasurable, JsTrackerInstallCheck, LanguagesManager, Live, Login, Marketplace, MobileMessaging, Monolog, Morpheus, MultiSites, Overlay, PagePerformance, PrivacyManager, ProfessionalServices, Proxy, Referrers, Resolution, RssWidget, SEO, ScheduledReports, SegmentEditor, SitesManager, TagManager, Tour, Transitions, TwoFactorAuth, UserCountry, UserCountryMap, UserId, UserLanguage, UsersManager, VisitFrequency, VisitTime, VisitorInterest, VisitsSummary, WebsiteMeasurable, Widgetize
#### Plugins Deactivated:
DBStats, MobileAppMeasurable, Modern 5.0.6
#### Plugins Invalid:
#### Server Info:
Apache
#### Had visits in last 1 day:
1
#### Had visits in last 3 days:
1
#### Had visits in last 5 days:
1
#### Archive Time Last Started:
-
#### Archive Time Last Finished:
-
#### User Agent:
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36
#### Browser Language:
it-it,it,en-us,en
#### Total Invalidation Count:
5
#### In Progress Invalidation Count:
0
#### Scheduled Invalidation Count:
5
#### Earliest invalidation ts_started:
#### Latest invalidation ts_started:
#### Earliest invalidation ts_invalidated:
2025-04-01 15:09:35
#### Latest invalidation ts_invalidated:
2025-04-02 07:00:59
#### Number of segment invalidations:
0
#### Number of plugin invalidations:
0
#### List of plugins being invalidated:
#### Anonymize Referrer:
#### Do Not Track enabled:
0
I noticed when doing a db check that this thing took 30s to load:
INFO [2025-04-03 06:38:33] 2673 Scheduler: executing task Piwik\Plugins\Marketplace\Tasks.sendNotificationIfUpdatesAvailable...
INFO [2025-04-03 06:39:03] 2673 Scheduler: finished. Time elapsed: 30.218s
I don’t think it’s because of the warnings of the system check since I only have 1 or 2 users per day on my website. When I try to go to the marketplace to install LogViewer I get a 500 error in the console. I don’t have any tmp/logs/matomo.log file.
Matomo is installed on a subdirectory of my website.
The database is accessible.
Tracking is working correctly with no delays.
The problem is that some pages take ages to load up and the marketplace doesn’t load at all.
What could be the problem?