Could not begin transaction triggered by bots

Danloona · February 26, 2020 at 11:58 AM

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

/home/site/hectorsky/home/public_html/lib/system/user/storage/UserStorageHandler.class.php (274): wcf\system\database\Database->beginTransaction(…)
/home/site/hectorsky/home/public_html/lib/system/WCF.class.php (214): wcf\system\user\storage\UserStorageHandler->shutdown(…)
[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

/home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167): PDO->beginTransaction(…)
/home/site/hectorsky/home/public_html/lib/system/user/storage/UserStorageHandler.class.php (274): wcf\system\database\Database->beginTransaction(…)
/home/site/hectorsky/home/public_html/lib/system/WCF.class.php (214): wcf\system\user\storage\UserStorageHandler->shutdown(…)
[internal function] (?): wcf\system\WCF::destruct(…)

Tue, 25 Feb 2020 17:00:47 +0000
Message: Could not begin transaction
PHP version: 7.3.14
WoltLab Suite version: 5.2.2
Request URI: /index.php?ajax-proxy/&t=067c6f7ad58cad7c350f639d3c4233613567ec00
Referrer: https://hectorsky.net/
User Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0
Peak Memory Usage: 11345056/134217728
======
Error Class: wcf\system\database\exception\DatabaseTransactionException
Error Message: Could not begin transaction
Error Code: 0
File: /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (180)
Extra Information: -
Stack Trace: [{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/user\/storage\/UserStorageHandler.class.php","line":274,"function":"beginTransaction","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/WCF.class.php","line":214,"function":"shutdown","class":"wcf\\system\\user\\storage\\UserStorageHandler","type":"->","args":[]},{"function":"destruct","class":"wcf\\system\\WCF","type":"::","args":[],"file":"[internal function]","line":"?"}]
======
Error Class: PDOException
Error Message: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error Code: 0
File: /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167)
Extra Information: -
Stack Trace: [{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/database\/Database.class.php","line":167,"function":"beginTransaction","class":"PDO","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/user\/storage\/UserStorageHandler.class.php","line":274,"function":"beginTransaction","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/WCF.class.php","line":214,"function":"shutdown","class":"wcf\\system\\user\\storage\\UserStorageHandler","type":"->","args":[]},{"function":"destruct","class":"wcf\\system\\WCF","type":"::","args":[],"file":"[internal function]","line":"?"}]

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

/home/site/hectorsky/home/public_html/lib/system/user/storage/UserStorageHandler.class.php (274): wcf\system\database\Database->beginTransaction(…)
/home/site/hectorsky/home/public_html/lib/system/WCF.class.php (214): wcf\system\user\storage\UserStorageHandler->shutdown(…)
[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

/home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167): PDO->beginTransaction(…)
/home/site/hectorsky/home/public_html/lib/system/user/storage/UserStorageHandler.class.php (274): wcf\system\database\Database->beginTransaction(…)
/home/site/hectorsky/home/public_html/lib/system/WCF.class.php (214): wcf\system\user\storage\UserStorageHandler->shutdown(…)
[internal function] (?): wcf\system\WCF::destruct(…)

Thu, 20 Feb 2020 03:35:41 +0000
Message: Could not begin transaction
PHP version: 7.3.14
WoltLab Suite version: 5.2.2
Request URI: /index.php?ajax-proxy/&t=ac466612e02d14919ebc9548e60fe10af711ccb6
Referrer: https://hectorsky.net/
User Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:73.0) Gecko/20100101 Firefox/73.0
Peak Memory Usage: 11345088/134217728
======
Error Class: wcf\system\database\exception\DatabaseTransactionException
Error Message: Could not begin transaction
Error Code: 0
File: /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (180)
Extra Information: -
Stack Trace: [{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/user\/storage\/UserStorageHandler.class.php","line":274,"function":"beginTransaction","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/WCF.class.php","line":214,"function":"shutdown","class":"wcf\\system\\user\\storage\\UserStorageHandler","type":"->","args":[]},{"function":"destruct","class":"wcf\\system\\WCF","type":"::","args":[],"file":"[internal function]","line":"?"}]
======
Error Class: PDOException
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.
Error Code: 0
File: /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167)
Extra Information: -
Stack Trace: [{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/database\/Database.class.php","line":167,"function":"beginTransaction","class":"PDO","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/user\/storage\/UserStorageHandler.class.php","line":274,"function":"beginTransaction","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/WCF.class.php","line":214,"function":"shutdown","class":"wcf\\system\\user\\storage\\UserStorageHandler","type":"->","args":[]},{"function":"destruct","class":"wcf\\system\\WCF","type":"::","args":[],"file":"[internal function]","line":"?"}]

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

/home/site/hectorsky/home/public_html/lib/system/registry/RegistryHandler.class.php (165): wcf\system\database\Database->beginTransaction(…)
/home/site/hectorsky/home/public_html/lib/system/WCF.class.php (213): wcf\system\registry\RegistryHandler->shutdown(…)
[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

/home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167): PDO->beginTransaction(…)
/home/site/hectorsky/home/public_html/lib/system/registry/RegistryHandler.class.php (165): wcf\system\database\Database->beginTransaction(…)
/home/site/hectorsky/home/public_html/lib/system/WCF.class.php (213): wcf\system\registry\RegistryHandler->shutdown(…)
[internal function] (?): wcf\system\WCF::destruct(…)

Sat, 15 Feb 2020 03:19:59 +0000
Message: Could not begin transaction
PHP version: 7.3.14
WoltLab Suite version: 5.2.2
Request URI: /index.php?ajax-proxy/&t=d88b0ed8e63524f3fc55a9857ff9ca7f052297dd
Referrer: https://hectorsky.net/
User Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0
Peak Memory Usage: 11345072/134217728
======
Error Class: wcf\system\database\exception\DatabaseTransactionException
Error Message: Could not begin transaction
Error Code: 0
File: /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (180)
Extra Information: -
Stack Trace: [{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/registry\/RegistryHandler.class.php","line":165,"function":"beginTransaction","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/WCF.class.php","line":213,"function":"shutdown","class":"wcf\\system\\registry\\RegistryHandler","type":"->","args":[]},{"function":"destruct","class":"wcf\\system\\WCF","type":"::","args":[],"file":"[internal function]","line":"?"}]
======
Error Class: PDOException
Error Message: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Error Code: 0
File: /home/site/hectorsky/home/public_html/lib/system/database/Database.class.php (167)
Extra Information: -
Stack Trace: [{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/database\/Database.class.php","line":167,"function":"beginTransaction","class":"PDO","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/registry\/RegistryHandler.class.php","line":165,"function":"beginTransaction","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/home\/site\/hectorsky\/home\/public_html\/lib\/system\/WCF.class.php","line":213,"function":"shutdown","class":"wcf\\system\\registry\\RegistryHandler","type":"->","args":[]},{"function":"destruct","class":"wcf\\system\\WCF","type":"::","args":[],"file":"[internal function]","line":"?"}]

SoftCreatR · February 26, 2020 at 12:00 PM

Quote from Hectorsky

MySQL server has gone away

That's the important information. However, that's nothing you could fix by yourself. Your hoster has do look at it.

Danloona · February 26, 2020 at 12:01 PM

Quote from SoftCreatR

That's the important information. However, that's nothing you could fix by yourself. Your hoster has do look at it.

Hey, I'm the owner of the server.

i have full root access

Server is on CloudLinux 7.7

Woodmen · February 26, 2020 at 12:03 PM

Quote from Hectorsky

Hey, I'm the owner of the server.
i have full root access
Server is on CloudLinux 7.7

Then check your MySQL Configuration.

SoftCreatR · February 26, 2020 at 12:04 PM

Well then: https://dev.mysql.com/doc/refman/8.0/en/gone-away.html

There are plenty of possible reasons, however it's pretty likely, that you just need to adjust your MySQL configuration to meet your requirements.

Danloona · February 26, 2020 at 12:05 PM

Quote from Woodmen

Then check your MySQL Configuration.

I've checked.

Here is the config

Code

[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
symbolic-links = 0
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
character_set_server=utf8mb4
default-storage-engine=INNODB
innodb_large_prefix=ON
innodb_default_row_format=DYNAMIC
max_allowed_packet=256M
innodb_log_file_size=256M

Display More

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

Danloona · March 6, 2020 at 9:56 PM Best Answer

Issue was gone after update to 5.2.3

Participate now!