Hi list, after my upgrade to spamassassin version 3.1.0 and migrate the database from mySQL to PostgreSQL there are coming up many errors in the postgres logfile all like this:
ERROR: operator does not exist: character = bytea HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts. ERROR: current transaction is aborted, commands ignored until end of transaction block ERROR: current transaction is aborted, commands ignored until end of transaction block after running spamd with -D it shows: Mar 27 16:48:13 base spamd[2117]: spamd: checking message (unknown) for (unknown):98 Mar 27 16:48:13 base spamd[2117]: dns: name server: 127.0.0.1, family: 2, ipv6: 0 Mar 27 16:48:13 base spamd[2117]: received-header: parsed as [ ip=218.248.20.20 rdns= helo=-1208590568 by=e-dict.net ident= envfrom= intl=0 id=k2REm3oO002642 auth= ] Mar 27 16:48:13 base spamd[2117]: received-header: relay 218.248.20.20 trusted? no internal? no Mar 27 16:48:13 base spamd[2117]: metadata: X-Spam-Relays-Trusted: Mar 27 16:48:13 base spamd[2117]: metadata: X-Spam-Relays-Untrusted: [ ip=218.248.20.20 rdns= helo=-1208590568 by=e-dict.net ident= envfrom= intl=0 id=k2REm3oO002642 auth= ] Mar 27 16:48:13 base spamd[2117]: message: ---- MIME PARSER START ---- Mar 27 16:48:13 base spamd[2117]: message: main message type: text/plain Mar 27 16:48:13 base spamd[2117]: message: parsing normal part Mar 27 16:48:13 base spamd[2117]: message: added part, type: text/plain Mar 27 16:48:13 base spamd[2117]: message: ---- MIME PARSER END ---- Mar 27 16:48:13 base spamd[2117]: message: no encoding detected Mar 27 16:48:13 base spamd[2117]: rules: local tests only, ignoring RBL eval Mar 27 16:48:13 base spamd[2117]: check: running tests for priority: 0 Mar 27 16:48:13 base spamd[2117]: rules: running header regexp tests; score so far=0 Mar 27 16:48:13 base spamd[2117]: rules: ran header rule __HAS_RCVD ======> got hit: "f" Mar 27 16:48:13 base spamd[2117]: eval: all '*From' addrs: Mar 27 16:48:13 base spamd[2117]: eval: all '*To' addrs: Mar 27 16:48:13 base spamd[2117]: rules: ran eval rule MISSING_HB_SEP ======> got hit Mar 27 16:48:13 base spamd[2117]: eval: forged-HELO: from= helo=-1208590568 by=e-dict.net Mar 27 16:48:13 base spamd[2117]: rules: ran eval rule __ENV_AND_HDR_FROM_MATCH ======> got hit Mar 27 16:48:13 base spamd[2117]: eval: trying Received header date for real time: 27 Mar 2006 16:48:09 (CEST) Mar 27 16:48:13 base spamd[2117]: eval: time_t from date=1143470889, rcvd= 27 Mar 2006 16:48:09 (CEST) Mar 27 16:48:13 base spamd[2117]: eval: date chosen from message: Mon Mar 27 16:48:09 2006 Mar 27 16:48:13 base spamd[2117]: rules: running body-text per-line regexp tests; score so far=2.5 Mar 27 16:48:13 base spamd[2117]: uri: running uri tests; score so far=2.5 Mar 27 16:48:13 base spamd[2117]: bayes: corpus size: nspam = 239, nham = 75492 Mar 27 16:48:13 base spamd[2117]: bayes: tok_get_all: token count: 15 Mar 27 16:48:13 base spamd[2117]: bayes: tok_get_all: SQL error: ERROR: operator does not exist: character = bytea Mar 27 16:48:13 base spamd[2117]: bayes: HINT: No operator matches the given name and argument type(s). You may need to add xplicit type casts. Mar 27 16:48:13 base spamd[2117]: bayes: cannot use bayes on this message; none of the tokens were found in the database Mar 27 16:48:13 base spamd[2117]: bayes: not scoring message, returning undef Mar 27 16:48:13 base spamd[2117]: bayes: get_running_expire_tok: SQL error: ERROR: current transaction is aborted, commands ignored until end of transaction block Mar 27 16:48:13 base spamd[2117]: bayes: get_storage_variables: SQL error: ERROR: current transaction is aborted, commands ignored until end of transaction block Mar 27 16:48:13 base spamd[2117]: bayes: DB expiry: tokens in DB: 0, Expiry max size: 150000, Oldest atime: 0, Newest atime: 0, Last expire: 0, Current time: 1143470893 Mar 27 16:48:13 base spamd[2117]: rules: running raw-body-text per-line regexp tests; score so far=2.5 Mar 27 16:48:13 base spamd[2117]: rules: running full-text regexp tests; score so far=2.5 Mar 27 16:48:13 base spamd[2117]: check: running tests for priority: 500 Mar 27 16:48:13 base spamd[2117]: rules: running meta tests; score so far=2.5 Mar 27 16:48:13 base spamd[2117]: rules: running header regexp tests; score so far=6.392 Mar 27 16:48:13 base spamd[2117]: rules: running body-text per-line regexp tests; score so far=6.392 Mar 27 16:48:13 base spamd[2117]: uri: running uri tests; score so far=6.392 Mar 27 16:48:13 base spamd[2117]: rules: running raw-body-text per-line regexp tests; score so far=6.392 Mar 27 16:48:13 base spamd[2117]: rules: running full-text regexp tests; score so far=6.392 Mar 27 16:48:13 base spamd[2117]: check: running tests for priority: 1000 Mar 27 16:48:13 base spamd[2117]: rules: running meta tests; score so far=6.392 Mar 27 16:48:13 base spamd[2117]: rules: running header regexp tests; score so far=6.392 Mar 27 16:48:13 base spamd[2117]: rules: running body-text per-line regexp tests; score so far=6.392 Mar 27 16:48:13 base spamd[2117]: uri: running uri tests; score so far=6.392 Mar 27 16:48:13 base spamd[2117]: rules: running raw-body-text per-line regexp tests; score so far=6.392 Mar 27 16:48:13 base spamd[2117]: rules: running full-text regexp tests; score so far=6.392 Mar 27 16:48:13 base spamd[2117]: plugin: Mail::SpamAssassin::Plugin::AutoLearnThreshold=HASH(0x8eb44d4) implements 'autolearn_discriminator' Mar 27 16:48:13 base spamd[2117]: learn: auto-learn: currently using scoreset 2, recomputing score based on scoreset 0 Mar 27 16:48:13 base spamd[2117]: learn: auto-learn: message score: 6.392, computed score for autolearn: 5.794 Mar 27 16:48:13 base spamd[2117]: learn: auto-learn? ham=0.1, spam=12, body-points=0, head-points=2.5, learned-points=0 Mar 27 16:48:13 base spamd[2117]: learn: auto-learn? no: inside auto-learn thresholds, not considered ham or spam Mar 27 16:48:13 base spamd[2117]: check: is spam? score=6.392 required=5 Mar 27 16:48:13 base spamd[2117]: check: tests=EMPTY_MESSAGE,MISSING_HB_SEP,MISSING_SUBJECT,TO_CC_NONE Mar 27 16:48:13 base spamd[2117]: check: subtests=__ENV_AND_HDR_FROM_MATCH,__HAS_RCVD Mar 27 16:48:13 base spamd[2117]: spamd: identified spam (6.4/5.0) for (unknown):98 in 4.0 seconds, 148 bytes. Mar 27 16:48:13 base spamd[2117]: spamd: result: Y 6 - EMPTY_MESSAGE,MISSING_HB_SEP,MISSING_SUBJECT,TO_CC_NONE scantime=4.0,size=148,user=(unknown),uid=98,required_score=5.0,rhost=localhost,raddr=127.0.0.1,rport=56502,mid=(unknown),autolearn=no Mar 27 16:48:13 base spamd[2117]: config: copying current conf from backup Mar 27 16:48:13 base spamd[2117]: prefork: sysread(8) not ready, wait max 300 secs Mar 27 16:48:13 base spamd[2113]: prefork: child 2117: entering state 1 ... What am I doing wrong, can anybody help? -Ingo.
