Yes, or try to find a file type with hashing algorithm that will guarantee that they cannot hash to the same group.
Brian > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > Manu Fernandes > Sent: 29 July 2009 16:17 > To: U2 Users List > Subject: Re: [U2] [UV]recurring database, indexing and > deadlatch errors > > I suppose you think about a DEFINE.DF based on the key structure ! > That can be a solution... > > Manu > > > > -----Message d'origine----- > > De : [email protected] [mailto:u2-users- > > [email protected]] De la part de Brian Leach Envoyé : > > mercredi 29 juillet 2009 16:35 À : > [email protected] Objet > > : Re: [U2] [UV]recurring database, indexing and deadlatch errors > > > > Hi Manu > > > > It is a good question... > > > > What do the record keys look like, and how many records are there? > > > > Brian > > > > > -----Original Message----- > > > From: [email protected] > > > [mailto:[email protected]] On Behalf Of Manu > > > Fernandes > > > Sent: 29 July 2009 13:54 > > > To: U2 Users List > > > Subject: [U2] [UV]recurring database, indexing and > deadlatch errors > > > > > > > > > Hello U2 group, > > > > > > Probably a good question. > > > > > > We define a < recurring > file. > > > Attribute<1> refer to a record in the same file (pointer > to a parent > > > record). > > > We have a I-Type SUBR which return the "root" key/item of > a current > > > item (read the parent until parent = @NULL ) > > > > > > Then we create a index with this I-type to retrieve > easily the items > > > childs of a "root-id". > > > > > > All work fine ... > > > except when the root-item is stored on the same FileGroup of the > > > child-item. > > > (at TCL, *RECORD file root-id* return the same value then *RECORD > > > file > > > child-id*) > > > > > > If this occurs, at the write step (save a child record) into the > > > SUBR called by indices processing, we get a "Self > deadlatch error" > > > and return to TCL. > > > This occurs because we are in a "write" which is a internal > > > "transaction with isolation level 0" and we try to read a record > > > already in the isolation..... > > > > > > Do you have any idea to solve it ? > > > Thanks by advance. > > > Manu > > > _______________________________________________ > > > U2-Users mailing list > > > [email protected] > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > > _______________________________________________ > > U2-Users mailing list > > [email protected] > > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
