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