@Max Kostikov no, I#m working on mariadb 10.11.19 - Unfortunately, the problem does exist!
original
Comment on @Hubzilla Support Forum If you are under reliatively fresh MySQL 8 then try
SELECT workerq_id, workerq_cmd FROM workerq WHERE workerq_reservationid IS NULL ORDER BY workerq_priority DESC, workerq_id ASC LIMIT 1 FOR UPDATE SKIP LOCKED;