Upgrade Alfresco from 5.1 to 6.2

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

Upgrade Alfresco from 5.1 to 6.2

Hello,

I am trying to migrate data from an Alfresco 5.1 server to an Alfresco 6.2 server. I have installed the 6.2 on a separate CentOS 7.9 server and installed Alfresco manually. The database is postgresql11-server-11.4. I have also installed my required AMPs, the server was running okay and without errors at this point.

According to these steps https://docs.alfresco.com/content-services/6.2/upgrade/#upgrade-process I concluded that I can migrate only contentstore, contentstore.deleted and the database and solr will take care of reindexing by itself.

The steps I have done are:

  1. Backup database: (on 5.1)

./pg_dump -v -U alfresco alfresco > dumpfile.sql

    2.Backup contentstore: (on 5.1)

tar -czvf backup-contentstore.tar.gz contentstore contentstore.deleted

3. Restore data: (on 6.2)

  • systemctl stop tomcat8@alfresco

  • systemctl stop alfresco-search

  • delete contentstore and contentstore.deleted folders from /opt/alfresco6/alf_data

  • delete database

    su - postgres
    psql
    DROP database alfresco;
    create database alfresco encoding 'utf8';
    grant all on database alfresco to alfresco;\q
  • delete folders /opt/alfresco6/alf_data/solr6/solrhome/AlfrescoModels and opt/alfresco6/alf_data/solr6/solrhome/archive/index
  • restore backups: move contentstore, contentstore.deleted to /opt/alfresco6/alf_data
  • restore database: 
    su - postgres

          psql -d alfresco -f /srv/dumpfile.sql

 

Server started with this error:

 ERROR [admin.patch.PatchExecuter] [localhost-startStop-1] 09220020 org.alfresco.error.AlfrescoRuntimeException: 09220019 Bootstrap failed      at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBoo
tstrap.java:367)        at org.alfresco.repo.admin.patch.impl.GenericBootstrapPatch.applyInternal(GenericBootstrapPatch.java:130)       at org.alfresco.repo.admin.patch.AbstractPatch$1.execute(AbstractPatch.java:455)        at org.alfres
co.repo.admin.patch.AbstractPatch$1.execute(AbstractPatch.java:1)       at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:450)  at org.alfresco.repo.admin.patch.AbstractPatch.applyW
ithTxns(AbstractPatch.java:462) at org.alfresco.repo.admin.patch.AbstractPatch.access$0(AbstractPatch.java:442) at org.alfresco.repo.admin.patch.AbstractPatch$4.doWork(AbstractPatch.java:620) at org.alfresco.repo.admin.patch.AbstractPatc
h$4.doWork(AbstractPatch.java:1)        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:602)      at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:624)    at org.alfres
co.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:586) at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.applyPatch(PatchServiceImpl.java:564)       at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.execute(P
atchServiceImpl.java:477)       at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:332) at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:309)  at org.alfres
co.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:198) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)       at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.in
voke(NativeMethodAccessorImpl.java:62)  at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)    

.....

org.springframework.dao.DataIntegrityViolationException:
### Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(1024)
### The error may involve alfresco.appliedpatch.update_AppliedPatch-Inline
### The error occurred while setting parameters
### SQL: update alf_applied_patch             set                 description = ?,                 fixes_from_schema = ?,                 fixes_to_schema = ?,                 target_schema = ?,                 applied_to_schema = ?,
            applied_on_date = ?,                 applied_to_server = ?,                 was_executed = ?,                 succeeded = ?,                 report = ?             where                 id = ?
### Cause: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(1024)
; ERROR: value too long for type character varying(1024); nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(1024)
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)

 

What does this error indicate and am I doing something wrong in the steps of upgrading? Should I actually make the upgrade in-server? I am trying to avoid production server down time.

Any help would be appreciated.

Thank you.

1 Reply
angelborroy
Alfresco Employee

Re: Upgrade Alfresco from 5.1 to 6.2

You may try upgrading to 5.2 and after that upgrade to 6.2.

As reference, these are the DB patches that needs to be applied to upgrade Postgres DB from 5.1 to 6.2:

https://github.com/Alfresco/alfresco-community-repo/tree/master/repository/src/main/resources/alfres...

Hyland Developer Evangelist