Could not begin transaction triggered by bots

  • Affected Version
    WoltLab Suite 5.2

    Hello everyone,

    I found weird issue with what i need some advice.


    I often receive these codes on my WoltLab site, mostly it's triggered by bots, maybe someone had this type of issue?

    Requested URL
    /index.php?ajax-proxy/&t=067c6f7ad58cad7c350f639d3c4233613567ec00
    Referrer
    https://hectorsky.net/
    Error Message
    Could not begin transaction
    Type
    wcf\system\database\exception\DatabaseTransactionException
    File (Line)
    /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (180)
    Stacktrace
    1. /home/site/hectorsky/home/public_html/lib/system/user/storage/UserStorageHandler.class.php (274): wcf\system\database\Database->beginTransaction(…)
    2. /home/site/hectorsky/home/public_html/lib/system/WCF.class.php (214): wcf\system\user\storage\UserStorageHandler->shutdown(…)
    3. [internal function] (?): wcf\system\WCF::destruct(…)
    Error Message
    SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
    Type
    PDOException
    File (Line)
    /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167)
    Stacktrace
    1. /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167): PDO->beginTransaction(…)
    2. /home/site/hectorsky/home/public_html/lib/system/user/storage/UserStorageHandler.class.php (274): wcf\system\database\Database->beginTransaction(…)
    3. /home/site/hectorsky/home/public_html/lib/system/WCF.class.php (214): wcf\system\user\storage\UserStorageHandler->shutdown(…)
    4. [internal function] (?): wcf\system\WCF::destruct(…)
    Requested URL
    /index.php?ajax-proxy/&t=ac466612e02d14919ebc9548e60fe10af711ccb6
    Referrer
    https://hectorsky.net/
    Error Message
    Could not begin transaction
    Type
    wcf\system\database\exception\DatabaseTransactionException
    File (Line)
    /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (180)
    Stacktrace
    1. /home/site/hectorsky/home/public_html/lib/system/user/storage/UserStorageHandler.class.php (274): wcf\system\database\Database->beginTransaction(…)
    2. /home/site/hectorsky/home/public_html/lib/system/WCF.class.php (214): wcf\system\user\storage\UserStorageHandler->shutdown(…)
    3. [internal function] (?): wcf\system\WCF::destruct(…)
    Error Message
    SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
    Type
    PDOException
    File (Line)
    /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167)
    Stacktrace
    1. /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167): PDO->beginTransaction(…)
    2. /home/site/hectorsky/home/public_html/lib/system/user/storage/UserStorageHandler.class.php (274): wcf\system\database\Database->beginTransaction(…)
    3. /home/site/hectorsky/home/public_html/lib/system/WCF.class.php (214): wcf\system\user\storage\UserStorageHandler->shutdown(…)
    4. [internal function] (?): wcf\system\WCF::destruct(…)
    Requested URL
    /index.php?ajax-proxy/&t=d88b0ed8e63524f3fc55a9857ff9ca7f052297dd
    Referrer
    https://hectorsky.net/
    Error Message
    Could not begin transaction
    Type
    wcf\system\database\exception\DatabaseTransactionException
    File (Line)
    /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (180)
    Stacktrace
    1. /home/site/hectorsky/home/public_html/lib/system/registry/RegistryHandler.class.php (165): wcf\system\database\Database->beginTransaction(…)
    2. /home/site/hectorsky/home/public_html/lib/system/WCF.class.php (213): wcf\system\registry\RegistryHandler->shutdown(…)
    3. [internal function] (?): wcf\system\WCF::destruct(…)
    Error Message
    SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
    Type
    PDOException
    File (Line)
    /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167)
    Stacktrace
    1. /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167): PDO->beginTransaction(…)
    2. /home/site/hectorsky/home/public_html/lib/system/registry/RegistryHandler.class.php (165): wcf\system\database\Database->beginTransaction(…)
    3. /home/site/hectorsky/home/public_html/lib/system/WCF.class.php (213): wcf\system\registry\RegistryHandler->shutdown(…)
    4. [internal function] (?): wcf\system\WCF::destruct(…)
  • Go to Best Answer
  • Then check your MySQL Configuration.

    I've checked.

    Here is the config

    On the same database server, works also Jira and everything is fine, only WoltLab spits in.

    About the error, it appears just periodicaly. mostly at night

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!