[dspam-users] Lock wait timeout exceeded

[john espiro]

Hello -

I am running the following:

CentOS 4.5
MySQL 5.0.45 14.12
dspam

I get the following error randonmly throughout the day, but especially around 
the time my cron daily job wraps up... Cron job is posted way below, and the 
error is pasted here, snipped off due to the length of the data.

Can anyone let me know what I should try to do to troubleshoot this?  Is there 
any other data I can provide?


Error:

[06/11/2008 07:32:29] 18017: Lock wait timeout exceeded; try restarting 
transaction: update dspam_token_data set last_hit = current_date(), spam_hits = 
greatest(0, spam_hits + 1), innocent_hits = greatest(0, innocent_hits - 0) 
where uid = 3 and token 
in('4301950420733384838','8470769528426426573','4702753284075552768','9262019483354755276','15868778196753871051','9363122826218903147','11330574739319517388','5732484895227843917','17447635076284224467','7025702031337165437','55761

Cron.daily:

# Optimize the table structure nightly
mysqlcheck -u$DBUSER -p$DBPASSWD -h$DBHOST -oA

DBS=`mysql -u$DBUSER -p$DBPASSWD -h$DBHOST -e"show databases"`

for DATABASE in $DBS
do
        if [ $DATABASE != "Database" ]; then
                echo "Dumping $DATABASE now..."
                mysqldump -u$DBUSER -p$DBPASSWD -h$DBHOST --add-drop-table -e 
$DATABASE > ${DATE}_${DATABASE}.sql



      

!DSPAM:1011,48505899150922318735894!