Problem with daily report / archiving

LightMan · March 21, 2026, 11:45am

This is my configuration:

Matomo version: 5.8.0
MySQL version: 10.3.35-MariaDB
PHP version: 7.4.30

Hello everyone,
for the past few weeks I’ve noticed that Matomo is no longer able to process/confirm daily reports for my analytics.

In the main view, the last few days remain marked as “invalidated”, but if I apply any segment, everything looks fine.

Today I also noticed another issue: when I select the year view for 2024, it shows 0 visits and 0 page views (everything is zero). However, if I switch to monthly or daily view, all data is there and correct.

The database backup (with data retention set to delete raw data after 180 days) is about 35 GB (compressed), and we have roughly 1 million page views per day.

How can I investigate this issue and understand:

Why daily reports are no longer being processed correctly
Why the yearly view for 2024 shows zero data

The cron job is configured to run every 3600 seconds and is executed via CRON every hour.

If you want, I can also make it more technical (for developers) or more concise

Jason_1282 · March 24, 2026, 11:12pm

Have you had a chance to check out the troubleshooting here: How can I find diagnostic information for report archiving? FAQ - On-Premise - Matomo Analytics Platform

LightMan · March 25, 2026, 6:37am

Hi jason, i have launched this :

/usr/bin/php /var/www/matomo/console diagnostic:archiving-queue

ERROR [2026-03-25 06:35:33] 1317109 Uncaught exception: /core/Date.php(1153): Date format must be: YYYY-MM-DD, or ‘today’ or ‘yesterday’ or any keyword supported by the strtotime function (see for more information): NULL [Query: , CLI mode: 1]

In Date.php line 1153:

Date format must be: YYYY-MM-DD, or ‘today’ or ‘yesterday’ or any keyword supported by the strtotime function (see for more information): NULL

diagnostics:archiving-queue [–json]

Any idea to resolve this ?

LightMan · March 25, 2026, 5:49pm

This is the output : archiving-instance-statistic

±---------------------±----------------+

| Statistic Name | Value |

±---------------------±----------------+

| Site Count | 2 |

| Segment Count | 18 |

| Database Version | 10.3.35-MariaDB |

| Last full Month Hits | 26552551 |

| Last 12 Month Hits | 135002783 |

±---------------------±----------------+

Archive Config:

±---------±------------------------------------------------------------±------------------+

| Section | Setting | Value |

±---------±------------------------------------------------------------±------------------+

| database | enable_segment_first_table_join_prefix | 0 |

| database | enable_first_table_join_prefix | 0 |

| general | browser_archiving_disabled_enforce | 0 |

| general | enable_processing_unique_visitors_day | 1 |

| general | enable_processing_unique_visitors_week | 1 |

| general | enable_processing_unique_visitors_month | 1 |

| general | enable_processing_unique_visitors_year | 0 |

| general | enable_processing_unique_visitors_range | 0 |

| general | enable_processing_unique_visitors_multiple_sites | 0 |

| general | process_new_segments_from | beginning_of_time |

| general | time_before_today_archive_considered_outdated | 900 |

| general | time_before_week_archive_considered_outdated | -1 |

| general | time_before_month_archive_considered_outdated | -1 |

| general | time_before_year_archive_considered_outdated | -1 |

| general | time_before_range_archive_considered_outdated | -1 |

| general | enable_browser_archiving_triggering | 1 |

| general | archiving_range_force_on_browser_request | 1 |

| general | archiving_custom_ranges[] | |

| general | archiving_query_max_execution_time | 7200 |

| general | archiving_ranking_query_row_limit | 50000 |

| general | disable_archiving_segment_for_plugins | |

| general | disable_archive_actions_goals | 0 |

| general | datatable_archiving_maximum_rows_referrers | 1000 |

| general | datatable_archiving_maximum_rows_subtable_referrers | 50 |

| general | datatable_archiving_maximum_rows_userid_users | 50000 |

| general | datatable_archiving_maximum_rows_custom_dimensions | 1000 |

| general | datatable_archiving_maximum_rows_subtable_custom_dimensions | 1000 |

| general | datatable_archiving_maximum_rows_actions | 500 |

| general | datatable_archiving_maximum_rows_subtable_actions | 100 |

| general | datatable_archiving_maximum_rows_site_search | 500 |

| general | datatable_archiving_maximum_rows_events | 500 |

| general | datatable_archiving_maximum_rows_subtable_events | 500 |

| general | datatable_archiving_maximum_rows_products | 10000 |

| general | datatable_archiving_maximum_rows_standard | 500 |

±---------±------------------------------------------------------------±------------------+

archiving-status

Invalidation Queue

±-------------±--------±-----±-------±-----±------------±--------±--------±-----------±-------+

±-------------±--------±-----±-------±-----±------------±--------±--------±-----------±-------+

Archiving Metrics

±-------------------------------------±------+

| Metric | Value |

±-------------------------------------±------+

| Total Invalidation Count | 0 |

| In Progress Invalidation Count | 0 |

| Scheduled Invalidation Count | 0 |

| Earliest invalidation ts_started | |

| Latest invalidation ts_started | |

| Earliest invalidation ts_invalidated | |

| Latest invalidation ts_invalidated | |

| Number of segment invalidations | 0 |

| Number of plugin invalidations | 0 |

| List of plugins being invalidated | |

±-------------------------------------±------+

Archiving Configuration Settings