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
