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]
