Today I get to figure out why ColdFusion server is having mail get stuck in spool.
mail.log looks like:
Searching file : mail.log View Raw Data Compact View 1 – 10 of 27054 / Next
Date Time Severity ThreadID Application Name
Jul 20, 2006 2:09 PM Debug 0
Running delivery in this thread (16 entries).
Jul 20, 2006 2:09 PM Error 0Jul 20, 2006 2:09 PM Debug 0
Closing mail server connections.
Jul 20, 2006 2:09 PM Debug 0
Next mail spool run in 15 seconds.
Jul 20, 2006 2:08 PM Debug 0
Running delivery in this thread (16 entries).
Jul 20, 2006 2:08 PM Error 0Jul 20, 2006 2:08 PM Debug 0
Closing mail server connections.
Jul 20, 2006 2:08 PM Debug 0
Next mail spool run in 15 seconds.
Jul 20, 2006 2:08 PM Debug 0
Running delivery in this thread (16 entries).
Jul 20, 2006 2:08 PM Error 0
…
Today’s technical guess: Maybe there’s a process that’s holding a file lock to the 1st entry in the spool (opened for exclusive write) or database deadlock if outgoing mail is in the database. You’re running mail spool every 15 seconds, could be a race condition. Have you tried running the spool less frequently? If it’s a Windows box, you could use FileMon (http://www.sysinternals.com/Utilities/Filemon.html) to see if any of the spooled files are locked.