Duplicate entry '4183884' for key 'PRIMARY'

Hi, 

We have started getting more of these errors recently, now that the system is under a bit 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, 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


------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d