Database Errore

  • Resolved tendenzeshabbychic

    (@tendenzeshabbychic)


    2 years, 9 months ago

    WordPress errore sul database Connection was killed per la query SELECT *, CASE
    WHEN type = 3 THEN 0
    WHEN type = 4 THEN 1
    WHEN type = 7 THEN 2
    WHEN type = 6 THEN 3
    WHEN type = 5 THEN 4
    WHEN type = 9 THEN 5
    WHEN type = 8 THEN 6
    WHEN type = 2 THEN 7
    WHEN type = 1 THEN 8
    ELSE 9999
    END AS typeSort, CASE
    WHEN type = 3 THEN parameters
    WHEN type = 4 THEN parameters
    WHEN type = 1 THEN IP
    WHEN type = 9 THEN IP
    WHEN type = 5 THEN IP
    WHEN type = 6 THEN IP
    WHEN type = 7 THEN IP
    WHEN type = 2 THEN IP
    WHEN type = 8 THEN IP
    ELSE 9999
    END AS detailSort
    FROM db_wfblocks7 WHERE type IN (4) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC fatta da wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::patternBlocks, wfBlock::allBlocks

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter tendenzeshabbychic

    (@tendenzeshabbychic)

    Hello.
    Forgive me in the rush to paste I sent without presenting the problem.
    I tried unsuccessfully for a solution.
    Can you help me?

    Plugin Support wfpeter

    (@wfpeter)

    Hi @tendenzeshabbychic, thanks for the log information highlighting the issue.

    We see posts about this exact issue from time-to-time and have been sent log information from our customers where the exact same error is also reporting for other WordPress plugins.

    For this reason, we believe that the issue is related to the database itself where MySQL/MariaDB is stopping, reconnecting and leaving the connection in a state that somehow causes this query error to appear.

    We usually request that you or your host check the database server logs and other logs for the website(s) on the server such as syslog etc. to see what else is going on with the server at the timestamp of these issues. I would expect the database to be unavailable temporarily, either because it is restarting or has crashed.

    This customer was having intermittent load issues on their server:
    https://www.ads-software.com/support/topic/commands-out-of-sync-can-we-get-a-resolution-please/

    Although investigation isn’t conclusive here, Elegant Themes looks to be experiencing similar “Commands out of sync” issues on a server also flagging these problems with wfblocks7: https://www.ads-software.com/support/topic/database-error-wfblocks7/

    To assist us see whether there’s a consistent element between your case and others, can you send a diagnostic report to wftest @ wordfence . com? You can find the link to do so at the top of the Wordfence > Tools > Diagnostics page. Then click on “Send Report by Email”. Please add your forum username where indicated and respond here after you have sent it.

    NOTE: It should look as follows – Screenshot of Tools > Diagnostic > Send by Email

    Thanks,

    Peter.

    Thread Starter tendenzeshabbychic

    (@tendenzeshabbychic)

    I send report.

    Thanks

    Plugin Support wfpeter

    (@wfpeter)

    Hi @tendenzeshabbychic,

    I still don’t see your forum username when searching our inboxes for diagnostic reports, including our spam folders. Did you include it when sending? Feel free to send again with your forum username to see if it works again.

    Thanks again,

    Peter.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database Errore’ is closed to new replies.