Hello!
First of all, thank to all MODx developers for their work.
My question is: what should I do to limit simultaneous connections to the DB in manager (especially when phpthumb is generating images in the filemanager) to keep it working and not popping me out of the session? This is the log of the "crash":
[2011-05-03 21:37:56] (ERROR in xPDO::connect @ /home/vol3/byethost7.com/b7_7374124/htdocs/core/xpdo/xpdo.class.php : 342) SQLSTATE[42000] [1203] User b7_7374124 already has more than 'max_user_connections' active connections
[2011-05-03 21:37:56] (ERROR @ /connectors/system/phpthumb.php) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ? - Array
(
[0] => 00000
)
[2011-05-03 21:37:59] (ERROR in xPDO::connect @ /home/vol3/byethost7.com/b7_7374124/htdocs/core/xpdo/xpdo.class.php : 342) SQLSTATE[42000] [1203] User b7_7374124 already has more than 'max_user_connections' active connections
[2011-05-03 21:37:59] (ERROR in xPDO::connect @ /home/vol3/byethost7.com/b7_7374124/htdocs/core/xpdo/xpdo.class.php : 342) SQLSTATE[42000] [1203] User b7_7374124 already has more than 'max_user_connections' active connections
[2011-05-03 21:37:59] (ERROR @ /connectors/system/phpthumb.php) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ? -
[2011-05-03 21:37:59] (ERROR in xPDO::connect @ /home/vol3/byethost7.com/b7_7374124/htdocs/core/xpdo/xpdo.class.php : 342) SQLSTATE[42000] [1203] User b7_7374124 already has more than 'max_user_connections' active connections
[2011-05-03 21:37:59] (ERROR in xPDO::connect @ /home/vol3/byethost7.com/b7_7374124/htdocs/core/xpdo/xpdo.class.php : 342) SQLSTATE[42000] [1203] User b7_7374124 already has more than 'max_user_connections' active connections
[2011-05-03 21:37:59] (ERROR @ /connectors/system/phpthumb.php) Error preparing statement for query: SELECT modAccessContext.id, modAccessContext.target, modAccessContext.principal, modAccessContext.authority, modAccessContext.policy, Policy.data FROM `modx_access_context` AS `modAccessContext` LEFT JOIN `modx_access_policies` `Policy` ON `modAccessContext`.`policy` = `Policy`.`id` WHERE ( `modAccessContext`.`principal_class` = ? AND `modAccessContext`.`target` = ? ) ORDER BY modAccessContext.target,modAccessContext.principal,modAccessContext.authority,modAccessContext.policy ASC -
[2011-05-03 21:37:59] (ERROR in xPDO::connect @ /home/vol3/byethost7.com/b7_7374124/htdocs/core/xpdo/xpdo.class.php : 342) SQLSTATE[42000] [1203] User b7_7374124 already has more than 'max_user_connections' active connections
[2011-05-03 21:37:59] (ERROR in xPDO::connect @ /home/vol3/byethost7.com/b7_7374124/htdocs/core/xpdo/xpdo.class.php : 342) SQLSTATE[42000] [1203] User b7_7374124 already has more than 'max_user_connections' active connections
[2011-05-03 21:37:59] (ERROR @ /connectors/system/phpthumb.php) Error preparing statement for query: SELECT `modContext`.`key` AS `modContext_key`, `modContext`.`description` AS `modContext_description` FROM `modx_context` AS `modContext` WHERE `modContext`.`key` = ? -
[2011-05-03 21:38:01] (ERROR in xPDO::connect @ /home/vol3/byethost7.com/b7_7374124/htdocs/core/xpdo/xpdo.class.php : 342) SQLSTATE[42000] [1203] User b7_7374124 already has more than 'max_user_connections' active connections
[2011-05-03 21:38:01] (ERROR @ /connectors/system/phpthumb.php) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ? - Array
(
[0] => 00000
)
Also, how to find out the actual ’max_user_connections’?
My environment is:
Revolution 2.1.0-rc1
Apache version: 2.2.15 (Unix)
PHP version: 5.2.13
MySQL version: 5.1.45
Thanks in advance.
