On 22.06.09 16:56, Pedro Ferreira wrote: > Hello all, > We occasionally get some messages like this in the logs: > > 2009-06-22T14:12:42 (30651/137.138.128.213:35787) Transaction blocked > waiting for storage. Clients waiting: 1. > > But today we eventually got to: > > 2009-06-22T16:00:11 (30651/137.138.4.153:53416) Transaction blocked > waiting for storage. Clients waiting: 204. > > Which lasted some minutes. During that time, our system seemed to hang, > even if it was possible to connect to the db through the command line. > It eventually went back to normal by itself. > Any clue on what might have caused this? The reason is likely a long running transaction. Since the storage server is single-threaded, a long running transaction will block pending requests.
-aj
begin:vcard fn:Andreas Jung n:Jung;Andreas org:ZOPYX Ltd. & Co. KG adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany email;internet:i...@zopyx.com title:CEO tel;work:+49-7071-793376 tel;fax:+49-7071-7936840 tel;home:+49-7071-793257 x-mozilla-html:FALSE url:www.zopyx.com version:2.1 end:vcard
_______________________________________________ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev