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

[Matthew Jones]

This thread came up a few months [1] ago, I responded to check to make sure
the database type was innodb as 'strongly recommended' [2] in the install
guide, but a step that almost everyone seems to skip, especially since it's
not very obvious how to do it in osx. I don't completely know if this fixed
it or not as nobody responded. I didn't see this issue on the mysql server
that I setup for eval trunk a few months ago and its utf8/innodb.

[1]
http://collab.sakaiproject.org/pipermail/sakai-dev/2010-February/005935.html
[2] http://confluence.sakaiproject.org/display/DOC/MySQL+my.cnf+(2.x)

On Wed, Jun 16, 2010 at 9:35 AM, Silverio, Gonzalo <gsilver at umich.edu>wrote:

> latin1 - but this was just to get running do that I could do the work I
> needed to do.
>
>        - Gonzalo
>
> ------------------------------
>
> On Jun 16, 2010, at 9:18 AM, "Jim Eng" <jimeng at umich.edu> wrote:
>
> 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>
> 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>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"
>
>
> <ATT00001..txt>
>
>
> _______________________________________________
> 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/e168ed18/attachment.html