[
http://opencast.jira.com/browse/MH-9407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=33008#comment-33008
]
Adam McKenzie commented on MH-9407:
-----------------------------------
I reproduced this as well:
2013-02-13 14:18:41 ERROR (ServiceRegistryJpaImpl:243) - Error registarting JMX
statistic beans {}
org.opencastproject.serviceregistry.api.ServiceRegistryException: Exception
[EclipseLink-4002] (Eclipse Persistence Services - 2.0.2.v20100323-r6872):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Unknown column 't0.active' in 'field list'
Error Code: 1054
Call: SELECT t0.id, t0.path, t0.job_producer, t0.active,
t0.warning_state_trigger, t0.error_state_trigger, t0.service_type,
t0.service_state, t0.state_changed, t0.online, t0.online_from,
t0.host_registration, t1.status, COUNT(t1.status), AVG(t1.queue_time),
AVG(t1.run_time) FROM service_registration t0, job t1 WHERE (t0.id =
t1.processor_service) GROUP BY t0.id, t0.path, t0.job_producer, t0.active,
t0.warning_state_trigger, t0.error_state_trigger, t0.service_type,
t0.service_state, t0.state_changed, t0.online, t0.online_from,
t0.host_registration, t1.status
Query: ReportQuery(name="ServiceRegistration.statistics"
referenceClass=JobJpaImpl sql="SELECT t0.id, t0.path, t0.job_producer,
t0.active, t0.warning_state_trigger, t0.error_state_trigger, t0.service_type,
t0.service_state, t0.state_changed, t0.online, t0.online_from,
t0.host_registration, t1.status, COUNT(t1.status), AVG(t1.queue_time),
AVG(t1.run_time) FROM service_registration t0, job t1 WHERE (t0.id =
t1.processor_service) GROUP BY t0.id, t0.path, t0.job_producer, t0.active,
t0.warning_state_trigger, t0.error_state_trigger, t0.service_type,
t0.service_state, t0.state_changed, t0.online, t0.online_from,
t0.host_registration, t1.status")
at
org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.getServiceStatistics(ServiceRegistryJpaImpl.java:1542)
at
org.opencastproject.serviceregistry.impl.ServiceRegistryJpaImpl.activate(ServiceRegistryJpaImpl.java:235)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.felix.scr.impl.helper.BaseMethod.invokeMethod(BaseMethod.java:227)
at
org.apache.felix.scr.impl.helper.BaseMethod.access$500(BaseMethod.java:38)
at
org.apache.felix.scr.impl.helper.BaseMethod$Resolved.invoke(BaseMethod.java:591)
at
org.apache.felix.scr.impl.helper.BaseMethod.invoke(BaseMethod.java:472)
at
org.apache.felix.scr.impl.helper.ActivateMethod.invoke(ActivateMethod.java:146)
at
org.apache.felix.scr.impl.manager.ImmediateComponentManager.createImplementationObject(ImmediateComponentManager.java:226)
at
org.apache.felix.scr.impl.manager.ImmediateComponentManager.createComponent(ImmediateComponentManager.java:118)
at
org.apache.felix.scr.impl.manager.AbstractComponentManager$Unsatisfied.activate(AbstractComponentManager.java:997)
at
org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:333)
at
org.apache.felix.scr.impl.manager.DependencyManager.serviceAdded(DependencyManager.java:283)
at
org.apache.felix.scr.impl.manager.DependencyManager.serviceChanged(DependencyManager.java:170)
at
org.apache.felix.framework.util.EventDispatcher.invokeServiceListenerCallback(EventDispatcher.java:932)
at
org.apache.felix.framework.util.EventDispatcher.fireEventImmediately(EventDispatcher.java:793)
at
org.apache.felix.framework.util.EventDispatcher.fireServiceEvent(EventDispatcher.java:543)
at org.apache.felix.framework.Felix.fireServiceEvent(Felix.java:4260)
at org.apache.felix.framework.Felix.registerService(Felix.java:3275)
at
org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:346)
at
org.apache.felix.framework.BundleContextImpl.registerService(BundleContextImpl.java:320)
at org.opencastproject.db.Activator.start(Activator.java:123)
at
org.apache.felix.framework.util.SecureAction.startActivator(SecureAction.java:641)
at org.apache.felix.framework.Felix.activateBundle(Felix.java:1977)
at org.apache.felix.framework.Felix.startBundle(Felix.java:1895)
at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:944)
at
org.apache.felix.fileinstall.internal.DirectoryWatcher.process(DirectoryWatcher.java:1175)
at
org.apache.felix.fileinstall.internal.DirectoryWatcher.process(DirectoryWatcher.java:1153)
at
org.apache.felix.fileinstall.internal.DirectoryWatcher.process(DirectoryWatcher.java:458)
at
org.apache.felix.fileinstall.internal.DirectoryWatcher.run(DirectoryWatcher.java:263)
> mysql ddl misses active field for host_registration and service_registration
> ----------------------------------------------------------------------------
>
> Key: MH-9407
> URL: http://opencast.jira.com/browse/MH-9407
> Project: Matterhorn Project
> Issue Type: Bug
> Components: Administrative Tools
> Affects Versions: 1.4
> Reporter: Kristof Keppens
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
http://opencast.jira.com/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Matterhorn mailing list
Matterhorn@opencastproject.org
http://lists.opencastproject.org/mailman/listinfo/matterhorn
To unsubscribe please email
matterhorn-unsubscr...@opencastproject.org
_______________________________________________
