Hi David,
I'm sorry that I must say that there is currently no upgrade path. I
guess that there was a discussion on the mailing list some month ago
about this issue. We know that this is a problem and hard to
communicate, but we have limited development resources.
As far as I know we are hoping to provide upgrade paths from 1.2 on.
Currently the only way to upgrade is to reingest the old mediapackages
into 1.2.
If you still have all ZIP-Packages you can use the inbox.
For the 1.0 to 1.1 upgrade I wrote myself a shell script that probably
only needs moderate changes to work for 1.1 to 1.2. This works on the
files in the matterhorn Working File Repository directory and does not
need the zip files or a running matterhorn.
I can share it, but it is not intensivly tested and unsupported. So you
should only use it if you know how shell scripts work.
Regards
Rüdiger
Am 30.08.2011 11:01, schrieb David Horwitz:
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
--
________________________________________________
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
