[
https://jira.nuxeo.com/browse/NXP-7534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=101866#comment-101866
]
Benoit Delbosc commented on NXP-7534:
-------------------------------------
Hi,
Thank you for your reporting and patches.
As you mention it, we require a case sensitive collation
(http://doc.nuxeo.com/x/EgI7)
What is your current and previous database collation ?
ben
> Invalid object name in some SQL queries using MSSQL
> ---------------------------------------------------
>
> Key: NXP-7534
> URL: https://jira.nuxeo.com/browse/NXP-7534
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Core SQL Storage
> Affects Versions: 5.4.2
> Environment: Debian Linux 5.0.8
> Sun Java 1.6.0_24
> Cluster
> Reporter: José M. Palomar
> Priority: Major
> Attachments: quartz.properties, sqlserver.sql.txt
>
>
> After upgrading to 5.4.2-HF08 to get MSSQL performance enhancements I got
> this exception:
> 2011-09-14 12:07:19,133 ERROR
> [org.apache.geronimo.connector.outbound.MCFConnectionInterceptor] Error
> occurred creating ManagedConnection for
> org.apache.geronimo.connector.outbound.ConnectionInfo@74c6fd69
> org.nuxeo.ecm.core.storage.StorageException: java.sql.SQLException: Error
> executing: DELETE FROM CLUSTER_INVALS WHERE NODEID IN (
> SELECT DISTINCT CLUSTER_INVALS.NODEID
> FROM CLUSTER_INVALS LEFT JOIN CLUSTER_NODES ON CLUSTER_INVALS.NODEID =
> CLUSTER_NODES.NODEID
> WHERE CLUSTER_NODES.NODEID IS NULL
> ) : Invalid object name 'CLUSTER_INVALS'.
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createClusterNode(JDBCMapper.java:367)
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.ClusterNodeHandler.<init>(ClusterNodeHandler.java:47)
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.JDBCBackend.newMapper(JDBCBackend.java:163)
> at
> org.nuxeo.ecm.core.storage.sql.RepositoryImpl.getConnection(RepositoryImpl.java:346)
> at
> org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionFactoryImpl.getConnection(ManagedConnectionFactoryImpl.java:313)
> at
> org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionImpl.<init>(ManagedConnectionImpl.java:104)
> at
> org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:191)
> at
> org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:49)
> at
> org.apache.geronimo.connector.outbound.XAResourceInsertionInterceptor.getConnection(XAResourceInsertionInterceptor.java:41)
> at
> org.apache.geronimo.connector.outbound.SinglePoolMatchAllConnectionInterceptor.internalGetConnection(SinglePoolMatchAllConnectionInterceptor.java:87)
> at
> org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:80)
> at
> org.apache.geronimo.connector.outbound.MultiPoolConnectionInterceptor.getConnection(MultiPoolConnectionInterceptor.java:81)
> at
> org.apache.geronimo.connector.outbound.ThreadLocalCachingConnectionInterceptor.getConnection(ThreadLocalCachingConnectionInterceptor.java:70)
> at
> org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:46)
> at
> org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:103)
> at
> org.apache.geronimo.connector.outbound.SubjectInterceptor.getConnection(SubjectInterceptor.java:58)
> at
> org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43)
> at
> org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)
> at
> org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:66)
> at
> org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:87)
> at
> org.nuxeo.runtime.jtajca.NuxeoContainer$ConnectionManagerWrapper.allocateConnection(NuxeoContainer.java:443)
> at
> org.nuxeo.ecm.core.storage.sql.ra.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:161)
> at
> org.nuxeo.ecm.core.storage.sql.ra.ConnectionFactoryImpl.getSession(ConnectionFactoryImpl.java:236)
> at
> org.nuxeo.ecm.core.api.local.LocalSession.createSession(LocalSession.java:104)
> at
> org.nuxeo.ecm.core.api.local.LocalSession.getSession(LocalSession.java:166)
> at
> org.nuxeo.ecm.core.api.AbstractSession.connect(AbstractSession.java:214)
> 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.nuxeo.ecm.core.api.TransactionalCoreSessionWrapper.invoke(TransactionalCoreSessionWrapper.java:94)
> at $Proxy25.connect(Unknown Source)
> at
> org.nuxeo.ecm.core.api.repository.Repository.open(Repository.java:155)
> at
> org.nuxeo.ecm.core.api.repository.Repository.open(Repository.java:113)
> at
> org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:139)
> at
> org.nuxeo.ecm.platform.publisher.impl.service.DomainsFinder.getDomains(DomainsFinder.java:61)
> at
> org.nuxeo.ecm.platform.publisher.impl.service.PublisherServiceImpl.registerPendingDescriptors(PublisherServiceImpl.java:662)
> at
> org.nuxeo.ecm.platform.publisher.impl.service.PublisherServiceImpl.applicationStarted(PublisherServiceImpl.java:95)
> at
> org.nuxeo.runtime.model.impl.RegistrationInfoImpl.notifyApplicationStarted(RegistrationInfoImpl.java:321)
> at
> org.nuxeo.runtime.osgi.OSGiRuntimeService.notifyComponentsOnStarted(OSGiRuntimeService.java:458)
> at
> org.nuxeo.runtime.osgi.OSGiRuntimeService.fireApplicationStarted(OSGiRuntimeService.java:483)
> at
> org.nuxeo.runtime.osgi.OSGiRuntimeService.frameworkEvent(OSGiRuntimeService.java:493)
> at org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:231)
> at
> org.nuxeo.osgi.application.loader.FrameworkLoader.doStart(FrameworkLoader.java:179)
> at
> org.nuxeo.osgi.application.loader.FrameworkLoader.start(FrameworkLoader.java:122)
> 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.nuxeo.osgi.application.FrameworkBootstrap.start(FrameworkBootstrap.java:135)
> at
> org.nuxeo.runtime.tomcat.NuxeoLauncher.handleEvent(NuxeoLauncher.java:94)
> at
> org.nuxeo.runtime.tomcat.NuxeoLauncher.lifecycleEvent(NuxeoLauncher.java:70)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4424)
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
> at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:556)
> at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491)
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
> at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:516)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
> 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.catalina.startup.Bootstrap.start(Bootstrap.java:288)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> Caused by: java.sql.SQLException: Error executing: DELETE FROM CLUSTER_INVALS
> WHERE NODEID IN (
> SELECT DISTINCT CLUSTER_INVALS.NODEID
> FROM CLUSTER_INVALS LEFT JOIN CLUSTER_NODES ON CLUSTER_INVALS.NODEID =
> CLUSTER_NODES.NODEID
> WHERE CLUSTER_NODES.NODEID IS NULL
> ) : Invalid object name 'CLUSTER_INVALS'.
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.dialect.SQLStatement.execute(SQLStatement.java:282)
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.SQLInfo.executeSQLStatements(SQLInfo.java:1178)
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createClusterNode(JDBCMapper.java:364)
> ... 75 more
> Caused by: java.sql.SQLException: Invalid object name 'CLUSTER_INVALS'.
> at
> net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
> at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
> at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
> at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
> at
> net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
> at
> net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
> at
> net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
> at
> net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1160)
> at
> net.sourceforge.jtds.jdbcx.proxy.StatementProxy.execute(StatementProxy.java:287)
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.dialect.SQLStatement.execute(SQLStatement.java:279)
> ... 77 more
> Problem is that MSSQL is case sensitive after changing database collation and
> some object names like CLUSTER_INVALS must be undercase.
> Changing nuxeovcs/sqlserver.sql.txt file in nuxeo-core-storage-5.4.2-HF08.jar
> made the magic.
> Same issue with quartz tables. You must change table prefix from qrtz_ to
> QRTZ_ in quartz.properties in mssql-quartz-cluster template.
> 2011-09-12 13:59:14,557 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock:
> Invalid object name 'QRTZ_LOCKS'. [See nested exception:
> java.sql.SQLException: Invalid object name 'QRTZ_LOCKS'.]
> 2011-09-12 13:59:14,557 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.obtainLock(StdRowLockSemaphore.java:155)
> 2011-09-12 13:59:14,557 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.quartz.impl.jdbcjobstore.JobStoreCMT.doCheckin(JobStoreCMT.java:1382)
> 2011-09-12 13:59:14,557 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:2378)
> 2011-09-12 13:59:14,557 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.initialize(JobStoreSupport.java:2365)
> 2011-09-12 13:59:14,557 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:506)
> 2011-09-12 13:59:14,557 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:396)
> 2011-09-12 13:59:14,557 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.quartz.impl.StdScheduler.start(StdScheduler.java:147)
> 2011-09-12 13:59:14,557 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.ecm.platform.scheduler.core.service.SchedulerRegistryService.activate(SchedulerRegistryService.java:77)
> 2011-09-12 13:59:14,557 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.ComponentInstanceImpl.activate(ComponentInstanceImpl.java:120)
> 2011-09-12 13:59:14,558 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.RegistrationInfoImpl.activate(RegistrationInfoImpl.java:338)
> 2011-09-12 13:59:14,558 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.RegistrationInfoImpl.resolve(RegistrationInfoImpl.java:432)
> 2011-09-12 13:59:14,558 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.ComponentManagerImpl._register(ComponentManagerImpl.java:213)
> 2011-09-12 13:59:14,558 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.ComponentManagerImpl.register(ComponentManagerImpl.java:153)
> 2011-09-12 13:59:14,558 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.DefaultRuntimeContext.deploy(DefaultRuntimeContext.java:115)
> 2011-09-12 13:59:14,558 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.DefaultRuntimeContext.deploy(DefaultRuntimeContext.java:94)
> 2011-09-12 13:59:14,558 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.osgi.OSGiRuntimeService.loadComponents(OSGiRuntimeService.java:220)
> 2011-09-12 13:59:14,558 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.osgi.OSGiRuntimeService.createContext(OSGiRuntimeService.java:170)
> 2011-09-12 13:59:14,558 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.osgi.OSGiComponentLoader.install(OSGiComponentLoader.java:62)
> 2011-09-12 13:59:14,558 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.osgi.OSGiComponentLoader.<init>(OSGiComponentLoader.java:42)
> 2011-09-12 13:59:14,558 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.osgi.OSGiRuntimeActivator.start(OSGiRuntimeActivator.java:79)
> 2011-09-12 13:59:14,558 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.nuxeo.osgi.BundleImpl.start(BundleImpl.java:226)
> 2011-09-12 13:59:14,558 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.nuxeo.osgi.BundleRegistry.doRegister(BundleRegistry.java:173)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.nuxeo.osgi.BundleRegistry.register(BundleRegistry.java:128)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.nuxeo.osgi.BundleRegistry.install(BundleRegistry.java:83)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.nuxeo.osgi.OSGiAdapter.install(OSGiAdapter.java:186)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.osgi.application.loader.FrameworkLoader.install(FrameworkLoader.java:204)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.osgi.application.loader.FrameworkLoader.doStart(FrameworkLoader.java:173)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.osgi.application.loader.FrameworkLoader.start(FrameworkLoader.java:122)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at java.lang.reflect.Method.invoke(Method.java:597)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.osgi.application.FrameworkBootstrap.start(FrameworkBootstrap.java:135)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.nuxeo.runtime.tomcat.NuxeoLauncher.handleEvent(NuxeoLauncher.java:94)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.tomcat.NuxeoLauncher.lifecycleEvent(NuxeoLauncher.java:70)
> 2011-09-12 13:59:14,559 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4424)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:556)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> 2011-09-12 13:59:14,560 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> 2011-09-12 13:59:14,561 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.StandardService.start(StandardService.java:516)
> 2011-09-12 13:59:14,561 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
> 2011-09-12 13:59:14,561 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
> 2011-09-12 13:59:14,561 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 2011-09-12 13:59:14,561 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 2011-09-12 13:59:14,561 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 2011-09-12 13:59:14,561 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at java.lang.reflect.Method.invoke(Method.java:597)
> 2011-09-12 13:59:14,561 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
> 2011-09-12 13:59:14,561 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> 2011-09-12 13:59:14,561 INFO [org.nuxeo.log4j.ThreadedStreamGobbler] *
> Nested Exception (Underlying Cause) ---------------
> 2011-09-12 13:59:14,561 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> java.sql.SQLException: Invalid object name 'QRTZ_LOCKS'.
> 2011-09-12 13:59:14,561 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
> 2011-09-12 13:59:14,561 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:943)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> net.sourceforge.jtds.jdbc.MSCursorResultSet.<init>(MSCursorResultSet.java:154)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:424)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:778)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.obtainLock(StdRowLockSemaphore.java:137)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.quartz.impl.jdbcjobstore.JobStoreCMT.doCheckin(JobStoreCMT.java:1382)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:2378)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.initialize(JobStoreSupport.java:2365)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:506)
> 2011-09-12 13:59:14,562 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:396)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.quartz.impl.StdScheduler.start(StdScheduler.java:147)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.ecm.platform.scheduler.core.service.SchedulerRegistryService.activate(SchedulerRegistryService.java:77)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.ComponentInstanceImpl.activate(ComponentInstanceImpl.java:120)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.RegistrationInfoImpl.activate(RegistrationInfoImpl.java:338)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.RegistrationInfoImpl.resolve(RegistrationInfoImpl.java:432)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.ComponentManagerImpl._register(ComponentManagerImpl.java:213)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.ComponentManagerImpl.register(ComponentManagerImpl.java:153)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.DefaultRuntimeContext.deploy(DefaultRuntimeContext.java:115)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.model.impl.DefaultRuntimeContext.deploy(DefaultRuntimeContext.java:94)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.osgi.OSGiRuntimeService.loadComponents(OSGiRuntimeService.java:220)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.osgi.OSGiRuntimeService.createContext(OSGiRuntimeService.java:170)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.osgi.OSGiComponentLoader.install(OSGiComponentLoader.java:62)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.osgi.OSGiComponentLoader.<init>(OSGiComponentLoader.java:42)
> 2011-09-12 13:59:14,563 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.osgi.OSGiRuntimeActivator.start(OSGiRuntimeActivator.java:79)
> 2011-09-12 13:59:14,564 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.nuxeo.osgi.BundleImpl.start(BundleImpl.java:226)
> 2011-09-12 13:59:14,564 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.nuxeo.osgi.BundleRegistry.doRegister(BundleRegistry.java:173)
> 2011-09-12 13:59:14,564 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.nuxeo.osgi.BundleRegistry.register(BundleRegistry.java:128)
> 2011-09-12 13:59:14,564 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.nuxeo.osgi.BundleRegistry.install(BundleRegistry.java:83)
> 2011-09-12 13:59:14,564 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.nuxeo.osgi.OSGiAdapter.install(OSGiAdapter.java:186)
> 2011-09-12 13:59:14,565 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.osgi.application.loader.FrameworkLoader.install(FrameworkLoader.java:204)
> 2011-09-12 13:59:14,565 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.osgi.application.loader.FrameworkLoader.doStart(FrameworkLoader.java:173)
> 2011-09-12 13:59:14,565 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.osgi.application.loader.FrameworkLoader.start(FrameworkLoader.java:122)
> 2011-09-12 13:59:14,565 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 2011-09-12 13:59:14,565 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 2011-09-12 13:59:14,565 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 2011-09-12 13:59:14,566 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at java.lang.reflect.Method.invoke(Method.java:597)
> 2011-09-12 13:59:14,566 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.osgi.application.FrameworkBootstrap.start(FrameworkBootstrap.java:135)
> 2011-09-12 13:59:14,566 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.nuxeo.runtime.tomcat.NuxeoLauncher.handleEvent(NuxeoLauncher.java:94)
> 2011-09-12 13:59:14,566 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.nuxeo.runtime.tomcat.NuxeoLauncher.lifecycleEvent(NuxeoLauncher.java:70)
> 2011-09-12 13:59:14,566 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> 2011-09-12 13:59:14,566 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4424)
> 2011-09-12 13:59:14,566 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
> 2011-09-12 13:59:14,566 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
> 2011-09-12 13:59:14,566 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
> 2011-09-12 13:59:14,566 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630)
> 2011-09-12 13:59:14,566 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:556)
> 2011-09-12 13:59:14,566 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491)
> 2011-09-12 13:59:14,566 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
> 2011-09-12 13:59:14,567 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
> 2011-09-12 13:59:14,567 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> 2011-09-12 13:59:14,567 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> 2011-09-12 13:59:14,567 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
> 2011-09-12 13:59:14,567 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> 2011-09-12 13:59:14,567 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> 2011-09-12 13:59:14,567 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.StandardService.start(StandardService.java:516)
> 2011-09-12 13:59:14,567 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
> 2011-09-12 13:59:14,567 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
> 2011-09-12 13:59:14,567 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 2011-09-12 13:59:14,567 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 2011-09-12 13:59:14,567 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 2011-09-12 13:59:14,567 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at java.lang.reflect.Method.invoke(Method.java:597)
> 2011-09-12 13:59:14,568 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
> 2011-09-12 13:59:14,568 INFO [org.nuxeo.log4j.ThreadedStreamGobbler]
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> I attach working files.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
