Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-27976

Auto ddl failing with Oracle

    XMLWordPrintable

    Details

      Description

      http://nightly2.sakaiproject.org/logs/tomcat-nightly-oracle/catalina.out contains SQLExceptions:

      2014-10-10 04:11:02,461  WARN localhost-startStop-1 org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: create index irwikiobject_name on rwikiobject (name)
      java.sql.SQLException: ORA-01408: such column list already indexed
      
      	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
      	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
      	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
      	at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1623)
      	at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1588)
      	at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
      ...
      
      2014-10-10 04:11:02,845  WARN localhost-startStop-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): recordAlreadyExists: false, failQuiet: true, : error code: 955, sql:  CREATE TABLE SAKAI_CONFIG_ITEM ( ID				NUMBER(20) NOT NULL, NODE			VARCHAR2(255), NAME			VARCHAR2(255) NOT NULL, VALUE			CLOB, RAW_VALUE		CLOB, TYPE			VARCHAR2(255) NOT NULL, DEFAULT_VALUE	CLOB, DESCRIPTION		CLOB, SOURCE			VARCHAR2(255) DEFAULT NULL, DEFAULTED		CHAR(1) NOT NULL, REGISTERED		CHAR(1) NOT NULL, SECURED			CHAR(1) NOT NULL, DYNAMIC			CHAR(1) NOT NULL, CREATED			TIMESTAMP NOT NULL, MODIFIED		TIMESTAMP NOT NULL, POLL_ON			TIMESTAMP DEFAULT NULL ), binds: , error: java.sql.SQLException: ORA-00955: name is already used by an existing object
      
      2014-10-10 04:11:03,201  WARN localhost-startStop-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): recordAlreadyExists: false, failQuiet: true, : error code: 955, sql:  CREATE TABLE SAKAI_USER_ID_MAP ( USER_ID             VARCHAR2(99) NOT NULL, EID                 VARCHAR2(99) NOT NULL ), binds: , error: java.sql.SQLException: ORA-00955: name is already used by an existing object
      
      2014-10-10 04:11:04,210  WARN localhost-startStop-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): recordAlreadyExists: false, failQuiet: true, : error code: 1430, sql:  ALTER TABLE SAKAI_SITE_PAGE ADD (POPUP CHAR(1) DEFAULT '0' CHECK (POPUP IN (1, 0))), binds: , error: java.sql.SQLException: ORA-01430: column being added already exists in table
      
      2014-10-10 04:11:04,212  WARN localhost-startStop-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): recordAlreadyExists: false, failQuiet: true, : error code: 1430, sql:  ALTER TABLE SAKAI_SITE ADD (CUSTOM_PAGE_ORDERED CHAR(1) DEFAULT '0' CHECK (CUSTOM_PAGE_ORDERED IN (1, 0))), binds: , error: java.sql.SQLException: ORA-01430: column being added already exists in table
      
      2014-10-10 04:11:04,838  WARN localhost-startStop-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): recordAlreadyExists: true, failQuiet: false, : error code: 1, sql:  INSERT INTO SAKAI_REALM_FUNCTION VALUES (SAKAI_REALM_FUNCTION_SEQ.NEXTVAL, 'site.viewRoster'), binds: , error: java.sql.SQLException: ORA-00001: unique constraint (SAK.IE_SAKAI_REALM_FUNCTION_NAME) violated
      
      2014-10-10 04:11:11,505  WARN localhost-startStop-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): recordAlreadyExists: false, failQuiet: true, : error code: 1430, sql:  ALTER TABLE SAKAI_REALM_ROLE_DESC ADD (PROVIDER_ONLY CHAR(1) NULL), binds: , error: java.sql.SQLException: ORA-01430: column being added already exists in table
      
      2014-10-10 04:11:12,996  WARN localhost-startStop-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): recordAlreadyExists: false, failQuiet: true, : error code: 1430, sql:  ALTER TABLE CONTENT_RESOURCE ADD (RESOURCE_UUID VARCHAR2 (36)), binds: , error: java.sql.SQLException: ORA-01430: column being added already exists in table
      
      2014-10-10 04:11:13,774  WARN localhost-startStop-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): recordAlreadyExists: false, failQuiet: true, : error code: 955, sql:  CREATE INDEX schdulr_trggr_vnts_eventTime ON scheduler_trigger_events(eventTime), binds: , error: java.sql.SQLException: ORA-00955: name is already used by an existing object
      
      2014-10-10 04:11:13,868  WARN localhost-startStop-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): recordAlreadyExists: false, failQuiet: true, : error code: 1408, sql:  create index CM_ENR_SET_INSTR_IDX on cm_official_instructors_t (INSTRUCTOR_ID), binds: , error: java.sql.SQLException: ORA-01408: such column list already indexed
      
      2014-10-10 04:13:24,808  WARN localhost-startStop-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): error code: 1408 sql:  create index lb_prop_idx on lesson_builder_properties(attribute) binds:  
      java.sql.SQLException: ORA-01408: such column list already indexed
      
      	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
      	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
      ...
      
      2014-10-10 04:13:33,606  WARN localhost-startStop-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): recordAlreadyExists: false, failQuiet: true, : error code: 955, sql:  create index irwikicurrentcontent_rwi on  rwikicurrentcontent (rwikiid), binds: , error: java.sql.SQLException: ORA-00955: name is already used by an existing object
      
      2014-10-10 04:13:34,249  WARN localhost-startStop-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): error code: 955 sql:  create index SAM_ITEM_SECTIONID_I on SAM_ITEM_T (SECTIONID) binds:  
      java.sql.SQLException: ORA-00955: name is already used by an existing object
      
      	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
      	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
      ...
      
      2014-10-10 04:13:34,733  WARN localhost-startStop-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): recordAlreadyExists: true, failQuiet: false, : error code: 1, sql:  INSERT INTO SAM_TYPE_T ("TYPEID" ,"AUTHORITY", "DOMAIN", "KEYWORD", "DESCRIPTION", "STATUS", "CREATEDBY", "CREATEDDATE", "LASTMODIFIEDBY", "LASTMODIFIEDDATE") VALUES (12 , 'stanford.edu', 'assessment.item', 'Multiple Correct Single Selection', NULL, 1, 1, SYSDATE, 1, SYSDATE), binds: , error: java.sql.SQLException: ORA-00001: unique constraint (SAK.SYS_C009651299) violated
      

      I may have missed a few others while copying and pasting.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  jean-francois.leveque@upmc.fr Jean-François Lévêque
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code