Here is my software version:
Matomo version: 5.2.1
MySQL version: 8.0.40-0ubuntu0.22.04.1
PHP version: 8.3.14
QueuedTracking 5.1.1
Problem:
When I enable the queuedtracking via web management, the queue number will be increased immeditely, but when I disable the queuedtracking, the queue number still increased, and even I run console command manually it does not help.
fan.chen@matomo-web1:/var/www/html/matomo/config$ sudo su www-data -s /bin/bash -c “/usr/bin/php8.3 /var/www/html/matomo/console queuedtracking:process”
Starting to process request sets, this can take a while
This worker finished queue processing with 0req/s (0 requests in 0.01 seconds)
fan.chen@matomo-web1:/var/www/html/matomo/config$ sudo su www-data -s /bin/bash -c “/usr/bin/php8.3 /var/www/html/matomo/console queuedtracking:lock-status”
“QueuedTrackingLock4” is locked for 15310 ms
Set option --unlock=QueuedTrackingLock4 to unlock the queue.
“QueuedTrackingLock10” is locked for 14449 ms
Set option --unlock=QueuedTrackingLock10 to unlock the queue.
“QueuedTrackingLock6” is locked for 16213 ms
Set option --unlock=QueuedTrackingLock6 to unlock the queue.
“QueuedTrackingLock9” is locked for 14363 ms
Set option --unlock=QueuedTrackingLock9 to unlock the queue.
“QueuedTrackingLock13” is locked for 26049 ms
Set option --unlock=QueuedTrackingLock13 to unlock the queue.
“QueuedTrackingLock5” is locked for 14359 ms
Set option --unlock=QueuedTrackingLock5 to unlock the queue.
“QueuedTrackingLock11” is locked for 13444 ms
Set option --unlock=QueuedTrackingLock11 to unlock the queue.
“QueuedTrackingLock0” is locked for 5549 ms
Set option --unlock=QueuedTrackingLock0 to unlock the queue.
“QueuedTrackingLock2” is locked for 29824 ms
Set option --unlock=QueuedTrackingLock2 to unlock the queue.
“QueuedTrackingLock15” is locked for 19551 ms
Set option --unlock=QueuedTrackingLock15 to unlock the queue.
“QueuedTrackingLock12” is locked for 14392 ms
Set option --unlock=QueuedTrackingLock12 to unlock the queue.
“QueuedTrackingLock1” is locked for 6662 ms
Set option --unlock=QueuedTrackingLock1 to unlock the queue.
“QueuedTrackingLock14” is locked for 18543 ms
Set option --unlock=QueuedTrackingLock14 to unlock the queue.
“QueuedTrackingLock8” is locked for 24709 ms
Set option --unlock=QueuedTrackingLock8 to unlock the queue.
“QueuedTrackingLock3” is locked for 4401 ms
Set option --unlock=QueuedTrackingLock3 to unlock the queue.
“QueuedTrackingLock7” is locked for 14323 ms
Set option --unlock=QueuedTrackingLock7 to unlock the queue.
