db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Will Glass-Husain" <wgl...@forio.com>
Subject duplicate ID exception in cluster
Date Tue, 05 Dec 2006 15:04:42 GMT

I just set up a new 2 server cluster with two instances of Tomcat both
reading/writing from a single database.  I'm using Torque 3.0, the
default ID Broker and MySQL 5. (InnoDB)

My problem... Under heavy load, I notice that most write requests on
one of the servers fails with a duplicate ID error.  Typically, each
page request that fails does 10-20 insert statements.

Any tips as to how I might make this cluster work with simultaneous writes?


To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message