!ENTRY org.locationtech.udig.libs 2 0 2025-03-04 08:51:43.171 !MESSAGE 2025-03-04 08:51:43 SqlExceptionHelper - SQL Error: 30000, SQLState: 40XL1 !ENTRY org.locationtech.udig.libs 4 0 2025-03-04 08:51:43.172 !MESSAGE 2025-03-04 08:51:43 SqlExceptionHelper - A lock could not be obtained within the time requested !ENTRY org.wcs.smart.cybertracker 4 0 2025-03-04 08:51:43.173 !MESSAGE javax.persistence.OptimisticLockException: org.hibernate.exception.LockAcquisitionException: could not extract ResultSet: {"geometry":{"coordinates":[11.402866666666668,-0.32066666666666666],"type":"Point"},"type":"Feature","properties":{"dateTime":"2025-03-03T13:10:58.328+01:00","altitude":0,"rootId":"7106563b1282435e8ec649d44b191b1d","appName":"Survey - LTM","latitude":-0.32066666666666666,"ctVersion":"1.0.478","id":"061068a39cbc4c229599c843a17a9fcd","deviceId":"bd0591af02c24cc2bb39196ba0c9db93","sighting":{"e:35fd2a42f6c544b4b11a60ef3c3a13a8":true,"SMART_MP_businessorfarmname":"Otter","l:0:81bba4c092ca465c8bcf206ffc9b9bc2":true,"SMART_MP_farmowner":"Ott","SMART_SamplingUnit":"su:null","l:0:20f3b7cd842d4074a77053a5bd02bc11":true,"SMART_DefaultAttributeValues":"{}","SMART_SightingGroupId":"704391e894764a2ba72721952ba0531e","SMART_Leader":"e:35fd2a42f6c544b4b11a60ef3c3a13a8","SMART_PatrolID":"b3916662bcf74b72a1bd4adcd9276b9c","l:0:fcb81e6cdffb48c89987701d95a00a22":true,"SMART_PatrolStartTime":"13:02:33","l:0:921d372f114e4d4c850980c0d8bfcc7f":true,"SMART_DataType":"survey","SMART_PatrolStartDate":"2025\/03\/03","SMART_ObservationType":"Observation","c:0":"5bcda14ca8ab4d58aff2d20bf7a701ca","SMART_DefaultPatrolValues":"{}","SMART_NewWaypoint":true,"a:0:d10f958a5aa441fbaaf8b51c740d7d22":"l:ee28499e6f6d47b887c9403e981692ac","SMART_ObsCounter":13,"SMART_MP_threedigitcode":"zzz","SMART_SurveyDesign":"eovlongterm","e:571c4e1d6d8d4ac496e6fae52338f1dd":true},"longitude":11.402866666666668}} !STACK 0 java.lang.RuntimeException: javax.persistence.OptimisticLockException: org.hibernate.exception.LockAcquisitionException: could not extract ResultSet at org.wcs.smart.common.attachment.AttachmentInterceptor.onSave(AttachmentInterceptor.java:152) at org.hibernate.event.internal.AbstractSaveEventListener.substituteValuesIfNecessary(AbstractSaveEventListener.java:391) at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:271) at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:196) at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:139) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:191) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:176) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:97) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73) at org.hibernate.internal.SessionImpl.fireSaveOrUpdate(SessionImpl.java:681) at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:673) at org.hibernate.engine.spi.CascadingActions$5.cascade(CascadingActions.java:219) at org.hibernate.engine.internal.Cascade.cascadeToOne(Cascade.java:490) at org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:415) at org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:216) at org.hibernate.engine.internal.Cascade.cascadeCollectionElements(Cascade.java:523) at org.hibernate.engine.internal.Cascade.cascadeCollection(Cascade.java:455) at org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:418) at org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:216) at org.hibernate.engine.internal.Cascade.cascade(Cascade.java:149) at org.hibernate.event.internal.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:459) at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:295) at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:196) at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:139) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:191) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:176) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:97) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73) at org.hibernate.internal.SessionImpl.fireSaveOrUpdate(SessionImpl.java:681) at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:673) at org.hibernate.engine.spi.CascadingActions$5.cascade(CascadingActions.java:219) at org.hibernate.engine.internal.Cascade.cascadeToOne(Cascade.java:490) at org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:415) at org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:216) at org.hibernate.engine.internal.Cascade.cascadeCollectionElements(Cascade.java:523) at org.hibernate.engine.internal.Cascade.cascadeCollection(Cascade.java:455) at org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:418) at org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:216) at org.hibernate.engine.internal.Cascade.cascade(Cascade.java:149) at org.hibernate.event.internal.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:159) at org.hibernate.event.internal.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:150) at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:83) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:38) at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1483) at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1469) at org.wcs.smart.cybertracker.survey.json.MissionJsonProcessor.processJson(MissionJsonProcessor.java:237) at org.wcs.smart.connect.dataqueue.cybertracker.CybertrackerItemProcessor.run(CybertrackerItemProcessor.java:221) at org.wcs.smart.connect.dataqueue.cybertracker.CybertrackerItemProcessor.run(CybertrackerItemProcessor.java:203) at org.wcs.smart.connect.dataqueue.cybertracker.CybertrackerItemProcessor.process(CybertrackerItemProcessor.java:122) at org.wcs.smart.connect.dataqueue.internal.process.DataQueueItemProcessor.processItem(DataQueueItemProcessor.java:220) at org.wcs.smart.connect.dataqueue.internal.process.DataQueueItemProcessor.run(DataQueueItemProcessor.java:132) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Caused by: javax.persistence.OptimisticLockException: org.hibernate.exception.LockAcquisitionException: could not extract ResultSet at org.hibernate.internal.ExceptionConverterImpl.wrapLockException(ExceptionConverterImpl.java:277) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:98) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1538) at org.hibernate.query.Query.getResultList(Query.java:165) at org.wcs.smart.er.model.SurveyWaypointSource.getDatastoreFileLocation(SurveyWaypointSource.java:84) at org.wcs.smart.observation.model.ObservationAttachment.getDatastoreFolderPath(ObservationAttachment.java:88) at org.wcs.smart.common.attachment.ISmartAttachment.computeFileLocation(ISmartAttachment.java:101) at org.wcs.smart.common.attachment.AttachmentInterceptor.onSave(AttachmentInterceptor.java:150) ... 51 more Caused by: org.hibernate.exception.LockAcquisitionException: could not extract ResultSet at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:75) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:69) at org.hibernate.loader.Loader.getResultSet(Loader.java:2171) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1934) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1896) at org.hibernate.loader.Loader.doQuery(Loader.java:936) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:339) at org.hibernate.loader.Loader.doList(Loader.java:2693) at org.hibernate.loader.Loader.doList(Loader.java:2676) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2510) at org.hibernate.loader.Loader.list(Loader.java:2505) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:396) at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219) at org.hibernate.internal.StatelessSessionImpl.list(StatelessSessionImpl.java:472) at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1561) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1529) ... 56 more Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained within the time requested at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:100) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:230) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:431) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:360) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2405) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:88) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1436) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1709) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(EmbedPreparedStatement.java:286) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60) ... 71 more Caused by: ERROR 40XL1: A lock could not be obtained within the time requested at org.apache.derby.shared.common.error.StandardException.newException(StandardException.java:300) at org.apache.derby.shared.common.error.StandardException.newException(StandardException.java:295) at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(ConcurrentLockSet.java:637) at org.apache.derby.impl.services.locks.AbstractPool.lockObject(AbstractPool.java:120) at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(ConcurrentPool.java:28) at org.apache.derby.impl.store.raw.xact.RowLocking2.lockRecordForRead(RowLocking2.java:166) at org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java:530) at org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java:654) at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(B2IRowLocking3.java:306) at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(B2IRowLocking3.java:590) at org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(B2IRowLockingRR.java:104) at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(BTreeForwardScan.java:313) at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(BTreeScan.java:1600) at org.apache.derby.impl.sql.execute.TableScanResultSet.loopControl(TableScanResultSet.java:451) at org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(TableScanResultSet.java:491) at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(IndexRowToBaseRowResultSet.java:346) at org.apache.derby.impl.sql.execute.JoinResultSet.openCore(JoinResultSet.java:149) at org.apache.derby.impl.sql.execute.JoinResultSet.openCore(JoinResultSet.java:146) at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(ProjectRestrictResultSet.java:182) at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(BasicNoPutResultSetImpl.java:266) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:472) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:351) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1344) ... 75 more