2010/7/22 Stefan Georg <[email protected]> > We are getting a few errors like this: > > Query error: Lock wait timeout exceeded; try restarting transaction. Query: > UPDATE ezcontentobject_tree SET modified_subnode=1279768018 WHERE > node_id='1' OR node_id='2' OR node_id='220' OR node_id='84458' > > once in a while, does it have to do with high DB traffic preventing the > lock from being set. > > And if so, can the lock timeout be increased somehow? > Increasing the lock timeout probably isn't the right solution. Check the following: - if using ezfind, are you using DelayedIndexing ? - has your SQL server been tuned correctly (innodb_buffer_pool_size, etc) ?
-- Bertrand
-- Sdk-public mailing list [email protected] http://lists.ez.no/mailman/listinfo/sdk-public
