Are you having multiple servers or multiple applications access the database? This can cause problems in the absence of transactions.
WILL On Nov 15, 2007 5:40 AM, Hidde Boonstra [Us Media] < [EMAIL PROTECTED]> wrote: > Hi all, > > we're experiencing some weird trouble while using the IDBroker. Two of > our sites (one running on MySQL 5.x + Torque 3.3-RC1 and one running on > Postgres 8.x + Torque 3.3-RC2) start throwing duplicate key exceptions > after running (without problems) for a while. The IDs generated are much > lower than the next_id entry in the id_table. When I restart the > application the problem is gone, but after a while (days/weeks) it > returns. Does anybody know what is going on, or has experienced similar > problems? > > Thanks in advanced, > > with kind regards, > > -- > Hidde Boonstra > Us Media B.V. > Stadhouderskade 115 > 1073 AX Amsterdam > > t: 020 428 68 68 > f: 020 470 69 05 > www.usmedia.nl > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Forio Business Simulations Will Glass-Husain [EMAIL PROTECTED] www.forio.com
