[Building Sakai] sakai 2.9.3 loading issue

[Sanghyun Jeon]

Thank you for your reply.

I resolved this issue via JAVA_OPTS modification.

S


On Tue, Mar 11, 2014 at 7:39 AM, Earle Nietzel <enietzel at anisakai.com>wrote:

> Hi Sanghyun,
>
> In your message I don't think you provided enough information regarding
> your issue.
>
> You mentioned an upgrade:
> 1) Did you use a fresh tomcat, i.e. you didn't reuse the previous tomcat
> installation?
> 2) what version your upgrading from
> 3) Did you run ALL the DB the upgrade scripts
> 4) It looks as though you have auto.ddl set to true, if you ran the
> upgrade scripts this generally is not needed.
>
> Given the information you provided above, SQL exceptions about tables that
> already exists are generally ok. The problem with sakai not starting is
> probably not due to the errors above.
>
> Earle
>
>
>
> On Thu, Mar 6, 2014 at 1:58 PM, Sanghyun Jeon <euksa99 at gmail.com> wrote:
>
>> Hello
>>
>> We upgrade sakai 2.9.3 with Tomcat7.0.42, Jdk1.7.0_40, and Maven 3.1.0
>> and notice the weird tomcat loading issue  as follows:
>>
>> We have two app servers and each server has two tomcats with different
>> port number.
>> We also have one apache (ajp) proxy server (load balancer) in front of
>> these two app servers.
>>
>> When we deploy both tomcats at the same time, loading the second tomcat
>> (either TomcatA or Tomcat B) takes more than 30 minutes and we also notice
>> that it got delayed at the same place:
>>
>> 2014-03-05 14:04:19.034 [INFO]
>> org.sakaiproject.email.impl.BasicEmailService:397 - init(): smtp:
>> sakaitest.aiso.claremont.edu bounces to:
>> postmaster at Sakaitest.AISO.Claremont.Edu maxRecipients: 100 testMode:
>> false
>>
>> INFO: [GenericDao] Could not execute first DDL line, skipping the rest:
>> StatementCallback; bad SQL grammar [CREATE TABLE ENTITY_PROPERTIES (
>> id            bigint(20) AUTO_INCREMENT NOT NULL PRIMARY KEY,
>> entityRef       varchar(255) NOT NULL, entityPrefix    varchar(255) NOT
>> NULL, propertyName    varchar(255) NOT NULL, propertyValue   text NOT NULL,
>> INDEX (entityRef, entityPrefix, propertyName) )]; nested exception is
>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>> 'ENTITY_PROPERTIES' already
>> exists:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>> 'ENTITY_PROPERTIES' already exists
>>
>> INFO: [GenericDao] Could not execute first DDL line, skipping the rest:
>> StatementCallback; bad SQL grammar [CREATE TABLE ENTITY_TAG_APPLICATIONS (
>> id            bigint(20) AUTO_INCREMENT NOT NULL PRIMARY KEY,
>> entityRef       varchar(255) NOT NULL, entityPrefix    varchar(255) NOT
>> NULL, tag             varchar(255) NOT NULL, INDEX (entityRef,
>> entityPrefix, tag) )]; nested exception is
>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>> 'ENTITY_TAG_APPLICATIONS' already
>> exists:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>> 'ENTITY_TAG_APPLICATIONS' already exists
>>
>> 2014-03-05 14:48:32.713 [INFO]
>> org.sakaiproject.memory.impl.BasicMemoryService:167 - Added Cache name
>> [org.sakaiproject.user.api.UserDirectoryService.callCache] as Cache
>> [org.sakaiproject.user.api.UserDirectoryService.callCache]
>>
>> 2014-03-05 14:48:32.762 [INFO]
>> org.sakaiproject.user.impl.BaseUserDirectoryService:577 - init(): provider:
>> edu.amc.sakai.user.HMCJLDAPDirectoryProvider separateIdEid: true
>>
>> after about 30 minutes later and it starts to deploy again. Looks like
>> the second one is waiting for free cache (INFO]
>> org.sakaiproject.memory.impl.BasicMemoryService:167 - Added Cache name
>> [org.sakaiproject.user.api.UserDirectoryService.callCache] ) so that we
>> tweak the JVM setting and the current JVM setting is as follows (each
>> server has 8 G):
>>
>>
>> export JAVA_OPTS="-server -Xms768m -Xmx2048m -XX:PermSize=256m
>> -XX:MaxPermSize=512m -XX:NewSize=256m -XX:MaxNewSize=512m
>> -Djava.awt.headless=true -Dcom.sun.management.jmxremote -Dhttp.agent=Sakai
>> -Dorg.apache.jasper.compiler.Parser.STRICT_QUOTE_ESCAPING=false
>> -Dorg.apache.jasper.compiler.Parser.STRICT_WHITESPACE=false
>> -Djava.util.Arrays.useLegacyMergeSort=true
>> -Dsun.lang.ClassLoader.allowArraySyntax=true
>>  -Dsakai.security=/opt/sakai-cfg -Dsakai.home=/opt/sakai-cfg/tc2A"
>>
>>
>>
>> However, we cannot resolve the issue and we don't have a chance to have a
>> load testing but we notice that the system is very slow.
>>  Can anybody have the same loading issue on Sakai 2.9.3? Please shed some
>> light on this issue and thank you.
>>
>>
>> _______________________________________________
>> 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/20140311/0b0560c1/attachment.html