Do you have an "id_table" and a separate "ID_TABLE"? I have run into that before.
"Hidde Boonstra [Us Media]" To <hidde.boonstr Apache Torque Users List [EMAIL PROTECTED]> <torque-user@db.apache.org> cc 11/15/07 12:02 Subject PM Re: idbroker generates existing ID's Please respond to "Apache Torque Users List" <[EMAIL PROTECTED] b.apache.org> Hi will, thanks for your response. No, I don't. I have thought about the possibility of transactions (or the lack of transactions) causing the problem, but since it also occurs with Postgres I thought I could rule it out. The weird thing is that the id_table states (for example) a next id of 180000 and a quantity of 1400, but the exception states it trying to insert an entry with id 24000. It does increment with each call (although I haven't tried 1400 calls). I have never had this problem with earlier version (i.e. pre 3.3 releases of Torque) and similar usage patterns. Will Glass-Husain wrote: > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]