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

Index creation error on Mysql

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 10.0
    • Fix Version/s: 10.0
    • Component/s: edu-services
    • Labels:
      None

      Description

      2012-06-27 10:37:46,653 INFO pool-2-thread-1 org.sakaiproject.conditions.impl.BaseConditionService - init()
      2012-06-27 10:37:46,657 INFO pool-2-thread-1 org.sakaiproject.tool.gradebook.facades.sakai2impl.GradebookConfigurationSakai - About to call sqlService.ddl with sakai_gradebook_post_schemaupdate
      2012-06-27 10:37:47,056 WARN pool-2-thread-1 org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): error code: 1061 sql: create index GB_GRADE_RECORD_STUDENT_ID_IDX on GB_GRADE_RECORD_T (STUDENT_ID) binds:
      com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate key name 'GB_GRADE_RECORD_STUDENT_ID_IDX'
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
      at com.mysql.jdbc.Util.getInstance(Util.java:382)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)

      at org.sakaiproject.tool.gradebook.facades.sakai2impl.GradebookConfigurationSakai.init(GradebookConfigurationSakai.java:48)

      Relates to mysql upgrade - hibernate is creating the index

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  dhorwitz David Horwitz
                  Reporter:
                  dhorwitz David Horwitz
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code