Error: Last Successful Archiving completion

Hello,

We have got an issue with our Matomo analytics data. It is not recording data and there is some error.

This error occurred after we’ve upgraded to PHP 8 on the server.

Both error log and screenshot demonstrating the issue are provided below.

What could be the reason for this issue to occur, and what do we need to do in order to fix it?

Thank you

Screenshot demonstrating the issue:

Error log:
<details>
<summary>Click to view System Check</summary>

Mandatory checks

PHP version >= 7.2.5:

:heavy_check_mark: 8.1.6

PDO extension:

:heavy_check_mark:

PDO\MYSQL extension:

:heavy_check_mark:

MYSQLI extension:

:heavy_check_mark:

Other required extensions:

:heavy_check_mark: zlib :heavy_check_mark: json :heavy_check_mark: filter :heavy_check_mark: hash :heavy_check_mark: session

Required functions:

:heavy_check_mark: debug_backtrace :heavy_check_mark: eval :heavy_check_mark: hash :heavy_check_mark: gzcompress :heavy_check_mark: gzuncompress :heavy_check_mark: pack

Required PHP configuration (php.ini):

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

Directories with write access:

:heavy_check_mark: $DOC_ROOT/tmp :heavy_check_mark: $DOC_ROOT/tmp/assets :heavy_check_mark: $DOC_ROOT/tmp/cache :heavy_check_mark: $DOC_ROOT/tmp/climulti :heavy_check_mark: $DOC_ROOT/tmp/latest :heavy_check_mark: $DOC_ROOT/tmp/logs :heavy_check_mark: $DOC_ROOT/tmp/sessions :heavy_check_mark: $DOC_ROOT/tmp/tcpdf :heavy_check_mark: $DOC_ROOT/tmp/templates_c

Optional checks

Required Private Directories:

:heavy_check_mark: All private directories are inaccessible from the internet.

Recommended Private Directories:

:heavy_check_mark: All private directories are inaccessible from the internet.

File integrity:

:heavy_check_mark:

64-bit PHP Binary:

:heavy_check_mark:

Tracker status:

:heavy_check_mark:

Memory limit:

:heavy_check_mark: 128M

Time zone:

:heavy_check_mark:

Open URL:

:heavy_check_mark: curl

PageSpeed is turned off:

:heavy_check_mark:

GD > 2.x + FreeType (graphics):

:heavy_check_mark:

Other extensions:

:heavy_check_mark: json :heavy_check_mark: libxml :heavy_check_mark: dom :heavy_check_mark: SimpleXML :heavy_check_mark: openssl

Other functions:

:heavy_check_mark: shell_exec :heavy_check_mark: set_time_limit :heavy_check_mark: mail :heavy_check_mark: parse_ini_file :heavy_check_mark: glob :heavy_check_mark: gzopen :heavy_check_mark: md5_file

Filesystem:

:heavy_check_mark:

Set up Cron - Managing processes via CLI:

:heavy_check_mark: Ok

Last Successful Archiving Completion:

:warning: Error: Archiving last ran successfully on Thursday, May 19, 2022 10:00:31 which is 16 days 03:04:37 ago.<br/><br/>Please check that you have setup a crontab calling the <code>core:archive</code> console command, and that you have configured a <code>MAILTO</code> to receive errors by email if archiving fails. You can also try to run the console command to archive your reports manually: <code>$DOC_ROOT/console --matomo-domain=OBSFURCATED.com core:archive</code>. Learn more.

Database abilities:

:heavy_check_mark: UTF8mb4 charset :warning: Warning: LOAD DATA INFILE<br/>Hint: Using LOAD DATA INFILE by updating your PHP and MySQL software and ensuring your database user has the FILE privilege speeds up Matomo’s archiving process a lot.<br/>You should fix this problem if your Matomo server tracks high-traffic websites (e.g. > 100,000 pages per month).<br/><strong>Error:</strong> LOAD DATA INFILE failed… Error was: <br/> Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user ‘OBSFURCATED’@‘localhost’ (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 :heavy_check_mark: CREATE TEMPORARY TABLES :heavy_check_mark: Changing transaction isolation level

Max Packet Size:

:heavy_check_mark:

Forced SSL Connection:

:heavy_check_mark:

Geolocation:

:heavy_check_mark: geoip2php (continent_code, continent_name, country_code, country_name, region_code, region_name, city_name, postal_code, lat, long)

Update over HTTPS:

:heavy_check_mark:

Writable JavaScript Tracker ("/matomo.js" & “/piwik.js”):

:heavy_check_mark:

Informational results

Matomo Version:

4.10.1

Matomo Update History:

4.9.1,4.6.2,4.6.1,4.5.0,4.4.1,4.3.1

Matomo Install Version:

Unknown - pre 3.8.

Latest Available Version:

4.10.1

Is Git Deployment:

0

PHP_OS:

Linux

PHP_BINARY:

/usr/local/bin/lsphp

PHP SAPI:

litespeed

Timezone Version:

0.system

PHP Timezone:

UTC

PHP Time:

1654347908

PHP Datetime:

2022-06-04 13:05:08

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.83.1, OpenSSL/1.1.1o

Suhosin Installed:

0

DB Prefix:

piwik_

DB Charset:

utf8mb4

DB Adapter:

PDO\MYSQL

MySQL Version:

8.0.29

Num Tables:

321

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, CustomVariables 4.1.0, Dashboard, DevicePlugins, DevicesDetection, Diagnostics, Ecommerce, Events, Feedback, GeoIp2, Goals, Heartbeat, ImageGraph, Insights, Installation, Intl, IntranetMeasurable, LanguagesManager, Live, Login, Marketplace, MobileMessaging, Monolog, Morpheus, MultiSites, Overlay, PagePerformance, PrivacyManager, ProfessionalServices, Proxy, Referrers, Resolution, RssWidget, SEO, ScheduledReports, SegmentEditor, SitesManager, Tour, Transitions, TwoFactorAuth, UserCountry, UserCountryMap, UserId, UserLanguage, UsersManager, VisitFrequency, VisitTime, VisitorInterest, VisitsSummary, WebsiteMeasurable, Widgetize

Plugins Deactivated:

DBStats, MobileAppMeasurable, Provider 4.0.3, TagManager

Plugins Invalid:

Server Info:

LiteSpeed

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:

1652954401

Archive Time Last Finished:

1652954431

User Agent:

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.61 Safari/537.36

Browser Language:

en-gb

Total Invalidation Count:

55

In Progress Invalidation Count:

0

Scheduled Invalidation Count:

55

Earliest invalidation ts_started:

Latest invalidation ts_started:

Earliest invalidation ts_invalidated:

2022-05-29 17:01:06

Latest invalidation ts_invalidated:

2022-05-29 17:01:06

Number of segment invalidations:

0

Number of plugin invalidations:

0

List of plugins being invalidated:

Anonymize Referrer:

Do Not Track enabled:

1

</details>

Do you see any error in the Matomo log file?