The mailing list for listmasters using Sympa

["Jahnke-Zumbusch, Dirk" <address@concealed>]

Hi all,

>Don't the Sympa logs show something about failed queries?

o.k., would have been a good idea, if I had started bulk.pl by hand
with -d -F ...

I get this

debug Bulk::message_from_spool() (messagekey : 
5d2e81c15c0a320655305a0b6b2bbe9d)
DBD::Oracle::st fetchrow_hashref failed: ORA-24345: A Truncation or null 
fetch error occurred (DBD ERROR: ORA-01406 error on field 1 of 7, ora_type 8, 
LongReadLen too small and/or LongTruncOk not set) [for Statement "SELECT 
message_bulkspool AS message, messageid_bulkspool AS messageid, 
dkim_d_bulkspool AS  dkim_d,  dkim_i_bulkspool AS  dkim_i, 
dkim_privatekey_bulkspool AS dkim_privatekey, dkim_selector_bulkspool AS 
dkim_selector,dkim_header_list_bulkspool AS dkim_header_list FROM 
bulkspool_table WHERE messagekey_bulkspool = 
'5d2e81c15c0a320655305a0b6b2bbe9d'"] at /usr/share/sympa/lib/Bulk.pm line 227.

Now I set LongReadLen by hand to 20MByte -- et voilà -- evrything works
fine. This is an issue which applies only to Oracle and which did not
pop up with SYMPA 5.1.2, but since then the SQL stuff has changed.

I'll send my alteration off-list to David.

Cheers & joyeux noël à tous

--
Dirk Jahnke-Zumbusch              Deutsches Elektronen-Synchrotron DESY
IT Information Fabrics              Member of the Helmholtz Association
D-22603 Hamburg                        Notkestrasse 85  / 22607 Hamburg