Hi @asmecher @NateWr @bozana can you help me to solve the statistics problem?
I have seen several times that UsageStats jobs fail. I don’t know how to handle this error.
Illuminate\Queue\MaxAttemptsExceededException: APP\jobs\statistics\CompileUsageStatsFromTemporaryRecords has been attempted too many times or run too long. The job may have previously timed out. in /ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Queue/Worker.php:746
Stack trace:
#0 /ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(505): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(415): Illuminate\Queue\Worker->markJobAsFailedIfAlreadyExceedsMaxAttempts()
#2 /ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#3 /ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(326): Illuminate\Queue\Worker->runJob()
#4 /ojs/lib/pkp/classes/core/PKPQueueProvider.php(104): Illuminate\Queue\Worker->runNextJob()
#5 /ojs/lib/pkp/classes/queue/JobRunner.php(220): PKP\core\PKPQueueProvider->runJobInQueue()
#6 /ojs/lib/pkp/classes/core/PKPQueueProvider.php(128): PKP\queue\JobRunner->processJobs()
#7 [internal function]: PKP\core\PKPQueueProvider->PKP\core\{closure}()
#8 {main}
#0 /ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(505): Illuminate\Queue\Worker->maxAttemptsExceededException()
#1 /ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(415): Illuminate\Queue\Worker->markJobAsFailedIfAlreadyExceedsMaxAttempts()
#2 /ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(375): Illuminate\Queue\Worker->process()
#3 /ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(326): Illuminate\Queue\Worker->runJob()
#4 /ojs/lib/pkp/classes/core/PKPQueueProvider.php(104): Illuminate\Queue\Worker->runNextJob()
#5 /ojs/lib/pkp/classes/queue/JobRunner.php(220): PKP\core\PKPQueueProvider->runJobInQueue()
#6 /ojs/lib/pkp/classes/core/PKPQueueProvider.php(128): PKP\queue\JobRunner->processJobs()
#7 [internal function]: PKP\core\PKPQueueProvider->PKP\core\{closure}()
#8 {main}
{
"uuid": "98c1c005-ce6a-4062-aab7-0d9574bba4c4",
"displayName": "APP\\jobs\\statistics\\CompileUsageStatsFromTemporaryRecords",
"job": "Illuminate\\Queue\\CallQueuedHandler@call",
"maxTries": 1,
"maxExceptions": 3,
"failOnTimeout": true,
"backoff": "5",
"timeout": 60,
"retryUntil": null,
"data": {
"commandName": "APP\\jobs\\statistics\\CompileUsageStatsFromTemporaryRecords",
"command": "O:57:\"APP\\jobs\\statistics\\CompileUsageStatsFromTemporaryRecords\":3:{s:9:\"\u0000*\u0000loadId\";s:25:\"usage_events_20240113.log\";s:10:\"connection\";s:8:\"database\";s:5:\"queue\";s:5:\"queue\";}"
}
}
{
"message": "APP\\jobs\\statistics\\CompileUsageStatsFromTemporaryRecords has been attempted too many times or run too long. The job may have previously timed out.",
"code": 0,
"file": "\/ojs\/lib\/pkp\/lib\/vendor\/laravel\/framework\/src\/Illuminate\/Queue\/Worker.php",
"line": 746,
"trace": [
{
"file": "\/ojs\/lib\/pkp\/lib\/vendor\/laravel\/framework\/src\/Illuminate\/Queue\/Worker.php",
"line": 505,
"function": "maxAttemptsExceededException",
"class": "Illuminate\\Queue\\Worker",
"type": "->"
},
{
"file": "\/ojs\/lib\/pkp\/lib\/vendor\/laravel\/framework\/src\/Illuminate\/Queue\/Worker.php",
"line": 415,
"function": "markJobAsFailedIfAlreadyExceedsMaxAttempts",
"class": "Illuminate\\Queue\\Worker",
"type": "->"
},
{
"file": "\/ojs\/lib\/pkp\/lib\/vendor\/laravel\/framework\/src\/Illuminate\/Queue\/Worker.php",
"line": 375,
"function": "process",
"class": "Illuminate\\Queue\\Worker",
"type": "->"
},
{
"file": "\/ojs\/lib\/pkp\/lib\/vendor\/laravel\/framework\/src\/Illuminate\/Queue\/Worker.php",
"line": 326,
"function": "runJob",
"class": "Illuminate\\Queue\\Worker",
"type": "->"
},
{
"file": "\/EPUB\/ojs\/lib\/pkp\/classes\/core\/PKPQueueProvider.php",
"line": 104,
"function": "runNextJob",
"class": "Illuminate\\Queue\\Worker",
"type": "->"
},
{
"file": "\/EPUB\/ojs\/lib\/pkp\/classes\/queue\/JobRunner.php",
"line": 220,
"function": "runJobInQueue",
"class": "PKP\\core\\PKPQueueProvider",
"type": "->"
},
{
"file": "\/ojs\/lib\/pkp\/classes\/core\/PKPQueueProvider.php",
"line": 128,
"function": "processJobs",
"class": "PKP\\queue\\JobRunner",
"type": "->"
},
{
"function": "PKP\\core\\{closure}",
"class": "PKP\\core\\PKPQueueProvider",
"type": "->"
}
]
}