db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Kromkamp" <r.kromk...@pagelink.nl>
Subject id broker occurs duplicate key
Date Tue, 31 Jan 2006 12:28:22 GMT
Hi All,

I get the error below. I'm using torque 3.1.1 and postgres 8.0 . I wonder why the quantity
of the specific record in id-table is increased and one second later it will fail during an
insert. This table is only accessed by using the idbroker method of Torque. It worked for
2 months perfectly except for now. Does anyone has an idea?

2006/01/31 11:05:59 | - Forced id retrieval - no available list
2006/01/31 11:05:59 | - updateQuantity: UPDATE ID_TABLE SET QUANTITY = 3 WHERE TABLE_NAME
= 'LOCKING'
2006/01/31 11:05:59 | - updateNextId: UPDATE ID_TABLE SET NEXT_ID = 1373 WHERE TABLE_NAME
= 'LOCKING'
2006/01/31 11:06:00 | - Exception
2006/01/31 11:06:00 | org.apache.torque.TorqueException: java.sql.SQLException: ERROR: duplicate
key violates unique constraint "locking_pkey"
2006/01/31 11:06:00 | 	at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:200)
2006/01/31 11:06:00 | 	at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:867)

Cheers,
Robert


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


Mime
View raw message