[Tickets #5108] Re: session table deadlock with remote calendars

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=5108
-----------------------------------------------------------------------
 Ticket             | 5108
 Updated By         | Chuck Hagenbuch <chuck at horde.org>
 Summary            | session table deadlock with remote calendars
 Queue              | Kronolith
 Version            | 2.1.4
 Type               | Bug
 State              | Assigned
 Priority           | 2. Medium
 Owners             | Horde Developers
-----------------------------------------------------------------------


Chuck Hagenbuch <chuck at horde.org> (2007-06-22 22:08) wrote:

> Actually, why is the page fetching the remote calendar still holding a
lock on the 
> session table at this point anyways?

A simple answer is that we use the session to cache results of remote
calendar lookups. A more complicated answer is that we do a _lot_ of
caching in the session, and it'd take a lot of careful work to make sure
that we do everything we need to the session, including all possible
preferences changes, then close the session (or write close, anyway), and
only then list events.

Jan, do you remember what about remote calendars needs a session in
ics.php? If we can't fix that, either we can do that work to close the
session before listing events, we can try to recognize shares on the same
server and translate them internally. If I understand the problem right we
can't really pin this on table-level locking since at best a user would
still be able to lock their own session up, right?