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

Reply via email to