[Contrib: Evaluation System] EVALSYS broken for MySQL???

Ellis, Richard rwellis at umich.edu
Wed Jun 16 08:04:26 PDT 2010


There's a long thread on this topic (years worth) in the MySQL lit. Gonzalo got around it by changing the character set so fewer bytes were stored in the strings. A better solution would be to build an index using a hash of the strings rather than the strings themselves.  That should be faster, too.

Dick
________________________________
From: Jim Eng <jimeng at umich.edu>
Date: Wed, 16 Jun 2010 10:58:55 -0400
To: evaluation <evaluation at collab.sakaiproject.org>
Subject: [Contrib: Evaluation System] EVALSYS broken for MySQL???

I think we've discussed this before, but I am not finding a record of it.

I am attempting to build trunk of evaluation along with the 1.2.5 tag of hierarchy in sakai trunk.  It builds and deploys just fine but fails to start up due to SQL errors.  In particular, there are a number of errors relating to primary keys that exceed MySQL's 1000-byte maximum key length.  Here's an example:

WARN main org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: create table EVAL_ASSIGN_USER (ID bigint not null auto_increment, EID varchar(255), LAST_MODIFIED datetime not null, OWNER varchar(255) not null, USER_ID varchar(255) not null, GROUP_ID varchar(255) not null, ASSIGN_TYPE varchar(255) not null, ASSIGN_STATUS varchar(255) not null, LIST_ORDER integer not null, ASSIGN_GROUP_ID bigint, EVALUATION_FK bigint not null, primary key (ID), unique (USER_ID, GROUP_ID, ASSIGN_TYPE, EVALUATION_FK))
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes

Have other people seen this with MySQL?  Is there an existing fix or workaround?

Thanks.

Jim
_______________________________________________
evaluation mailing list
evaluation at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/evaluation

TO UNSUBSCRIBE: send email to evaluation-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/evaluation/attachments/20100616/1f634864/attachment.html 


More information about the evaluation mailing list