Error HY000 executing statement in Log


Getting error in the Log saying:

[2022-07-19 14:58:40] (ERROR @ /home/magellaninreview/xcore/xpdo/om/xpdoobject.class.php : 1452) Error HY000 executing statement:
INSERT INTO modx_session (id, access, data) VALUES (‘79f1c2e8fadf5ce83ac0ca6f0219146a’, 1658206720, ‘modx.user.contextTokens|a:1:{s:3:"mgr";i:1;}modx.mgr.user.token|s:52:"modx627899188eca60.86935435_162d5ec4fdb6570.39000064";modx.mgr.session.cookie.lifetime|i:0;modx.mgr.user.config|a:0:{}modx.user.1.userGroupNames|a:1:{i:0;s:13:"Administrator";}newResourceTokens|a:9:{i:0;s:23:"62d5efb2b84b45.54551654";i:1;s:23:"62d5efbaea9fd8.22899996";i:2;s:23:"62d5efbcc838a4.58680592";i:3;s:23:"62d5efbd77d6b7.65791587";i:4;s:23:"62d60af35260f1.35594564";i:5;s:23:"62d60afa7cc153.74217185";i:6;s:23:"62d60afb223696.18853315";i:7;s:23:"62d60afce47933.25922711";i:8;s:23:"62d620014fe398.32914473";}’)
[0] => HY000
[1] => 2014
[2] => 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.

Have optimised the database.

Step to reproduce

Not sure what is causing this to happen

Observed behavior

Not sure whether this is affecting the performance of the site or not. The site had a hit of about 3,500 users yesterday with no errors and then this morning got this error. It looks like this could be something related to updating the modx_session table

Expected behavior

Not appear in the Error Log


MODX 2.8.4
MySQL 5.7.38
PHP 7.2.34 with PHP-FPM enabled