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
Solved! Go to Solution.
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.
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?
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.
@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.
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.