I'm not so sure that cf is creating duplicate id's, if i read what you are doing with your data. Typically, these errors occur when you are using non thread-safe code in a multithreaded environment. Writing every hit to a flat file definitely can be something considered 'under heavy load' and it can raise some issues. I have never used fuseboxlogs, but maybe somebody else knows if it's thread safe. Did you change something on the default behavour? Do you lock the file properly befor you import it into the database? Maybe you will discover that it's always the first or the last line from the flat file that gets double entries in the database. Is it only double entries, sometimes triple or more entries? Is there a correlation between duplicate uuid's and their timestamps?
Try adding (thread-safe) additional logs, for example only append the same uuid+timestamp to a new flat file, never store it to database, and when you find a double entry in the database, compare it with this flat file. I just find it hard to believe, since i have never ever gotten a double entry in my own cms for years, neither on windows, neither on unix, regardless of the cf version, and the createuuid really gets hammered there. Good luck. Stijn On Tue, 31 May 2005, Edward Chowdhury wrote: > it's the vanilla Cold Fusion CreateUUID function call. The server is running > on Fedora Core 2 so it's not a windows issue. > > The way that fuseboxlogs works is that every hit is recorded and given a > log_id using CreateUUID. These hits are first stored on disk in a pipe > delimited text file and then every 10 minutes the log file is bulk loaded > into the log database. > > What I noticed was that at least once a week the insert would fail because > there was a duplicate log_id in the database. I can't figure out how this > duplicate log_id would have gotten there unless CreateUUID had generated a > duplicate key. > > I noticed this behaviour somewhere else as well. I was demoing our site to a > client and I got an database error.Our rich text editor uses createUUID to > temporarily store the contents of the text in a strings table and the insert > messed up because there was a duplicate UUID in the strings table. Again I > can't figure out how this would have happened unless CreateUUID generated > duplicate values. > > ed > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Dave Watts > Sent: Tuesday, May 31, 2005 8:48 PM > To: CFCDev@cfczone.org > Subject: RE: [SPAM] RE: [CFCDev] OT: Web Analytics Tool > > > > createUUID, as in #createUUID()# the coldfusion function or > > something in the database creating a uuid? Do you think you > > know what might be causing it to create duplicate keys?? That > > is sort of disconcerting... > > I've never known it to create duplicate keys, but there is a known issue on > some versions of CF on Windows in which the UUIDs created may be very > similar when they shouldn't be. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the > email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > CFCDev is supported by New Atlanta, makers of BlueDragon > http://www.newatlanta.com/products/bluedragon/index.cfm > > An archive of the CFCDev list is available at > www.mail-archive.com/cfcdev@cfczone.org > > > > > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the > email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > CFCDev is supported by New Atlanta, makers of BlueDragon > http://www.newatlanta.com/products/bluedragon/index.cfm > > An archive of the CFCDev list is available at > www.mail-archive.com/cfcdev@cfczone.org > > ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org
