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

[Matthew Jones]

You might also want to see if you're using the latest version of the mysql
connector. I think I'm looking at the same thing, but it seems like I am
able to run this query successfully outside the app on a utf8 table. I've
also not seen any problems with running auto.ddl=true with the latest trunk
of eval on the same mysql server on qa6-us. (Table name changed to
EVAL_ASSIGN_USER_TMP in this sample). It might also be an issue with certain
storage engines InnoDB verses mysiam as well.

Server version: 5.1.31-community-log MySQL Community Server (GPL)

mysql> create table EVAL_ASSIGN_USER_TMP (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));
Query OK, 0 rows affected (0.01 sec)

mysql> show table status where name='EVAL_ASSIGN_USER_TMP';
+----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| Name                 | Engine | Version | Row_format | Rows |
Avg_row_length | Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_time         | Update_time | Check_time | Collation
      | Checksum | Create_options | Comment |
+----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| eval_assign_user_tmp | InnoDB |      10 | Compact    |    0 |
 0 |       16384 |               0 |        16384 |   7340032 |
 1 | 2010-02-16 16:27:44 | NULL        | NULL       | utf8_general_ci |
NULL |                |         |
+----------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+

On Tue, Feb 16, 2010 at 4:23 PM, Steve Swinsburg
<steve.swinsburg at gmail.com>wrote:

> 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"
>>
>
>
> _______________________________________________
> 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/20100216/b688e873/attachment.html