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

Oracle tests may fail due to previous ACLR_MODIFIED with int sequences

    XMLWordPrintable

    Details

      Description

      On Oracle if TestSQLBackendSequenceId is run it creates a global temporary table ACLR_MODIFIED with an INT column for HIERARCHY_ID. However the test scripts fail to properly delete it when starting. Then later TestSQLBackend is run with this existing table and insertion of STRING-based ids fails.

      org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "MIXINTYPES", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION", "ISVERSION") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
              at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:580)
              at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:481)
              at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:451)
              at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:356)
              at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:373)
              at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:346)
              at org.nuxeo.ecm.core.storage.sql.SessionImpl.save(SessionImpl.java:325)
              at org.nuxeo.ecm.core.storage.sql.SessionImpl.computeRootNode(SessionImpl.java:1274)
              at org.nuxeo.ecm.core.storage.sql.SessionImpl.<init>(SessionImpl.java:150)
              at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.newSession(RepositoryImpl.java:324)
              at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.getConnection(RepositoryImpl.java:278)
              at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.getConnection(RepositoryImpl.java:56)
              at org.nuxeo.ecm.core.storage.sql.TestSQLBackend.testRootNode(TestSQLBackend.java:109)
              ...
      Caused by: java.sql.BatchUpdateException: ORA-01722: invalid number
      ORA-06512: at "MGTEST.NX_TRIG_HIERARCHY_INSERT", line 2
      ORA-04088: error during execution of trigger 'MGTEST.NX_TRIG_HIERARCHY_INSERT'
              at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296)
              at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216)
              at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:564)
              ... 59 more
      Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
      ORA-06512: at "MGTEST.NX_TRIG_HIERARCHY_INSERT", line 2
      ORA-04088: error during execution of trigger 'MGTEST.NX_TRIG_HIERARCHY_INSERT'
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
              at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
              at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:10096)
              at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10200)
              ... 61 more
      

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                PagerDuty

                Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.