[Tickets #11133] Error while using MySQL-PDO instead of MySQLi...

[bugs at horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/11133
------------------------------------------------------------------------------
  Ticket           | 11133
  Erstellt Von     | klaus at tachtler.net
  Zusammenfassung  | Error while using MySQL-PDO instead of MySQLi...
  Warteschlange    | Horde Base
  Version          | 4.0.14
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


klaus at tachtler.net (2012-04-05 16:03) hat geschrieben:

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.