If you have this problem, you'll see a line like this in your mail log:
DBERROR: skiplist recovery /home/cyrus/user/u/username.seen: ADD at 4C48 existsThe recommended way to fix this is to truncate the file at the location the problem is detected. In the case above, at the hex byte 4C48.
I've had to do this often enough that I've written a shell script to do it, which just needs the username and hex location supplied via command line.
Notes:
- it's a shell script, but python is used to do hex conversion.
- you'll probably need to change the path (/home/cyrus/user/) to your cyrus user directory (mine is non-standard).
- you must supply the hex location where the corruption is detected. You can find this in your mail log file (usually /var/log/mail.log).
- if your cyrus files are owned by other than user cyrus and group mail, you'll need to change the chown cyrus:mail.
- the existing *.seen file is backed up with a unique filename (current timestamp), so it can be restored if something goes wrong.
#!/bin/sh if [ $# != 2 ]; then echo "USAGE: $0 login hex" exit fi TRUNC=`python -c "print int('$2', 16)"` DATE=`date +%Y%m%dT%H%M` DBPATH=/home/cyrus/user/$1 if [ -d $DBPATH ]; then dd if=$DBPATH/$1.seen of=$DBPATH/$1.seen.fixed bs=1 count=$TRUNC chown cyrus:mail $DBPATH/$1.seen.fixed chmod 600 $DBPATH/$1.seen.fixed mv $DBPATH/$1.seen $DBPATH/$1.seen.$DATE.corrupt.at.$TRUNC mv $DBPATH/$1.seen.fixed $DBPATH/$1.seen else echo "No such directory: $DBPATH" fi