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 protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
