queue workers get 'stuck' with very long latency
i reset worker.. page loading spinner thingy goes on and on and onm
i click dashboard and get this error
Error: Query Error: Lock wait timeout exceeded; try restarting transaction
as a debugging method i try show proicesslist while its sitting there trying to reset the worker so i could see what tables are being locked
nothing as you clearly see (did it 3 times while it was "waiting" no locks seemed pending when i get the errors
MariaDB [(none)]> SHOW PROCESSLIST;
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| 2064 | greentec_jam | localhost | greentec_jam | Sleep | 62 | | NULL | 0.000 |
| 3143 | greentec_jam | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
| 3228 | greentec_jam | localhost | greentec_jam | Sleep | 0 | | NULL | 0.000 |
| 3229 | greentec_jam | localhost | greentec_jam | Sleep | 0 | | NULL | 0.000 |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
4 rows in set (0.00 sec)
MariaDB [(none)]> SHOW PROCESSLIST;
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| 2064 | greentec_jam | localhost | greentec_jam | Sleep | 73 | | NULL | 0.000 |
| 3143 | greentec_jam | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
| 3389 | greentec_jam | localhost | greentec_jam | Sleep | 0 | | NULL | 0.000 |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
3 rows in set (0.00 sec)
MariaDB [(none)]> SHOW PROCESSLIST;
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
| 2064 | greentec_jam | localhost | greentec_jam | Sleep | 76 | | NULL | 0.000 |
| 3143 | greentec_jam | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
+------+--------------+-----------+--------------+---------+------+-------+------------------+----------+
2 rows in set (0.00 sec)
attached is what my queue lookslike now
image and vid queues both have troubler resetting workers
core seemed to have worked instantly
as per a suggestion i increased the value of the innodb_lock_wait_timeout=120
--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
updated by @soaringeagle: 12/19/17 04:29:54PM
