Forums / Setup & design / eZDFSFileHandlerMySQLBackend::_startCacheGeneration: Unexpected error #1205

eZDFSFileHandlerMySQLBackend::_startCacheGeneration: Unexpected error #1205

Author Message

Francis Martinez

Thursday 28 April 2011 10:16:18 am

Hi,

I have a clusterized site and i get this errors:

[ Apr 27 2011 14:41:20 ] [192.168.100.38] eZDFSFileHandlerMySQLBackend::_startCacheGeneration:
Unexpected error #1205 when trying to start cache generation on var/elheraldo_site/cache/template-block/2/2/8/2284715345.cache (Lock wait timeout exceeded; try restarting transaction)

eZDFSFileHandlerMySQLBackend::_startCacheGeneration:
Unexpected error #2006 when trying to start cache generation on var/elheraldo_site/cache/template-block/subtree/2/0/7/cache/2/3/1/2315520902.cache (MySQL server has gone away)

eZDFSFileHandlerMySQLBackend::_startCacheGeneration:
Unexpected error #1213 when trying to start cache generation on var/elheraldo_site/storage/images/ediciones/2011/04/26/noticias/el-sueno-americano-de-un-centroamericano-hecho-realidad/4359253-1-esl-HN/El-sueno-americano-de-un-centroamericano-hecho-realidad.jpg (Deadlock found when trying to get lock; try restarting transaction)

I receantly changed the password of my Database User and changed the file.ini, site.ini and the cluster file, but since I get all this error I rolled back to the old password, but the problems seems to continue.

Can someone help me? The user site stops workings, and then suddenly starts working again, I see that the cluster database is heavily loaded. The admin site seems to works just fine.