One more thing... should I do anything with the errors in sql.errors, i.e. re-run them? What happens if I don't?
Thanks, John ----- Original Message ---- From: john espiro <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, June 11, 2008 3:58:29 PM Subject: Lock wait timeout exceeded 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,48505933150927221775590!
