[Tickets #14175] oci8 driver sesion handler

[noreply at bugs.horde.org]

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

Ticket URL: https://bugs.horde.org/ticket/14175
------------------------------------------------------------------------------
  Ticket             | 14175
  Created By         | ico at cc.upv.es
  Summary            | oci8 driver sesion handler
  Queue              | Horde Groupware Webmail Edition
  Version            | 5.2.11
  Type               | Bug
  State              | Unconfirmed
  Priority           | 3. High
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


ico at cc.upv.es (2015-12-02 16:24) wrote:

I think there's a bug passign sql sentence to oci9 driver.
Oracle has a limit of 4000 when writting a blob. It seems to be needed  
binding data in Oracle.

Here is the log:

Dec 2 17:18:49 DEBUG: HORDE SQL  (0,0006s)
         SELECT 1 FROM horde_sessionhandler WHERE session_id =
           'e9o7r02bttkvltmr58ord29ap1' [pid 3399 on line 328 of  
"/usr/share/pear/Horde/Db/Adapter/Oci8.php"]
Dec 2 17:18:49 DEBUG: HORDE SQL
         INSERT INTO horde_sessionhandler (session_id, session_data,
           session_lastmodified) VALUES ('e9o7r02bttkvltmr58ord29ap1',
            
'5f627c693a313434393037333132393b5f727c693a313434393039343732393b686f7
        ...
            
56e74697479223a22686f726465222c226c6173745f6c6f67696e7461736b73223a226
            
13a303a7b7d222c22757067726164655f7461736b73223a22613a303a7b7d227d5d7d2
            
23b733a31333a2273657373696f6e5f746f6b656e223b733a32343a22004679776c474
           d545564386a5348465855466e3162526e7a223b7d', 1449073129)  
[pid 3399 on line 313 of "/usr/share/pear/Horde/Db/Adapter/Oci8.php"]
Dec 2 17:18:49 ERR: HORDE SQL QUERY FAILED: ORA-01704: literal de  
cadena demasiado largo
         INSERT INTO horde_sessionhandler (session_id, session_data,
           session_lastmodified) VALUES ('e9o7r02bttkvltmr58ord29ap1',
            
'5f627c693a313434393037333132393b5f727c693a313434393039343732393b686f7
         ...
            
c79706f736974696f6e223a22626f74746f6d222c2261637469766573796e635f69646
            
56e74697479223a22686f726465222c226c6173745f6c6f67696e7461736b73223a226
            
13a303a7b7d222c22757067726164655f7461736b73223a22613a303a7b7d227d5d7d2
            
23b733a31333a2273657373696f6e5f746f6b656e223b733a32343a22004679776c474
           d545564386a5348465855466e3162526e7a223b7d', 1449073129)  
[pid 3399 on line 314 of "/usr/share/pear/Horde/Db/Adapter/Oci8.php"]
Dec 2 17:18:49 DEBUG: HORDE Failed to write session data  
(e9o7r02bttkvltmr58ord29ap1) [pid 3399]

Thank you.