bayes in MySQL with replication

Jason Ede J.Ede at
Fri Feb 22 17:05:30 GMT 2008

-----Original Message-----
From: mailscanner-bounces at [mailto:mailscanner-bounces at] On Behalf Of Julian Field
Sent: 22 February 2008 16:50
To: MailScanner discussion
Subject: Re: bayes in MySQL with replication

Hash: SHA1

> 080222 15:38:55 [ERROR] Slave: Error 'You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version
> for the right syntax to use near 'ON DUPLICATE KEY UPDATE spam_count =
> GREATEST(spam_count + '0', 0),
> ' at line 2' on query. Default database: 'sa_bayes'. Query: 'INSERT
> INTO bayes_token
> (id ON DUPLICATE KEY UPDATE spam_count = GREATEST(spam_count + '0', 0),
> ham_count = GREATEST(ham_count + '1', 0),
> atime = GREATEST(atime, '1203694258')Ã', Error_code: 1064
That capital A with an accent of some sort right at the end of the query
it reports looks very suspicious to me...
> 080222 15:38:55 [ERROR] Error running query, slave SQL thread aborted.
> Fix the problem, and restart the slave SQL thread with "SLAVE START".
> We stopped at log 'mysql-bin.000011' position 5334725

I was kinda suspecting that... Although I'd have thought other people would have come across this if there was a problem in the bayes SQL code, but I can't seem to find that  problem reported.. I'll try some more digging.


More information about the MailScanner mailing list