topic Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive. in Alfresco Archive

Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

albertdbwong — Mon, 20 Oct 2008 02:08:11 GMT

Dear allWould someone have any idea on why this error will be logged when the Lab3 server shuts down? Everything else seems to be working fine. Is this an installation or configuration issue?ERROR [context.support.XmlWebApplicationContext] Exception thrown from ApplicationListener handling ContextCl

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

dna — Mon, 20 Oct 2008 14:53:52 GMT

Hi,

I have the same problem. What platform and what db are you using ?

Danielle

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

raghukumar_c — Tue, 21 Oct 2008 13:35:14 GMT

I too have the same problem. I have installed it on RHEL/Tomcat and use MySQL as the DB. However I read from a thread on log4j bug tracker that it has something to do with Tomcat/Struts. I am not sure about this though.

The horrible thing about this is that the Tomcat server doesnt stop, I need to manually kill it by finding its PID.

Has someone found a way around this. I even tried using the earlier version of Log4j - 1.2.14. But that doesnt make any difference.

-raghu

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

raghukumar_c — Wed, 22 Oct 2008 10:38:14 GMT

Is anyone else facing the same issue?

-raghu

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

albertdbwong — Wed, 22 Oct 2008 11:40:07 GMT

My setup environment is
Linux: SuSE SLES 10 sp2
Java: 1.5.0_14
Tomcat: 5.5.27
Database: MySQL 5.0.x
Alfresco deployed from the war

We are in testing phrase to upgrade our current v.2.0.0, because usage of the system as our DMS has increased sufficiently. it really seems it is not always the best idea to upgrade to the latest version… There are on and off a lot more log errors coming up for each restart.. sometimes the error will appear but sometimes not, even without any changes. Really strange.

Alfresco is really a good software but as with most cases, the documentation is slowing down the adoption speed.

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

mrogers — Wed, 22 Oct 2008 14:12:25 GMT

I'm trying to nail this problem down.

Could people please state whether they are seeing this problem on 3A, 3B or HEAD.    And whether this happens every time or just occasionally.

And also check to see whether the link validation service definition in public-services-context.xml looks like this; in particular the definition of "onShutdown".

    <bean id="linkValidationServiceWriteTxnAdvisor"
          class="org.springframework.aop.support.NameMatchMethodPointcutAdvisor">
        <property name="advice">
            <ref bean="retryingWriteTxnAdvice"/>
        </property>
        <property name="mappedNames">
            <list>
                    <value>onBootstrap</value>
                    <value>onShutdown</value>
                    <value>setLinkValidationDisabled</value>
                    <value>updateHrefInfo</value>
            </list>
        </property>
    </bean>

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

raghukumar_c — Wed, 22 Oct 2008 15:14:34 GMT

Roger,

I have pasted the part that is relevant to you. I have used Alfresco-Labs-3b-linux-x86-install.
Sorry to say this. I didn't want to remove the ^M characters because that is exactly the way you have it
in the public-services-context.xml. I think the ^M characters would have got in when the person who edited this file ftp'd it between a unix/windows machine. Anyways, it is there in every config file under this installer distribution. I thought I will just mention that.
———————————————-
    <!– LinkValidationService –>^M
    <!– Read transaction advisor for link validation service. –>^M
    <bean id="linkValidationServiceReadTxnAdvisor"^M
          class="org.springframework.aop.support.NameMatchMethodPointcutAdvisor">^M
        <property name="advice">^M
            <ref bean="retryingReadTxnAdvice"/>^M
        </property>^M
        <property name="mappedNames">^M
            <list>^M
                    <value>getHrefManifest</value>^M
                    <value>getBrokenHrefManifest</value>^M
                    <value>getHrefDifference</value>^M
                    <value>getHrefManifestBrokenByNewOrMod</value>^M
                    <value>getHrefsDependentUponFile</value>^M
                    <value>getPollInterval</value>^M
                    <value>isLinkValidationDisabled</value>^M
            </list>^M
        </property>^M
    </bean>^M
^M
    <!– Write transaction advisor for link validation service. –>^M
    <bean id="linkValidationServiceWriteTxnAdvisor"^M
          class="org.springframework.aop.support.NameMatchMethodPointcutAdvisor">^M
        <property name="advice">^M
            <ref bean="retryingWriteTxnAdvice"/>^M
        </property>^M
        <property name="mappedNames">^M
            <list>^M
                    <value>onBootstrap</value>^M
                    <value>onShutdown</value>^M
                    <value>setLinkValidationDisabled</value>^M
                    <value>updateHrefInfo</value>^M
            </list>^M
        </property>^M
    </bean>^M
^M
    <bean id="LinkValidationService"^M
          class="org.springframework.aop.framework.ProxyFactoryBean"^M
          lazy-init="true">^M
        <property name="proxyInterfaces">^M
            <list>^M
                <value>org.alfresco.linkvalidation.LinkValidationService</value>^M
            </list>^M
        </property>^M
        <property name="targetName">^M
            <value>linkValidationService</value>^M
        </property>^M
        <property name="interceptorNames">^M
            <list>^M
                <value>linkValidationServiceWriteTxnAdvisor</value>^M
                <value>linkValidationServiceReadTxnAdvisor</value>^M
                <value>checkTxnAdvisor</value>^M
            </list>^M
        </property>^M
    </bean>^M
—————————————-
Answering your question, I always get this error and have to fetch the PID and kill it. Tomcat shutdown doesn't stop the server.

Thank you for looking into this.

Regards,
Raghu

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

dna — Thu, 23 Oct 2008 07:51:19 GMT

Hello all,

I'm using alfresco labs3b (126) donwloaded from http://dev.alfresco.com/downloads/nightly/dist/ (the one from 01/10/08) on windows vista sp1 with MySQL db v5.0.67.

I always have the problem when stopping the server but finaly (after a long time, one or two minutes) the console windows closes and I can restart the server without problems.

Here is a part of my "public-services-context.xml" :

<!– LinkValidationService –>
    <!– Read transaction advisor for link validation service. –>
    <bean id="linkValidationServiceReadTxnAdvisor"
          class="org.springframework.aop.support.NameMatchMethodPointcutAdvisor">
        <property name="advice">
            <ref bean="retryingReadTxnAdvice"/>
        </property>
        <property name="mappedNames">
            <list>
                    <value>getHrefManifest</value>
                    <value>getBrokenHrefManifest</value>
                    <value>getHrefDifference</value>
                    <value>getHrefManifestBrokenByNewOrMod</value>
                    <value>getHrefsDependentUponFile</value>
                    <value>getPollInterval</value>
                    <value>isLinkValidationDisabled</value>
            </list>
        </property>
    </bean>

    <!– Write transaction advisor for link validation service. –>
    <bean id="linkValidationServiceWriteTxnAdvisor"
          class="org.springframework.aop.support.NameMatchMethodPointcutAdvisor">
        <property name="advice">
            <ref bean="retryingWriteTxnAdvice"/>
        </property>
        <property name="mappedNames">
            <list>
                    <value>onBootstrap</value>
                    <value>onShutdown</value>
                    <value>setLinkValidationDisabled</value>
                    <value>updateHrefInfo</value>
            </list>
        </property>
    </bean>

    <bean id="LinkValidationService"
          class="org.springframework.aop.framework.ProxyFactoryBean"
          lazy-init="true">
        <property name="proxyInterfaces">
            <list>
                <value>org.alfresco.linkvalidation.LinkValidationService</value>
            </list>
        </property>
        <property name="targetName">
            <value>linkValidationService</value>
        </property>
        <property name="interceptorNames">
            <list>
                <value>linkValidationServiceWriteTxnAdvisor</value>
                <value>linkValidationServiceReadTxnAdvisor</value>
                <value>checkTxnAdvisor</value>
            </list>
        </property>
    </bean>

Hope this help.

Danielle

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

amit_wmw — Mon, 27 Oct 2008 11:38:02 GMT

Hello Danielle,

I tired, keeping the file configurations (alfresco.bat, alf_stop.bat, public-services-context.xml) exactly same as you have mentioned here and “I am sure that this is not working in windows XP” but “I am not sure about the same on Vista with sp1”. Still server needs to be stopped manually! After which it does not allows to execute program or restart server unless one cleans alf_data directory and recreates DB after dropping.

In between has anyone got any clue on the same? If, then please share.

Thanks and regards
Amit.

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

mrogers — Mon, 27 Oct 2008 12:48:27 GMT

I'm continuing to look into this.   The reason for me posting to this forum was that my instance of Labs3B on XP Service pack 3 does shut down.   Admittedly sometimes with error messages, sometimes with delay but it always shuts down.     And this was backed up by Danielle's posting. There's clearly a problem somewhere but I can't nail it down.

I've investigated the log4j/Tomcat/Apache portable runtime exception and eliminated it as the cause of this problem.

In the meantime I'm in the middle of implementing a "ShutdownBackstop" feature which will terminate the JVM after a timeout.   This will address raghukumar.c 's problem and all the problems of alfresco failing to shutdown.

I would also like to emphasise that you should not need to resort to dropping the DB.   On windows if shutdown fouls up, kill the java process through the task manager.

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

amit_wmw — Mon, 27 Oct 2008 17:29:01 GMT

Hi Rogers

Thanks for reply! But what can be an alternative or work around for not dropping DB? Because once server goes down with an error-under discussion (after manually shutting it down) the next time I cannot execute my programs from eclipse(same program or other programs of SDK); they fail throwing below mentioned error. The only solution I have for this error is to drop DB and clear alt_data directory (after server goes down with the error under discussion) and then proceed :cry:

#####################################################################################################
10:14:30,574 WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
10:14:33,430 WARN [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
10:14:38,142 INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
10:14:40,171 INFO [domain.schema.SchemaBootstrap] Executing database script C:\Users\Amit\AppData\Local\Temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-6839.sql (Generated).
10:14:46,833 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
   SQL: alter table alf_access_control_entry add index FKFFF41F99B25A50BF (authority_id), add constraint FKFFF41F99B25A50BF foreign key (authority_id) references alf_authority (recipient)
   Error: Can't create table '.\alfresco\#sql-7d4_bf.frm' (errno: 150)
   File: C:\Users\Amit\AppData\Local\Temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-6839.sql
   Line: 26
10:14:46,833 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLException: Can't create table '.\alfresco\#sql-7d4_bf.frm' (errno: 150)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)
   at com.mysql.jdbc.Statement.execute(Statement.java:692)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:700)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:675)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:485)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:767)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:92)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:77)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:68)
   at org.alfresco.sample.FirstJCRClient.main(FirstJCRClient.java:49)
Caught exception org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:815)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:92)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:77)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:68)
   at org.alfresco.sample.FirstJCRClient.main(FirstJCRClient.java:49)
Caused by: java.sql.SQLException: Can't create table '.\alfresco\#sql-7d4_bf.frm' (errno: 150)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)
   at com.mysql.jdbc.Statement.execute(Statement.java:692)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:700)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:675)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:485)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:767)
   … 10 more
##########################################################################
Thanks
Amit.

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

mrogers — Mon, 27 Oct 2008 18:57:09 GMT

Amit,

I was presuming that this issue was that people were having problems shutting down after alfresco had been running a while.   It looks like you forced a shutdown during the bootstrapping of the database.    Is my assumption correct?

In which case I agree that it will require an reversion of the database (or a drop and recreate.)    The work around for that particular problem is not to shut down alfresco while it is updating the database schema.

Amit could you clarify what steps you are doing to require a refresh of the DB.     I'm interested in any exceptions before being unable to restart.

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

amit_wmw — Wed, 29 Oct 2008 13:26:35 GMT

Hi Roger

Apologies for delay reply!

I am not sure on when the bootstrapping of the database happens? My understanding was DB automatically is getting refreshed.

Anyways, I had tested few things as per your suggestion by keeping server running for quite long time (say for an hour) and here are my observations:

1)   By keeping server up for an hour and refreshing DB (by logging in to MYSQL and refreshing DB manually); I can able to shutdown alfresco server automatically using “alf_stop” script. Though it throws some error while stopping. Below are the server log details:

#############################################################################33
14:31:44,631 INFO [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
15:03:57,568 ERROR [org.springframework.web.context.support.XmlWebApplicationContext] Exception thrown from
ApplicationListener handling ContextClosedEvent
java.lang.IllegalStateException: The org.alfresco.cache.sysAdminCache Cache is not alive.
   at net.sf.ehcache.Cache.checkStatus(Cache.java:1588)
   at net.sf.ehcache.Cache.get(Cache.java:774)
   at net.sf.ehcache.Cache.get(Cache.java:755)
   at org.alfresco.repo.cache.EhCacheAdapter.get(EhCacheAdapter.java:87)
   at org.alfresco.repo.cache.TransactionalCache.get(TransactionalCache.java:347)
   at org.alfresco.repo.transaction.TransactionServiceImpl.isReadOnly(TransactionServiceImpl.java:82)
   at org.alfresco.repo.transaction.TransactionServiceImpl.getUserTransaction(TransactionServiceImpl.java:137)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:283)
   at org.alfresco.repo.transaction.RetryingTransactionAdvice.invoke(RetryingTransactionAdvice.java:73)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy172.onShutdown(Unknown Source)
   at org.alfresco.linkvalidation.LinkValidationServiceBootstrap.onShutdown(LinkValidationServiceBootstrap.java:62)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:73)
   at
org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at
org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:676)
   at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:651)
   at org.springframework.web.context.ContextLoader.closeWebApplicationContext(ContextLoader.java:336)
   at org.springframework.web.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:74)
   at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:3805)
   at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4357)
   at org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:893)
   at org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:1180)
   at org.apache.catalina.startup.HostConfig.stop(HostConfig.java:1151)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:313)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
   at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1055)
   at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1067)
   at org.apache.catalina.core.StandardEngine.stop(StandardEngine.java:448)
   at org.apache.catalina.core.StandardService.stop(StandardService.java:510)
   at org.apache.catalina.core.StandardServer.stop(StandardServer.java:734)
   at org.apache.catalina.startup.Catalina.stop(Catalina.java:602)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:577)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)

###################################################################################333333333

2) After stopping the server (automatically) I cannot further execute program as I have mentioned in my previous post. Program fails with error as mentioned below. The only remedy to this which I have at the moment is to drop DB, recreate it and clear contents inside alf_data directory and then successfully execute the program.

#############################################^^^^^^^^
18:28:14,304 WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
18:28:17,351 WARN [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
18:28:21,085 INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
18:28:25,788 INFO [domain.schema.SchemaBootstrap] Executing database script C:\DOCUME~1\AMIT~1.KAR\LOCALS~1\Temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-14584.sql (Generated).
18:28:31,492 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
   SQL: alter table alf_access_control_entry add index FKFFF41F99B25A50BF (authority_id), add constraint FKFFF41F99B25A50BF foreign key (authority_id) references alf_authority (recipient)
   Error: Can't create table '.\alfresco\#sql-460_164.frm' (errno: 150)
   File: C:\DOCUME~1\AMIT~1.KAR\LOCALS~1\Temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-14584.sql
   Line: 25
18:28:31,492 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLException: Can't create table '.\alfresco\#sql-460_164.frm' (errno: 150)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)
   at com.mysql.jdbc.Statement.execute(Statement.java:692)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:700)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:675)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:485)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:767)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:92)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:77)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:68)
   at org.alfresco.sample.FirstJCRClient.main(FirstJCRClient.java:28)
Caught exception org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:815)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:92)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:77)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:68)
   at org.alfresco.sample.FirstJCRClient.main(FirstJCRClient.java:28)
Caused by: java.sql.SQLException: Can't create table '.\alfresco\#sql-460_164.frm' (errno: 150)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3047)
   at com.mysql.jdbc.Statement.execute(Statement.java:692)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:700)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:675)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:485)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:767)
   … 10 more
#########################################################################################################

Please let me know if you need any more information on this from my side. My Conclusion: "Server stops but after that I cannot further execute programs unless I clean DB".

Thanks n reg-
Amit.

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

pjanuario — Fri, 31 Oct 2008 11:13:56 GMT

Hi,

I have a similar problem with start of alfresco.
I'm trying to build my custom spaces on bootstrap.
For that i cleaned my alf_dat directory and dropped my DB schema and user after changed the my custom spaces xml definition.
The problem is that alfresco doesn't start, lauch startup error. Cannot open connection.
Now I know that shouldn't clean repository and db that way.

My question is what is the best aproach to stay with a fesh and clean instance of alfreco without reinstall it?

Regards,
Pedro Januário

Re: Lab3 Shutdown Error in log: sysAdmin Cache is not alive.

velrajan — Mon, 24 Nov 2008 07:34:21 GMT

Hello All ,
while injecting amp file to alfresco.war file getting the following exception :
Exception in thread "Thread-44" java.lang.IllegalStateException: The org.alfresco.cache.sysAdminCache Cache is not alive.
        at net.sf.ehcache.Cache.checkStatus(Cache.java:1588)
        at net.sf.ehcache.Cache.get(Cache.java:774)
        at net.sf.ehcache.Cache.get(Cache.java:755)
        at org.alfresco.repo.cache.EhCacheAdapter.get(EhCacheAdapter.java:87)
        at org.alfresco.repo.cache.TransactionalCache.get(TransactionalCache.java:347)
        at org.alfresco.linkvalidation.LinkValidationServiceImpl.isLinkValidationDisabled(LinkValidationServiceImpl.java:363)
        at org.alfresco.linkvalidation.LinkValidationServiceImpl.run(LinkValidationServiceImpl.java:584)
        at java.lang.Thread.run(Thread.java:595)

After that the server response stopped . Once again ps -eaf and kill the alfresco tomcat process ID .
any suggestion to avoid this ?