Unable to start the alfresco application

[siddardha]

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

[afaust]

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]

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

[nadeaumr]

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]

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]

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]

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]

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]

Hi @oounoughi,

Does this guide help? 

Cheers.