Details
-
Bug
-
Resolution: Obsolete
-
Medium
-
None
-
4.0.0, 4.0.0beta1, 4.0.0rc1
-
None
-
Operating System:
PHP Version: (please be specific, like '4.4.3' or '5.1.5')
Database and version: Mysql 5.0.32
Browser (and version):
Description
When you have many concurrent users you often(90% of the time) get deadlocks when generating cache
Processlist in mysql shows many like these:
5760 | ezp_trunk_usr | 192.168.0.5:57827 | ezp_trunk_db | Query | 48 | update | INSERT INTO ezdbfile (name, name_hash, expired, mtime) VALUES ('var/ezwebin_site/cache/template-block/subtree/2/cache/2/7/5/2750944196.cache', '3f16e67fd4aaae42deed5e02dfd0f335', 1, -1) ON DUPLICATE KEY UPDATE mtime=-ABS(mtime), expired=1 |
Tested with eZPublish 4 stable and eZPublish 4 from svn trunk
Steps to reproduce
1. Install eZPublish
2. change to ezdb handler(cluster setup) according to documentation
3. Generate traffic on the site