nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Migration from 5.0 to 6.0.5

eee777

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!

Find more posts tagged with

Alfresco Content Services

Comments

eee777

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

sistemi

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

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: jdbcostgresql://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.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.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