Error stopping Alfresco labs '3.0'.

[amit_wmw]

Hello,

I am getting following error while stopping Alfresco server. I am using Alfresco labs "3.0".

Also in console I am unable to find few options like checkin, checkout of a node(as I found in other versions of alfresco like labs 3b, 3c or even in 2.1 community edition)! Please suggest.
————————————————————————————————-

Feb 10, 2009 10:58:05 AM org.apache.catalina.loader.WebappClassLoader loadClass
INFO: Illegal access: this web application instance has been stopped already.  Could
not load org.apache.log4j.spi.NOPLoggerRepository.  The eventual following stack tr
ace is caused by an error thrown for debugging purposes as well as to attempt to ter
minate the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.
java:1273)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.
java:1233)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at org.apache.log4j.LogManager.getLoggerRepository(LogManager.java:175)
        at org.apache.log4j.LogManager.getLogger(LogManager.java:199)
        at org.apache.log4j.Logger.getLogger(Logger.java:105)
        at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:28
3)
        at org.apache.commons.logging.impl.Log4JLogger.error(Log4JLogger.java:239)
        at org.alfresco.repo.shutdown.ShutdownBackstop$ShutdownBackstopThread.run(Sh
utdownBackstop.java:131)
Exception in thread "Alfresco Shutdown Backstop Thread (Self Destruct)" java.lang.No
ClassDefFoundError: org/apache/log4j/spi/NOPLoggerRepository
        at org.apache.log4j.LogManager.getLoggerRepository(LogManager.java:175)
        at org.apache.log4j.LogManager.getLogger(LogManager.java:199)
        at org.apache.log4j.Logger.getLogger(Logger.java:105)
        at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:28
3)
        at org.apache.commons.logging.impl.Log4JLogger.error(Log4JLogger.java:239)
        at org.alfresco.repo.shutdown.ShutdownBackstop$ShutdownBackstopThread.run(Sh
utdownBackstop.java:131)
————————————————————————————————————

Thanks
Amit.

[jcobb]

I got similar log output (NOPlogger not found) and alfresco wouldn't shutdown.

Removing studio (just removed studio.war and the studio directory from webapps) has stopped this happening.

Still investigating where the issue comes from…

[amit_wmw]

Thanks Jcobb!

You are correct that removes the problem of stopping server and I didn't got any error messages while stopping the server. But after that when I am trying to exectue further programs I am getting following error. Are you also facing similar issue?

——————————————————————————————-
18:23:31,921 WARN  [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
18:23:34,765 WARN  [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
18:23:38,640 INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
18:23:44,781 INFO  [domain.schema.SchemaBootstrap] Executing database script C:\DOCUME~1\AMIT~1.KAR\LOCALS~1\Temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-53154.sql (Generated).
18:23:53,109 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-55c_d3.frm' (errno: 150)
   File: C:\DOCUME~1\AMIT~1.KAR\LOCALS~1\Temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-53154.sql
   Line: 34
18:23:53,140 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLException: Can't create table '.\alfresco\#sql-55c_d3.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:65)
Exception in thread "main" 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:65)
Caused by: java.sql.SQLException: Can't create table '.\alfresco\#sql-55c_d3.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.

[jcobb]

No - my installation is working fine without studio installed.

Looks like your errors are coming from the scripts that auto-update the mysql database on startup. I wonder if a non-clean startup / shutdown previously has left the database corrupted, or an update script half run?

I would start again with a clean mysql database and an empty alf_data (as long as there's no vital data in alfresco?) Otherwise maybe turn off schema updates - I think there's a setting in the database config files - and see what happens.

James

[breandanose]

I was getting this error too when installing the Alfresco-Labs-3Stable-Full-Setup.exe on Windows XP. It seemed to be related to having a previously installed version of Java on the machine. When I removed that and re-installed the Alfresco (thereby using the Java that came pre-packaged with the Alfresco installer), it removed the error and also created the jdk directory in the Alfresco folder. That seems to have cleared up the problem for me. Some very annoying problems with Alfresco really! Hope this helps!