[Building Sakai] SiteCache is not alive

Thu Sep 18 11:17:35 PDT 2014

Must be bad luck. I had everything working with mysql, compiled source, etc and have been using it for days with no issues. Only now did I shutdown and startup Tomcat again did I start getting these cacheNotAlive errors once more. As I have not touched any of the code or manually touched any data in the database I can only assume there is a problem with one of the core tools in Sakai 10.1 which is corrupting data somehow. I was able to fix the problem only through dropping the MySQL 'sakai' database schema and creating a new one from scratch. The log snippet at the end of this email shows the first instance in the tomcat log of a warning occurring (skipping past the few "table already exists" warnings) and its database related. Several more occur after this. Is this hibernate.id.Generator producing keys too large to be stored? This was all I could find online:

https://jira.sakaiproject.org/browse/SAK-26580?jql=labels%20%3D%20%22memory.use.legacy%22
- Triggered for me without a page being opened and was not intermittent but continually repeated, even after reboot.
http://forums.terracotta.org/forums/posts/list/7186.page

Its mentioned as the problem being "mostly harmless" but unless there is a fix aside from dropping an entire database I would disagree.

- Ryan

2014-09-18 13:38:14,751  INFO localhost-startStop-1 org.sakaiproject.springframework.orm.hibernate.SakaiCacheProvider - Starting Hibernate Cache org.sakaiproject.springframework.orm.hibernate.L2Cache ++++++++++++++++++++++++++++++++ 
2014-09-18 13:38:14,751  WARN localhost-startStop-1 org.hibernate.id.UUIDHexGenerator - Using org.hibernate.id.UUIDHexGenerator which does not generate IETF RFC 4122 compliant UUID values; consider using org.hibernate.id.UUIDGenerator instead
2014-09-18 13:38:17,964  INFO localhost-startStop-1 org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Updating database schema for Hibernate SessionFactory
2014-09-18 13:38:19,930  WARN localhost-startStop-1 org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Unsuccessful schema statement: create index URL_INDEX on URL_RANDOMISED_MAPPINGS_T (URL)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
	at com.mysql.jdbc.Util.getInstance(Util.java:383)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4208)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597)

- Ryan

From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Ryan VanDyke
Sent: Thursday, September 18, 2014 12:44 PM
To: Sam Ottenhoff; ahmed adel
Cc: Developers Sakai-Dev; eevenson at kratosdefense.com
Subject: Re: [Building Sakai] SiteCache is not alive

I’ve had this same exact problem Ahmed on some of the machines I’ve tried to deploy on but have yet to isolate what causes it or why. Let me know if you find anything out.

From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Sam Ottenhoff
Sent: Thursday, September 18, 2014 11:10 AM
To: ahmed adel
Cc: Developers Sakai-Dev
Subject: Re: [Building Sakai] SiteCache is not alive

You should provide your entire catalina.out logs instead of the small snippet. I would post it to a third-party site like https://gist.github.com/

On Thu, Sep 18, 2014 at 3:37 AM, ahmed adel <abou.alseoud at gmail.com> wrote:
Dears,

I'm new to Sakai and trying to deploy version 10.1 using java 7 and tomcat 7.0.55 and MySql  Ver. 14.14 Distrib. 5.6.20. After successful build and deploy for Sakai project using maven, when i try to start tomcat server, the catalina log displays many exceptions thrown while server first run. Visiting the portal, throws the following exception

WARN http-bio-8080-exec-2 org.sakaiproject.component.impl.SpringCompMgr - get(org.sakaiproject.citation.api.ConfigurationService): 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.sakaiproject.citation.api.ConfigurationService' defined in class path resource [org/sakaiproject/citation/impl/citations.xml]: Invocation of init method failed; nested exception is java.lang.IllegalStateException: The org.sakaiproject.site.impl.SiteCacheImpl.cache Cache is not alive (STATUS_SHUTDOWN)

and the application don't run in full features and throws the same exception in some links. I tried to use HSQLDB and for the first server run every things was OK but after restarting the server, the same exception was thrown and the site functionality goes wrong.

Any idea how to fix this problem? or the cause?

_______________________________________________
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"

--------------------------------------------------------------------------------------------------------------------

***NOTICE*** This e-mail and/or the attached documents may contain technical data within the definition of the International Traffic in Arms Regulations and/or Export Administration Regulations, and are subject to the export control laws of the U.S. Government. Transfer of this data by any means to a foreign person, whether in the United States or abroad, without an export license or other approval from the U.S. Department of State or Commerce, as applicable, is prohibited. No portion of this e-mail or its attachment(s) may be reproduced without written consent of Kratos Defense & Security Solutions, Inc. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient or believe that you may have received this document in error, please notify the sender and delete this e-mail and any attachments immediately.

 --------------------------------------------------------------------------------------------------------------------

***NOTICE*** This e-mail and/or the attached documents may contain technical data within the definition of the International Traffic in Arms Regulations and/or Export Administration Regulations, and are subject to the export control laws of the U.S. Government. Transfer of this data by any means to a foreign person, whether in the United States or abroad, without an export license or other approval from the U.S. Department of State or Commerce, as applicable, is prohibited. No portion of this e-mail or its attachment(s) may be reproduced without written consent of Kratos Defense & Security Solutions, Inc. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient or believe that you may have received this document in error, please notify the sender and delete this e-mail and any attachments immediately.