So when the data archiving process is run, we are getting an odd error.
When we run the update manually with this command
/usr/bin/php8.1 /home/stats/public_html/console core:archive --url=https://XXXX.YYYYYY.com
We have this error:
Uncaught exception: /home/stats/public_html/core/Date.php(166): The date ‘-0001-11-30’ is a date before first website was online. Try date that’s after Aug 6, 1991 (timestamp 681436800).: -62169984000 [Query: , CLI mode: 1]
(this is not related to the latest updates
We found found one similar report
however, it was resolved by modifying tag dates and we do not have any tag dates in our system. So the error is similar but not the same.
We also found another
But apparently this one was resolved by an update to 4.3 and we are on 4.13 (well past that version)
One good thing to note is that the raw data seems to be still collected. If we query the db directly with:
select * from nofNapt2_log_visit order by idvisit desc limit 500;
I can see logs for 8th, 9th, 10th, so it is still logging data but it is not able to generate the reports due to this date bug.
We have re-run the archive manually with extra debug mode on and now we see a full trace:
Exception trace:
() at /home/stats/public_html/core/Date.php:166
Piwik\Date::factory() at /home/stats/public_html/core/CronArchive/SegmentArchiving.php:206
Piwik\CronArchive\SegmentArchiving->getEarliestVisitTimeFor() at /home/stats/public_html/core/CronArchive/SegmentArchiving.php:166
Piwik\CronArchive\SegmentArchiving->getReArchiveSegmentStartDate() at /home/stats/public_html/core/CronArchive.php:948
Piwik\CronArchive->invalidateWithSegments() at /home/stats/public_html/core/CronArchive.php:902
Piwik\CronArchive->invalidateRecentDate() at /home/stats/public_html/core/CronArchive.php:856
Piwik\CronArchive->invalidateArchivedReportsForSitesThatNeedToBeArchivedAgainImpl() at /home/stats/public_html/core/CronArchive.php:806
Piwik\CronArchive->Piwik{closure}() at /home/stats/public_html/core/Tracker/Cache.php:296
Piwik\Tracker\Cache::withDelegatedCacheClears() at /home/stats/public_html/core/CronArchive.php:807
Piwik\CronArchive->invalidateArchivedReportsForSitesThatNeedToBeArchivedAgain() at /home/stats/public_html/core/CronArchive/QueueConsumer.php:178
Piwik\CronArchive\QueueConsumer->getNextArchivesToProcess() at /home/stats/public_html/core/CronArchive.php:392
Piwik\CronArchive->run() at /home/stats/public_html/core/CronArchive.php:278
Piwik\CronArchive->Piwik{closure}() at /home/stats/public_html/core/Access.php:661
Piwik\Access::doAsSuperUser() at /home/stats/public_html/core/CronArchive.php:284
Piwik\CronArchive->main() at /home/stats/public_html/plugins/CoreConsole/Commands/CoreArchiver.php:32
Piwik\Plugins\CoreConsole\Commands\CoreArchiver->execute() at /home/stats/public_html/vendor/symfony/console/Symfony/Component/Console/Command/Command.php:257
Symfony\Component\Console\Command\Command->run() at /home/stats/public_html/vendor/symfony/console/Symfony/Component/Console/Application.php:874
Symfony\Component\Console\Application->doRunCommand() at /home/stats/public_html/vendor/symfony/console/Symfony/Component/Console/Application.php:195
Symfony\Component\Console\Application->doRun() at n/a:n/a
call_user_func() at /home/stats/public_html/core/Console.php:135
Piwik\Console->Piwik{closure}() at /home/stats/public_html/core/Access.php:670
Piwik\Access::doAsSuperUser() at /home/stats/public_html/core/Console.php:136
Piwik\Console->doRunImpl() at /home/stats/public_html/core/Console.php:87
Piwik\Console->doRun() at /home/stats/public_html/vendor/symfony/console/Symfony/Component/Console/Application.php:126
Symfony\Component\Console\Application->run() at /home/stats/public_html/console:32