Problem upgrading from 3.3.0 to 3.4.d with hot backup

[chrisjscott]

I am attempting to upgrade from version 3.3.0 to 3.4.d.  My clean installation of 3.4.d works fine but I have a problem when I restore my hot backup of my content from 3.3.0 and then try to startup alfresco.  I have followed the Upgrade and Backup and Restore documentation.  It isn't able to reindex my content upon startup and then crashes.  I have set index.recovery.mode=AUTO.  Any help at all will be greatly appreciated.

Cheers
Chris

alfresco.log:

22:07:20,526 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
22:07:20,527 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
22:07:20,528 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/var/lib/tomcat6/webapps/alfresco/WEB-INF/classes/alfresco/module/tests/alfresco-global.properties]
22:07:20,528 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/var/lib/tomcat6/webapps/alfresco/WEB-INF/classes/alfresco/module/test/alfresco-global.properties]
22:07:20,528 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/var/lib/tomcat6/shared/classes/alfresco-global.properties]
22:07:20,569 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
22:07:20,671 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
22:07:20,692 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
22:07:28,977 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
22:07:28,979 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
22:07:33,470 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.PostgreSQLDialect.
22:07:34,754 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
22:07:34,830 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
22:07:34,837 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
22:07:34,838 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
22:07:34,838 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
22:07:34,844 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
22:07:35,655 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [thirdparty, default]
22:07:35,667 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
22:07:35,667 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
22:07:35,668 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
22:07:35,804 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete
22:07:35,804 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'OOoDirect' subsystem, ID: [OOoDirect, default]
22:07:35,812 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
22:07:35,813 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
22:07:35,813 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
22:07:36,171 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'OOoDirect' subsystem, ID: [OOoDirect, default] complete
22:07:36,172 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:07:36,346 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:08:13,951 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:08:13,995 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:08:52,530 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:08:52,568 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:09:33,250 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:09:33,281 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:10:08,404 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:10:08,430 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:10:41,159 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:10:41,181 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:11:17,125 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:11:17,148 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:11:51,579 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:11:51,602 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:12:27,340 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:12:27,372 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:13:11,546 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:13:11,576 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:13:52,406 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:13:52,430 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:14:29,183 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:14:29,205 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:15:02,105 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:15:02,129 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:15:37,887 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:15:37,908 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:16:13,760 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:16:13,779 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:16:49,772 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:16:49,793 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:17:20,209 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:17:20,230 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:17:54,752 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:17:54,773 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:18:31,438 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:18:31,452 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:19:08,592 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:19:08,612 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:19:44,208 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:19:44,228 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:20:22,916 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:20:22,936 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:20:59,753 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:20:59,772 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:21:44,071 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:21:44,090 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:22:18,609 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:22:18,627 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:22:54,622 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:22:54,641 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:23:37,084 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:23:37,103 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:24:12,667 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:24:12,682 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:24:52,086 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:24:52,104 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:25:31,515 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:25:31,534 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:26:06,713 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:26:06,731 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:26:47,922 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:26:47,938 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:27:30,740 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:27:30,754 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:28:06,510 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:28:06,531 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:28:46,401 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:28:46,417 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:29:31,560 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:29:31,577 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:30:07,544 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:30:07,559 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:30:50,684 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:30:50,701 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:31:35,433 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:31:35,449 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:32:09,018 DEBUG [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Performing index recovery for type: AUTO
22:32:09,035 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started.
22:32:48,094 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 03110040 Reindex failure for org.alfresco.repo.node.index.FullIndexRecoveryComponent
        at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:315)
        at org.alfresco.repo.node.index.IndexRecoveryBootstrapBean.onBootstrap(IndexRecoveryBootstrapBean.java:37)
        at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)
        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:593)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 03110039 Reindex failure for org.alfresco.repo.node.index.IndexTransactionTracker
        at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:315)
        at org.alfresco.repo.node.index.FullIndexRecoveryComponent.performPartialRecovery(FullIndexRecoveryComponent.java:307)
        at org.alfresco.repo.node.index.FullIndexRecoveryComponent.reindexImpl(FullIndexRecoveryComponent.java:207)
        at org.alfresco.repo.node.index.AbstractReindexComponent$1.execute(AbstractReindexComponent.java:300)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:272)
        at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:306)
        … 35 more
Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [25006]; error code [0];
— The error occurred in alfresco/ibatis/#resource.dialect#/node-insert-SqlMap.xml.
— The error occurred while applying a parameter map.
— Check the alfresco.node.insert_Server-InlineParameterMap.
— Check the statement (update failed).
— Cause: org.postgresql.util.PSQLException: ERROR: transaction is read-only; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/ibatis/#resource.dialect#/node-insert-SqlMap.xml.
— The error occurred while applying a parameter map.
— Check the alfresco.node.insert_Server-InlineParameterMap.
— Check the statement (update failed).
— Cause: org.postgresql.util.PSQLException: ERROR: transaction is read-only
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)
        at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:364)
        at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.insertServer(NodeDAOImpl.java:198)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$ServerIdCallback.getWithWriteLock(AbstractNodeDAOImpl.java:378)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$ServerIdCallback.getWithWriteLock(AbstractNodeDAOImpl.java:347)
        at org.alfresco.util.ReadWriteLockExecuter.execute(ReadWriteLockExecuter.java:103)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getServerId(AbstractNodeDAOImpl.java:395)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getTxnsByCommitTimeDescending(AbstractNodeDAOImpl.java:3141)
        at org.alfresco.repo.node.index.IndexTransactionTracker.getLastIndexedCommitTime(IndexTransactionTracker.java:439)
        at org.alfresco.repo.node.index.IndexTransactionTracker.getStartingTxnCommitTime(IndexTransactionTracker.java:411)
        at org.alfresco.repo.node.index.IndexTransactionTracker$1.execute(IndexTransactionTracker.java:181)
        at org.alfresco.repo.node.index.IndexTransactionTracker$1.execute(IndexTransactionTracker.java:178)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381)
        at org.alfresco.repo.node.index.IndexTransactionTracker.reindexImpl(IndexTransactionTracker.java:245)
        at org.alfresco.repo.node.index.AbstractReindexComponent$1.execute(AbstractReindexComponent.java:300)
        at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:310)
        … 41 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/ibatis/#resource.dialect#/node-insert-SqlMap.xml.
— The error occurred while applying a parameter map.
— Check the alfresco.node.insert_Server-InlineParameterMap.
— Check the statement (update failed).
— Cause: org.postgresql.util.PSQLException: ERROR: transaction is read-only
        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:393)
        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
        at org.springframework.orm.ibatis.SqlMapClientTemplate$8.doInSqlMapClient(SqlMapClientTemplate.java:366)
        at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)
        … 56 more
Caused by: org.postgresql.util.PSQLException: ERROR: transaction is read-only
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:360)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
        at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:100)
        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)
        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)
        … 60 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

postgresql-8.4-main.log:

2011-04-11 22:07:36 CEST ERROR:  transaction is read-only
2011-04-11 22:07:36 CEST STATEMENT:  insert into alf_server (id, version, ip_address)         values ($1, $2, $3)
2011-04-11 22:07:36 CEST ERROR:  transaction is read-only
2011-04-11 22:07:36 CEST STATEMENT:  insert into alf_server (id, version, ip_address)         values ($1, $2, $3)
2011-04-11 22:07:36 CEST ERROR:  transaction is read-only
2011-04-11 22:07:36 CEST STATEMENT:  insert into alf_server (id, version, ip_address)         values ($1, $2, $3)
2011-04-11 22:07:36 CEST ERROR:  transaction is read-only
2011-04-11 22:07:36 CEST STATEMENT:  insert into alf_server (id, version, ip_address)         values ($1, $2, $3)
2011-04-11 22:07:36 CEST ERROR:  transaction is read-only
2011-04-11 22:07:36 CEST STATEMENT:  insert into alf_server (id, version, ip_address)         values ($1, $2, $3)
2011-04-11 22:07:37 CEST ERROR:  transaction is read-only
2011-04-11 22:07:37 CEST STATEMENT:  insert into alf_server (id, version, ip_address)         values ($1, $2, $3)
2011-04-11 22:07:37 CEST ERROR:  transaction is read-only
2011-04-11 22:07:37 CEST STATEMENT:  insert into alf_server (id, version, ip_address)         values ($1, $2, $3)
2011-04-11 22:07:37 CEST ERROR:  transaction is read-only
2011-04-11 22:07:37 CEST STATEMENT:  insert into alf_server (id, version, ip_address)         values ($1, $2, $3)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The above lines repeat many times.

[tony_carrillo]

I have exactly the same issue trying to upgrade to any version over 3.3. I tried going to 4 which doesn't come with the MySQL bundle. I tried 3.4d and couldn't make it work with my data. I tried 3.4c and I'm getting exactly the same error. It doesn't matter which set of instructions are there the basic installation works but not the upgrade. If I'm re-install 3.3 and restore the data then it works.

I installed the desired version. I try it and works well. I configure the authentication and else until I feel confident. I drop the database and re-create it. I restore my data backup (MySQL and alf_data). I set my repository file to recreate indexes. And that's it…..

16:35:40,252  INFO  [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: C:\Alfresco2\alf_data‍

I have done the backup and restore in a couple of different ways and it doesn't work (cold, hot, any). I need to upgrade because webfolders (webdav) doesn't work for WIndows 7 in the 3.0 stable version. ANy help would be tremendously appreciated.

Tony

[chrisjscott]

I'll followup to say that I solved this issue by reluctantly taking my Alfresco instance offline, taking a cold backup and performing the upgrade procedure into a new instance, restoring my cold backup and porting my config into the newer properties file.

The content was fine but I then hit this issue https://forums.alfresco.com/en/viewtopic.php?f=47&t=38458 where my Alfresco was now useless.

After a lot of pain to upgrade and eventually having to rollback I am still running Alfresco 3.3. I got a similar story from a friend who runs the Enterprise edition on a similarly failed upgrade attempt that required an up-to-the-minute fix from the Developers under his support contract. In summary, I won't be using Alfresco again.

Cheers
Chris

[tony_carrillo]

Alfresco 3.4 doesn't work with upgrades….. I gave up trying.