"Refurbished" worker doesn't want to work

Sat, 25 Mar 2023 22:34:53 +0100
adminsforum@hubzilla.org
0mega 🕱 [hz] wrote the following post Sat, 25 Mar 2023 22:34:53 +0100
"Refurbished" worker doesn't want to work

Hello,

several days after upgrading my Hubzilla to 8.2 I noticed something strange. Interaction with posts didn't get federated/sent to servers, post weren't showing up in Diaspora or ActivityPub servers. I finally had some time to take a look at the logfile and it also gives me a hint about the lazy worker:
loooong logfile spoiler
webserver2:/# grep -e "workerq" /var/www/html/hzlogs
2023-03-25T21:11:05Z:LOG_INFO:247dae41e1:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:11:08Z:LOG_INFO:0a5f2e3441:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:11:14Z:LOG_INFO:b04b344e8c:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:11:32Z:LOG_INFO:b62756afce:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:11:45Z:LOG_INFO:35b01289e8:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:12:03Z:LOG_INFO:fda3474962:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:12:10Z:LOG_INFO:cad597389d:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:12:29Z:LOG_INFO:000bfc33fa:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:12:32Z:LOG_INFO:f91f96cb2f:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:12:36Z:LOG_INFO:39807e2ca4:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:12:38Z:LOG_INFO:4b04cbab68:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:13:06Z:LOG_INFO:1d87f5b665:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:13:15Z:LOG_INFO:766ea14712:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:13:20Z:LOG_INFO:63cb56bbd9:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:13:39Z:LOG_INFO:6512093788:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:13:44Z:LOG_INFO:2ad18d8390:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:13:55Z:LOG_INFO:20ead33078:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:14:05Z:LOG_ERR:ebd8f194e6:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:14:05Z:LOG_ERR:c6f9283736:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:14:05Z:LOG_ERR:c6f9283736:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:14:05Z:LOG_ERR:c6f9283736:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:14:06Z:LOG_INFO:af410eee46:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:14:32Z:LOG_INFO:864564bc69:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:14:35Z:LOG_INFO:117434de08:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:14:45Z:LOG_INFO:06afbaa3ee:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:15:02Z:LOG_INFO:3705ec455b:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:15:10Z:LOG_INFO:90522229a9:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:15:32Z:LOG_INFO:dc648414d9:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:16:02Z:LOG_INFO:f1d3cf5f96:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:16:09Z:LOG_INFO:fc8d2aae5c:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:16:30Z:LOG_INFO:3a0d9a3c2e:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:16:50Z:LOG_INFO:b116869f42:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:16:53Z:LOG_INFO:7b8af31359:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:16:57Z:LOG_ERR:d455725c59:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:16:57Z:LOG_ERR:140a4f51a6:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:16:57Z:LOG_ERR:140a4f51a6:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:16:57Z:LOG_ERR:140a4f51a6:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:17:05Z:LOG_INFO:8296f0251c:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:17:13Z:LOG_INFO:f4a8c2a123:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:17:19Z:LOG_INFO:f2e540fe92:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:17:44Z:LOG_INFO:5f313be667:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:17:54Z:LOG_INFO:192a7d4742:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:18:06Z:LOG_INFO:3adb964fdb:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:18:06Z:LOG_ERR:e17361ac17:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:18:07Z:LOG_ERR:9eaa52345a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:18:07Z:LOG_ERR:9eaa52345a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:18:07Z:LOG_ERR:9eaa52345a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:18:09Z:LOG_INFO:6301a10012:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:18:13Z:LOG_INFO:07b54c1a62:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:18:26Z:LOG_INFO:f77fdb638b:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:18:30Z:LOG_INFO:08d644c62e:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:18:36Z:LOG_ERR:70ceaf6df4:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:18:36Z:LOG_ERR:7809fbe50a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:18:36Z:LOG_ERR:7809fbe50a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:18:36Z:LOG_ERR:7809fbe50a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:19:04Z:LOG_INFO:db7b6970a0:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:19:12Z:LOG_INFO:1bce0357e1:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:19:30Z:LOG_INFO:e9ec44ce17:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:19:37Z:LOG_INFO:61aeaf059f:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:19:45Z:LOG_INFO:f71753f7cb:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:19:52Z:LOG_INFO:5a6b90b34b:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:20:28Z:LOG_INFO:9ad2049123:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:20:29Z:LOG_INFO:d3862a8af7:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:20:32Z:LOG_ERR:7514c36cf7:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:20:33Z:LOG_INFO:3dc017b972:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:20:33Z:LOG_ERR:7b745cddf2:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:20:33Z:LOG_ERR:7b745cddf2:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:20:33Z:LOG_ERR:7b745cddf2:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:20:38Z:LOG_INFO:3b2fc0bcd9:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:20:44Z:LOG_ERR:498d3b5f49:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:20:44Z:LOG_ERR:5bc4d2648a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:20:44Z:LOG_ERR:5bc4d2648a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:20:44Z:LOG_ERR:5bc4d2648a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:20:47Z:LOG_INFO:1f5fc4e1cb:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:21:08Z:LOG_INFO:749882e154:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:21:12Z:LOG_INFO:846901ad95:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:21:14Z:LOG_INFO:71c77ef596:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:21:34Z:LOG_INFO:eec9e0d102:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:21:54Z:LOG_INFO:60ba75d55e:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:21:58Z:LOG_ERR:a8cadabfc2:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:21:59Z:LOG_ERR:b5e50a6858:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:21:59Z:LOG_ERR:b5e50a6858:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:21:59Z:LOG_ERR:b5e50a6858:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:22:03Z:LOG_INFO:2210d4b6a1:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:22:06Z:LOG_INFO:67cad2f582:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:22:11Z:LOG_INFO:84ef4435e7:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
2023-03-25T21:22:33Z:LOG_ERR:d4c870e2b0:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:22:33Z:LOG_ERR:16e94bbc99:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:22:33Z:LOG_ERR:16e94bbc99:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:22:33Z:LOG_ERR:16e94bbc99:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:22:39Z:LOG_INFO:66a67d6666:QueueWorker.php:60:Summon: Summon: Ignoring duplicate workerq task
root@webserver2:/# grep -e "ERROR" /var/www/html/hzlogs
2023-03-25T21:14:05Z:LOG_ERR:ebd8f194e6:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:14:05Z:LOG_ERR:c6f9283736:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:14:05Z:LOG_ERR:c6f9283736:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:14:05Z:LOG_ERR:c6f9283736:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:16:57Z:LOG_ERR:d455725c59:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:16:57Z:LOG_ERR:140a4f51a6:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:16:57Z:LOG_ERR:140a4f51a6:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:16:57Z:LOG_ERR:140a4f51a6:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:18:06Z:LOG_ERR:e17361ac17:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:18:07Z:LOG_ERR:9eaa52345a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:18:07Z:LOG_ERR:9eaa52345a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:18:07Z:LOG_ERR:9eaa52345a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:18:36Z:LOG_ERR:70ceaf6df4:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:18:36Z:LOG_ERR:7809fbe50a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:18:36Z:LOG_ERR:7809fbe50a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:18:36Z:LOG_ERR:7809fbe50a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:20:32Z:LOG_ERR:7514c36cf7:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:20:33Z:LOG_ERR:7b745cddf2:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:20:33Z:LOG_ERR:7b745cddf2:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:20:33Z:LOG_ERR:7b745cddf2:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:20:44Z:LOG_ERR:498d3b5f49:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:20:44Z:LOG_ERR:5bc4d2648a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:20:44Z:LOG_ERR:5bc4d2648a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:20:44Z:LOG_ERR:5bc4d2648a:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:21:58Z:LOG_ERR:a8cadabfc2:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:21:59Z:LOG_ERR:b5e50a6858:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:21:59Z:LOG_ERR:b5e50a6858:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:21:59Z:LOG_ERR:b5e50a6858:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:22:33Z:LOG_ERR:d4c870e2b0:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:22:33Z:LOG_ERR:16e94bbc99:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:22:33Z:LOG_ERR:16e94bbc99:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:22:33Z:LOG_ERR:16e94bbc99:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:23:09Z:LOG_ERR:c0c226b2cb:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:23:09Z:LOG_ERR:e6e27a1d79:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:23:09Z:LOG_ERR:e6e27a1d79:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:23:09Z:LOG_ERR:e6e27a1d79:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
2023-03-25T21:23:24Z:LOG_ERR:a4a0327742:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:23:24Z:LOG_ERR:088031a6a3:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:23:25Z:LOG_ERR:088031a6a3:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id FROM workerq WHERE workerq_reservationid IS NOT NULL AND workerq_processtimeout < UTC_TIMESTAMP() FOR UPDATE NOWAIT
2023-03-25T21:23:25Z:LOG_ERR:088031a6a3:dba_driver.php:463:db_logger: dba_pdo: ERROR: SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE NOWAIT
It looks like I might have been missing something after the upgrade. workerq has 2034 items at the moment. Any hint what went wrong and how I might fix it would be great. Thanks!
show all 4 comments
Sun, 26 Mar 2023 10:22:28 +0200
Victoria
vsrjaccount@hub.netzgemeinde.eu
There seem to be a lot of queueing issues on different instances since 8.2 was rolled out. I wonder if this is happening elsewhere, too.
Sun, 26 Mar 2023 16:58:56 +0200
Mario Vavti
mario@hub.somaton.com
@0mega 🕱 [hz] which DB and version?
Wed, 05 Apr 2023 07:08:59 +0200
hosh
hosh@hub.vikshepa.com
I have discovered that my modest personal hub, with its one channel, has been affected by the same issue. Queueworker reports a back log of 16,000 items and growing, and the last post to propagate was before the 8.2 update.