Skip to content

awstats cronjob randomly aborts with error

Summary

since November 2022 i noticed that some on websites some days show 0 Entries in the statistics, the first day where the stats were missing was for 21.11.2022 (3.2.9 Release)

it looks like the cronjob is aborted on some website and for all unprocessed websites not statistics is generated.

Steps to reproduce

i do not know how to reproduce the issue, all i can say is that it does not happen every day, about 3 times last month, and at least once in december.

Correct behaviour

statistics should include data for all days.

Environment

Server OS + version: Debian 10.13 ISPConfig version: 3.2.9

Software version of the related software: Apache/2.4.38 (Debian) PHP 7.3.33-8

Related log entries

on these days /var/log/syslog contains:

Dec  9 03:21:21 php: Stack trace:
Dec  9 03:21:21 php: #0 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(270): mysqli_ping(Object(mysqli))                      
Dec  9 03:21:21 php: #1 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(339): db->_query('SELECT domain F...', '298')          
Dec  9 03:21:21 php: #2 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(395): db->query('SELECT domain F...', '298')           
Dec  9 03:21:21 php: #3 /usr/local/ispconfig/server/lib/classes/cron.d/150-awstats.inc.php(99): db->queryAllRecords('SELECT domain F...', '298')
Dec  9 03:21:21 php: #4 /usr/local/ispconfig/server/lib/classes/cronjob.inc.php(90): cronjob_awstats->onRunJob()                        
Dec  9 03:21:21 php: #5 /usr/local/ispconfig/server/cron.php(116): cronjob->run()                                                       
Dec  9 03:21:21 php: #6 {main}
Dec  9 03:21:21 php:   thrown in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 270

i tried to remove awstats from an "affected" domain, but now the error occured at another domain. there where no errors with the statistics before November 2022 with any domain.