Hi all,
I have installed the latest 1.2 release but I found that the ingest service
is not functioning properly. It seems that 1.2 has lots of new service and
bundle. Attached the logs which shows the error.
Best Regards,
Eric Shek
The following are the logs:
2011-08-30 16:01:00 WARN (ServiceRegistryJpaImpl$JobDispatcher:1468) -
Error dispatching jobs
org.opencastproject.serviceregistry.api.ServiceRegistryException: Exception
[EclipseLink-4002] (Eclipse Persistence Services - 2.0.2.v20100323-r6872):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Column "CREATOR" not
found; SQL statement:
SELECT ID, STATUS, PAYLOAD, DATESTARTED, RUNTIME, creator, instance_version,
DATECOMPLETED, operation, DISPATCHABLE, organization, DATECREATED,
QUEUETIME, processor_svc, PARENTJOB_ID, ROOTJOB_ID, creator_svc FROM JOB
WHERE ((DISPATCHABLE = ?) AND (STATUS = ?)) ORDER BY DATECREATED ASC
[42122-149]
Error Code: 42122
Call: SELECT ID, STATUS, PAYLOAD, DATESTARTED, RUNTIME, creator,
instance_version, DATECOMPLETED, operation, DISPATCHABLE, organization,
DATECREATED, QUEUETIME, processor_svc, PARENTJOB_ID, ROOTJOB_ID, creator_svc
FROM JOB WHERE ((DISPATCHABLE = ?) AND (STATUS = ?)) ORDER BY DATECREATED
ASC
bind => [true, 0]
Query: ReadAllQuery(name="Job.dispatchable.status" referenceClass=JobJpaImpl
sql="SELECT ID, STATUS, PAYLOAD, DATESTARTED, RUNTIME, creator,
instance_version, DATECOMPLETED, operation, DISPATCHABLE, organization,
DATECREATED, QUEUETIME, processor_svc, PARENTJOB_ID, ROOTJOB_ID, creator_svc
FROM JOB WHERE ((DISPATCHABLE = ?) AND (STATUS = ?)) ORDER BY DATECREATED
ASC")
at
org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.getDispatchableJobs(ServiceRegistryJpaImpl.java:873)
at
org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl$JobDispatcher.run(ServiceRegistryJpaImpl.java:1428)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at
java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services -
2.0.2.v20100323-r6872): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Column "CREATOR" not
found; SQL statement:
SELECT ID, STATUS, PAYLOAD, DATESTARTED, RUNTIME, creator, instance_version,
DATECOMPLETED, operation, DISPATCHABLE, organization, DATECREATED,
QUEUETIME, processor_svc, PARENTJOB_ID, ROOTJOB_ID, creator_svc FROM JOB
WHERE ((DISPATCHABLE = ?) AND (STATUS = ?)) ORDER BY DATECREATED ASC
[42122-149]
Error Code: 42122
Call: SELECT ID, STATUS, PAYLOAD, DATESTARTED, RUNTIME, creator,
instance_version, DATECOMPLETED, operation, DISPATCHABLE, organization,
DATECREATED, QUEUETIME, processor_svc, PARENTJOB_ID, ROOTJOB_ID, creator_svc
FROM JOB WHERE ((DISPATCHABLE = ?) AND (STATUS = ?)) ORDER BY DATECREATED
ASC
bind => [true, 0]
Query: ReadAllQuery(name="Job.dispatchable.status" referenceClass=JobJpaImpl
sql="SELECT ID, STATUS, PAYLOAD, DATESTARTED, RUNTIME, creator,
instance_version, DATECOMPLETED, operation, DISPATCHABLE, organization,
DATECREATED, QUEUETIME, processor_svc, PARENTJOB_ID, ROOTJOB_ID, creator_svc
FROM JOB WHERE ((DISPATCHABLE = ?) AND (STATUS = ?)) ORDER BY DATECREATED
ASC")
at
org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:687)
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:530)
at
org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:529)
at
org.eclipse.persistence.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:133)
at
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
at
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
at
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:263)
at
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:619)
at
org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2537)
at
org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2496)
at
org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:455)
at
org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:997)
at
org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:675)
at
org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:958)
at
org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:432)
at
org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1021)
at
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2898)
at
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1225)
at
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1207)
at
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1181)
at
org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:453)
at
org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:681)
at
org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.getDispatchableJobs(ServiceRegistryJpaImpl.java:871)
... 10 more
Caused by: org.h2.jdbc.JdbcSQLException: Column "CREATOR" not found; SQL
statement:
SELECT ID, STATUS, PAYLOAD, DATESTARTED, RUNTIME, creator, instance_version,
DATECOMPLETED, operation, DISPATCHABLE, organization, DATECREATED,
QUEUETIME, processor_svc, PARENTJOB_ID, ROOTJOB_ID, creator_svc FROM JOB
WHERE ((DISPATCHABLE = ?) AND (STATUS = ?)) ORDER BY DATECREATED ASC
[42122-149]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at
org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:126)
at org.h2.command.dml.Select.prepare(Select.java:773)
at org.h2.command.Parser.prepare(Parser.java:202)
at org.h2.command.Parser.prepareCommand(Parser.java:214)
at org.h2.engine.Session.prepareLocal(Session.java:425)
at org.h2.engine.Session.prepareCommand(Session.java:374)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1056)
at
org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:233)
at
com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213)
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1404)
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1353)
at
org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:645)
at
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:580)
... 32 more
_______________________________________________
Matterhorn-users mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn-users
