Console core:archive broken after upgrade from 4.16 to 5.3

futureweb · March 17, 2025, 4:21pm

Hello,
today I upgraded out matomo instance from 4.16 to current 5.3. Now I noticed that the archive Job seems to be broken.

INFO      [2025-03-17 16:15:06] 2457642  ''
ERROR     [2025-03-17 16:15:06] 2457642  Error unserializing the following response from ?module=API&method=CoreAdminHome.archiveReports&idSite=5&period=month&date=2025-03-01&format=json&plugin=Actions&trigger=archivephp&pluginOnly=1&requestedReport=Actions_hits: ''
ERROR     [2025-03-17 16:15:06] 2457642  Got invalid response from API request: ?module=API&method=CoreAdminHome.archiveReports&idSite=5&period=year&date=2025-01-01&format=json&plugin=Actions&trigger=archivephp&pluginOnly=1&requestedReport=Actions_hits. The response was empty. This usually means a server error. A solution to this error is generally to increase the value of 'memory_limit' in your php.ini file.  For more information and the error message please check in your PHP CLI error log file. As this core:archive command triggers PHP processes over the CLI, you can find where PHP CLI logs are stored by running this command: php -i | grep error_log

Also on executing it I get Segfault?

# sudo -u apache /usr/bin/php /var/www/piwik/console core:archive --url=https://dom.tld/ > /var/log/piwik.cron.log
Segmentation fault

CT-453 /# php -v
PHP 8.3.17 (cli) (built: Feb 11 2025 22:03:03) (NTS gcc x86_64)

PHP Error logs are empty, memory_limit already upped from 1GB which was working in 4 to 8GB - but still not working.

I hope someone here got an idea on that?

Thank you
Andreas

futureweb · March 17, 2025, 4:28pm

when running with -vvv I get:

DEBUG     [2025-03-17 16:24:55] 2459752  Found invalidation for segment that does not have auto archiving enabled, skipping: 400138
DEBUG     [2025-03-17 16:24:55] 2459752  Could not find stored segment for done flag hash: done41d843321ad217ed3cec122b9d7b81dc
DEBUG     [2025-03-17 16:24:55] 2459752  Found invalidation for segment that does not have auto archiving enabled, skipping: 326413
DEBUG     [2025-03-17 16:24:55] 2459752  Could not find stored segment for done flag hash: done4fd90ac4f0011017429f702bef0adec4
DEBUG     [2025-03-17 16:24:55] 2459752  Found invalidation for segment that does not have auto archiving enabled, skipping: 252688
DEBUG     [2025-03-17 16:24:55] 2459752  Could not find stored segment for done flag hash: done6c05fcdde514f05d9a295fd352a5dcfc
DEBUG     [2025-03-17 16:24:55] 2459752  Found invalidation for segment that does not have auto archiving enabled, skipping: 178963
DEBUG     [2025-03-17 16:24:55] 2459752  No usable archive exists (ts_archived of existing = , now = 2025-03-17 16:24:55).
DEBUG     [2025-03-17 16:24:55] 2459752  Found invalidated archive we can skip (no visits): [idinvalidation = 170574, idsite = 13, period = week(2025-02-24 - 2025-03-02), name = done.Actions, segment = ]
DEBUG     [2025-03-17 16:24:55] 2459752  Could not find stored segment for done flag hash: done6795a2d9cdd1e3a9316f9ae5b562a5fb
DEBUG     [2025-03-17 16:24:55] 2459752  Found invalidation for segment that does not have auto archiving enabled, skipping: 612924
DEBUG     [2025-03-17 16:24:55] 2459752  Could not find stored segment for done flag hash: done21b7e98637a31453151ff3b47bc90383
DEBUG     [2025-03-17 16:24:55] 2459752  Found invalidation for segment that does not have auto archiving enabled, skipping: 539199
DEBUG     [2025-03-17 16:24:55] 2459752  Could not find stored segment for done flag hash: done313deb671b0f7d3757e033860c414331
DEBUG     [2025-03-17 16:24:55] 2459752  Found invalidation for segment that does not have auto archiving enabled, skipping: 465474
DEBUG     [2025-03-17 16:24:55] 2459752  Could not find stored segment for done flag hash: done41d843321ad217ed3cec122b9d7b81dc
DEBUG     [2025-03-17 16:24:55] 2459752  Found invalidation for segment that does not have auto archiving enabled, skipping: 391749
DEBUG     [2025-03-17 16:24:55] 2459752  Could not find stored segment for done flag hash: done4fd90ac4f0011017429f702bef0adec4
DEBUG     [2025-03-17 16:24:55] 2459752  Found invalidation for segment that does not have auto archiving enabled, skipping: 318024
DEBUG     [2025-03-17 16:24:55] 2459752  Could not find stored segment for done flag hash: done6c05fcdde514f05d9a295fd352a5dcfc
DEBUG     [2025-03-17 16:24:55] 2459752  Found invalidation for segment that does not have auto archiving enabled, skipping: 244299
DEBUG     [2025-03-17 16:24:55] 2459752  No usable archive exists (ts_archived of existing = , now = 2025-03-17 16:24:55).
Segmentation fault

futureweb · March 17, 2025, 4:40pm

System-Check says all OK?

Click to view System Check

Mandatory checks

PHP-Version >= 7.2.5:

8.3.17

PDO Erweiterung:

PDO\MYSQL Erweiterung:

MYSQLI Erweiterung:

Weitere erforderliche Anforderungen:

zlib json filter hash session

Erforderliche Funktionen:

debug_backtrace eval hash gzcompress gzuncompress pack

Benötigte PHP Konfiguration (php.ini):

session.auto_start = 0 max_execution_time = 0 OR = -1 OR >= 30

Verzeichnisse mit Schreibzugriff:

$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

Optional checks

Verzeichnisse, welche privat sein müssen:

Alle privaten Verzeichnisse sind nicht aus dem Internet zugänglich.

Empfohlene private Verzeichnisse:

Alle privaten Verzeichnisse sind nicht aus dem Internet zugänglich.

Dateiintegrität:

64-bit PHP Binär:

Tracker-Status:

Speicherlimit:

128M

Zeitzone:

Öffnen einer URL:

curl

PageSpeed ist deaktiviert:

GD > 2.x + FreeType (Grafiken):

Andere Erweiterungen:

json libxml dom SimpleXML openssl

Andere Funktionen:

shell_exec set_time_limit mail parse_ini_file glob gzopen md5_file hash_file

Dateisystem:

Cron einrichten - Prozesse via CLI steuern:

OK

Letzter erfolgreicher Abschluss der Archivierung:

Der Archivierungsprozess wurde vor 01:16:41 erfolgreich abgeschlossen.

Datenbankfähigkeiten:

UTF8mb4 charset Connection collation LOAD DATA INFILE CREATE TEMPORARY TABLES Changing transaction isolation level

Maximale Packetgröße:

Erzwungene SSL Verbindung:

Standorterkennung:

geoip2php (continent_code, continent_name, country_code, country_name, region_code, region_name, city_name, postal_code, lat, long, isp, org)

Update über HTTPS:

Mobile Messaging SMS Provider:

not configured

Schreibbarer JavaScript-Tracker (“/matomo.js” & “/piwik.js”):

Informational results

Matomo Version:

5.3.0

Matomo Update History:

4.16.0,4.11.0,4.10.1,4.9.1,4.6.2,4.6.1

Matomo Install Version:

Unknown - pre 3.8.

Latest Available Version:

5.3.0

Is Git Deployment:

0

PHP_OS:

Linux

PHP_BINARY:

/usr/sbin/php-fpm

PHP SAPI:

fpm-fcgi

Timezone Version:

2025.1

PHP Timezone:

UTC

PHP Time:

1742229451

PHP Datetime:

2025-03-17 16:37:31

PHP INI max_execution_time:

30

PHP INI post_max_size:

8M

PHP INI max_input_vars:

1000

PHP INI zlib.output_compression:

Curl Version:

7.76.1, OpenSSL/3.2.2

Suhosin Installed:

0

DB Prefix:

piwik_

DB Charset:

utf8mb4

DB Collation:

utf8mb4_general_ci

DB Adapter:

MYSQLI

MySQL Version:

11.4.5-MariaDB

Num Tables:

456

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, AjaxOptOut 1.5.0, Annotations, BulkTracking, Contents, CoreAdminHome, CoreConsole, CoreHome, CorePluginsAdmin, CoreUpdater, CoreVisualizations, CoreVue, CustomDimensions, CustomJsTracker, DBStats, Dashboard, DevicePlugins, DevicesDetection, Diagnostics, Ecommerce, Events, FeatureFlags, GeoIp2, Goals, Heartbeat, ImageGraph, Installation, Intl, IntranetMeasurable, JsTrackerInstallCheck, LanguagesManager, Live, Login, Marketplace, MobileMessaging, Monolog, Morpheus, MultiSites, Overlay, PagePerformance, PrivacyManager, Provider 5.0.4, Proxy, Referrers, Resolution, RssWidget, SEO, ScheduledReports, SegmentEditor, SitesManager, Tour, Transitions, TwoFactorAuth, UserCountry, UserCountryMap, UserId, UserLanguage, UsersManager, VisitFrequency, VisitTime, VisitorInterest, VisitsSummary, WebsiteMeasurable, Widgetize

Plugins Deactivated:

AnonymousPiwikUsageMeasurement 5.0.1, CustomOptOut 2.0.5, CustomVariables 5.0.4, ExampleFeedburner, ExampleRssWidget 1.0, Feedback, GeoIPMap, Insights, MobileAppMeasurable, PiwikPro 5.3.0, ProfessionalServices, SecurityInfo, TagManager, TasksTimetable 5.0.1, VisitorGenerator, Zeitgeist 5.3.0

Plugins Invalid:

ExampleFeedburner, GeoIPMap, SecurityInfo, VisitorGenerator

Server Info:

Apache/2.4.62 (AlmaLinux) OpenSSL/3.2.2

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:

2025-03-17 16:33:41

Archive Time Last Finished:

2025-03-17 15:20:50

User Agent:

Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:136.0) Gecko/20100101 Firefox/136.0

Browser Language:

de,en-us,en

Total Invalidation Count:

263523

In Progress Invalidation Count:

8

Scheduled Invalidation Count:

263515

Earliest invalidation ts_started:

2025-03-17 17:22:48

Latest invalidation ts_started:

2025-03-17 17:33:48

Earliest invalidation ts_invalidated:

2025-03-17 16:05:02

Latest invalidation ts_invalidated:

2025-03-17 16:33:46

Number of segment invalidations:

224264

Number of plugin invalidations:

263247

List of plugins being invalidated:

Actions

Anonymize Referrer:

Do Not Track enabled:

0