[horde] webmail session problems, help required...

[Kostas Katsamakas]

Jan Schneider wrote:
> Zitat von Kostas Katsamakas <kmak at ccf.auth.gr>:
>
>> Hello to everyone.
>>
>> Recently our horde/imp email has been upgraded and we are facing some 
>> problems regarding
>> our sessions.
>>
>> We are curently using
>> horde 3.3.6
>> imp H3 4.3.4
>>
>> We get a lot of log messages:
>>
>> [horde] Error retrieving session data (id = 
>> 7331c3f467119efaa34fcdb38464a629): Lock wait timeout exceeded; try 
>> restarting transaction [pid 25439 on line 144 of 
>> "/var/www/mydomain/htdocs/horde/lib/Horde/SessionHandler/mysql.php"]
>>
>> and some
>>
>> [horde] Error writing session data: Lock wait timeout exceeded; try 
>> restarting transaction [pid 25440 on line 185 of 
>> "/var/www/mydomain/htdocs/horde/lib/Horde/SessionHandler/mysql.php"]
>>
>> these problems appear really often when i set in horde config:
>> $conf[sessionhandler][params][persistent] = true
>
> Then don't enable it. Unless you have a bottleneck in authenticating 
> database users or making database connections, it won't help you much 
> anyway.
>
Yes, for the moment we keep the persistent connection disabled.
>> Note: I use Mysql based sessions and 
>> $conf[sessionhandler][params][rowlocking] = true;
>
> And do you use the InnoDB engine for the session handler table?
>
Yes horde_sessionhandler table is InnoDB , all other tables are MyISAM 
in the database.
>> When i set persistent connections to false then these messages don't 
>> disappear completelly but become very much scarce.
>> They appear much less often.
>>
>> In our old horde/imp system no problem occured and it had the same 
>> options i mentioned before.
>>
>> Our old system was with:
>> imp H3 4.1.4 cvs
>> horde 3.1.6
>>
>>
>> I don't know what could be wrong. I even compared the source code of 
>> the source files mentioned in the log with the source code in the 
>> previous horde version.
>> It was almost the same and with no 'important' changes.
>> Has anyone faced this problem  and solved it?
>>
>> Thank you.
>>
>>
>>
>> -- 
>> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>>
>
>
>
> Jan.
>