Duplicate entry '4183884' for key 'PRIMARY'
Duplicate entry '4183884' for key 'PRIMARY'
- Subject: Duplicate entry '4183884' for key 'PRIMARY'
- From: Mark Gowdy <email@hidden>
- Date: Fri, 17 May 2013 21:03:56 +0100
Hi,
We have started getting more of these errors recently, now that the system is under more load.
----
EvaluateExpression failed: <com.webobjects.jdbcadaptor._MySQLPlugIn$MySQLExpression: "INSERT INTO queue_item(ITEM_DATE, ... etc....)
Duplicate entry '4183884' for key 'PRIMARY'
----
I believe the problem is due to the fact that there is more than one instance trying to write to the 'queue_item' table, and the EO_PK_TABLE mechanism is handing out the same ID more than once.
Probably something to do with locking.
Our Database is MySQL 5, and the EO_PK_TABLE is of type MyISAM.
I tried to find the mechanism that allocate the primary key, but I keep bumping up against:
EOAdaptorChannel:
@Deprecated
public NSDictionary<String, Object> primaryKeyForNewRowWithEntity(EOEntity entity){
return null;
}
Any advise would be appreciated,
Thanks,
Mark
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden