Hi Eric,
there is no upgrading from 1.1 to 1.2 you will have to setup a new
database for 1.2. It seems to me that you are still using the 1.1 database.
Regards
Rüdiger
Am 30.08.2011 10:02, schrieb Eric Shek:
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
--
________________________________________________
Rüdiger Rolf, M.A.
Universität Osnabrück - Zentrum virtUOS
Heger-Tor-Wall 12, 49069 Osnabrück
Telefon: (0541) 969-6511 - Fax: (0541) 969-16511
E-Mail: [email protected]
Internet: www.virtuos.uni-osnabrueck.de
_______________________________________________
Matterhorn-users mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn-users
