topic Re: Getting Issue when I'm pointing to the external postgres DB in docker-compose.yml - Alfresco 6.2 in Alfresco Forum

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

Aswani_Juvva — Tue, 24 Nov 2020 12:09:43 GMT

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=jdbcostgresql://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=\"failovernio://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

Re: Getting Issue when I'm pointing to the external postgres DB in docker-compose.yml - Alfresco 6.2

Aswani_Juvva — Tue, 24 Nov 2020 12:16:51 GMT

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)

Re: Getting Issue when I'm pointing to the external postgres DB in docker-compose.yml - Alfresco 6.2

abhinavmishra14 — Wed, 25 Nov 2020 15:10:36 GMT

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?

Re: Getting Issue when I'm pointing to the external postgres DB in docker-compose.yml - Alfresco 6.2

Aswani_Juvva — Thu, 26 Nov 2020 11:04:02 GMT

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

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.

Re: Getting Issue when I'm pointing to the external postgres DB in docker-compose.yml - Alfresco 6.2

abhinavmishra14 — Thu, 26 Nov 2020 14:51:59 GMT

Good catch 👏 Glad you figured out.

Re: Getting Issue when I'm pointing to the external postgres DB in docker-compose.yml - Alfresco 6.2

abhinavmishra14 — Thu, 26 Nov 2020 15:03:05 GMT

@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.