Re: patch.fixWebscriptTemplate

jan_vanoverveld — Mon, 01 Apr 2019 05:21:49 GMT

Hello Axel, thank you for your reaction, I just tried an upgrade again. It still complains about the. (patch.fixWebscriptTemplate)

See the attached log file, hop you see something.

2019-04-01 07:10:14,346 INFO [org.alfresco.repo.admin] [localhost-startStop-1] Using database URL 'jdbc:mysql://dc-testdms-db-01.dummy.local/migratie?useUnicode=yes&characterEncoding=UTF-8' with user 'alfmigratie'.

2019-04-01 07:10:14,350 INFO [org.alfresco.repo.admin] [localhost-startStop-1] Connected to database MySQL version 5.5.57-0ubuntu0.14.04.1-log

2019-04-01 07:10:17,766 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes

2019-04-01 07:10:17,767 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V5.1-metadata-query-indexes

2019-04-01 07:10:23,475 INFO [krinkels.alfresco.ocr.consumer.OcrDoneConsumer] [localhost-startStop-1] OcrDoneConsumer is being started. (QUEUE listener)

2019-04-01 07:10:23,476 INFO [krinkels.alfresco.ocr.consumer.OcrDoneConsumer] [localhost-startStop-1] Setting up JMS connection to %s

2019-04-01 07:10:23,681 INFO [krinkels.alfresco.ocr.consumer.OcrDoneConsumer] [localhost-startStop-1] Listening to queue %s

2019-04-01 07:10:23,706 INFO [krinkels.alfresco.ocr.consumer.OcrDoneConsumer] [localhost-startStop-1] OcrDoneConsumer is started and listens to the queue.

2019-04-01 07:10:23,924 INFO [org.springframework.extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor Repository Template Processor for extension ftl

2019-04-01 07:10:23,926 INFO [org.springframework.extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor Repository Script Processor for extension js

2019-04-01 07:10:25,445 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]

2019-04-01 07:10:25,480 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete

2019-04-01 07:10:25,554 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc:mysql://dc-testdms-db-01.dummy.local/migratie?useUnicode=yes&characterEncoding=UTF-8, UserName=alfmigratie@10.0.40.73, MySQL Connector Java

2019-04-01 07:10:25,555 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.

2019-04-01 07:10:27,318 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] No changes were made to the schema.

2019-04-01 07:10:28,526 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Authentication' subsystem, ID: [Authentication, managed, passthru1]

2019-04-01 07:10:28,651 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Authentication' subsystem, ID: [Authentication, managed, passthru1] complete

2019-04-01 07:10:28,651 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Authentication' subsystem, ID: [Authentication, managed, ldap-ad1]

2019-04-01 07:10:28,739 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Authentication' subsystem, ID: [Authentication, managed, ldap-ad1] complete

2019-04-01 07:10:28,739 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]

2019-04-01 07:10:28,784 DEBUG [org.alfresco.web.app.servlet.NTLMAuthenticationFilter] [localhost-startStop-1] NTLM filter guest access allowed

2019-04-01 07:10:28,785 DEBUG [org.alfresco.repo.webdav.auth.NTLMAuthenticationFilter] [localhost-startStop-1] NTLM filter guest access allowed

2019-04-01 07:10:28,798 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1] complete

2019-04-01 07:10:33,455 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'thirdparty' subsystem, ID: [thirdparty, default]

2019-04-01 07:10:33,568 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete

2019-04-01 07:10:33,569 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'OOoDirect' subsystem, ID: [OOoDirect, default]

2019-04-01 07:10:33,820 WARN [org.alfresco.util.OpenOfficeConnectionTester] [localhost-startStop-1] An initial OpenOffice connection could not be established.

2019-04-01 07:10:33,823 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'OOoDirect' subsystem, ID: [OOoDirect, default] complete

2019-04-01 07:10:33,827 INFO [org.alfresco.repo.admin.ConfigurationChecker] [localhost-startStop-1] The Alfresco root data directory ('dir.root') is: /opt/alf51/alf_data

2019-04-01 07:10:33,827 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Search' subsystem, ID: [Search, managed, solr4]

2019-04-01 07:10:34,046 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Search' subsystem, ID: [Search, managed, solr4] complete

2019-04-01 07:10:34,076 INFO [org.alfresco.repo.admin.patch.PatchExecuter] [localhost-startStop-1] Checking for patches to apply ...

2019-04-01 07:10:35,360 INFO [org.alfresco.repo.admin.patch.PatchExecuter] [localhost-startStop-1] Applying patch 'patch.fixWebscriptTemplate' (Reimport fixed sample template.).

2019-04-01 07:10:37,135 ERROR [org.alfresco.repo.admin.patch.PatchExecuter] [localhost-startStop-1] 03010000 java.lang.IllegalStateException: Already value [org.mybatis.spring.SqlSessionHolder@1ecdaa9c] for key [org.apache.ibatis.session.defaults.DefaultSqlSessionFactory@862b025] bound to thread [localhost-startStop-1]

at org.springframework.transaction.support.TransactionSynchronizationManager.bindResource(TransactionSynchronizationManager.java:189)

at org.mybatis.spring.SqlSessionUtils$SqlSessionSynchronization.resume(SqlSessionUtils.java:268)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.doResumeSynchronization(AbstractPlatformTransactionManager.java:681)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.resume(AbstractPlatformTransactionManager.java:633)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.cleanupAfterCompletion(AbstractPlatformTransactionManager.java:1015)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:805)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)

at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:475)

at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:482)

at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:479)

at org.alfresco.repo.admin.patch.AbstractPatch.applyWithTxns(AbstractPatch.java:455)

at org.alfresco.repo.admin.patch.AbstractPatch.access$0(AbstractPatch.java:435)

at org.alfresco.repo.admin.patch.AbstractPatch$4.doWork(AbstractPatch.java:613)

at org.alfresco.repo.admin.patch.AbstractPatch$4.doWork(AbstractPatch.java:1)

at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)

at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:617)

at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:579)

at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.applyPatch(PatchServiceImpl.java:557)

at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.execute(PatchServiceImpl.java:470)

at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:325)

at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:302)

at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:191)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at com.sun.proxy.$Proxy121.applyOutstandingPatches(Unknown Source)

at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:76)

at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:124)

at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:1)

at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)

at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:128)

at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)

at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:207)

at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:178)

at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)

at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:950)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)

at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)

at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)

at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5524)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)

at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1859)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

2019-04-01 07:10:37,213 ERROR [org.alfresco.repo.admin.patch.PatchExecuter] [localhost-startStop-1]

=== Failed to apply patch ===

ID: patch.fixWebscriptTemplate

RESULT:

03010000 java.lang.IllegalStateException: Already value [org.mybatis.spring.SqlSessionHolder@1ecdaa9c] for key [org.apache.ibatis.session.defaults.DefaultSqlSessionFactory@862b025] bound to thread [localhost-startStop-1]