• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Won't resolve Queries

#1
Please see logs. Don't know how to get these to resolve.

('deferredRun', 'i:14107319 |
| 2222 | arborist_user | localhost | arborist_xenforonew | Execute | 404 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2225 | arborist_user | localhost | arborist_xenforonew | Execute | 403 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2231 | arborist_user | localhost | arborist_xenforonew | Execute | 402 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2311 | arborist_user | localhost | arborist_xenforonew | Execute | 397 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2315 | arborist_user | localhost | arborist_xenforonew | Execute | 396 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2321 | arborist_user | localhost | arborist_xenforonew | Execute | 395 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2434 | arborist_user | localhost | arborist_xenforonew | Execute | 386 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2449 | arborist_user | localhost | arborist_xenforonew | Execute | 385 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2450 | arborist_user | localhost | arborist_xenforonew | Execute | 384 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2459 | arborist_user | localhost | arborist_xenforonew | Execute | 383 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2548 | arborist_user | localhost | arborist_xenforonew | Execute | 378 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2595 | arborist_user | localhost | arborist_xenforonew | Execute | 376 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2611 | arborist_user | localhost | arborist_xenforonew | Execute | 376 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2615 | arborist_user | localhost | arborist_xenforonew | Execute | 375 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2645 | arborist_user | localhost | arborist_xenforonew | Execute | 373 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2648 | arborist_user | localhost | arborist_xenforonew | Execute | 373 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2649 | arborist_user | localhost | arborist_xenforonew | Execute | 373 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2680 | arborist_user | localhost | arborist_xenforonew | Execute | 372 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2693 | arborist_user | localhost | arborist_xenforonew | Execute | 371 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2694 | arborist_user | localhost | arborist_xenforonew | Execute | 370 | update | INSERT INTO xf_deferred
(execute_class, execute_data, unique_key, manual_execute, trigger_date) |
| 2784 | arborist_user | localhost | arborist_xenforonew | Execute | 364 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2793 | arborist_user | localhost | arborist_xenforonew | Execute | 364 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2813 | arborist_user | localhost | arborist_xenforonew | Execute | 363 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2819 | arborist_user | localhost | arborist_xenforonew | Execute | 362 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2825 | arborist_user | localhost | arborist_xenforonew | Execute | 362 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2840 | arborist_user | localhost | arborist_xenforonew | Execute | 360 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2876 | arborist_user | localhost | arborist_xenforonew | Execute | 353 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107319 |
| 2927 | arborist_user | localhost | arborist_xenforonew | Execute | 348 | update | INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
('deferredRun', 'i:14107320 |
| 3075 | arborist_user | localhost | arborist_xenforonew | Execute | 343 | update | INSERT INTO xf_data_registry..



Please help!
 

Mike

XenForo developer
Staff member
#2
There are likely older queries there that are the ones that are fundamentally executing, but everything you're showing likely just points to the server being totally overloaded/starved for resources. When you have a busy forum and there's a massive load spike, it's likely to just compound and get worse unless/until you interrupt it (such as disabling access to the server for your users).

You may need to kill many of these queries manually.
 
#3
This give more info? The process won't kill.




Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
20 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
23 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
29 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
32 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
34 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
35 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
36 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
37 minutes ago - library/Zend/Db/Statement/Mysqli.php:214
Delete...
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
 

Mike

XenForo developer
Staff member
#4
That's really just the query timing out (unsurprising if the query was running/waiting more than 400 seconds, likely blocked by another query).