Re: v13 - UUID COLLISION!!! [observation]
according to Wikipedea: the number of random version 4 UUIDs which need to be generated in order to have a 50% probability of at least one collision is 2.71 quintillion, This number is equivalent to generating 1 billion UUIDs per second for about 85 years, and a file containing this many UUIDs, at 16 bytes per UUID, would be about 45 exabytes, many times larger than the largest databases currently in existence, which are on the order of hundreds of petabytes.[17][18] so... why couldn't I have gotten this duplication on a power ball ($720 million) or mega millions ($1.7 Billion) ticket :p Chip On Mon, 29 Oct 2018 14:53:29 -0400, Chip Scheide via 4D_Tech wrote: > UUID value ="E092AB501E1D41F5A5D15B56E835D2EE" > this value appears to be duplicated in my database! > > ideas? thoughts? > Chip > --- > Gas is for washing parts > Alcohol is for drinkin' > Nitromethane is for racing > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: v13 - UUID COLLISION!!!
no - the new record is a related record added via a double click on a listbox. The code being used has been in operation for years. it works/worked else where. I am working though trying to figure out what has happened. 4D is throwing an error about a duplicated (unique) value. after checking the structure (to be sure there was not a field accidentally set to unique that shouldd not have been). I confirmed there are 2 unique fields in the table. - Record_ID the table's relational key (longint, indexed, unique, mandatory) - Journal_Key UUID, auto generated, unique, primary key, text I verified the record_ID field is NOT duplicated. I copied the UUID from the new record in the debugger, searched the table's journal_key for the UUID just copied from the debugger -- it exists! -- with a different Record ID and different record data. In addition, the new record is not saved (4D error) and even if it had been saved it would NOT be visible to another process, as the new record is being created inside a transaction (which is currently open). Chip On Mon, 29 Oct 2018 13:57:16 -0500, Stephen J. Orth wrote: > Chip, > > Did you duplicate a record? > > > Steve > > * > Stephen J. Orth > The Aquila Group, Inc. Office: (608) 834-9213 > P.O. Box 690 Mobile: (608) 347-6447 > Sun Prairie, WI 53590 > > E-Mail: s.o...@the-aquila-group.com > * > > > -Original Message- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip > Scheide via 4D_Tech > Sent: Monday, October 29, 2018 1:53 PM > To: 4D iNug Technical <4d_tech@lists.4d.com> > Cc: Chip Scheide <4d_o...@pghrepository.org> > Subject: v13 - UUID COLLISION!!! > > UUID value ="E092AB501E1D41F5A5D15B56E835D2EE" > this value appears to be duplicated in my database! > > ideas? thoughts? > Chip > --- > Gas is for washing parts > Alcohol is for drinkin' > Nitromethane is for racing > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** > > --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: v13 - UUID COLLISION!!!
yes - auto generate No - not imported, nor exported. Collision happened on saving a new record Chip On Mon, 29 Oct 2018 18:57:11 +, Dennis, Neil wrote: >> UUID value ="E092AB501E1D41F5A5D15B56E835D2EE" >> this value appears to be duplicated in my database! > > Is the field set to auto generate? > Was a record exported and imported? > > > Neil > > > > > > > -- > > Privacy Disclaimer: This message contains confidential information > and is intended only for the named addressee. If you are not the > named addressee you should not disseminate, distribute or copy this > email. Please delete this email from your system and notify the > sender immediately by replying to this email. If you are not the > intended recipient you are notified that disclosing, copying, > distributing or taking any action in reliance on the contents of this > information is strictly prohibited. > > The Alternative Investments division of UMB Fund Services provides a > full range of services to hedge funds, funds of funds and private > equity funds. Any tax advice in this communication is not intended > to be used, and cannot be used, by a client or any other person or > entity for the purpose of (a) avoiding penalties that may be imposed > on any taxpayer or (b) promoting, marketing, or recommending to > another party any matter addressed herein. --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: v13 - UUID COLLISION!!!
Chip, Did you duplicate a record? Steve * Stephen J. Orth The Aquila Group, Inc. Office: (608) 834-9213 P.O. Box 690 Mobile: (608) 347-6447 Sun Prairie, WI 53590 E-Mail: s.o...@the-aquila-group.com * -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip Scheide via 4D_Tech Sent: Monday, October 29, 2018 1:53 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Chip Scheide <4d_o...@pghrepository.org> Subject: v13 - UUID COLLISION!!! UUID value ="E092AB501E1D41F5A5D15B56E835D2EE" this value appears to be duplicated in my database! ideas? thoughts? Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ** ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: v13 - UUID COLLISION!!!
>UUID value ="E092AB501E1D41F5A5D15B56E835D2EE" >this value appears to be duplicated in my database! Is the field set to auto generate? Was a record exported and imported? Neil -- Privacy Disclaimer: This message contains confidential information and is intended only for the named addressee. If you are not the named addressee you should not disseminate, distribute or copy this email. Please delete this email from your system and notify the sender immediately by replying to this email. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. The Alternative Investments division of UMB Fund Services provides a full range of services to hedge funds, funds of funds and private equity funds. Any tax advice in this communication is not intended to be used, and cannot be used, by a client or any other person or entity for the purpose of (a) avoiding penalties that may be imposed on any taxpayer or (b) promoting, marketing, or recommending to another party any matter addressed herein. ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
