[Building Sakai] Datapoint startup issue

[Robert E. Long]

As a follow up, I got it to work. For those interested, this is what I had to do:

1. Run a mysqldump on the GMT tables (with the --no-create-info switch)
2. Remove the foreign key constraints from the GMT tables
3. Drop the GMT tables
4. Reboot Tomcat and have the tables recreated automagically with the proper schema, etc.
5. Import the mysqldump files from #1

All is well now.

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: "Stephen Marquard" <stephen.marquard at uct.ac.za>
To: "Robert E. Long" <relong at svsu.edu>
Cc: "sakai-dev Dev" <sakai-dev at collab.sakaiproject.org>
Sent: Wednesday, August 12, 2009 10:29:35 AM GMT -05:00 US/Canada Eastern
Subject: Re: [Building Sakai] Datapoint startup issue

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