[Dspam-user] Missing Messages

[Chad E. B. <ch...@bd...>]

Hello All-
I am relatively new to dspam and trying to perfect our setup.  I have been
having lots of issues with dspam reporting errors, which I have been trying
to track down with no luck so far.  Recently I discovered that some messages
were not being delivered to my account.  I can see them in the webfrontend,
and they indicate they were delivered, but I never received them.  From the
logs it appears there is an issue with the MySQL query timing out, which is
another issue altogether.  My question is how can I ensure that the messages
will be delivered if there is a failure, or at least where can I find the
message if it fails?  

I did recently change OnFail from error to unlearn, though the documentation
isn't very clear as to what those paramters do to the message delievery.

My setup is running on debian testing, version 3.10.2 of dspam, MySQL 5.5
and qmail.  I can provide the config file if needed.  Below are the
relavenent log file entries

qmail log:
2013-12-02 09:24:17.628786500 new msg 10059856
2013-12-02 09:24:17.628787500 info msg 10059856: bytes 81293 from
<se...@do...> qp 12147 uid 162
2013-12-02 09:24:17.628792500 starting delivery 105319: msg 10059856 to
local bdh...@do...
2013-12-02 09:31:04.236665500 delivery 105319: success: did_0+0+1/

/var/spool/dspam/system.log:
1385998262      I       "Sender" <se...@do...>
2,529ca7b2319157980610840       Re: Subject       404.440355
rec...@do... Delivered       <CEC2009D.240F%se...@do...>
(1385998262 is Monday, December 2, 2013 9:31:02 AM)

/var/log/mail.info:
Dec  2 09:30:39 srv2 dspam[31915]: query error: Lock wait timeout exceeded;
try restarting transaction: see sql.errors for more details
Dec  2 09:30:39 srv2 dspam[31915]: bailing on error -2
Dec  2 09:30:39 srv2 dspam[31915]: received invalid result (!DSR_ISSPAM &&
!DSR_ISINNOCENT): -2
Dec  2 09:30:41 srv2 dspam[31915]: process_message returned error -5.
delivering.

/var/log/dspam/sql.errors:
[12/02/2013 09:30:39] 31915: Lock wait timeout exceeded; try restarting
transaction: UPDATE dspam_token_data SET
last_hit=CURRENT_DATE(),innocent_hits=innocent_hits+1 WHERE uid=2 AND token
IN (.................)



As a side note throughout the day I see lots of errors like the below that I
haven't been able to determine what is causing them as well:
Dec  3 19:29:14 srv2 dspam[3484]: Client exited with error -5
Dec  3 19:49:33 srv2 dspam[7866]: Client exited with error -5
Dec  3 20:35:41 srv2 dspam[15640]: Client exited with error -5
Dec  3 21:36:22 srv2 dspam[26743]: Client exited with error -5
Dec  3 22:12:20 srv2 dspam[32492]: Client exited with error -5
Dec  3 22:43:31 srv2 dspam[4856]: Client exited with error -5
Dec  4 00:18:07 srv2 dspam[18963]: Client exited with error -5
Dec  4 00:51:19 srv2 dspam[23668]: Client exited with error -5
Dec  4 02:05:03 srv2 dspam[1472]: Client exited with error -5
Dec  4 02:19:27 srv2 dspam[3743]: Client exited with error -5
Dec  4 02:25:26 srv2 dspam[5010]: Client exited with error -5
Dec  4 02:45:34 srv2 dspam[8093]: Client exited with error -5
Dec  4 02:49:02 srv2 dspam[8436]: Client exited with error -5
Dec  4 03:02:34 srv2 dspam[10665]: Client exited with error -5
Dec  4 03:10:48 srv2 dspam[12020]: Client exited with error -5
Dec  4 03:23:19 srv2 dspam[14374]: Client exited with error -5
Dec  4 03:35:29 srv2 dspam[16233]: Client exited with error -5
Dec  4 03:37:49 srv2 dspam[16485]: Client exited with error -5
Dec  4 04:03:02 srv2 dspam[20013]: Client exited with error -5
Dec  4 04:03:21 srv2 dspam[20101]: Client exited with error -5
Dec  4 04:08:52 srv2 dspam[21041]: Client exited with error -5
Dec  4 05:02:34 srv2 dspam[27280]: Client exited with error -5
Dec  4 05:05:09 srv2 dspam[27622]: Client exited with error -5
Dec  4 05:53:35 srv2 dspam[2854]: Client exited with error -5

Thanks in advance for any assistance!