Unable to start the alfresco application

cancel
Showing results for 
Search instead for 
Did you mean: 
siddardha
Active Member II

Unable to start the alfresco application

 

Hi Team,

 

I am getting below error while starting the application.

 

2019-10-07 14:10:37,356 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] The current Alfresco cluster node is waiting for another chance to bootstrap the DB schema. Attempt: 4 of 24
2019-10-07 14:10:42,428 WARN [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 87 potential problems, results written to: /opt/acs/tomcat/temp/Alfresco/Alfresco-Oracle9Dialect-Validation-Pre-Upgrade-alf_-1012580688530083771.txt
2019-10-07 14:10:42,446 WARN [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 26 potential problems, results written to: /opt/acs/tomcat/temp/Alfresco/Alfresco-Oracle9Dialect-Validation-Pre-Upgrade-act_-5941621153781702131.txt
2019-10-07 14:10:42,470 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/acs/tomcat/temp/Alfresco/Alfresco-schema-Oracle9Dialect-pre-upgrade-alf_-5156991516469762127.xml.
2019-10-07 14:10:42,470 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/acs/tomcat/temp/Alfresco/Alfresco-schema-Oracle9Dialect-pre-upgrade-act_-3271976051965525632.xml.
2019-10-07 14:10:42,474 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] The current Alfresco cluster node is waiting for another chance to bootstrap the DB schema. Attempt: 5 of 24
2019-10-07 14:10:47,541 WARN [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 87 potential problems, results written to: /opt/acs/tomcat/temp/Alfresco/Alfresco-Oracle9Dialect-Validation-Pre-Upgrade-alf_-6653754273147223697.txt
2019-10-07 14:10:47,551 WARN [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 26 potential problems, results written to: /opt/acs/tomcat/temp/Alfresco/Alfresco-Oracle9Dialect-Validation-Pre-Upgrade-act_-6723406696985547067.txt
2019-10-07 14:10:47,567 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/acs/tomcat/temp/Alfresco/Alfresco-schema-Oracle9Dialect-pre-upgrade-alf_-9103537056684048726.xml.
2019-10-07 14:10:47,567 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/acs/tomcat/temp/Alfresco/Alfresco-schema-Oracle9Dialect-pre-upgrade-act_-2353632165131219804.xml.
2019-10-07 14:10:47,570 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] The current Alfresco cluster node is waiting for another chance to bootstrap the DB schema. Attempt: 6 of 24

SEVERE: Exception sending context initialized event to listener instance of class [org.alfresco.repo.webdav.WebDAVSessionListener]
org.alfresco.error.AlfrescoRuntimeException: 09070001 Schema auto-update failed
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1792)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:221)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:186)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:206)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:398)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:355)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:882)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:400)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:291)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:103)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:70)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4753)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5215)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:629)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1839)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 09070000 A long running upgrade was found to be running on another node of the cluster. This node is shutting down.
at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1751)
... 25 more

8 Replies
afaust
Master

Re: Unable to start the alfresco application

If you perform a retry of the first Alfresco start (after a failure), a temporary table alf_boostrap may exist, which is used to protect against two applications starting at the same time bootstrapping the schema. You need to delete that table and try again, making sure to only start one server.

siddardha
Active Member II

Re: Unable to start the alfresco application

@afaust Seems to be there is no table alf_boostrap in database.

nadeaumr
Customer

Re: Unable to start the alfresco application

Hi,

   From my experience, Alfresco with Oracle database. When i started it for the first time, i've got to define the db.url without the POOLED parameter. After the first start, i can put back POOLED.

Hope it woul help...

 

Marc

cseickel
Customer

Re: Unable to start the alfresco application

I am having the same problem with SQL Server database.  The database is restored from 6.0 and I am trying to start a new 6.1 install against this db.  The database is restored from an on prem SQL Server to an AWS RDS instance.  Any one have any advice?  I do not have the temp table and there are no other servers that could e connecting to it.

cseickel
Customer

Re: Unable to start the alfresco application

As it turns out, this was caused by a problem with my connection string.  Becasue the deployment was scripted in a bash script, the semicolons in the connection string got interpreted as aseparate commands and the database name and connection timout cluases were lost.  I guess it was just working against the master schema by default.

oounoughi
Established Member

Re: Unable to start the alfresco application

Hi Marc,

What do youo mean by the POOLED parameter in db.url ??

I have the same issue and in my conf 

db.url= jdbc:oracle:thin:@${db.host}:${db.port}:${db.name}

 

Can you give me exemple ?

Regards,

O.

dissertations
Member II

Re: Unable to start the alfresco application

Would it be a PHP version & SQL error? I had something similar and update to the latest vesion of PHP and the error was resolved.

EddieMay
Alfresco Employee

Re: Unable to start the alfresco application

Hi @oounoughi,

Does this guide help? 

Cheers.

Digital Community Manager, Alfresco Software.
Problem solved? Click Accept as Solution!