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

Oracle migration script and auto.ddl startup on trunk/10 errors

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.0
    • Fix Version/s: 10.0, 11.0
    • Component/s: Forums Tool, Rwiki, Search
    • Labels:
      None
    • 10 status:
      Resolved

      Description

      This error is showing up on the nightly oracle logs and effects (currently) 5 different places. We believe it's related to hibernate upgrade and the hbm.xml files having unique-key and index in as attributes. They should only have unique-key. (Index removed)

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

      java.sql.SQLException: ORA-01408: such column list already indexed

      2014-04-17 12:13:01,890 WARN localhost-startStop-1 org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: create index MFR_SYN_STU_I on MFR_SYNOPTIC_ITEM (USER_ID, SITE_ID)

      2014-04-17 12:13:03,016 WARN localhost-startStop-1 org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: create index irwikiobject_name on rwikiobject (name)

      2014-04-17 12:13:03,079 WARN localhost-startStop-1 org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: create index irwikiproperties_name on rwikiproperties (name)

      2014-04-17 12:13:03,090 WARN localhost-startStop-1 org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: create index isearchbuilderitem_name on searchbuilderitem (name)

      2014-04-17 12:13:03,121 WARN localhost-startStop-1 org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: create index isearchwriterlock_lk on searchwriterlock (lockkey)

      Additionally there are these 2 which appear to be slightly different
      2014-04-17 12:17:19,010 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-00955: name is already used by an existing object

      2014-04-17 12:17:32,872 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

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  aaronz Aaron Zeckoski (Inactive)
                  Reporter:
                  jonespm Matthew Jones
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  7 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code