OptimisticLockException /stuck workflows

Paul Pettit

unread,

Oct 26, 2017, 9:32:09 AM10/26/17

to us...@opencast.org

Hi,

I've been seeing a few org.eclipse.persis

tence.exceptions.OptimisticLockException again recently.

I have dispatchinterval=0 set in org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.cfg on all servers other than admin.

I am not sure if it is related but I also have had a few workflows get stuck in a weird state. They get all the way to the final cleanup operation and get stuck there. In the adminui, the workflow says processing failed, but there is no comment added, and the cleanup operation says 'RUNNING'. In the jobs tab there are 'START_OPERATION' jobs for each stuck workflow that I can not work out how to get rid of.

Any Ideas?

Thanks,

Paul.

2017-10-26 01:00:21,756 | WARN | (JavaLog:300) -

Exception [EclipseLink-5006] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persis

tence.exceptions.OptimisticLockException

Exception Description: The object [Job {id:748486, operation:Inspect, status:DISPATCHING}] cannot be upda

ted because it has changed or been deleted since it was last read.

Class> org.opencastproject.job.jpa.JpaJob Primary Key> 748,486

at org.eclipse.persistence.exceptions.OptimisticLockException.objectChangedSinceLastReadWhenUpdat

ing(OptimisticLockException.java:144)

at org.eclipse.persistence.descriptors.VersionLockingPolicy.validateUpdate(VersionLockingPolicy.java:790)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.updateObjectForWriteWithChangeSet(DatabaseQueryMechanism.java:1086)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.queries.UpdateObjectQuery.executeCommitWithChangeSet(UpdateObjectQuery.java:84)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:301)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1790)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.CommitManager.commitChangedObjectsForClassWithChangeSet(CommitManager.java:273)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:131)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4264)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1441)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1531)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:278)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1169)[276:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:134)[277:org.eclipse.persistence.jpa:2.6.4.v20160829-44060b6]

at org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.updateInternal(ServiceRegistryJpaImpl.java:943)[113:matterhorn-serviceregistry:3.2.0]

at org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl$JobDispatcher.dispatchJob(ServiceRegistryJpaImpl.java:3050)[113:matterhorn-serviceregistry:3.2.0]

at org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl$JobDispatcher.dispatchDispatchableJobs(ServiceRegistryJpaImpl.java:2978)[113:matterhorn-serviceregistry:3.2.0]

at org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl$JobDispatcher.run(ServiceRegistryJpaImpl.java:2874)[113:matterhorn-serviceregistry:3.2.0]

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)[:1.8.0_144]

at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)[:1.8.0_144]

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)[:1.8.0_144]

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)[:1.8.0_144]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)[:1.8.0_144]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)[:1.8.0_144]

at java.lang.Thread.run(Thread.java:748)[:1.8.0_144]

kdolan

unread,

Oct 26, 2017, 10:17:19 AM10/26/17

to us...@opencast.org

Hi Paul,

> OptimisticLockException

OptimisticLockException means something happened that then caused the hopefulness and confidence about a successful outcome of the database’s optimistic lock strategy to fail.

The workflows get stuck in a weird state prior to optimism failure, is a likely candidate.

Look at log lines above the OptimisticLockException, they could be way above, depending on how much is going on in your server, for something that doesn’t look quite right. For example, an INFO or WARN log that says there was a failure or unable to do something, or missing something, or skipping because no space left on disk, etc.

Best of luck,
Karen

Rute Santos

unread,

Oct 4, 2018, 4:57:22 PM10/4/18

to us...@opencast.org

Hi,

We are seeing instances of OptimisticLockException in ServiceRegistry dispatchJob. The same error was mentioned before in an old post (see below) and I opened MH-13147 with some ideas. I am curious to know if others are seeing this. We are using OC 5.0.

Thanks,

Rute

--
You received this message because you are subscribed to the Google Groups "Opencast Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to users+un...@opencast.org.

Paul Pettit

unread,

Oct 5, 2018, 4:47:50 AM10/5/18

to us...@opencast.org

Hi Rute,

I am still getting this a lot (still using 3.x as didn't manage to get 5 sorted in time). In some cases jobs are very obviously shown in the logs as being dispatched twice within a few milliseconds. This is from the presentation node for example:

2018-10-04 02:48:36,292 | INFO | (OaiPmhPublicationServiceImpl:256) - Published 77da2b97-c271-47e5-991d

-c01b5610f9a6 to OAI-PMH repository default

2018-10-04 02:49:01,604 | INFO | (OaiPmhPublicationServiceImpl:239) - Publishing media package 992903cb

-90db-4675-a416-8e6cbda39cb4 to OAI-PMH

2018-10-04 02:49:01,773 | INFO | (OaiPmhPublicationServiceImpl:239) - Publishing media package 992903cb

-90db-4675-a416-8e6cbda39cb4 to OAI-PMH

2018-10-04 02:49:02,113 | WARN | (JavaLog:300) -

Exception [EclipseLink-5006] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.OptimisticLockException

Exception Description: The object [Job {id:6675921, operation:Distribute, status:QUEUED}] cannot be updated because it has changed or been deleted since it was last read.

Class> org.opencastproject.job.jpa.JpaJob Primary Key> 6,675,921

at org.eclipse.persistence.exceptions.OptimisticLockException.objectChangedSinceLastReadWhenUpdating(OptimisticLockException.java:144)

at org.eclipse.persistence.descriptors.VersionLockingPolicy.validateUpdate(VersionLockingPolicy.java:790)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.updateObjectForWriteWithChangeSet(DatabaseQueryMechanism.java:1086)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.queries.UpdateObjectQuery.executeCommitWithChangeSet(UpdateObjectQuery.java:84)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:301)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1790)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.CommitManager.commitChangedObjectsForClassWithChangeSet(CommitManager.java:273)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:131)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4264)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1441)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1531)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:278)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1169)[225:org.eclipse.persistence.core:2.6.4.v20160829-44060b6]

at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:134)[226:org.eclipse.persistence.jpa:2.6.4.v20160829-44060b6]

at org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.updateInternal(ServiceRegistryJpaImpl.java:943)[84:matterhorn-serviceregistry:3.2.0]

at org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.updateJob(ServiceRegistryJpaImpl.java:876)[84:matterhorn-serviceregistry:3.2.0]

at org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.updateJob(ServiceRegistryJpaImpl.java:899)[84:matterhorn-serviceregistry:3.2.0]

at org.opencastproject.job.api.JobBarrier.suspendWaiterJob(JobBarrier.java:159)[39:matterhorn-common:3.2.0]

at org.opencastproject.job.api.JobBarrier.waitForJobs(JobBarrier.java:220)[39:matterhorn-common:3.2.0]

at org.opencastproject.util.JobUtil.waitForJobs(JobUtil.java:108)[39:matterhorn-common:3.2.0]

at org.opencastproject.util.JobUtil.waitForJobs(JobUtil.java:127)[39:matterhorn-common:3.2.0]

at org.opencastproject.util.JobUtil.waitForJobs(JobUtil.java:144)[39:matterhorn-common:3.2.0]

at org.opencastproject.util.JobUtil.waitForJobs(JobUtil.java:226)[39:matterhorn-common:3.2.0]

at org.opencastproject.publication.oaipmh.OaiPmhPublicationServiceImpl.publishElementsToDownload(OaiPmhPublicationServiceImpl.java:342)[73:matterhorn-publication-service-oaipmh:3.2.0]

at org.opencastproject.publication.oaipmh.OaiPmhPublicationServiceImpl.publishInternal(OaiPmhPublicationServiceImpl.java:248)[73:matterhorn-publication-service-oaipmh:3.2.0]

at org.opencastproject.publication.oaipmh.OaiPmhPublicationServiceImpl.process(OaiPmhPublicationServiceImpl.java:427)[73:matterhorn-publication-service-oaipmh:3.2.0]

at org.opencastproject.job.api.AbstractJobProducer$JobRunner.call(AbstractJobProducer.java:281)[39:matterhorn-common:3.2.0]

at org.opencastproject.job.api.AbstractJobProducer$JobRunner.call(AbstractJobProducer.java:240)[39:matterhorn-common:3.2.0]

at java.util.concurrent.FutureTask.run(FutureTask.java:266)[:1.8.0_171]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)[:1.8.0_171]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)[:1.8.0_171]

at java.lang.Thread.run(Thread.java:748)[:1.8.0_171]

2018-10-04 02:49:02,114 | WARN | (JobBarrier:164) - Unable to put Some(6675905) into a waiting state, this may cause a deadlock: javax.persistence.RollbackException: javax.persistence.OptimisticLockException: Exception [EclipseLink-5006] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.OptimisticLockException

Exception Description: The object [Job {id:6675921, operation:Distribute, status:QUEUED}] cannot be updated because it has changed or been deleted since it was last read.

Class> org.opencastproject.job.jpa.JpaJob Primary Key> 6,675,921

2018-10-04 02:49:28,269 | INFO | (WorkspaceImpl:364) - Downloading https://playback-media.keele.ac.uk/mh_default_org/oaipmh-default/992903cb-90db-4675-a416-8e6cbda39cb4/catalog-0/catalog.xml to /srv/opencast/workspace/https_playback-media.keele.ac.uk/mh_default_org/oaipmh-default/992903cb-90db-4675-a416-8e6cbda39cb4/catalog-0/catalog.xml

2018-10-04 02:49:28,588 | INFO | (SeriesServiceRemoteImpl:281) - Successfully get series ACL RDI-10005-2018-SEM1-2-A from the remote series index

2018-10-04 02:49:28,626 | INFO | (OaiPmhPublicationServiceImpl:256) - Published 992903cb-90db-4675-a416-8e6cbda39cb4 to OAI-PMH repository default

2018-10-04 02:49:32,775 | INFO | (WorkspaceImpl:364) - Downloading https://playback-media.keele.ac.uk/mh_default_org/oaipmh-default/992903cb-90db-4675-a416-8e6cbda39cb4/catalog-0/catalog.xml to /srv/opencast/workspace/https_playback-media.keele.ac.uk/mh_default_org/oaipmh-default/992903cb-90db-4675-a416-8e6cbda39cb4/catalog-0/catalog.xml

2018-10-04 02:49:32,949 | INFO | (SeriesServiceRemoteImpl:281) - Successfully get series ACL RDI-10005-2018-SEM1-2-A from the remote series index

2018-10-04 02:49:32,957 | INFO | (OaiPmhPublicationServiceImpl:256) - Published 992903cb-90db-4675-a416-8e6cbda39cb4 to OAI-PMH repository default

Lars Kiesow

unread,

Oct 5, 2018, 6:00:00 AM10/5/18

to us...@opencast.org

The first thing that comes to mind is if you have Job dispatching
enabled on nodes other than the admin? I get them a lot if I let just
anyone dispatch and they more or less go away once I limit that to the
admin.
–Lars

Paul Pettit

unread,

Oct 5, 2018, 6:16:00 AM10/5/18

to us...@opencast.org

Hi Lars,

dispatchinterval is set to 0 on all servers except for admin, where it is left at the default.

Thanks,

Paul.

Rute Santos

unread,

Oct 5, 2018, 9:09:58 AM10/5/18

to us...@opencast.org

Hi,

This is the sequence that causes it for us (more details are in MH-13147):

1) On a worker, composer service encodes media and then creates the inspect job with QUEUED state so the dispatcher on admin can dispatch it at any time.

2) Admin node is in the middle of the dispatcher logic and ready to update the inspect job in the database (has already read it to merge).

3) Worker sets the waiter job, etc, updates the job in the db.

4) Dispatcher gets the optimistic lock at commit because 3) changed the jpa version after the job was read from the db.

I believe this is not a huge problem because the job will be dispatched in the next round of the dispatcher but it's still ugly. I have some ideas on how to fix it in MH-13147, but if anyone has a better one I would be interested!

Thanks,

Rute

James Perrin

unread,

Oct 12, 2018, 10:26:03 AM10/12/18

to us...@opencast.org, Rute Santos

Hi,

This may or may not be related. We have had the occasional:

javax.persistence.PersistenceException: Internal Exception: java.sql.SQLException: Transaction (Process ID 110) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Full log below. However we have notice that the frequency has increased significantly this week. Mostly related to ingests but also to publications. We are using MS-SQL so I would expect there to be a difference in behaviour but it does seem similar. Like Paul we are running r/3.x and dispatchinterval=0 on all but Admin where it is 2000 (2s).

Regards
James

2018-10-11 14:56:39,387 | INFO | (ServiceRegistryJpaImpl:2431) - State set to WARNING for current service org.opencastproject.ingest on host http://upload02.opencast.manchester.ac.uk
2018-10-11 14:56:39,407 | WARN | (IngestRestService:977) - javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Transaction (Process ID 110) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Error Code: 1205
Call: SELECT t0.host, t2.status, SUM(t2.job_load) FROM mh_service_registration t3, mh_job t2, mh_service_registration t1, mh_host_registration t0 WHERE ((((((t1.online = ?) AND (t1.active = ?)) AND (t0.maintenance = ?)) AND (t2.status IN (?,?))) AND (t3.service_type <> ?)) AND (((t1.id = t2.processor_service) AND (t0.id = t1.host_registration)) AND (t3.id = t2.creator_service))) GROUP BY t0.host, t2.status
bind => [6 parameters bound]
Query: ReportQuery(name="ServiceRegistration.hostloads" referenceClass=JpaJob sql="SELECT t0.host, t2.status, SUM(t2.job_load) FROM mh_service_registration t3, mh_job t2, mh_service_registration t1, mh_host_registration t0 WHERE ((((((t1.online = ?) AND (t1.active = ?)) AND (t0.maintenance = ?)) AND (t2.status IN ?)) AND (t3.service_type <> ?)) AND (((t1.id = t2.processor_service) AND (t0.id = t1.host_registration)) AND (t3.id = t2.creator_service))) GROUP BY t0.host, t2.status")
Default FetchGroup(){creatorServiceRegistration, creator, jobLoad, dispatchable, version, queueTime, dateCreated, blockingJobId, dateStarted, parentJob, dateCompleted, organization, rootJob, arguments, id, runTime, blockedJobIds, operation, childJobs, processorServiceRegistration, status}
org.opencastproject.ingest.api.IngestException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Transaction (Process ID 110) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Error Code: 1205
Call: SELECT t0.host, t2.status, SUM(t2.job_load) FROM mh_service_registration t3, mh_job t2, mh_service_registration t1, mh_host_registration t0 WHERE ((((((t1.online = ?) AND (t1.active = ?)) AND (t0.maintenance = ?)) AND (t2.status IN (?,?))) AND (t3.service_type <> ?)) AND (((t1.id = t2.processor_service) AND (t0.id = t1.host_registration)) AND (t3.id = t2.creator_service))) GROUP BY t0.host, t2.status
bind => [6 parameters bound]
Query: ReportQuery(name="ServiceRegistration.hostloads" referenceClass=JpaJob sql="SELECT t0.host, t2.status, SUM(t2.job_load) FROM mh_service_registration t3, mh_job t2, mh_service_registration t1, mh_host_registration t0 WHERE ((((((t1.online = ?) AND (t1.active = ?)) AND (t0.maintenance = ?)) AND (t2.status IN ?)) AND (t3.service_type <> ?)) AND (((t1.id = t2.processor_service) AND (t0.id = t1.host_registration)) AND (t3.id = t2.creator_service))) GROUP BY t0.host, t2.status")
Default FetchGroup(){creatorServiceRegistration, creator, jobLoad, dispatchable, version, queueTime, dateCreated, blockingJobId, dateStarted, parentJob, dateCompleted, organization, rootJob, arguments, id, runTime, blockedJobIds, operation, childJobs, processorServiceRegistration, status}
at org.opencastproject.ingest.impl.IngestServiceImpl.addZippedMediaPackage(IngestServiceImpl.java:582)
at org.opencastproject.ingest.endpoint.IngestRestService.ingestZippedMediaPackage(IngestRestService.java:967)
at org.opencastproject.ingest.endpoint.IngestRestService.addZippedMediaPackage(IngestRestService.java:900)
at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.8.0_181]
at java.lang.reflect.Method.invoke(Method.java:498)[:1.8.0_181]
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180)[109:org.apache.cxf.cxf-core:3.1.7]
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)[109:org.apache.cxf.cxf-core:3.1.7]

Blah, blah, blah

-- 
------------------------------------------------------------------------
 James S. Perrin

 Media Technologies Team
 Office One, Kilburn Building
 The University of Manchester
 Oxford Road, Manchester, M13 9PL

 t: +44 (0) 161 275 6945
 e: james....@manchester.ac.uk

Reply all

Reply to author

Forward