[Building Sakai] Cannot startup cafe trunk: Hibernate issue on Snow Leopard Server

[Steve Swinsburg]

Hi Lovemore,

I've hit the same bug in MySQL on OS X with another table used in Sakai that
also defines a multi-column key. This is an issue in MySQL, but was meant to
be fixed in 5.0.19: (http://bugs.mysql.com/bug.php?id=13835), but its not:
http://bugs.mysql.com/bug.php?id=4541. The problem is UTF-8 uses 3 bytes per
character, so it's hitting the limit earlier. Apart from specifying a
shorter key, I'm not sure of another fix.

cheers,
Steve


On Wed, Feb 17, 2010 at 5:33 AM, Lovemore Nalube
<lovemore.nalube at uct.ac.za>wrote:

>  Hi
>
> I have been running an instance of cafe trunk with not startup issues.
> Today I was working on Course Evaluations and dropped that into my instance
> and now sakai won't start.
>
> There seems to be a hibernate related error in the logs:
>
> 2010-02-16 20:20:17,851  INFO main
> org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean -
> Updating database schema for Hibernate SessionFactory
> 2010-02-16 20:20:18,641  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.jdbc4.MySQLSyntaxErrorException: Specified key
> was too long; max key length is 1000 bytes
>  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>  at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>  at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>  at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>
> I am running MySql Server version: 5.1.43 on a MAC OSX Snow Leopard Server.
> Can someone help me with this?
>
>
> --
> Lovemore Nalube
> Online Learning Environments Developer (Vula)
> PASS Transformation Committee REP
> Centre for Educational Technology
> CHED
> University of Cape Town
> www.cet.uct.ac.za
>
> /* Work Email: lovemore.nalube at uct.ac.za
> /* Cell: 076 186 1244
> /* GTalk: lovenalube at gmail.com
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100217/471f3a8c/attachment.html