Hi Ruediger,
I asked a question about upgrade paths yesterday - its not mentioned
anywhere in the release notes at all. Some indication of how one goes
about updating a 1.1 installation to 1.2 would be very useful. If its in
raw form in the list archives/jira or where ever I'm happy to help beat
it into some useful form if pointed in the right direction.
Regards
David
On 08/30/2011 10:40 AM, Ruediger Rolf wrote:
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
_______________________________________________
Matterhorn-users mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn-users
