Migration from 5.0 to 6.0.5

cancel
Showing results for 
Search instead for 
Did you mean: 
eee777
Member II

Migration from 5.0 to 6.0.5

Hello everyone,

I'm trying to upgrade our Alfresco CE from 5.0 to the latest 6. Also i wanted to switch from PostgreSQL to mariaDB. So, i have installed a new CentOS7 instance with Tomcat, mariaDB and nginx as reverse proxy. Alfresco deployment went well and i was able to access the share as well as the admin console. I have moved the alf_data content and migrated the PostgreSQL database from the old instance to mariaDB. Now the issue is that the alfresco service does not start because of the database schema auto-update:

2019-01-24 15:25:30,332 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.alfresco.repo.domain.dialect.MySQLInnoDBDialect.

2019-01-24 15:25:30,373 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Another cluster node is doing a DB schema initialization or DB update. Waiting for the other node to finish...

2019-01-24 15:25:30,373 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] DB lock failed on schema bootstrap. Attempt: 0

2019-01-24 15:25:35,381 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Another cluster node is doing a DB schema initialization or DB update. Waiting for the other node to finish...

2019-01-24 15:25:35,381 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] DB lock failed on schema bootstrap.

2019-01-24 15:27:30,518 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed

org.alfresco.error.AlfrescoRuntimeException: 00240000 A long running upgrade was found to be running on another node of the cluster. This node is shutting down.

2019-01-24 15:27:30,519 ERROR [org.springframework.web.context.ContextLoader] [localhost-startStop-1] Context initialization failed

org.alfresco.error.AlfrescoRuntimeException: 00240001 Schema auto-update failed

2019-01-24 15:27:30,809 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopping 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]

2019-01-24 15:27:30,810 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopped 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]

2019-01-24 15:27:31,456 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopping 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]

2019-01-24 15:27:31,456 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopped 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]

It's a single instance, there is no cluster or other node. Any suggestions how to fix it? Did i miss something during the migration?

Thank you for your time!

5 Replies
eee777
Member II

Re: Migration from 5.0 to 6.0.5

Ok, just realised that i did not stop the old alfresco instance during the database migration. I'll give it another try...

sistemi
Active Member II

Re: Migration from 5.0 to 6.0.5

Maybe you could try to first migrate from PostgreSQL to MariaDB keeping Alfresco at version 5, then upgrade Alfresco 5 (on MariaDB) to Alfresco 6. 

Take also a look at db.schema.update option in alfresco-global.properties .

However, how did you manage to migrate the database from PostgreSQL to MariaDB?

eee777
Member II

Re: Migration from 5.0 to 6.0.5

I've used MySQL Workbench to migrate from PostgreSQL to MySQL. Also i've changed schema.update to false:

db.schema.update=false

But i've got another error:

2019-01-29 15:07:51,082 INFO  [org.alfresco.repo.admin] [localhost-startStop-1] Connected to database MySQL version 5.5.60-MariaDB

.....

2019-01-29 15:10:14,375 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Bypassing schema update checks.

2019-01-29 15:10:14,981 ERROR [org.springframework.web.context.ContextLoader] [localhost-startStop-1] Context initialization failed

org.alfresco.error.AlfrescoRuntimeException: 00290001 Workflow deployment failed

Caused by: org.alfresco.error.AlfrescoRuntimeException: 00290000 Required path not found: {http://www.alfresco.org/model/system/1.0}authorities

No luck with postgres to postgres migration as well - invalid keystore eand permissions error.

Not sure if this config is correct:

dir.root=/usr/share/tomcat/webapps/alfresco/alf_data

#dir.keystore=${dir.root}/keystore

[root@docs alf_data]# ls

contentstore  contentstore.deleted  keystore  oouser  postgresql  solr4  solr4Backup

I've granted all permissions to the postgresql user but still:

ERROR: permission denied for relation alf_prop_class

2019-01-29 14:50:37,744 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Authentication' subsystem, ID: [Authentication, managed, ldap-ad1] complete

2019-01-29 14:50:40,833 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor Repository Template Processor for extension ftl

2019-01-29 14:50:40,835 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor Repository Script Processor for extension js

2019-01-29 14:50:43,792 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]

2019-01-29 14:50:43,860 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete

2019-01-29 14:50:43,942 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbcSmiley Tongueostgresql://localhost:5432/alfresco, UserName=alfresco, PostgreSQL JDBC Driver

2019-01-29 14:50:43,942 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.alfresco.repo.domain.dialect.PostgreSQLDialect.

2019-01-29 14:50:43,955 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Bypassing schema update checks.

2019-01-29 14:51:20,284 ERROR [org.springframework.web.context.ContextLoader] [localhost-startStop-1] Context initialization failed

org.alfresco.error.AlfrescoRuntimeException: 00290039 Keystores are invalid

at org.alfresco.encryption.EncryptionChecker$1.execute(EncryptionChecker.java:78)

at org.alfresco.encryption.EncryptionChecker$1.execute(EncryptionChecker.java:1)

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

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

at org.alfresco.encryption.EncryptionChecker.onBootstrap(EncryptionChecker.java:67)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:1149)

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

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

Caused by: org.springframework.jdbc.UncategorizedSQLException:

### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

### The error may exist in alfresco/ibatis/#resource.dialect#/propval-common-SqlMap.xml

### The error may involve alfresco.propval.select_PropertyClassByName-Inline

### The error occurred while setting parameters

### SQL: select             *         from             alf_prop_class         where             java_class_name_crc = ? and             java_class_name_short = ?

### Cause: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

; uncategorized SQLException; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:421)

at com.sun.proxy.$Proxy20.selectOne(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)

at org.alfresco.repo.domain.propval.ibatis.PropertyValueDAOImpl.findClassByValue(PropertyValueDAOImpl.java:145)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyClassCallbackDAO.findByValue(AbstractPropertyValueDAOImpl.java:370)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyClassCallbackDAO.findByValue(AbstractPropertyValueDAOImpl.java:1)

at org.alfresco.repo.cache.lookup.EntityLookupCache.getByValue(EntityLookupCache.java:405)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.getPropertyClass(AbstractPropertyValueDAOImpl.java:320)

at org.alfresco.repo.domain.propval.ibatis.PropertyValueDAOImpl.findPropertyValueByValue(PropertyValueDAOImpl.java:350)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyValueCallbackDAO.findByValue(AbstractPropertyValueDAOImpl.java:813)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyValueCallbackDAO.findByValue(AbstractPropertyValueDAOImpl.java:1)

at org.alfresco.repo.cache.lookup.EntityLookupCache.getByValue(EntityLookupCache.java:405)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.getPropertyValue(AbstractPropertyValueDAOImpl.java:737)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.deletePropertyUniqueContext(AbstractPropertyValueDAOImpl.java:1483)

at org.alfresco.repo.attributes.AttributeServiceImpl.removeAttribute(AttributeServiceImpl.java:273)

at org.alfresco.encryption.EncryptionKeysRegistryImpl.isKeyRegistered(EncryptionKeysRegistryImpl.java:140)

at org.alfresco.encryption.AlfrescoKeyStoreImpl.validateKeys(AlfrescoKeyStoreImpl.java:913)

at org.alfresco.encryption.AlfrescoKeyStoreImpl.validateKeys(AlfrescoKeyStoreImpl.java:188)

at org.alfresco.encryption.KeyStoreChecker.validateKeyStores(KeyStoreChecker.java:49)

at org.alfresco.encryption.EncryptionChecker$1.execute(EncryptionChecker.java:73)

... 29 more

Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)

at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)

at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)

at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:144)

at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62)

at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)

at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)

at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)

at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:73)

at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source)

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

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

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:408)

... 48 more

Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for relation alf_prop_class

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)

at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)

at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)

at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:144)

at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)

at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62)

at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)

at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)

at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)

at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:73)

at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source)

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

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

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:408)

at com.sun.proxy.$Proxy20.selectOne(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)

at org.alfresco.repo.domain.propval.ibatis.PropertyValueDAOImpl.findClassByValue(PropertyValueDAOImpl.java:145)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyClassCallbackDAO.findByValue(AbstractPropertyValueDAOImpl.java:370)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyClassCallbackDAO.findByValue(AbstractPropertyValueDAOImpl.java:1)

at org.alfresco.repo.cache.lookup.EntityLookupCache.getByValue(EntityLookupCache.java:405)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.getPropertyClass(AbstractPropertyValueDAOImpl.java:320)

at org.alfresco.repo.domain.propval.ibatis.PropertyValueDAOImpl.findPropertyValueByValue(PropertyValueDAOImpl.java:350)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyValueCallbackDAO.findByValue(AbstractPropertyValueDAOImpl.java:813)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyValueCallbackDAO.findByValue(AbstractPropertyValueDAOImpl.java:1)

at org.alfresco.repo.cache.lookup.EntityLookupCache.getByValue(EntityLookupCache.java:405)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.getPropertyValue(AbstractPropertyValueDAOImpl.java:737)

at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.getPropertyUniqueContext(AbstractPropertyValueDAOImpl.java:1264)

at org.alfresco.repo.attributes.AttributeServiceImpl.getAttribute(AttributeServiceImpl.java:110)

at org.alfresco.encryption.EncryptionKeysRegistryImpl.isKeyRegistered(EncryptionKeysRegistryImpl.java:135)

... 33 more

2019-01-29 14:51:20,376 WARN  [org.springframework.web.context.support.XmlWebApplicationContext] [localhost-startStop-1] Exception thrown from ApplicationListener handling ContextClosedEvent

java.lang.NullPointerException

at org.alfresco.repo.workflow.activiti.ActivitiEngineInitializer.onShutdown(ActivitiEngineInitializer.java:65)

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

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

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

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

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

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

at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:996)

at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:963)

at org.springframework.web.context.ContextLoader.closeWebApplicationContext(ContextLoader.java:525)

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

at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:5165)

at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5829)

at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:221)

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

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

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

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

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

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

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:1149)

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

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

2019-01-29 14:51:20,710 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopping 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]

2019-01-29 14:51:20,710 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopped 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]

2019-01-29 14:51:21,488 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopping 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]

2019-01-29 14:51:21,488 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Stopped 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]

2019-01-29 14:51:21,489 INFO  [org.alfresco.repo.management.subs

hiten_rastogi1
Established Member

Re: Migration from 5.0 to 6.0.5

Hi Evgeni,

Did you kept the db user same while migration means while dumping and restoring??

I am not sure but after looking at your logs and in particular ERROR: permission denied for relation alf_prop_class

I think the db user issue can be there.

Cheers

Hiten Rastogi

eee777
Member II

Re: Migration from 5.0 to 6.0.5

Hello Hitem, 

I've managed to fix the permission error - somehow the alfresco user has been replaced with default postgres user during the restore. Now the database is imported with correct permissions. Now the error message is:

### Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: column "has_graphical_notation_" of relation "act_re_procdef" does not exist

  Position: 161

### The error may involve org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.insertProcessDefinition-Inline

### The error occurred while setting parameters

### SQL: insert into ACT_RE_PROCDEF(ID_, REV_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, DESCRIPTION_, HAS_START_FORM_KEY_, HAS_GRAPHICAL_NOTATION_ , SUSPENSION_STATE_, TENANT_ID_)     values (?,       1,             ?,             ?,             ?,              ?,             ?,             ?,             ?,             ?,             ?,             ?,             ?,             ?)

### Cause: org.postgresql.util.PSQLException: ERROR: column "has_graphical_notation_" of relation "act_re_procdef" does not exist

  Position: 161

That column does not exist at the old database as well. Probably it does not exist at alfresco v5 and has been added to v6 ... I will verify that and try to add it manually but i'll need to make a fresh install and check the data type (varchar, int4, bool) and length, precision etc parameters ...