Hyland Connect

eee777 · ‎01-24-2019

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!

eee777 · ‎01-24-2019

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

sistemi · ‎01-31-2019

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 · ‎01-31-2019

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