Its possible that the mail being written to the same sector of a hard disk again and again can corrupt it. This is a theory but as I've had at least 2 corrupt disks on the HoF server over the last year or two, it's a possible one. It could also be that thousands of files in the same directory on a windows box kills the file system in some way.
> Thenks for the info Critter. Much appreciated. :) > > Now for a little story about what happened today. I created a newsletter > page so that a registered base of 150,000+ subscribers would get it on > what would most likely be a weekly basis. On its first run today however, > it sent out approximately 2000 emails and then... exploded. It didn't just > stop sending emails though, instead the entire server got fried! > > I called up the ISP and they say there's massive corruption throughout the > harddrive!?!?! WTF? Since the only thing that happened out of the > oridinary was the newsletter mailing today, they surmised that it was the > cause of the meltdown. Once again I ask... WTF?! Is ColdFusion unstable to > the point that sending out a newsletter would fry the server?!? One theory > is that messages got bounced back to the server and it couldn't handle the > load of outgoing and incoming. Ok fine, i'll buy that partially. Maybe it > was indeed a wussy server. But corruption? File corruption from > getting/sending emails? Hell the server wont even boot up now! > > Has anyone else had this happen to them? > > So here's a word of caution to anyone doing a newsletter from me. Try not > to fry your server in the process. *laugh* I still can't believe this > happened. > > Oh yeah, for those interrested in the code that allegedly melted down the > server, here it is: > > <cfquery datasource="zzz" name="newsletter"> > SELECT date, slug, content > FROM newsletter > WHERE newsletter_id=#form.tid# > </cfquery> > > <cfquery datasource="zzz" name="receivers"> > SELECT email_address > FROM members > WHERE newsletter_flag=-1 > </cfquery> > > <cfmail TO="#receivers.email_address#" > FROM="[EMAIL PROTECTED]" > BCC="[EMAIL PROTECTED]" > QUERY="receivers" > SUBJECT="#newsletter.slug#"> > ZZZ Newsletter > #DateFormat(newsletter.date, "DDDD, MMMM D YYYY")# > #receivers.email_address# > ================================================================= > > #newsletter.content# > > ================================================================= > UNSUBSCRIBE > Here's how to unsubscribe or change your settings. > http://www.zzz.com/updateprofile.asp > </cfmail> > > .. and yes, that's how I know 2000 emails got sent out, because I got > 2000+ blind CC's. Left it in there from the testing phase. Ugh. > > -------------------------------------------------------------------------- > Bryant Tyson, WEB DEVELOPER > http://webtys.com > WebTY's, The Educated Choice. > > On Sun, 28 Oct 2001, Critz wrote: > > > oi Bryant!! > > > > > > CHR(13)& CHR(10) is carriage return, line feed > > > > -- > > Best regards, > > > > Critter [critz.org] > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
