topic Re: Error stopping alfresco server - labs3 in Alfresco Archive

Error stopping alfresco server - labs3

dna — Fri, 10 Oct 2008 09:12:33 GMT

Hi,I installed alfresco labs3 on windows vista SP1. It seems to start, I can connect to the webclient but when I want to stop the alfresco server I get a lot of errors and the console doesn't close. I try first with the full setup (http://wiki.alfresco.com/wiki/Alfresco_Labs_3), typical install with

Re: Error stopping alfresco server - labs3

norgan — Fri, 10 Oct 2008 10:08:25 GMT

Hello Danielle,
I dont get the exceptions, but when I start & stop the windows+derby install more than once or if I switch to Hibernate for a while (I reboot my system usually 1-2 a week, tops), I cannot connect to alfresco anymore as well. My trick :

Go into the alfresco dir and start "apply_amps.bat". After that, my systems work again.

Sidenote : it seems to relate to derby, since my derby log stays quiet on the failing restarts.

If you can confirm this, a ticket in issues.alfresco.com would be the thing to do, I guess

Regards, Norgan

Re: Error stopping alfresco server - labs3

dna — Fri, 10 Oct 2008 11:33:50 GMT

Hello Norgan,
thanks for your reply. Unfortunately, I run apply_amps.bat then restart alfresco server and I get exactly the same errors than before.
Another clue ?

Re: Error stopping alfresco server - labs3

dna — Fri, 10 Oct 2008 12:08:18 GMT

Here is my "alf_stop.bat" :

@echo off
rem —————————————————————————
rem Stop script for the Alfresco Server
rem —————————————————————————

call "%~dp0alfresco.bat" stop

and the "alfresco.bat"

@echo off
rem —————————————————————————
rem Start script for the Alfresco Server
rem —————————————————————————

rem set Alfresco home (includes trailing \ e.g. c:\alfresco\)
set ALF_HOME=%~dp0
set CATALINA_HOME=%ALF_HOME%tomcat

rem Set any default JVM options
set JAVA_OPTS=-Xms128m -Xmx512m -Xss96k -XX:MaxPermSize=128m -server

rem — If SetPaths.bat already exists - assume set by hand and use as is
set PATH=%ALF_HOME%bin;%PATH%
if not exist "SetPaths.bat" goto getpaths
call SetPaths.bat
goto start

:getpaths
call RegPaths.exe
call SetPaths.bat
del SetPaths.bat

:start
set PATH=%JAVA_HOME%\bin;%PATH%
rem —————————————
rem Start Components
rem —————————————

if not ""%1"" == ""start"" goto nostart

rem —————————————
rem Start Tomcat
rem —————————————

echo Starting Tomcat…
call "%CATALINA_HOME%\bin\startup.bat"

rem ———————————
rem Start Virtualization if available
rem ———————————
rem if exist "~dp0virtual_start.bat" call "~dp0virtual_start.bat"

goto nostop
:nostart

rem —————————————
rem Stop Components
rem —————————————

if not ""%1"" == ""stop"" goto nostop

echo Shutting down Tomcat…
call "%CATALINA_HOME%\bin\shutdown.bat"

rem if exist "virtual_start.bat" call virtual_stop.bat

:nostop

Re: Error stopping alfresco server - labs3

dna — Fri, 10 Oct 2008 12:51:45 GMT

I think it's a fatal error. Alfresco does not start anymore.

Re: Error stopping alfresco server - labs3

dna — Mon, 13 Oct 2008 06:32:36 GMT

Hello, first of all, thanks a lot for your help.

Here is a summary of the problem :
1. install alfresco labs 3b on windows vista
2. start alfresco server (1st log) –> it works fine
3. stop alfresco server –> errors (2nd log) –> impossible to close the console
4. after that, it's impossible to start the server again.

So, I stop windows, uninstall alfresco, download another release, re-install it and I get exactly the same problem. Once I stop the server, I got errors, can not rightly close the console and then, can not work with alfresco anymore.

Re: Error stopping alfresco server - labs3

dna — Fri, 17 Oct 2008 10:01:26 GMT

Still have the problem. Anybody has the same problem with alfresco labs3b, full setup, derby db, on windows vista SP1 ?

Re: Error stopping alfresco server - labs3

dna — Mon, 20 Oct 2008 15:06:04 GMT

Hello Belmekki,

I install MySQL 5.0.67 and the associated database connector "mysql-connector-java-5.0.8-bin.jar" and it works better. For information, the database connector "mysql-connector-java-5.1.6-bin.jar" witch is packed in the full setup didn't work.

I still have an error when stopping alfresco (cfr this other post : http://forums.alfresco.com/en/viewtopic.php?f=8&p=48857#p48857) but it doesn't seem to be serious because Alfresco start after all.

If you want some logs or other informations, just let me know.

Thank you for your help.

Re: Error stopping alfresco server - labs3

amit_wmw — Mon, 27 Oct 2008 11:35:36 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.

Belmekki (or any 1 )

In between have you got any clue on the same? If, then please share.

Thanks and regards
Amit.

Re: Error stopping alfresco server - labs3

dna — Thu, 30 Oct 2008 12:22:46 GMT

Hello everybody,
I'm sorry for the delay but I was out of office and busy with another work.
I removed the "solved" because I still have a lot of problems, even with the MySQL DB. I succeeded in testing labs3b for some days. But after some tests, it didn't stop again. I don't know what I did wrong ? I tried to delete "alf_data" directory and recreate the db but now I still have a lot of errors. I think I will wait for a more stable version. I just wanted to test dynamics models and it's done. So I will stop testing labs3 for that moment.

Re: Error stopping alfresco server - labs3

jpbarba — Fri, 31 Oct 2008 12:51:51 GMT

I have installed the Windows version and I have a problem related to derby database so it is imposible to deploy correctly
Alfresco. Teorically, with this embedded database it must work but doesn't. I haven't yet tested with mysql but I wonder
people have the same problem. if anyone knows how this problem could be solved write a post.

Re: Error stopping alfresco server - labs3

amit_wmw — Wed, 31 Dec 2008 12:41:13 GMT

Hello friends

Have came to know that this server crashing issue (at the time of stopping server) will not occur if we will use same version of alfresco and SDK. With that spirit I downloaded "alfresco-labs-sdk-3b", installed alfresco server 3 b and tried executing a basic program but got the following error. Please suggest. Maybe if we will resolve this we will resolve our main issue of server crashing.
############################################################################

17:59:18,984 INFO [config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'cifsServer' defined in class path resource [alfresco/bootstrap-context.xml]: Cannot resolve reference to bean 'fileServerConfiguration' while setting constructor argument; nested exception is org.springframework.beans.factory.CannotLoadBeanClassException: Error loading class [org.alfresco.filesys.ServerConfigurationBean] for bean with name 'fileServerConfiguration' defined in class path resource [alfresco/bootstrap-context.xml]: problem with class file or dependent class; nested exception is java.lang.NoClassDefFoundError: org/alfresco/jlan/server/config/ServerConfiguration
Caused by: org.springframework.beans.factory.CannotLoadBeanClassException: Error loading class [org.alfresco.filesys.ServerConfigurationBean] for bean with name 'fileServerConfiguration' defined in class path resource [alfresco/bootstrap-context.xml]: problem with class file or dependent class; nested exception is java.lang.NoClassDefFoundError: org/alfresco/jlan/server/config/ServerConfiguration
Caused by: java.lang.NoClassDefFoundError: org/alfresco/jlan/server/config/ServerConfiguration
   at java.lang.ClassLoader.defineClass1(Native Method)
   at java.lang.ClassLoader.defineClass(Unknown Source)
   at java.security.SecureClassLoader.defineClass(Unknown Source)
   at java.net.URLClassLoader.defineClass(Unknown Source)
   at java.net.URLClassLoader.access$100(Unknown Source)
   at java.net.URLClassLoader$1.run(Unknown Source)
   at java.security.AccessController.doPrivileged(Native Method)
   at java.net.URLClassLoader.findClass(Unknown Source)
   at java.lang.ClassLoader.loadClass(Unknown Source)
   at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
   at java.lang.ClassLoader.loadClass(Unknown Source)
   at org.springframework.util.ClassUtils.forName(ClassUtils.java:201)
   at org.springframework.beans.factory.support.AbstractBeanDefinition.resolveBeanClass(AbstractBeanDefinition.java:327)
   at org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1075)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:346)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
   at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:389)
   at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:120)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:799)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:717)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:384)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:247)
   at org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:796)
   at org.springframework.context.support.AbstractApplicationContext.registerListeners(AbstractApplicationContext.java:592)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:91)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:75)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:65)
   at org.alfresco.sample.FirstJCRClient.main(FirstJCRClient.java:64)

############################################################################
Thanks
Amit

Re: Error stopping alfresco server - labs3

mrogers — Wed, 31 Dec 2008 14:48:52 GMT

There's another thread talking about the problems shutting down Alfresco. This thread has wandered off subject and become confusing.

If your instance of alfresco 3 fails to stop after a reasonable time with ctrl-C. Then kill it. On unix with a kill -9, on Windows from the task manager. It will shut down, and will restart correctly.

There have been several shutdown fixes applied to Alfresco 3 and a rather brutal feature called "shutdown backstop" is in the pipeline, unfortunately a full solution to shutdown is dependent upon a major re-architecture of Alfresco and is possibly in the Alfresco 4 timeline or later.

Re: Error stopping alfresco server - labs3

amit_wmw — Fri, 02 Jan 2009 10:42:03 GMT

Hi Roger

Thanks and wish you a very happy new year!

If your instance of alfresco 3 fails to stop after a reasonable time with ctrl-C. Then kill it. On unix with a kill -9, on Windows from the task manager. It will shut down, and will restart correctly.

As you suggest above in your mail:
1] I stopped alfresco server from task manager, by doing end task. Server stopped giving errors.
2] Then I tried executing other sample programs from alfrecso SDK but got error as below.

######################################################################################

16:02:06,854 WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
16:02:09,479 WARN [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
16:02:13,573 INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
16:02:17,043 INFO [domain.schema.SchemaBootstrap] Executing database script C:\DOCUME~1\AMIT~1.KAR\LOCALS~1\Temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-29476.sql (Generated).
16:02:22,981 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-7bc_3d.frm' (errno: 150)
   File: C:\DOCUME~1\AMIT~1.KAR\LOCALS~1\Temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-29476.sql
   Line: 25
16:02:22,981 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLException: Can't create table '.\alfresco\#sql-7bc_3d.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:44)
org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed Caught exception 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:44)
Caused by: java.sql.SQLException: Can't create table '.\alfresco\#sql-7bc_3d.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
######################################################################################

These programs will next execute only when I clear alf_data and drop & recreate DB :cry: Please suggest how to proceed here.

Thanks
Amit.

Re: Error stopping alfresco server - labs3

mrogers — Fri, 02 Jan 2009 14:27:12 GMT

Amit, your error seems to be due to an upgrade of the database going wrong.

I've seen this sort of thing myself when I've impatiently shut down alfresco while it is in the middle of initialising itself for the first time.    You need to leave Alfresco to start up correctly for the first time before killing it.   I did a fresh install (dropped the db and alf_data) and then imported my previously exported content to recover.

What are you doing with the SDK? Are you running Alfresco in some sort of test mode, say within Eclipse?   If so I'd suggest leaving the SDK well alone until you get Alfresco running correctly.

Re: Error stopping alfresco server - labs3

amit_wmw — Mon, 05 Jan 2009 10:31:29 GMT

Thanks Rogers for your reply!

I tried as you suggested above but still issue persists for me. Please help.

During which of the following steps do you think I should hold myself and for how long to execute the next program correctly without dropping DB and not getting the following error?

Step-1) Freshly installed alfresco server and mysql database.
Step-2) Executed a sample program from eclipse, content successfully pushed to repository; waited for 15 min before doing any further operation.
Step-3) Started alfresco server; after starting waited for 30 min before doing any further operation.
Step-4) Stopped alfresco server with the help of script (alf_stop). Wait for 15 min, before doing any further operation.
Step-5) Tried to run another program. Unable to execute; execution failed with same error message:

##########################################################
15:27:51,850 WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect

RMI registry - creating new one
15:27:54,256 WARN [alfresco.util.OpenOfficeConnectionTester] A

connection to OpenOffice could not be established.
15:27:57,975 INFO [domain.schema.SchemaBootstrap] Schema managed by

database dialect org.hibernate.dialect.MySQLInnoDBDialect.
15:28:00,913 INFO [domain.schema.SchemaBootstrap] Executing database

script

C:\DOCUME~1\AMIT~1.KAR\LOCALS~1\Temp\Alfresco\AlfrescoSchemaUpdate-org.hi

bernate.dialect.MySQLInnoDBDialect-43032.sql (Generated).
15:28:06,507 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-570_27.frm' (errno: 150)
   File:

C:\DOCUME~1\AMIT~1.KAR\LOCALS~1\Temp\Alfresco\AlfrescoSchemaUpdate-org.hi

bernate.dialect.MySQLInnoDBDialect-43032.sql
   Line: 25
15:28:06,538 ERROR [domain.schema.SchemaBootstrap] Schema auto-update

failed
java.sql.SQLException: Can't create table '.\alfresco\#sql-570_27.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.j

ava:261)at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBo

otstrap.java:700)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaB

ootstrap.java:675)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootst

rap.java:485)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstr

ap.java:767)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecy

cleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run

(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.j

ava:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multi

castEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEve

nt(AbstractApplicationContext.java:241)
   at org.springframework.context.support.AbstractApplicationContext.refresh(Ab

stractApplicationContext.java:349)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>

(ClassPathXmlApplicationContext.java:92)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>

(ClassPathXmlApplicationContext.java:77)
   at org.alfresco.util.ApplicationContextHelper.getApplicationContext(Applicat

ionContextHelper.java:55)
   at org.alfresco.sample.FirstFoundationClient.main(FirstFoundationClient.java

:69)Exception in thread "main" org.alfresco.error.AlfrescoRuntimeException:

Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstr

ap.java:815)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecy

cleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run

(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.j

ava:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multi

castEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEve

nt(AbstractApplicationContext.java:241)
   at org.springframework.context.support.AbstractApplicationContext.refresh(Ab

stractApplicationContext.java:349)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>

(ClassPathXmlApplicationContext.java:92)
   at org.springframework.context.support.ClassPathXmlApplicationContext.<init>

(ClassPathXmlApplicationContext.java:77)
   at org.alfresco.util.ApplicationContextHelper.getApplicationContext(Applicat

ionContextHelper.java:55)
   at org.alfresco.sample.FirstFoundationClient.main(FirstFoundationClient.java

:69)Caused by: java.sql.SQLException: Can't create table

'.\alfresco\#sql-570_27.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.j

ava:261)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBo

otstrap.java:700)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaB

ootstrap.java:675)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootst

rap.java:485)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstr

ap.java:767)… 10 more

##########################################################

1 more point to be noted over here is at the time of stopping server via stopping script(at step-4), server stopped but thrown error while stopping. Then when I checked DB there was a alf_bootstrap_lock table got created. But dropping this table also has no effect on error, error persisted.
Thanks
Amit.

Re: Error stopping alfresco server - labs3

sisao — Mon, 09 Feb 2009 09:06:48 GMT

had the same problem, i've solved it by changing "localhost" –> "127.0.0.1" in the alfresco-shared file of tomcat/shared/classes/alfresco/extension.

Re: Error stopping alfresco server - labs3

amit_wmw — Tue, 10 Feb 2009 06:51:41 GMT

Thanks for your help Sisao.

I tired as you suggested above but issue still persists for me. Firstly I didn't found alfresco-shared file in the directory you mentioned (i.e. tomcat/shared/classes/alfresco/extension). For me when I install alfresco labs (3b) I got alfresco-shared file in directory Alfresco\virtual-tomcat\conf. Then I did the change suggested by you ("localhost" –> "127.0.0.1") but still manage to find the same issue.

Please suggest.

Thanks
Amit.