db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Will Glass-Husain" <wglasshus...@gmail.com>
Subject Re: idbroker generates existing ID's
Date Thu, 15 Nov 2007 16:39:24 GMT
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] <
hidde.boonstra@usmedia.nl> 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>


-- 
Forio Business Simulations

Will Glass-Husain
wglass@forio.com
www.forio.com

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message