On Mon, Jun 22, 2009 at 10:06 AM, Andreas Jung<li...@zopyx.com> wrote:
> 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/18.104.22.168:35787) Transaction blocked
>> waiting for storage. Clients waiting: 1.
>> But today we eventually got to:
>> 2009-06-22T16:00:11 (30651/22.214.171.124: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.
Will the ZEO server respond to LOAD requests from ZEO clients while
WRITEs are pending?
For more information about ZODB, see the ZODB Wiki:
ZODB-Dev mailing list - ZODB-Dev@zope.org