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

Fix functional tests on 6.0 on mssql

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 6.0-HF28
    • Fix Version/s: 6.0-HF32
    • Component/s: Core VCS
    • Tags:
    • Sprint:
      nxSL Sprint 8.4.2, nxSL Sprint 8.4.3
    • Story Points:
      5

      Description

      All functional tests running on 6.0 and mssql show the following error in logs:

      https://qa.nuxeo.org/jenkins/view/reports/job/6.0/job/FT-nuxeo-6.0-funkload-cap-tomcat-multidb/Slave=MULTIDB_LINUX,dbprofile=mssql,jdk=java-7-openjdk/30/

      Caused by: java.sql.SQLException: Error executing: CREATE FULLTEXT CATALOG [nuxeo]; : CREATE FULLTEXT CATALOG statement cannot be used inside a user transaction.
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createTables(JDBCMapper.java:374)
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createDatabase(JDBCMapper.java:159)
	... 59 more
Caused by: java.sql.SQLException: CREATE FULLTEXT CATALOG statement cannot be used inside a user transaction.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2893)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2335)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:638)
	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809)
	at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1282)
	at org.tranql.connector.jdbc.StatementHandle.execute(StatementHandle.java:119)
	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.createTables(JDBCMapper.java:372)
	... 60 more

      Visible on:

        Attachments

          Issue Links

          depends on

          Sub-task - The sub-task of the issue NXP-19049 work manager shutdown should not suspend works

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-19541 validationQuery is not taken in account by the connection pool

          • Major - Major loss of function.
          • Resolved
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. NXP-20306 Fix functional tests on 6.0 on postgresql

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: