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

Won't resolve Queries

Discussion in 'Troubleshooting and Problems' started by Arboristsite, Sep 14, 2014.

  1. Arboristsite

    Arboristsite Member

    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!
     
  2. Mike

    Mike XenForo Developer Staff Member

    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. Arboristsite

    Arboristsite Member

    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
     
  4. Mike

    Mike XenForo Developer Staff Member

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

Share This Page