Hi Brian, Thanks for your interest.
Keys are alpha chars like this Code Parent RP0907166311 11/5 RE0907162560 1108 RE0907162561 113305 RE0907162562 113502 RE0907162563 113502 RE0907162564 119BPL WP0907133832 RE0907162564 RE090721X RE0907162564 WP0907093668 RE0907162562 WP0907204811 RE0907162562 WP0907113771 RE0907162560 Actually we have 12'000 records but each day it's growing. Yes, if we RESIZE the file when the problem occurs, it solve ... until next time. 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
