Duplicate key name 'SAM_PUBLISHEDASSESSMENT2_I' on startup
Description
Activity
Earle Nietzel July 15, 2023 at 3:50 PM
ALTER TABLE SAM_ASSESSMENTGRADING_T MODIFY AGENTID VARCHAR(99);
ALTER TABLE SAM_GRADINGSUMMARY_T MODIFY AGENTID VARCHAR(99);
ALTER TABLE SAM_ITEMGRADING_T MODIFY AGENTID VARCHAR(99);
ALTER TABLE SAM_STUDENTGRADINGSUMMARY_T MODIFY AGENTID VARCHAR(99);
ALTER TABLE SAM_ASSESSMENTGRADING_T MODIFY GRADEDBY VARCHAR(99);
ALTER TABLE SAM_ITEMGRADING_T MODIFY GRADEDBY VARCHAR(99);
CREATE INDEX SAM_AG_AGENTID_I ON SAM_GRADINGSUMMARY_T(AGENTID);
CREATE INDEX SAM_ASSGRAD_AID_PUBASSEID_T ON SAM_ASSESSMENTGRADING_T(AGENTID, PUBLISHEDASSESSMENTID);Austin June 30, 2022 at 7:01 PMEdited
I’m still seeing errors on startup with these lines in sakai_samigo_post_schema_update.sql with the latest 23.x
create index SAM_ITEMGRADING_ITEM_I on SAM_ITEMGRADING_T (PUBLISHEDITEMID);
create index SAM_ITEMGRADING_ITEMTEXT_I on SAM_ITEMGRADING_T (PUBLISHEDITEMTEXTID);
create index SAM_ITEMGRADING_PUBANS_I on SAM_ITEMGRADING_T (PUBLISHEDANSWERID);If I comment out those lines, there is no error and the indexes are still created (I’m guessing through the hibernate config?
does it matter what sakai.properties configs are? I currently have them as their defaults (both are commented out)
# auto.ddl=true
# hibernate.hbm2ddl.auto=update
also, the
create index SAM_ASSGRAD_AID_PUBASSEID_T on SAM_ASSESSMENTGRADING_T (AGENTID,PUBLISHEDASSESSMENTID);index MUST remain in that .sql file or else it won’t be created. or should it be moved to the hibernate config and removed from that .sql file?
Automation for Jira May 5, 2022 at 2:33 AM
A pull request has been created, "SAK-12148 fix first-time startup errors around SakaiBootstrap", you can see it at https://github.com/sakaiproject/sakai/pull/10513
Megan May February 12, 2008 at 3:13 PM
Closing based on the previously made comments. Your work together to investigate this problem is greatly appreciated!
Hui Tsao February 12, 2008 at 9:36 AM
Yes. I agree that it's ok to close this bug. Thanks.
Details
Details
Priority
Blocker
INFO: SakaiBootStrap.init(): autoDdl enabled; running DDL... (2007-11-08 16:45:57,672 main_org.sakaiproject.tool.assessment.shared.SakaiBootStrap)
WARN: Sql.dbWrite(): error code: 1061 sql: create index SAM_PUBLISHEDASSESSMENT2_I on SAM_STUDENTGRADINGSUMMARY_T (PUBLISHEDASSESSMENTID) binds: (2007-11-08 16:45:57,732 main_org.s
akaiproject.db.impl.BasicSqlService)
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Duplicate key name 'SAM_PUBLISHEDASSESSMENT2_I'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1202)
at org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1057)
at org.sakaiproject.db.impl.BasicSqlService.ddl(BasicSqlService.java:1969)
at org.sakaiproject.tool.assessment.shared.SakaiBootStrap.init(SakaiBootStrap.java:76)
Startup dies a little while after this...