Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-17823

TestActivateFactories.testSetActiveFactories failing under PostgreSQL due to bad H2 driver configuration

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 7.3
    • Fix Version/s: 6.0-HF20, 7.4
    • Component/s: Nuxeo Drive
    • Sprint:
      Drive
    • Story Points:
      1

      Description

      See http://qa.nuxeo.org/jenkins/view/Drive/job/addons_nuxeo-drive-server-master-multidb/PYTHON=System-CPython-2.7,Slave=MULTIDB_LINUX,dbprofile=pgsql,jdk=java-8-oracle/lastCompletedBuild/testReport/org.nuxeo.drive.operations/TestActivateFactories/testSetActiveFactories/

      12:59:04,951 WARN  [DetectThreadDeadlocksFeature] Thread dump available at target/tcheck-4878297936910067059.tdump
      12:59:06,004 ERROR [RegistrationInfoImpl] Component service:org.nuxeo.ecm.core.repository.RepositoryServiceComponent notification of application started failed.
      org.nuxeo.ecm.core.api.NuxeoException: java.sql.SQLException: Error post creating table: CALL NXFT_CREATE_INDEX('PUBLIC_FULLTEXT_default', 'PUBLIC', 'FULLTEXT', ('SIMPLETEXT', 'BINARYTEXT'), 'french') : Error creating or initializing trigger "NXFT_FULLTEXT" object, class "org.nuxeo.ecm.core.storage.sql.db.H2Fulltext$Trigger", cause: "java.sql.SQLException: java.lang.ClassNotFoundException: french"; see root cause for details; SQL statement:
      CREATE TRIGGER "PUBLIC"."NXFT_FULLTEXT" AFTER INSERT, UPDATE, DELETE ON "PUBLIC"."FULLTEXT" FOR EACH ROW CALL "org.nuxeo.ecm.core.storage.sql.db.H2Fulltext$Trigger" [90043-177]
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createDatabase(JDBCMapper.java:146)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.doInvoke(JDBCMapperConnector.java:22)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.invoke(JDBCMapperConnector.java:55)
      	at com.sun.proxy.$Proxy84.createDatabase(Unknown Source)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCBackend.newMapper(JDBCBackend.java:210)
      	at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.newMapper(RepositoryImpl.java:258)
      	at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.getConnection(RepositoryImpl.java:240)
      	at org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionFactoryImpl.initialize(ManagedConnectionFactoryImpl.java:273)
      	at org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:177)
      	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:88)
      	at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:80)
      	at org.apache.geronimo.connector.outbound.ThreadLocalCachingConnectionInterceptor.getConnection(ThreadLocalCachingConnectionInterceptor.java:70)
      	at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:49)
      	at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:109)
      	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:77)
      	at org.nuxeo.runtime.jtajca.NuxeoContainer$ConnectionManagerWrapper.allocateConnection(NuxeoContainer.java:837)
      	at org.nuxeo.ecm.core.storage.sql.ra.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:98)
      	at org.nuxeo.ecm.core.storage.sql.ra.ConnectionFactoryImpl.getSession(ConnectionFactoryImpl.java:161)
      	at org.nuxeo.ecm.core.repository.RepositoryService.getSession(RepositoryService.java:218)
      	at org.nuxeo.ecm.core.api.local.LocalSession.createSession(LocalSession.java:116)
      	at org.nuxeo.ecm.core.api.local.LocalSession.connect(LocalSession.java:82)
      	at org.nuxeo.ecm.core.api.CoreInstance.acquireCoreSession(CoreInstance.java:169)
      	at org.nuxeo.ecm.core.api.CoreInstance.openCoreSession(CoreInstance.java:164)
      	at org.nuxeo.ecm.core.api.CoreInstance.openCoreSession(CoreInstance.java:79)
      	at org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:126)
      	at org.nuxeo.ecm.core.repository.RepositoryService.openRepository(RepositoryService.java:137)
      	at org.nuxeo.ecm.core.repository.RepositoryService.applicationStarted(RepositoryService.java:92)
      	at org.nuxeo.runtime.model.impl.RegistrationInfoImpl.notifyApplicationStarted(RegistrationInfoImpl.java:325)
      	at org.nuxeo.runtime.osgi.OSGiRuntimeService.notifyComponentsOnStarted(OSGiRuntimeService.java:480)
      	at org.nuxeo.runtime.osgi.OSGiRuntimeService.fireApplicationStarted(OSGiRuntimeService.java:516)
      	at org.nuxeo.runtime.osgi.OSGiRuntimeService.frameworkEvent(OSGiRuntimeService.java:526)
      	at org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:232)
      	at org.nuxeo.runtime.test.NXRuntimeTestCase.fireFrameworkStarted(NXRuntimeTestCase.java:189)
      	at org.nuxeo.runtime.test.runner.RuntimeFeature.beforeRun(RuntimeFeature.java:153)
      	at org.nuxeo.runtime.test.runner.FeaturesRunner$2.call(FeaturesRunner.java:157)
      	at org.nuxeo.runtime.test.runner.FeaturesLoader.apply(FeaturesLoader.java:109)
      	at org.nuxeo.runtime.test.runner.FeaturesLoader.apply(FeaturesLoader.java:96)
      	at org.nuxeo.runtime.test.runner.FeaturesRunner.beforeRun(FeaturesRunner.java:153)
      	at org.nuxeo.runtime.test.runner.FeaturesRunner$BeforeClassStatement.evaluate(FeaturesRunner.java:265)
      	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
      	at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
      	at org.junit.runners.Suite.runChild(Suite.java:127)
      	at org.junit.runners.Suite.runChild(Suite.java:26)
      	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
      	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
      	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
      	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
      	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
      	at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
      	at org.junit.runner.JUnitCore.run(JUnitCore.java:160)
      	at org.junit.runner.JUnitCore.run(JUnitCore.java:138)
      	at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.createRequestAndRun(JUnitCoreWrapper.java:113)
      	at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.executeEager(JUnitCoreWrapper.java:85)
      	at org.apache.maven.surefire.junitcore.JUnitCoreWrapper.execute(JUnitCoreWrapper.java:54)
      	at org.apache.maven.surefire.junitcore.JUnitCoreProvider.invoke(JUnitCoreProvider.java:134)
      	at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
      	at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
      	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
      Caused by: java.sql.SQLException: Error post creating table: CALL NXFT_CREATE_INDEX('PUBLIC_FULLTEXT_default', 'PUBLIC', 'FULLTEXT', ('SIMPLETEXT', 'BINARYTEXT'), 'french') : Error creating or initializing trigger "NXFT_FULLTEXT" object, class "org.nuxeo.ecm.core.storage.sql.db.H2Fulltext$Trigger", cause: "java.sql.SQLException: java.lang.ClassNotFoundException: french"; see root cause for details; SQL statement:
      CREATE TRIGGER "PUBLIC"."NXFT_FULLTEXT" AFTER INSERT, UPDATE, DELETE ON "PUBLIC"."FULLTEXT" FOR EACH ROW CALL "org.nuxeo.ecm.core.storage.sql.db.H2Fulltext$Trigger" [90043-177]
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createTables(JDBCMapper.java:230)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createDatabase(JDBCMapper.java:144)
      	... 66 more
      Caused by: org.h2.jdbc.JdbcSQLException: Error creating or initializing trigger "NXFT_FULLTEXT" object, class "org.nuxeo.ecm.core.storage.sql.db.H2Fulltext$Trigger", cause: "java.sql.SQLException: java.lang.ClassNotFoundException: french"; see root cause for details; SQL statement:
      CREATE TRIGGER "PUBLIC"."NXFT_FULLTEXT" AFTER INSERT, UPDATE, DELETE ON "PUBLIC"."FULLTEXT" FOR EACH ROW CALL "org.nuxeo.ecm.core.storage.sql.db.H2Fulltext$Trigger" [90043-177]
      	at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
      	at org.h2.message.DbException.get(DbException.java:167)
      	at org.h2.schema.TriggerObject.load(TriggerObject.java:77)
      	at org.h2.schema.TriggerObject.setTriggerClassName(TriggerObject.java:92)
      	at org.h2.command.ddl.CreateTrigger.update(CreateTrigger.java:110)
      	at org.h2.command.CommandContainer.update(CommandContainer.java:79)
      	at org.h2.command.Command.executeUpdate(Command.java:254)
      	at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:186)
      	at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:160)
      	at org.nuxeo.ecm.core.storage.sql.db.H2Fulltext.createTrigger(H2Fulltext.java:243)
      	at org.nuxeo.ecm.core.storage.sql.db.H2Fulltext.createIndex(H2Fulltext.java:181)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at org.h2.engine.FunctionAlias$JavaMethod.getValue(FunctionAlias.java:481)
      	at org.h2.expression.JavaFunction.getValue(JavaFunction.java:39)
      	at org.h2.command.dml.Call.query(Call.java:66)
      	at org.h2.command.CommandContainer.query(CommandContainer.java:91)
      	at org.h2.command.Command.executeQuery(Command.java:197)
      	at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)
      	at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:160)
      	at org.tranql.connector.jdbc.StatementHandle.execute(StatementHandle.java:119)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createTables(JDBCMapper.java:227)
      	... 67 more
      Caused by: java.sql.SQLException: java.lang.ClassNotFoundException: french
      	at org.nuxeo.ecm.core.storage.sql.db.H2Fulltext.getAnalyzer(H2Fulltext.java:435)
      	at org.nuxeo.ecm.core.storage.sql.db.H2Fulltext.getIndexWriter(H2Fulltext.java:476)
      	at org.nuxeo.ecm.core.storage.sql.db.H2Fulltext.access$100(H2Fulltext.java:71)
      	at org.nuxeo.ecm.core.storage.sql.db.H2Fulltext$Trigger.init(H2Fulltext.java:684)
      	at org.h2.schema.TriggerObject.load(TriggerObject.java:72)
      	... 88 more
      

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: