Mark- My mistake, it is a cfloop, not a cfoutput. I wasn't thinking when I typed. We did pull up some of the cfmail files and all appeared to be fine in there. The way I found out what I did was by pulling up the mailsent log file to see who the message had gone out to. As far as I could tell the request had completed. We actually deleted all the cfmail files out of the directory to stop it so that people wouldn't get any more and there were no new ones created. That's why I attributed it to the deletion of the .cfmail files. Is that a separate process or do the spooler do this when it is finished sending the mail? I'm still leaning towards believing that it has something to do with the attachments and how the mail was being generated because of the individual <cfmail> tags within the <cfloop>. I'm not sure if that's a reasonable explanation, but so far that's the best I've come up with.
John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -----Original Message----- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Monday, November 28, 2005 9:10 AM To: CF-Talk Subject: RE: REPOST: Crazy CF Mail Spooler problem - HELP! 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225397 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
