Le dimanche 2 décembre 2012 15:53:13, vous avez écrit : > Package: dspam > Version: 3.10.1+dfsg-5 > Severity: normal > > Dear Maintainer, > > After migrating my dspam database to a new PostgreSQL server, I'm seeing > the following errors in PG's log (edited for readability): > ERROR: invalid byte sequence for encoding "UTF8": 0xae: > INSERT INTO dspam_signature_data (uid,signature,length,created_on,data) > VALUES (1,E'4ed4de1c291545272412566',752,CURRENT_DATE,... ') > which results in the insert being aborted. Although the message gets > delivered succesfully, users cannot retrain on these messages because the > signature doesn't get stored in the database. > > According to > http://article.gmane.org/gmane.mail.spam.dspam.user/18022 > http://sourceforge.net/tracker/?func=detail&atid=1126468&aid=3023888&group_ > id=250683 the workaround is to set standard_conforming_strings=off in > postgresql.conf, which works for me but may not be possible for others > (e.g. because of other databases in the same cluster). > > I can think of multiple solutions here: > - unblock 3.10.2 because it is said to have a fix for this issue (not > verified, I don't want to start mixing releases even before wheezy is > released) > - backport the 3.10.2 fix to wheezy's 3.10.1
Both of these solution are not possible since the bug is only severity normal. It might be OK for the release team to unblock a package with the workaround backported if the bug was severity important but I don't think this bug is "important". Dspam only fails to *retrain* (not filter) of *some* mails. > - document this incompatibility+workaround in the release notes I'll think about this one. Is the bug related to the new version of dspam? Were you using dspam with PostgreSQL before without this problem? In addition, we can provide backports for wheezy once it's released. > > Naturally the latter would be my least favourite option :) Unfortunetely, freeze means the other solution are not good options. > > > Regards, > Arno Thanks for your bug report. Best regards, Thomas
signature.asc
Description: This is a digitally signed message part.
