[Tickets #10978] 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
  Created By         | it at wenn.com
  Summary            | Issue viewing sessions when using MySQL/PDO Driver
  Queue              | Horde Base
  Version            | 4.0.13
  Type               | Bug
  State              | Unconfirmed
  Priority           | 3. High
  Milestone          |
  Patch              | 1
  Owners             |
------------------------------------------------------------------------------


it at wenn.com (2012-02-10 15:15) wrote:

When we view the Administrations->Sessions the page comes up with an error.

--horde.log--
2012-02-10T12:58:08+00:00 EMERG: HORDE [horde] There is already an  
active transaction [pid 28447 on line 644 of  
"/home/httpd/live/webmail.wenn.com/htdocs/pear/php/Horde/Db/Adapter/Base.php"]

--weboutput--
A fatal error has occurred
There is already an active transaction
1. Horde_SessionHandler->getSessionsInfo()  
/home/httpd/live/webmail/htdocs/admin/sessions.php:29
2. Horde_SessionHandler->read()  
/home/httpd/live/webmail/htdocs/pear/php/Horde/SessionHandler.php:275
3. Horde_SessionHandler_Storage_Stack->read()  
/home/httpd/live/webmail/htdocs/pear/php/Horde/SessionHandler.php:177
4. Horde_SessionHandler_Storage_Sql->read()  
/home/httpd/live/webmail/htdocs/pear/php/Horde/SessionHandler/Storage/Stack.php:88
5. Horde_Db_Adapter_Base->beginDbTransaction()  
/home/httpd/live/webmail/htdocs/pear/php/Horde/SessionHandler/Storage/Sql.php:91
6. PDO->beginTransaction()  
/home/httpd/live/webmail.wenn.com/htdocs/pear/php/Horde/Db/Adapter/Base.php:644

This error does not happen straight away after you login, it happens  
after you have gone though a few pages.
The issue does not seem to happen if i use the MySQLi driver instead  
of the PDO.

Things to note, we are running horde sessions in MySQL due to having a  
HAproxy LB setup.

Ive attached a patch file to fix. Seems that you are not closing the  
transaction just after you retrieve all the the SessionIDs, afterwards  
you then have to do lots more reads.



it at wenn.com (2012-02-10 15:15) uploaded: horde.patch

http://bugs.horde.org/h/services/download/?module=whups&actionID=download_file&file=horde.patch&ticket=10978&fn=%2Fhorde.patch