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

[Jim Eng]

I wasn't asking the right question. We had the same problem in another project within Sakai a year or two ago.  As I recall, everything worked fine in Oracle and other databases, but MySQL choked. I read some of the thread Dick referred to at that time, and if I remember correctly, we made a code change to deal with the problem.  But it sounds like that has not been necessary in evaluation if UCT has not had to do anything special. 

Here's the SQL for creating the database:

create database trunk default character set utf8;

Would another character set solve the problem?

Thanks.

Jim  

 
On Jun 16, 2010, at 11:07 AM, Jim Eng wrote:

>> A better solution would be to build an index using a hash of the strings rather than the strings themselves. 
> 
> 
> Would that be done with a code change in evaluation? 
> 
> I am using version 5.1.47 of MySQL, along with version 5.0.5 of the JDBC connector.
> 
> 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"
>> 
> 
> _______________________________________________
> 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/ae81b467/attachment.html