cancel
Showing results for 
Search instead for 
Did you mean: 

Facing Issue while running docker-compose.yml -Alfresco 6.2 V by config external postgres DB

Aswani_Juvva
Confirmed Champ
Confirmed Champ

Hi, After satrting the server for the below docker-compose file i'm getting error

below is my docker-compose file.

version: "2"

services:
alfresco:
build:
dockerfile: ./Dockerfile
context: ./configs-to-override/alfresco
args:
ACS_TAG: 6.2.1-A8
mem_limit: 1500m
environment:
CATALINA_OPTS : "-agentlib:jdwp=transport=dt_socket,address=*:7000,server=y,suspend=n"
JAVA_OPTS: "
-Ddb.driver=org.postgresql.Driver
-Ddb.username=postgres
-Ddb.password=postgres@123
-Ddb.url=jdbcSmiley Tongueostgresql://192.160.89.5:5432/postgres
-Dsolr.host=solr6
-Dsolr.port=9999
-Dsolr.secureComms=none
-Dsolr.base.url=/solr
-Dindex.subsystem.name=solr6
-Dshare.host=127.0.0.1
-Dshare.port=7080
-Dalfresco.host=localhost
-Dalfresco.port=7080
-Daos.baseUrlOverwrite=http://localhost:7080/alfresco/aos
-Dmessaging.broker.url=\"failoverSmiley Sadnio://activemq:61616)?timeout=3000&jms.useCompression=true\"
-Ddeployment.method=DOCKER_COMPOSE

-DlocalTransform.core-aio.url=http://transform-core-aio:8090/

-Dalfresco-pdf-renderer.url=http://transform-core-aio:8090/
-Djodconverter.url=http://transform-core-aio:8090/
-Dimg.url=http://transform-core-aio:8090/
-Dtika.url=http://transform-core-aio:8090/
-Dtransform.misc.url=http://transform-core-aio:8090/

-Dcsrf.filter.enabled=false
-Xms1500m -Xmx1500m
"
volumes:
- acs-volume:/usr/local/tomcat/alf_data
depends_on:
- postgres
- solr6

transform-core-aio:
image: alfresco/alfresco-transform-core-aio:2.3.2
mem_limit: 1536m
environment:
JAVA_OPTS: " -Xms256m -Xmx1536m"
ports:
- 8090:8090

share:
build:
dockerfile: ./Dockerfile
context: ./configs-to-override/share
args:
SHARE_TAG: 6.2.1
mem_limit: 1g
environment:
REPO_HOST: "alfresco"
REPO_PORT: "7080"
CATALINA_OPTS : "-agentlib:jdwp=transport=dt_socket,address=*:7000,server=y,suspend=n"
JAVA_OPTS: "
-Xms500m
-Xmx500m
-Dalfresco.host=localhost
-Dalfresco.port=7080
-Dalfresco.context=alfresco
-Dalfresco.protocol=http
"

postgres:
image: postgres:13.0
mem_limit: 512m
environment:
- POSTGRES_PASSWORD=postgres@123
- POSTGRES_USER=postgres
- POSTGRES_DB=postgres
command: postgres -c max_connections=300 -c log_min_messages=LOG -p 5432
ports:
- 5432:5432
volumes:
- db-volume:/var/lib/postgresql/data

solr6:
image: alfresco/alfresco-search-services:1.4.2.2
mem_limit: 2g
environment:
#Solr needs to know how to register itself with Alfresco
- SOLR_ALFRESCO_HOST=alfresco
- SOLR_ALFRESCO_PORT=7080
#Solr jetty port, to start solr6 on port 9999
- SOLR_PORT=9999
#Alfresco needs to know how to call solr
- SOLR_SOLR_HOST=solr6
- SOLR_SOLR_PORT=9999
#Create the default alfresco and archive cores
- SOLR_CREATE_ALFRESCO_DEFAULTS=alfresco,archive
#HTTP by default
- ALFRESCO_SECURE_COMMS=none
- "SOLR_JAVA_MEM=-Xms2g -Xmx2g"

ports:
- 8083:9999 #Browser port
volumes:
- ass-volume:/opt/alfresco-search-services/contentstore
- ass-volume:/opt/alfresco-search-services/data

activemq:
image: alfresco/alfresco-activemq:5.15.8
mem_limit: 1g
ports:
- 8161:8161 # Web Console
- 5672:5672 # AMQP
- 61616:61616 # OpenWire
- 61613:61613 # STOMP

proxy:
build:
dockerfile: ./Dockerfile
context: ./configs-to-override/proxy
args:
NGNIX_TAG: 1.0.0
mem_limit: 256m
depends_on:
- alfresco
ports:
- 7080:7080
links:
- alfresco
- share

volumes:
acs-volume:
external: true
db-volume:
external: true
ass-volume:
external: true

1 ACCEPTED ANSWER

Hi Abhinav,

Thanks for your responce!

It is not pointing to the external database!

The issue got resolved, here mistake was in alfresco service I'm pointing to the external database and at the same time I'm trying to create the database by below config in docker-compose file 

postgres:
image: postgres:13.0
mem_limit: 512m
environment:
- POSTGRES_PASSWORD=postgres@123
- POSTGRES_USER=postgres
- POSTGRES_DB=postgres
command: postgres -c max_connections=300 -c log_min_messages=LOG -p 5432
ports:
- 5432:5432
volumes:
- db-volume:/var/lib/postgresql/data

it worked, after removing the postgres service!

And here I have one more doubt.. when we are pointing to external database and  how to ensure that whether we are pointing to the 'dir.root' property is pointing to the correct data location.

View answer in original post

5 REPLIES 5

Aswani_Juvva
Confirmed Champ
Confirmed Champ

By config the postgres as mentioned in this ref  https://github.com/abhinavmishra14/change-acs-share-port-demo/blob/master/docker-compose.yml everyting working fine but when  I'm pointing to extrenal db as mentioned in above post, getting below error 

alfresco_1 | 2020-11-24 11:35:51,965 ERROR [impl.interceptor.CommandContext] [localhost-startStop-1] Error while closing command context
alfresco_1 | org.apache.ibatis.exceptions.PersistenceException:
alfresco_1 | ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: column j.proc_def_id_ does not exist
alfresco_1 | Hint: Perhaps you meant to reference the column "j.process_def_id_" or the column "j.job_def_id_".
alfresco_1 | Position: 69
alfresco_1 | ### The error may exist in org/activiti/db/mapping/entity/Job.xml
alfresco_1 | ### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.selectJobByTypeAndProcessDefinitionKeyNoTenantId-Inline
alfresco_1 | ### The error occurred while setting parameters
alfresco_1 | ### SQL: select J.* from ACT_RU_JOB J inner join ACT_RE_PROCDEF P on J.PROC_DEF_ID_ = P.ID_ where J.HANDLER_TYPE_ = ? and P.KEY_ = ? and (P.TENANT_ID_ = '' or P.TENANT_ID_ is null)
alfresco_1 | ### Cause: org.postgresql.util.PSQLException: ERROR: column j.proc_def_id_ does not exist
alfresco_1 | Hint: Perhaps you meant to reference the column "j.process_def_id_" or the column "j.job_def_id_".
alfresco_1 | Position: 69
alfresco_1 | at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
alfresco_1 | at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:122)
alfresco_1 | at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)
alfresco_1 | at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:442)
alfresco_1 | at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:433)
alfresco_1 | at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:428)
alfresco_1 | at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:405)
alfresco_1 | at org.activiti.engine.impl.persistence.entity.JobEntityManager.findJobsByTypeAndProcessDefinitionKeyNoTenantId(JobEntityManager.java:208)
alfresco_1 | at org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.removeObsoleteTimers(BpmnDeployer.java:349)
alfresco_1 | at org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.deploy(BpmnDeployer.java:223)
alfresco_1 | at org.activiti.engine.impl.persistence.deploy.DeploymentManager.deploy(DeploymentManager.java:58)
alfresco_1 | at org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:106)
alfresco_1 | at org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:37)
alfresco_1 | at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
alfresco_1 | at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
alfresco_1 | at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
alfresco_1 | at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
alfresco_1 | at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
alfresco_1 | at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
alfresco_1 | at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
alfresco_1 | at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
alfresco_1 | at org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:79)
alfresco_1 | at org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:156)
alfresco_1 | at org.alfresco.repo.workflow.activiti.ActivitiWorkflowEngine.deployDefinition(ActivitiWorkflowEngine.java:347)
alfresco_1 | at org.alfresco.repo.workflow.WorkflowServiceImpl.deployDefinition(WorkflowServiceImpl.java:237)
alfresco_1 | at jdk.internal.reflect.GeneratedMethodAccessor259.invoke(Unknown Source)
alfresco_1 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
alfresco_1 | at java.base/java.lang.reflect.Method.invoke(Method.java:566)
alfresco_1 | at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
alfresco_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
alfresco_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
alfresco_1 | at org.alfresco.service.cmr.workflow.WorkflowPermissionInterceptor.invoke(WorkflowPermissionInterceptor.java:64)
alfresco_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
alfresco_1 | at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:53)
alfresco_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
alfresco_1 | at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:166)
alfresco_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
alfresco_1 | at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
alfresco_1 | at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
alfresco_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
alfresco_1 | at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
alfresco_1 | at com.sun.proxy.$Proxy83.deployDefinition(Unknown Source)
alfresco_1 | at org.alfresco.repo.workflow.WorkflowDeployer.init(WorkflowDeployer.java:313)
alfresco_1 | at org.alfresco.repo.workflow.WorkflowDeployer$1$1.doWork(WorkflowDeployer.java:568)
alfresco_1 | at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:602)
alfresco_1 | at org.alfresco.repo.workflow.WorkflowDeployer$1.execute(WorkflowDeployer.java:564)
alfresco_1 | at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:450)
alfresco_1 | at org.alfresco.repo.workflow.WorkflowDeployer.onBootstrap(WorkflowDeployer.java:559)
alfresco_1 | at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
alfresco_1 | at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:221)
alfresco_1 | at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:186)
alfresco_1 | at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:206)
alfresco_1 | at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:402)
alfresco_1 | at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:359)
alfresco_1 | at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:896)
alfresco_1 | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552)
alfresco_1 | at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:401)
alfresco_1 | at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:292)
alfresco_1 | at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:103)
alfresco_1 | at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:70)
alfresco_1 | at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
alfresco_1 | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
alfresco_1 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
alfresco_1 | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
alfresco_1 | at org.apache.catalina.core.ContainerBase.access$000(ContainerBase.java:129)
alfresco_1 | at org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:150)
alfresco_1 | at org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:140)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:717)
alfresco_1 | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
alfresco_1 | at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1125)
alfresco_1 | at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1859)
alfresco_1 | at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
alfresco_1 | at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
alfresco_1 | at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
alfresco_1 | at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
alfresco_1 | at java.base/java.lang.Thread.run(Thread.java:834)
alfresco_1 | Caused by: org.postgresql.util.PSQLException: ERROR: column j.proc_def_id_ does not exist
alfresco_1 | Hint: Perhaps you meant to reference the column "j.process_def_id_" or the column "j.job_def_id_".
alfresco_1 | Position: 69
alfresco_1 | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2533)
alfresco_1 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2268)
alfresco_1 | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:313)
alfresco_1 | at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
alfresco_1 | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
alfresco_1 | at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:159)
alfresco_1 | at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:148)
alfresco_1 | at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
alfresco_1 | at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
alfresco_1 | at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
alfresco_1 | at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62)
alfresco_1 | at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)
alfresco_1 | at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
alfresco_1 | at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)
alfresco_1 | at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)
alfresco_1 | at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)
alfresco_1 | at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)
alfresco_1 | at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)
alfresco_1 | ... 75 more

STATE_PUBLISHER@1531094644 / IT #1606218030004] Tracking failure. See the stacktrace below for further details.
solr6_1 | org.alfresco.error.AlfrescoRuntimeException: 10240128 GetTransactions return status is 404
solr6_1 | at org.alfresco.solr.client.SOLRAPIClient.getTransactions(SOLRAPIClient.java:440)
solr6_1 | at org.alfresco.solr.tracker.NodeStatePublisher.doTrack(NodeStatePublisher.java:74)
solr6_1 | at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:210)
solr6_1 | at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:54)
solr6_1 | at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
solr6_1 | at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
solr6_1 | 2020-11-24 11:40:30.062 ERROR (org.alfresco.solr.AlfrescoCoreAdminHandler@1d3e6d34_Worker-13) [ ] o.a.s.t.AclTracker [alfresco / ACL@2029665071 / IT #1606218030002] Tracking failure. See the stacktrace below for further details.
solr6_1 | org.alfresco.error.AlfrescoRuntimeException: 10240129 api/solr/aclchangesets return status:404
solr6_1 | at org.alfresco.solr.client.SOLRAPIClient.callRepository(SOLRAPIClient.java:1595)
solr6_1 | at org.alfresco.solr.client.SOLRAPIClient.getAclChangeSets(SOLRAPIClient.java:184)
solr6_1 | at org.alfresco.solr.tracker.AclTracker.getSomeAclChangeSets(AclTracker.java:443)
solr6_1 | at org.alfresco.solr.tracker.AclTracker.trackAclChangeSets(AclTracker.java:671)
solr6_1 | at org.alfresco.solr.tracker.AclTracker.trackRepository(AclTracker.java:323)
solr6_1 | at org.alfresco.solr.tracker.AclTracker.doTrack(AclTracker.java:102)
solr6_1 | at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:210)
solr6_1 | at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:54)
solr6_1 | at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
solr6_1 | at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
solr6_1 | 2020-11-24 11:40:30.070 ERROR (org.alfresco.solr.AlfrescoCoreAdminHandler@1d3e6d34_Worker-3) [ ] o.a.s.t.ModelTracker [alfresco / MODEL@1604132169 / IT #1606218030002] Tracking failure. See the stacktrace below for further details.
solr6_1 | org.alfresco.error.AlfrescoRuntimeException: 10240130 api/solr/modelsdiff return status:404
solr6_1 | at org.alfresco.solr.client.SOLRAPIClient.callRepository(SOLRAPIClient.java:1595)
solr6_1 | at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1102)
solr6_1 | at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.java:290)
solr6_1 | at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:252)
solr6_1 | at org.alfresco.solr.tracker.ModelTracker.doTrack(ModelTracker.java:212)
solr6_1 | at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:210)
solr6_1 | at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:54)
solr6_1 | at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
solr6_1 | at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
solr6_1 | 2020-11-24 11:40:40.015 ERROR (org.alfresco.solr.AlfrescoCoreAdminHandler@1d3e6d34_Worker-36) [ ] o.a.s.t.NodeStatePublisher [archive / NODE_STATE_PUBLISHER@48058826 / IT #1606218040009] Tracking failure. See the stacktrace below for further details.
solr6_1 | org.alfresco.error.AlfrescoRuntimeException: 10240131 GetTransactions return status is 404
solr6_1 | at org.alfresco.solr.client.SOLRAPIClient.getTransactions(SOLRAPIClient.java:440)
solr6_1 | at org.alfresco.solr.tracker.NodeStatePublisher.doTrack(NodeStatePublisher.java:74)
solr6_1 | at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:210)
solr6_1 | at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:54)
solr6_1 | at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
solr6_1 | at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
solr6_1 | 2020-11-24 11:40:40.019 ERROR (org.alfresco.solr.AlfrescoCoreAdminHandler@1d3e6d34_Worker-23) [ ] o.a.s.t.AclTracker [archive / ACL@1006641450 / IT #1606218040003] Tracking failure. See the stacktrace below for further details.
solr6_1 | org.alfresco.error.AlfrescoRuntimeException: 10240132 api/solr/aclchangesets return status:404
solr6_1 | at org.alfresco.solr.client.SOLRAPIClient.callRepository(SOLRAPIClient.java:1595)
solr6_1 | at org.alfresco.solr.client.SOLRAPIClient.getAclChangeSets(SOLRAPIClient.java:184)
solr6_1 | at org.alfresco.solr.tracker.AclTracker.checkRepoAndIndexConsistency(AclTracker.java:354)
solr6_1 | at org.alfresco.solr.tracker.AclTracker.trackRepository(AclTracker.java:319)
solr6_1 | at org.alfresco.solr.tracker.AclTracker.doTrack(AclTracker.java:102)
solr6_1 | at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:210)
solr6_1 | at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:54)
solr6_1 | at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
solr6_1 | at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)

This error:

org.postgresql.util.PSQLException: ERROR: column j.proc_def_id_ does not exist
alfresco_1 | Hint: Perhaps you meant to reference the column "j.process_def_id_" or the column "j.job_def_id_".
alfresco_1 | Position: 69
alfresco_1 | ### The error may exist in org/activiti/db/mapping/entity/Job.xml
alfresco_1 | ### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.selectJobByTypeAndProcessDefinitionKeyNoTenantId-Inline
alfresco_1 | ### The error occurred while setting parameters

Seems to compalin about a missing column in act_evt_log table. 

https://soft-builder.com/en/docs/Alfresco/act_evt_log.html#Col_proc_def_id_

Questions:

1- Can you confirm whether acs is able to connect to the external postgres db? try pinging the extenal postgress from acs container and try doing a telnet to 192.160.89.5 5432

2- Are you setting up new instances (bootstrapping acs ) with newly pointed db ? --> In this case, you should not be getting the error as long as acs container is able to connect to external postgres db.

3- Have you started acs earlier with local postgres db and then tying to change to an external postgres db?

~Abhinav
(ACSCE, AWS SAA, Azure Admin)

Hi Abhinav,

Thanks for your responce!

It is not pointing to the external database!

The issue got resolved, here mistake was in alfresco service I'm pointing to the external database and at the same time I'm trying to create the database by below config in docker-compose file 

postgres:
image: postgres:13.0
mem_limit: 512m
environment:
- POSTGRES_PASSWORD=postgres@123
- POSTGRES_USER=postgres
- POSTGRES_DB=postgres
command: postgres -c max_connections=300 -c log_min_messages=LOG -p 5432
ports:
- 5432:5432
volumes:
- db-volume:/var/lib/postgresql/data

it worked, after removing the postgres service!

And here I have one more doubt.. when we are pointing to external database and  how to ensure that whether we are pointing to the 'dir.root' property is pointing to the correct data location.

Good catch 👏 Glad you figured out.

~Abhinav
(ACSCE, AWS SAA, Azure Admin)


@Aswani_Juvva wrote:

And here I have one more doubt.. when we are pointing to external database and  how to ensure that whether we are pointing to the 'dir.root' property is pointing to the correct data location.


dir.root is specific to acs not database. Check your alfresco-global.properties/JAVA_OPTS where we set the dir.root property. 
dir.root points to alf_data folder and default location is "/usr/local/tomcat/alf_data". You can create an external volume to map alf_data where it will be presisted or use bind mount on the host. 

https://docs.docker.com/storage/ 

https://docs.docker.com/storage/volumes/ 


You can also change the default location as needed.

~Abhinav
(ACSCE, AWS SAA, Azure Admin)