dspam operation and maintenance record_PHP tutorial

dspam operation and maintenance record

I am using extmail myself and found an error:
Apr 10 07:03:19 mail dspam[1468]: query error: Duplicate entry '1-2288815384906775934' for key 'id_token_data_01': see sql.errors for more details
Apr 10 07:03:19 mail dspam[1468]: bailing on error -2
Apr 10 07:03:19 mail dspam[1468]: received invalid result (!DSR_ISSPAM && !DSR_ISINNOCENT): -2
Apr 10 07:03:19 mail dspam[1468]: process_message returned error -5. delivering.

mysql appears "Incorrect key file for table" error!

Du Niang didn’t give me any help, so she came up with her own solution. It’s actually very simple. There is duplicate data recorded in the token field in the dspam_token_data table file of the dspam library in mysql. No matter how hard you try, it’s all in vain. The correct way to deal with it is:
The first method (the original data is not retained): first stop the dspamd service, service dspamd stop, then clear all the data of dspam_token_data (I used Navicat for mysql graphical interface to do it), and then on the table Make a primary key for the token field (the primary key will not be repeated). Then restart the service.
The second method (keep the original data in the table, find a way to remove duplicates, and then set the token as the primary key): first stop the dspamd service, export dspam_token_data into a txt file separated by ",", and then import it into Excel, be careful to define the token field in text format, otherwise the end of the data will all become 0000 (this is why you need to export text instead of exporting to excel). You can use "Data" --> "Delete Duplicate Data" in excel To clear the duplicate content, clear the dspam_token_data table in mysql, import the processed data, restore the dspamd service, and the error is gone!

http://www.bkjia.com/PHPjc/1118875.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1118875.htmlTechArticledspam operation and maintenance record I am using extmail myself and found an error: Apr 10 07:03:19 mail dspam[1468] : query error: Duplicate entry '1-2288815384906775934' for key 'id_token_data_01': see sql.e...