[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