You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by Kevin Peuhkurinen <ke...@hepcoe.com> on 2005/02/14 14:47:58 UTC
Error during Bayes DB upgrade
Hi all. I've got SA 3.02 installed on a new box. I've copied over
the Bayes database from my 2.64 installation and done "sa-learn --sync"
followed by "sa-learn --backup > backup.txt". I then added the
following to my local.cf file:
bayes_store_module Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn DBI:mysql:bayes:localhost
bayes_sql_username bayes
bayes_sql_password XXXXXXX
bayes_sql_override_username amavis
Finally, I did an "sa-learn -D --restore backup.txt". Everything seems
to run fine for a while, but finally fails with:
debug: bayes: seen_put: SQL Error: Duplicate entry
'11-!~!UENERkVCMDkAAQACAHAAAAAAAAAAOKG7EAXlEBqhuwgAKypWwgAARU1TTURCLkRMTA
AAAAAAAAAAG1X6IKpmEc2byACqAC/EWgwAAABFWENILVBST0QAL289SEVQQ09FL291PU1BSUwvY249UmVjaXBpZW5...'
for key 1
debug: bayes: Error inserting msgid in seen table for line: s h
!~!UENERkVCMDkAAQACAHAAAAAAAAAAOKG7EAXlEBqhuwgAKypWw
gAARU1TTURCLkRMTAAAAAAAAAAAG1X6IKpmEc2byACqAC/EWgwAAABFWENILVBST0QAL289SEVQQ09FL291PU1BSUwvY249U
mVjaXBpZW50cy9jbj1TSEFSS0kALgAAAAAAAAAz9pTKYRLUEZwZAJAn3ndqAQBN0oULOubTEZwDAJAn3ndqAAAANG3VAAAAAAA
ALgAAAAAAAAAz9pTKYRLUEZwZAJAn3ndqAQBN0oULOubTEZwDAJAn3ndqAAAANG3WAAAQAAAAFQxKTv3fv0CcPW5Eyh3SrxI
AAABSRTogQ3JlZGl0IEFkdmljZQA=@rutherfordglobal.com
Any ideas how I can get around this?
Thanks.
Re: Error during Bayes DB upgrade
Posted by Kevin Peuhkurinen <ke...@hepcoe.com>.
Michael Parker wrote:
>On Mon, Feb 14, 2005 at 08:47:58AM -0500, Kevin Peuhkurinen wrote:
>
>
>>Any ideas how I can get around this?
>>
>>
>>
>
>Find this line in the backup.txt file and remove it, then start the
>restore again.
>
>Michael
>
>
Thanks. I had hoped for a different solution since the backup.txt file
is over 37MB, but it worked.
Re: Error during Bayes DB upgrade
Posted by Michael Parker <pa...@pobox.com>.
On Mon, Feb 14, 2005 at 08:47:58AM -0500, Kevin Peuhkurinen wrote:
>
> Finally, I did an "sa-learn -D --restore backup.txt". Everything seems
> to run fine for a while, but finally fails with:
>
> debug: bayes: seen_put: SQL Error: Duplicate entry
> '11-!~!UENERkVCMDkAAQACAHAAAAAAAAAAOKG7EAXlEBqhuwgAKypWwgAARU1TTURCLkRMTA
> AAAAAAAAAAG1X6IKpmEc2byACqAC/EWgwAAABFWENILVBST0QAL289SEVQQ09FL291PU1BSUwvY249UmVjaXBpZW5...'
> for key 1
> debug: bayes: Error inserting msgid in seen table for line: s h
> !~!UENERkVCMDkAAQACAHAAAAAAAAAAOKG7EAXlEBqhuwgAKypWw
> gAARU1TTURCLkRMTAAAAAAAAAAAG1X6IKpmEc2byACqAC/EWgwAAABFWENILVBST0QAL289SEVQQ09FL291PU1BSUwvY249U
> mVjaXBpZW50cy9jbj1TSEFSS0kALgAAAAAAAAAz9pTKYRLUEZwZAJAn3ndqAQBN0oULOubTEZwDAJAn3ndqAAAANG3VAAAAAAA
> ALgAAAAAAAAAz9pTKYRLUEZwZAJAn3ndqAQBN0oULOubTEZwDAJAn3ndqAAAANG3WAAAQAAAAFQxKTv3fv0CcPW5Eyh3SrxI
> AAABSRTogQ3JlZGl0IEFkdmljZQA=@rutherfordglobal.com
>
> Any ideas how I can get around this?
>
Find this line in the backup.txt file and remove it, then start the
restore again.
Michael