[horde] oci8 session_handler error

Ico Izquierdo ico at cc.upv.es
Fri Dec 4 09:47:22 UTC 2015


I've write a bug (#14175) but I don't know if it is the right way.

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]

I appreciate some help.

Thank you.

-- 
Ico Izquierdo
Analista-Programador
ASIC - UPV



More information about the horde mailing list