You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@spamassassin.apache.org by bu...@issues.apache.org on 2011/03/21 15:30:44 UTC
[Bug 6559] New: BayesStore::PgSQL doesn't set bytea format (it's
problematic with postgresql-9.0)
https://issues.apache.org/SpamAssassin/show_bug.cgi?id=6559
Summary: BayesStore::PgSQL doesn't set bytea format (it's
problematic with postgresql-9.0)
Product: Spamassassin
Version: 3.3.1
Platform: PC
OS/Version: Linux
Status: NEW
Severity: normal
Priority: P2
Component: spamc/spamd
AssignedTo: dev@spamassassin.apache.org
ReportedBy: marcin@mejor.pl
BayesStore::PgSQL assumes bytea format is 'escape'. This format is default in
postgresql <9.0, in postgresql-9.0 default format is 'hex'.
This makes problem when using X-Spam_report:
X-Spam-bayes-token-summary: Tokens: new, 10; hammy, 0; neutral, 45; spammy,
79.
X-Spam-bayes-token-spam: (unknown), (unknown), (unknown),
(unknown), (unknown), (unknown), (unknown), (unknown), (unknown), (unknown)
X-Spam-bayes-token-ham:
I don't know if does it makes more seriously problems.
Imho client should set option SET bytea_output TO 'escape' or BayesStore::PgSQL
should be capable to use 'hex' format (and should check what is default in used
db)
--
Configure bugmail: https://issues.apache.org/SpamAssassin/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
[Bug 6559] BayesStore::PgSQL doesn't set bytea format (it's
problematic with postgresql-9.0)
Posted by bu...@issues.apache.org.
https://issues.apache.org/SpamAssassin/show_bug.cgi?id=6559
--- Comment #2 from Mark Martinec <Ma...@ijs.si> 2011-03-23 20:31:25 EDT ---
> until the DBD::Pg gets fixed.
Actually the fix should already be in DBD::Pg 2.17.2,
released on November 21, 2010, four months ago.
Please upgrade your DBD::Pg and see if that solves the problem
(leaving the bytea_output to its new hex default, which is
supposedly much faster than 'escape').
--
Configure bugmail: https://issues.apache.org/SpamAssassin/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
[Bug 6559] BayesStore::PgSQL doesn't set bytea format (it's
problematic with postgresql-9.0)
Posted by bu...@issues.apache.org.
https://issues.apache.org/SpamAssassin/show_bug.cgi?id=6559
--- Comment #1 from Mark Martinec <Ma...@ijs.si> 2011-03-23 20:20:30 EDT ---
The following thread sheds some light on the problem:
http://postgresql.1045698.n5.nabble.com/Gripe-bytea-output-default-gt-data-corruption-td3209840.html
A current workaround is to:
ALTER DATABASE foo SET bytea_output='escape';
until the DBD::Pg gets fixed.
--
Configure bugmail: https://issues.apache.org/SpamAssassin/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
[Bug 6559] BayesStore::PgSQL doesn't set bytea format (it's
problematic with postgresql-9.0)
Posted by bu...@issues.apache.org.
https://issues.apache.org/SpamAssassin/show_bug.cgi?id=6559
Mark Martinec <Ma...@ijs.si> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |INVALID
Target Milestone|Undefined |3.3.2
--- Comment #4 from Mark Martinec <Ma...@ijs.si> 2011-03-25 11:33:06 EDT ---
Thanks for testing! Closing as invalid.
--
Configure bugmail: https://issues.apache.org/SpamAssassin/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
[Bug 6559] BayesStore::PgSQL doesn't set bytea format (it's
problematic with postgresql-9.0)
Posted by bu...@issues.apache.org.
https://issues.apache.org/SpamAssassin/show_bug.cgi?id=6559
Marcin M <is...@mejor.pl> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |issues.apache.org@mejor.pl
--- Comment #3 from Marcin M <is...@mejor.pl> 2011-03-25 05:46:10 EDT ---
Thanks Mark!
I didn't know newer version of DBD:Pg solves this problem. I tried it and works
correctly for me. I've filled bug in Gentoo ( http://bugs.gentoo.org/360245 )
with stabilisation request for DBD:Pg. Probably this bug should be closed as
invalid, but i can't see such option.
Regards.
--
Configure bugmail: https://issues.apache.org/SpamAssassin/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.