[Tickets #7618] Re: Logout failed with mysql session handler

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/7618
------------------------------------------------------------------------------
  Ticket             | 7618
  Updated By         | falon at csi.it
  Summary            | Logout failed with mysql session handler
  Queue              | Horde Groupware Webmail Edition
  Version            | 1.2
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


falon at csi.it (2008-11-06 04:52) wrote:

> Do you have any other session problems with the mysql handler? Are
> you using innodb tables?

I use inno_db session_handler table.
I made some test again.

If I set conf[sessionhandler][params][persistent] to true, then I  
don't have logout issue, but after login session freezes. Sometime I  
can browse imap folder and navigate for a while, but finally browser  
freezes. The error I see into log is this:
"2008-11-06T10:43:00.348816+01:00 vm HORDE[22497]: [horde] Error  
retrieving session data (id = m4h77vd7f9tl94v9q7ludjbca4): Lock wait  
timeout exceeded; try restarting transaction [pid 22497 on line 144 of  
"/var/www/html/horde-webmail-1.2/lib/Horde/SessionHandler/mysql.php"]
2008-11-06T10:43:52.354482+01:00 vm HORDE[22497]: [imp] Error writing  
session data: Lock wait timeout exceeded; try restarting transaction  
[pid 22497 on line 185 of  
"/var/www/html/horde-webmail-1.2/lib/Horde/SessionHandler/mysql.php"]
2008-11-06T10:44:44.361514+01:00 vm HORDE[22497]: [horde] Error  
retrieving session data (id = m4h77vd7f9tl94v9q7ludjbca4): Lock wait  
timeout exceeded; try restarting transaction [pid 22497 on line 144 of  
"/var/www/html/horde-webmail-1.2/lib/Horde/SessionHandler/mysql.php"] "


If I set conf[sessionhandler][params][persistent] to false, I don't  
have problem. Horde is fast and work well. But if I try logout, I  
receive this error: "We cannot verify that this request was really  
sent by you. It could be a malicious request". If I go back to  
previous page I reload horde, so no logout happens.

MySQL is 5.0.32.