6.0.0-beta1
9/1/25

[#11133] Error while using MySQL-PDO instead of MySQLi...
Summary Error while using MySQL-PDO instead of MySQLi...
Queue Horde Base
Queue Version 4.0.14
Type Bug
State Duplicate
Priority 2. Medium
Owners
Requester klaus (at) tachtler (dot) net
Created 04/05/2012 (4897 days ago)
Due
Updated 04/05/2012 (4897 days ago)
Assigned
Resolved 04/05/2012 (4897 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
04/05/2012 07:41:56 PM klaus (at) tachtler (dot) net Comment #3 Reply to this comment
So, the patch from Bug #10978 solves the problem!

/* Explicitly do garbage collection call here to make sure session
          * data is correct. */
         $this->gc(ini_get('session.gc_maxlifetime'));

         $sessions = $this->getSessionIDs();
-->   $this->close();

         $this->_storage->readonly = true;

Thank you, so much for your fast and great help, on my small problems!

Klaus.
04/05/2012 06:11:15 PM Jan Schneider Comment #2
State ⇒ Duplicate
Reply to this comment
04/05/2012 04:03:23 PM klaus (at) tachtler (dot) net Comment #1
Priority ⇒ 2. Medium
Patch ⇒ No
Milestone ⇒
Queue ⇒ Horde Base
Summary ⇒ Error while using MySQL-PDO instead of MySQLi...
Type ⇒ Bug
State ⇒ Unconfirmed
Reply to this comment
When I use MySQL-PDO in horde4-Database settings, following error 
occurs, when I'm logged in as an Administrator and click to (German) 
--> Administration  | Sitzungen | Aktuelle Sessions.

When I use MySQLI in horde4-Database settings, the error doesn't occur 
and the sessions will be displayed, without any errors.

The horde-error log says:

--- LOG ---

Apr  5 18:00:55 host HORDE: [horde] There is already an active 
transaction [pid 14209 on line 644 of 
"/usr/share/pear/Horde/Db/Adapter/Base.php"]

--- LOG ---

The Browser screen says:

--- SCREEN ---

Ein schwerer Fehler ist aufgetreten:
There is already an active transaction

1. Horde_SessionHandler->getSessionsInfo() 
/var/www/horde4/admin/sessions.php:29
2. Horde_SessionHandler->read() /usr/share/pear/Horde/SessionHandler.php:275
3. Horde_SessionHandler_Storage_Sql->read() 
/usr/share/pear/Horde/SessionHandler.php:177
4. Horde_Db_Adapter_Base->beginDbTransaction() 
/usr/share/pear/Horde/SessionHandler/Storage/Sql.php:91
5. PDO->beginTransaction() /usr/share/pear/Horde/Db/Adapter/Base.php:644

Details
Die vollständige Fehlermeldung wurde in Hordes Logdatei geschrieben 
und für Administratoren weiter unten ausgegeben. Benutzer, die keine 
Administratoren sind, bekommen diese Details nicht zu sehen.

PDOException Object
(
     [message:protected] => There is already an active transaction
     [string:Exception:private] =>
     [code:protected] => 0
     [file:protected] => /usr/share/pear/Horde/Db/Adapter/Base.php
     [line:protected] => 644
     [trace:Exception:private] => Array
         (
             [0] => Array
                 (
                     [file] => /usr/share/pear/Horde/Db/Adapter/Base.php
                     [line] => 644
                     [function] => beginTransaction
                     [class] => PDO
                     [type] => ->
                     [args] => Array
                         (
                         )

                 )

             [1] => Array
                 (
                     [file] => 
/usr/share/pear/Horde/SessionHandler/Storage/Sql.php
                     [line] => 91
                     [function] => beginDbTransaction
                     [class] => Horde_Db_Adapter_Base
                     [type] => ->
                     [args] => Array
                         (
                         )

                 )

             [2] => Array
                 (
                     [file] => /usr/share/pear/Horde/SessionHandler.php
                     [line] => 177
                     [function] => read
                     [class] => Horde_SessionHandler_Storage_Sql
                     [type] => ->
                     [args] => Array
                         (
                             [0] => pn82oj2a077rjctg0ti0fde2a6
                         )

                 )

             [3] => Array
                 (
                     [file] => /usr/share/pear/Horde/SessionHandler.php
                     [line] => 275
                     [function] => read
                     [class] => Horde_SessionHandler
                     [type] => ->
                     [args] => Array
                         (
                             [0] => pn82oj2a077rjctg0ti0fde2a6
                         )

                 )

             [4] => Array
                 (
                     [file] => /var/www/horde4/admin/sessions.php
                     [line] => 29
                     [function] => getSessionsInfo
                     [class] => Horde_SessionHandler
                     [type] => ->
                     [args] => Array
                         (
                         )

                 )

         )

     [previous:Exception:private] =>
     [errorInfo] =>
)

--- SCREEN ---

Did I make a mistake in any configuration file, or is this a bug?


Thank you!

Klaus.

Saved Queries