Unable to start the alfresco application

siddardha — Mon, 07 Oct 2019 18:17:38 GMT

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

Re: Unable to start the alfresco application

afaust — Mon, 07 Oct 2019 20:40:28 GMT

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.

Re: Unable to start the alfresco application

siddardha — Tue, 08 Oct 2019 17:03:42 GMT

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

Re: Unable to start the alfresco application

nadeaumr — Tue, 08 Oct 2019 17:18:01 GMT

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

Re: Unable to start the alfresco application

cseickel — Thu, 17 Oct 2019 15:52:46 GMT

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.

Re: Unable to start the alfresco application

cseickel — Fri, 18 Oct 2019 13:26:56 GMT

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.

Re: Unable to start the alfresco application

oounoughi — Fri, 03 Jul 2020 13:20:40 GMT

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,

Re: Unable to start the alfresco application

dissertations — Mon, 06 Jul 2020 09:13:33 GMT

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.

Re: Unable to start the alfresco application

EddieMay — Tue, 07 Jul 2020 15:30:38 GMT

Hi @oounoughi,

Does this guide help?

Cheers.

topic Re: Unable to start the alfresco application in Alfresco Forum

Unable to start the alfresco application

Re: Unable to start the alfresco application

Re: Unable to start the alfresco application

Re: Unable to start the alfresco application

Re: Unable to start the alfresco application

Re: Unable to start the alfresco application

Re: Unable to start the alfresco application

Re: Unable to start the alfresco application

Re: Unable to start the alfresco application