installing Alfresco comunity from distribution zip 23.1

[emanuel_g]

Hi, I am trying to install alfresco comunity 23.1 performing all the steps from the guide and when I start tomcat for the first time I get this error message: 

Spoiler

2024-03-15 14:21:13,311 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: 02150000 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:1694) [alfresco-repository-23.1.0.255.jar:23.1.0.255]
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56) [spring-surf-core-9.0.jar:9.0]
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:232) [alfresco-repository-23.1.0.255.jar:23.1.0.255]
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:197) [alfresco-repository-23.1.0.255.jar:23.1.0.255]
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:217) [alfresco-repository-23.1.0.255.jar:23.1.0.255]
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:437) [spring-context-6.0.12.jar:6.0.12]
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:370) [spring-context-6.0.12.jar:6.0.12]
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:961) [spring-context-6.0.12.jar:6.0.12]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:611) [spring-context-6.0.12.jar:6.0.12]
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:394) [spring-web-6.0.12.jar:6.0.12]
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:274) [spring-web-6.0.12.jar:6.0.12]
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:102) [spring-web-6.0.12.jar:6.0.12]
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:70) [classes/:23.1.0.255]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4438) [catalina.jar:10.1.19]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4876) [catalina.jar:10.1.19]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:171) [catalina.jar:10.1.19]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:683) [catalina.jar:10.1.19]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:658) [catalina.jar:10.1.19]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:712) [catalina.jar:10.1.19]
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:969) [catalina.jar:10.1.19]
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1911) [catalina.jar:10.1.19]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]

Spoiler

###############################
## Common Alfresco Properties #
###############################
messaging.subsystem.autoStart=false

server.allowWrite = true

system.serverMode=UNKNOWN
alfresco.rmi.services.port=50500
transform.service.enabled=false
local.transform.service.enabled=false
legacy.transform.service.enabled=false

#db.schema.update=false
#db.schema.update.lockRetryCount=24
#db.schema.update.lockRetryWaitSeconds=5

#
# Sample custom content and index data location
#
dir.root=C:\\Tomcat\\Alfresco_store\\alf_data
dir.contentstore=${dir.root}\\contentstore
dir.contentstore.deleted=${dir.root}\\contentstore.deleted
dir.keystore=C:\\Tomcat\\shared\\classes\\alfresco\\extension\\keystore\\metadata-keystore\\

# Sample database connection properties
#

#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)

db.driver=org.postgresql.Driver
db.url=jdbcostgresql://${db.host}:${db.port}/${db.name}
db.name=alfresco
db.username=alfresco
db.password=alfresco
db.host=localhost
db.port=5432
db.pool.max=275

# URL Generation Parameters (The ${localname} token is replaced by the local server name)
#-------------
alfresco.context=alfresco
alfresco.host=localhost
alfresco.port=8080
alfresco.protocol=http

share.context=share
share.host=localhost
share.port=8080
share.protocol=http

#imap.server.enabled=true
#imap.server.port=143
#imap.server.host=localhost

#Smart Folders Config Properties

smart.folders.enabled=true
smart.folders.model=alfresco/model/smartfolder-model.xml
smart.folders.model.labels=alfresco/messages/smartfolder-model

#Smart reference config

#smart.reference.classpath.hash=${smart.folders.config.vanilla.processor.classpath}->1,${smart.folders.config.system.templates.classpath}->2

#Smart store config

#Company home relative download associations of smart entries
#smart.download.associations.folder=${spaces.dictionary.childname}/${spaces.smartdownloads.childname}

#Generic virtualization methods config

#Vanilla JSON templates javascript processor classpath. A java script processor used to
#covert JSON templates to internal smart folder definitions.

#smart.folders.config.vanilla.processor.classpath=/org/alfresco/repo/virtual/node/vanilla.js

#System virtualization method config

#System virtualization method aspect.
#smart.folders.config.system.aspect=smf:systemConfigSmartFolder
#System virtualization method aspect defined template location property.
#smart.folders.config.system.aspect.template.location.property=smf:system-template-location
#Classpath to be explored for *.json entries defining system templates.
#smart.folders.config.system.templates.classpath=/org/alfresco/repo/virtual/node
#A company home relative name or qname path location of repository system templates.
#smart.folders.config.system.templates.path=${spaces.dictionary.childname}/${spaces.smartfolders.childname}
#Content sub type of repository system templates.
#smart.folders.config.system.templates.template.type=smf:smartFolderTemplate

#Custom virtualization method config

#Custom virtualization method aspect.
#smart.folders.config.custom.aspect=smf:customConfigSmartFolder
#Custom virtualization method aspect template content association.
#smart.folders.config.custom.aspect.template.association=smf:custom-template-association

#Type virtualization method config

#A company home relative name or qname path location of the type mapped templates.
#smart.folders.config.type.templates.path=${spaces.dictionary.childname}/${spaces.smartfolders.childname}
#Type and aspect qname regular expression filter.
#smart.folders.config.type.templates.qname.filter=none

# Set the Elasticsearch subsystem
#index.subsystem.name=elasticsearch
# Elasticsearch index properties
#elasticsearch.indexName=alfresco
#elasticsearch.createIndexIfNotExists=true
# Elasticsearch server properties
#elasticsearch.host=localhost
#elasticsearch.port=9200
#elasticsearch.baseUrl=/

#from the docs - initial setup
solr.secureComms=none
#search services
solr.port=8983
index.subsystem.name=solr6

contentPropertyRestrictions.enabled=false

I've seen diffrent posts regaring  "Schema auto-update failed" and have tried all solutions from there, but for me it did not work.

Please let me know what am I missing here. I've installed ziped alfrescos before version 7 and did not encountered this issue at startup.

Regards,

Emanuel.

[angelborroy]

This is the error cause:

https://github.com/Alfresco/alfresco-community-repo/blob/a73cf6a71d019fa90eb71d42dde3089adb2222d5/re...

However, not sure what is happenning there...

[emanuel_g]

I get this error when starting the repository the first time, in the mean time I was able to install a repo 7.4 so work can continue. But can I provide any other logs so we can have a solition for 23.1 also? Thanks!

[steeed]

For me the similar problem was caused by absence of needed permissions in PostgreSQL 15 -making 'alfresco' user be superuser helped to run initial patched against the newly created DB