miraceti Apprentice
Joined: 07 Oct 2004 Posts: 165
|
Posted: Mon Oct 25, 2010 8:55 pm Post subject: Migration of spamassassin's db to MySQL |
|
|
I am trying to migrate spamassassin's db to MySQL using this guide:
http://www.gentoo.org/doc/en/mailfilter-guide.xml#doc_chap10
Everything fine, I even can learn a new ham - the tokens appear in the new database. However, when I am trying to run:
Code: | sa-learn --restore ./backup.txt -D |
I get something like this:
Code: | oct 25 23:43:47.337 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-_' for key 1
oct 25 23:43:47.337 [10815] dbg: bayes: error inserting token for line: t 0 4 1285585445 04a44c6bd5
oct 25 23:43:47.425 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-_' for key 1
oct 25 23:43:47.425 [10815] dbg: bayes: error inserting token for line: t 1 6 1267710280 15cc1b9b67
oct 25 23:43:47.458 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-4' for key 1
oct 25 23:43:47.458 [10815] dbg: bayes: error inserting token for line: t 2 0 1228777055 3489030365
oct 25 23:43:47.461 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-4' for key 1
oct 25 23:43:47.461 [10815] dbg: bayes: error inserting token for line: t 0 1 1279632091 34f824eb89
oct 25 23:43:47.632 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-h' for key 1
oct 25 23:43:47.632 [10815] dbg: bayes: error inserting token for line: t 0 1 1275938477 68e7f95024
oct 25 23:43:47.642 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-t' for key 1
oct 25 23:43:47.642 [10815] dbg: bayes: error inserting token for line: t 0 1 1254720776 74be3b1d6e
oct 25 23:43:47.658 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-z' for key 1
oct 25 23:43:47.658 [10815] dbg: bayes: error inserting token for line: t 3 0 1250272246 7af61f2550
oct 25 23:43:47.671 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-' for key 1
oct 25 23:43:47.671 [10815] dbg: bayes: error inserting token for line: t 1 0 1286585739 8505ae4153
oct 25 23:43:47.674 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-' for key 1
oct 25 23:43:47.674 [10815] dbg: bayes: error inserting token for line: t 0 1 1281734279 85ef45453e
oct 25 23:43:47.677 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-' for key 1
oct 25 23:43:47.678 [10815] dbg: bayes: error inserting token for line: t 3 0 1237922581 88f4be7b6f
oct 25 23:43:47.680 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-' for key 1
oct 25 23:43:47.681 [10815] dbg: bayes: error inserting token for line: t 0 1 1276452582 8d02085c3b
oct 25 23:43:47.683 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-' for key 1
oct 25 23:43:47.683 [10815] dbg: bayes: error inserting token for line: t 0 1 1285691367 8d695f6f30
oct 25 23:43:47.686 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-' for key 1
oct 25 23:43:47.686 [10815] dbg: bayes: error inserting token for line: t 0 1 1272484038 8de38005a3
oct 25 23:43:47.689 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-' for key 1
oct 25 23:43:47.690 [10815] dbg: bayes: error inserting token for line: t 0 1 1260184703 8e44ba0775
oct 25 23:43:47.696 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-' for key 1
oct 25 23:43:47.696 [10815] dbg: bayes: error inserting token for line: t 0 1 1286866327 8eb72b8824
oct 25 23:43:47.708 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-' for key 1
oct 25 23:43:47.709 [10815] dbg: bayes: error inserting token for line: t 3 0 1238593450 8faef49d6e
oct 25 23:43:47.711 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-' for key 1
oct 25 23:43:47.711 [10815] dbg: bayes: error inserting token for line: t 1 0 1228052472 912a531903
oct 25 23:43:47.721 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-' for key 1
oct 25 23:43:47.721 [10815] dbg: bayes: error inserting token for line: t 1 0 1273118028 91919f0fac
oct 25 23:43:47.741 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-' for key 1
oct 25 23:43:47.741 [10815] dbg: bayes: error inserting token for line: t 1 0 1244678299 94c8fdf126
oct 25 23:43:47.744 [10815] dbg: bayes: _put_token: SQL error: Duplicate entry '7-' for key 1
oct 25 23:43:47.745 [10815] dbg: bayes: error inserting token for line: t 1 0 1232234864 957d4145f0
bayes: encountered too many errors (20) while parsing token line, reverting to empty database and exiting
oct 25 23:43:47.759 [10815] dbg: plugin: Mail::SpamAssassin::Plugin::Bayes=HASH(0xa8425f0) implements 'learner_close', priority 0 |
What does it mean? How should I correctly restore the backup? When I try to restore it into old file, it works fine. But it does not work with MySQL. |
|