pk_service_semaphore error

[Jacques Le Roux]

While working in the POS I got this error, never seen that before (clean installation)...


2007-12-06 00:00:09,093 (default-invoker-Thread-15) [ EntitySyncServices.java:620:INFO ] In cleanSyncRemoveInfo removed [0] values with TX timestamp before [2007-12-05 23:36:09.078]
2007-12-06 00:00:09,796 (default-invoker-Thread-12) [    TransactionUtil.java:346:WARN ] No transaction in place, so not suspending.
2007-12-06 00:00:09,812 (default-invoker-Thread-12) [    TransactionUtil.java:346:WARN ] No transaction in place, so not suspending.
2007-12-06 00:00:09,812 (default-invoker-Thread-11) [    TransactionUtil.java:346:WARN ] No transaction in place, so not suspending.
2007-12-06 00:00:09,812 (default-invoker-Thread-13) [    TransactionUtil.java:346:WARN ] No transaction in place, so not suspending.
2007-12-06 00:00:09,890 (default-invoker-Thread-13) [   GenericDelegator.java:714:ERROR]
---- exception report ----------------------------------------------------------
Failure in create operation for entity [ServiceSemaphore]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ServiceSemaphore][createdStamp,2007-12-06 00:00:09.828(java.sql.Timestamp)][createdTxStamp,2007-12-06 00:00:09.828(java.sql.Timestamp)][lastUpdatedStamp,2007-12-06 00:00:09.828(java.sql.Timestamp)][lastUpdatedTxStamp,2007-12-06 00:00:09.828(java.sql.Timestamp)][lockThread,default-invoker-Thread-13(java.lang.String)][lockTime,2007-12-06 00:00:08.562(java.sql.Timestamp)][serviceName,purgeOldJobs(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.SERVICE_SEMAPHORE (SERVICE_NAME, LOCK_THREAD, LOCK_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key violates unique constraint "pk_service_semaphore")). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting: [GenericEntity:ServiceSemaphore][createdStamp,2007-12-06 00:00:09.828(java.sql.Timestamp)][createdTxStamp,2007-12-06 00:00:09.828(java.sql.Timestamp)][lastUpdatedStamp,2007-12-06 00:00:09.828(java.sql.Timestamp)][lastUpdatedTxStamp,2007-12-06 00:00:09.828(java.sql.Timestamp)][lockThread,default-invoker-Thread-13(java.lang.String)][lockTime,2007-12-06 00:00:08.562(java.sql.Timestamp)][serviceName,purgeOldJobs(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.SERVICE_SEMAPHORE (SERVICE_NAME, LOCK_THREAD, LOCK_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key violates unique constraint "pk_service_semaphore"))
---- stack trace ---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ServiceSemaphore][createdStamp,2007-12-06 00:00:09.828(java.sql.Timestamp)][createdTxStamp,2007-12-06 00:00:09.828(java.sql.Timestamp)][lastUpdatedStamp,2007-12-06 00:00:09.828(java.sql.Timestamp)][lastUpdatedTxStamp,2007-12-06 00:00:09.828(java.sql.Timestamp)][lockThread,default-invoker-Thread-13(java.lang.String)][lockTime,2007-12-06 00:00:08.562(java.sql.Timestamp)][serviceName,purgeOldJobs(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.SERVICE_SEMAPHORE (SERVICE_NAME, LOCK_THREAD, LOCK_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key violates unique constraint "pk_service_semaphore"))
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:170)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:696)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:586)
org.ofbiz.entity.GenericValue.create(GenericValue.java:119)
org.ofbiz.service.semaphore.ServiceSemaphore.dbWrite(ServiceSemaphore.java:145)
org.ofbiz.service.semaphore.ServiceSemaphore.checkLockNeedToWait(ServiceSemaphore.java:115)
org.ofbiz.service.semaphore.ServiceSemaphore.waitOrFail(ServiceSemaphore.java:83)
org.ofbiz.service.semaphore.ServiceSemaphore.acquire(ServiceSemaphore.java:53)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:208)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:229)
java.lang.Thread.run(Thread.java:595)

Jacques