Summary
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 INTOmodx_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";}’)
Array
(
[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
Environment
MODX 2.8.4
MySQL 5.7.38
PHP 7.2.34 with PHP-FPM enabled