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

[Jim Eng]

This was a recurring problem for several days. Eventually, I deleted the ibdata files in /usr/local/mysql/data/ (the mysql data directory on my machine), and that solve the problem.  Not a good solution if this occurs on a production instance, but it worked fine for my dev box.

Jim

  
On Jun 16, 2010, at 11:04 AM, Ellis, Richard wrote:

> 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/20100623/a562a620/attachment.html