topic Alfresco Stop Working After Restart in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/alfresco-stop-working-after-restart/m-p/52914#M19849 <HTML><HEAD></HEAD><BODY><P>I am getting following error when trying to restart the alfresco server.</P><P></P><P></P><P>2018-05-19 18:59:22,147 INFO [org.alfresco.repo.admin] [localhost-startStop-1] Using database URL 'jdbc<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://10.10.104.53:5444/alfresco' with user 'enterprisedb'.<BR />2018-05-19 18:59:22,149 INFO [org.alfresco.repo.admin] [localhost-startStop-1] Connected to database PostgreSQL version 9.6.2.7<BR />2018-05-19 18:59:25,195 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes<BR />2018-05-19 18:59:25,195 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V5.1-metadata-query-indexes<BR />2018-05-19 18:59:25,195 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V5.2-remove-jbpm-tables-from-db<BR />2018-05-19 18:59:29,146 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]<BR />2018-05-19 18:59:29,269 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1] complete<BR />2018-05-19 18:59:30,816 INFO [org.springframework.extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor Repository Template Processor for extension ftl<BR />2018-05-19 18:59:30,817 INFO [org.springframework.extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor Repository Script Processor for extension js<BR />2018-05-19 18:59:32,298 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]<BR />2018-05-19 18:59:32,323 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete<BR />2018-05-19 18:59:32,364 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://10.10.104.53:5444/alfresco, UserName=enterprisedb, PostgreSQL JDBC Driver<BR />2018-05-19 18:59:32,364 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.hibernate.dialect.PostgreSQLDialect.<BR />2018-05-19 18:59:32,424 WARN [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 85 potential problems, results written to: /opt/alfresco/tomcat/temp/Alfresco/Alfresco-PostgreSQLDialect-Validation-Pre-Upgrade-alf_-6068987026393523607.txt<BR />2018-05-19 18:59:32,434 WARN [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 26 potential problems, results written to: /opt/alfresco/tomcat/temp/Alfresco/Alfresco-PostgreSQLDialect-Validation-Pre-Upgrade-act_-6420022423221295122.txt<BR />2018-05-19 18:59:32,483 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco/tomcat/temp/Alfresco/Alfresco-schema-PostgreSQLDialect-pre-upgrade-alf_-5541759201426567863.xml.<BR />2018-05-19 18:59:32,484 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/alfresco/tomcat/temp/Alfresco/Alfresco-schema-PostgreSQLDialect-pre-upgrade-act_-7324360410893804397.xml.<BR />2018-05-19 18:59:32,488 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-PostgreSQLDialect-Update-4323774011122091047.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.PostgreSQLDialect/AlfrescoCreate-RepoTables.sql).<BR />2018-05-19 18:59:32,492 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Statement execution failed:<BR /> SQL: CREATE TABLE alf_applied_patch<BR />(<BR /> id VARCHAR(64) NOT NULL,<BR /> description VARCHAR(1024),<BR /> fixes_from_schema INT4,<BR /> fixes_to_schema INT4,<BR /> applied_to_schema INT4,<BR /> target_schema INT4,<BR /> applied_on_date TIMESTAMP,<BR /> applied_to_server VARCHAR(64),<BR /> was_executed BOOL,<BR /> succeeded BOOL,<BR /> report VARCHAR(1024),<BR /> PRIMARY KEY (id)<BR />)<BR /> Error: ERROR: relation "alf_applied_patch" already exists<BR /> File: /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-PostgreSQLDialect-Update-4323774011122091047.sql<BR /> Line: 24<BR />2018-05-19 18:59:32,492 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed<BR />org.postgresql.util.PSQLException: ERROR: relation "alf_applied_patch" already exists<BR /> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)<BR /> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)<BR /> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)<BR /> at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)<BR /> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)<BR /> at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)<BR /> at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)<BR /> at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)<BR /> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)<BR /> at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)<BR /> at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)<BR /> at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)<BR /> at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:1566)<BR /> at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1508)<BR /> at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:1148)<BR /> at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:907)<BR /> at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1737)<BR /> at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)<BR /> at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:214)<BR /> at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:185)<BR /> at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)<BR /> at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:954)<BR /> at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)<BR /> at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)<BR /> at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)<BR /> at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)<BR /> at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:70)<BR /> at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5118)<BR /> at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5634)<BR /> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)<BR /> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)<BR /> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)<BR /> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)<BR /> at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:679)<BR /> at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1966)<BR /> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)<BR /> at java.util.concurrent.FutureTask.run(FutureTask.java:266)<BR /> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)<BR /> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)<BR /> at java.lang.Thread.run(Thread.java:748)<BR />2018-05-19 18:59:32,498 ERROR [org.springframework.web.context.ContextLoader] [localhost-startStop-1] Context initialization failed<BR />org.alfresco.error.AlfrescoRuntimeException: 04190000 Schema auto-update failed<BR /> at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1836)<BR /> at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)<BR /> at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:214)<BR /> at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:185)<BR /> at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)<BR /> at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:954)<BR /> at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)<BR /> at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)<BR /> at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)<BR /> at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)<BR /> at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:70)<BR /> at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5118)<BR /> at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5634)<BR /> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)<BR /> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)<BR /> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)<BR /> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)<BR /> at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:679)<BR /> at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1966)<BR /> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)<BR /> at java.util.concurrent.FutureTask.run(FutureTask.java:266)<BR /> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)<BR /> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)<BR /> at java.lang.Thread.run(Thread.java:748)<BR />Caused by: org.postgresql.util.PSQLException: ERROR: relation "alf_applied_patch" already exists<BR /> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)<BR /> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)<BR /> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)<BR /> at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)<BR /> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)<BR /> at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)<BR /> at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)<BR /> at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)<BR /> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)<BR /> at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)<BR /> at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)<BR /> at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)<BR /> at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:1566)<BR /> at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1508)<BR /> at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:1148)<BR /> at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:907)<BR /> at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1737)<BR /> ... 23 more<BR />2018-05-19 18:59:32,679 WARN [org.springframework.web.context.support.XmlWebApplicationContext] [localhost-startStop-1] Exception thrown from ApplicationListener handling ContextClosedEvent<BR />java.lang.NullPointerException<BR /> at org.alfresco.repo.workflow.activiti.ActivitiEngineInitializer.onShutdown(ActivitiEngineInitializer.java:65)<BR /> at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:67)<BR /> at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:214)<BR /> at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:190)<BR /> at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)<BR /> at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1055)<BR /> at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:1016)<BR /> at org.springframework.web.context.ContextLoader.closeWebApplicationContext(ContextLoader.java:586)<BR /> at org.springframework.web.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:143)<BR /> at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:5165)<BR /> at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5829)<BR /> at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:221)<BR /> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:149)<BR /> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)<BR /> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)<BR /> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)<BR /> at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:679)<BR /> at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1966)<BR /> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)<BR /> at java.util.concurrent.FutureTask.run(FutureTask.java:266)<BR /> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)<BR /> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)<BR /> at java.lang.Thread.run(Thread.java:748)<BR />2018-05-19 18:59:33,049 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopping 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]<BR />2018-05-19 18:59:33,050 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopped 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]<BR />2018-05-19 18:59:33,242 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopping 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]<BR />2018-05-19 18:59:33,242 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopped 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]</P></BODY></HTML> Sat, 19 May 2018 14:57:39 GMT anuj 2018-05-19T14:57:39Z Alfresco Stop Working After Restart https://connect.hyland.com/t5/alfresco-forum/alfresco-stop-working-after-restart/m-p/52914#M19849 I am getting following error when trying to restart the alfresco server.2018-05-19 18:59:22,147 INFO [org.alfresco.repo.admin] [localhost-startStop-1] Using database URL 'jdbc<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://10.10.104.53:5444/alfresco' with user 'enterprisedb'.2018-05-19 18:59:22,149 INFO [org.alfresco.repo.admin] [lo Sat, 19 May 2018 14:57:39 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-stop-working-after-restart/m-p/52914#M19849 anuj 2018-05-19T14:57:39Z Re: Alfresco Stop Working After Restart https://connect.hyland.com/t5/alfresco-forum/alfresco-stop-working-after-restart/m-p/52915#M19850 <HTML><HEAD></HEAD><BODY><P>finally i&nbsp; got the solution for the same..</P><P></P><P>just set&nbsp;<SPAN style="color: #58595b; background-color: #ffffff;"><STRONG>db.schema.update=false</STRONG> into&nbsp;alfresco-global.properties.</SPAN></P><P></P><P><SPAN style="color: #58595b; background-color: #ffffff;">Thanks.</SPAN></P></BODY></HTML> Sat, 19 May 2018 15:57:47 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-stop-working-after-restart/m-p/52915#M19850 anuj 2018-05-19T15:57:47Z