[Tickets #10978] Re: Issue viewing sessions when using MySQL/PDO Driver

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/10978
------------------------------------------------------------------------------
  Ticket             | 10978
  Updated By         | Jan Schneider <jan at horde.org>
  Summary            | Issue viewing sessions when using MySQL/PDO Driver
  Queue              | Horde Base
  Version            | 4.0.13
  Type               | Bug
  State              | Resolved
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


Jan Schneider <jan at horde.org> (2012-02-17 18:57) wrote:

>>> Without my patch the sessions page takes 9 seconds to open up, with
>>> my patch it takes under 1 second to open up.
>>
>> It's still the wrong patch. You need to find out where it's spending
>> the additional time.
>
> Ive narrowed down the problem.
>
> Horde/SessionHandler.php:177
> It will hang on this call though to the DB read call but only if  
> userid is equal to the currently logged on userid. This was confimed  
> by putting a continue on a loop if id matched session_id;
> So maybe it seems that you are still holding a row readlock open on  
> the session table of the user.

This shouldn't happen. Can you track it further down into  
SessionHandler/Storage/Sql.php inside the read() method? Is it  
transactionStarted(), beginDbTransaction() or selectValue()?