[Building Sakai] Datapoint startup issue

[Stephen Marquard]

Googling suggests you have some sort of mysql db/schema issue related to foreign keys. 

Try bringing up your build pointing to a completely empty database and see what gets created, then replicate that table/key structure in your production db.

Cheers
Stephen
 
>>> "Robert E. Long" <relong at vmail.svsu.edu> 8/12/2009 4:23 PM >>> 
All, 

Sorry to bug the masses once again, but this is the last issue I have to fix before we put 2.6.0 into production here. Anything further to help me out? 

Thank you, 
Bob 


--- 
Robert E. Long, MA 
Saginaw Valley State University 
Open Source Programmer / Analyst 
Math / Education Instructor 
M.A. Instructional Technology 
O: 989.964.2245 
E: relong at svsu.edu 

----- Original Message ----- 
From: "Robert E. Long" <relong at svsu.edu> 
To: "Christopher Wayne Maurer" <chmaurer at iupui.edu> 
Cc: "Robert E. Long" <relong at svsu.edu>, "sakai-dev Dev" <sakai-dev at collab.sakaiproject.org> 
Sent: Monday, August 10, 2009 1:54:59 PM GMT -05:00 US/Canada Eastern 
Subject: Re: [Building Sakai] Datapoint startup issue 


Oh yes, I guess I did leave out that tiny detail... 

Yes, I am starting with the trunk build (revision 56342, the latest one). Unless there is one for 2.6.x that I am missing, I thought it would be a better place to start from that code base. 

--Bob 

From: "Christopher Wayne Maurer" <chmaurer at iupui.edu> 
To: "Robert E. Long" <relong at svsu.edu>, "Robert E. Long" <relong at vmail.svsu.edu>, "sakai-dev Dev" <sakai-dev at collab.sakaiproject.org> 
Sent: Monday, August 10, 2009 1:51:28 PM GMT -05:00 US/Canada Eastern 
Subject: Re: [Building Sakai] Datapoint startup issue 

Re: [Building Sakai] Datapoint startup issue Robert, what code base did you start with? Trunk? 

Chris 


On 8/10/09 10:48 AM, "Robert E. Long" < relong at vmail.svsu.edu > wrote: 



All, 

I am working with Datapoint, trying to get it ready for 2.6.0 and upon Tomcat startup I receive the error listed below concerning an unsuccessful schema statement. I have tried manually performing the statement in MySQL, but with no success. 

Any pointers? 

---------error--------- 
2009-08-10 10:28:52,966 INFO main org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Updating database schema for Hibernate SessionFactory 
2009-08-10 10:28:55,999 WARN main org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: alter table GMT_GOAL add index FK4D668884E4FA6CF8 (RUBRIC_ID), add constraint FK4D668884E4FA6CF8 foreign key (RUBRIC_ID) references GMT_RUBRIC (RUBRIC_ID) 
java.sql.SQLException: Can't create table './vspacetest/#sql-1b1e_9d.frm' (errno: 150) 
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056) 
.. 
.. 
.. 
2009-08-10 10:28:56,059 WARN main org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: alter table GMT_LINK add index FK4D68B96B379076EB (GOAL_DEV_LEVEL_DETAIL_ID), add constraint FK4D68B96B379076EB foreign key (GOAL_DEV_LEVEL_DETAIL_ID) references GMT_GOALDEVELOPMENTAL_LEVEL_DETAILS (GOALDEVELOPMENTAL_LEVEL_ID) 
java.sql.SQLException: Can't create table './vspacetest/#sql-1b1e_9d.frm' (errno: 150) 
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056) 
------------ 

Thank you, 
Bob 


--- 
Robert E. Long, MA 
Saginaw Valley State University 
Open Source Programmer / Analyst 
Math / Education Instructor 
M.A. Instructional Technology 
O: 989.964.2245 
E: relong at svsu.edu