John, So you are saying this is a problem with the files in the spool directory - AFTER you have created them and the request is not longer running - yes? Did you open the .cfmail files and look at the headers? For example, can you verify that the 2nd mail file did not have the address of the first fellow in it?
You should not be able to do a "cfoutput query="".... followed by a "cfmail"... Both tags are "output" tags and it should generate a nested output error. If you are making it "succeed" the question is how? Is there a "try catch" block around the whole thing? It should be a "cfloop", not a "cftouput". -Mark -----Original Message----- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Monday, November 28, 2005 6:14 AM To: CF-Talk Subject: REPOST: Crazy CF Mail Spooler problem - HELP! I'm guessing that a lot of people were out for the Thanksgiving holiday so I'm reposting this hoping to get some help. Thanks! John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -----Original Message----- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Friday, November 25, 2005 3:15 PM To: CF-Talk Subject: Crazy CF Mail Spooler problem - HELP! Ok, this is a weird one. I'm hoping it's a bug or someone can explain the reasoning behind it. We have a CF7 Enterprise installation on a UNIX box and we just sent out an email to all of the users of our site. The email had an 3 attachments (totaling about 150k) and went out to about 4,000 members. We fired the email off and the noticed we were getting the mail multiple times. We deleted all of the .cfmail files from the spool directory and went back to look at our mailsent logs and found some strange patterns. First of all, the spooler seemed to loop through all of the cfmail files to send the emails and had gotten through about 5 iterations and didn't seem to be deleting any of the .cfmail files. After further examination, it seemed like each time the spooler came in and started sending mail it deleted the first .cfmail file after it started it's loop. Therefore, the first guy on the list, got the email only once, the second guy got it twice, the third guy three time and so on. So, to my questions: 1. How does the spooler/cleanup work? Is it the same process that sends the mail and then deletes the file or is there a separate cleanup process to remove old mail? 2. The developer who wrote the script to do this grabbed a query of email address and did a <cfoutput query="..."> around a single <cfmail> tag. I know it's been talked about before on the list how <cfmail> with the QUERY attribute performs faster. Is this the sort of problem that can be solved? 3. Because of the <cfmail> nested in the <cfoutput query="..."> I'm guessing the server has to create a separate temp file for the attachments each time, then delete them. Does it just do it once if you use <cfmail query="..."> instead? Any insite or suggestions or places to look would be EXTREMELY helpful. Thanks a ton! John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225389 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
