Quote from: sottwell at Jan 30, 2012, 06:34 AMActually those errors indicate an overloaded MySQL server that cannot return the queries needed to perform the manager actions.
Well, I can assure you that we guessed that
Is there a way to un-overload it?
For example using memcached (which we have on our server, but cannot get MODx to recognize)?
Or forcing MODx to use persistent connections (which is not a documented feature)?
We tried the following steps, which seem to work well for now:
- Backed up site contents, snippets, chunks, templates, TVs and their relationships
- Erased the directories: /core,/connectors, /manager
- Reinstalled revo 2.2.0 from scratch (new install) - deleted cookies - and manager started working again (phew!)
- Overwritten site contents, TVs, etc. with the backed up tables, but site accesses still put the MySQL server off - too many connections, so...
[li]Added this in /core/config/config.inc.php:
$driver_options = array (
PDO::ATTR_PERSISTENT => true
);
[/code
]
In my opinion, this should be turned on by default... anyone knows any drawbacks in doing so?
[/li]
[ed. note: stefanp_safilo last edited this post 14 years, 8 months ago.]