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.

can 2.1 upgrade to lastest 3.2 directly ?

yahoon

my alfresco is 2.1 ,running on RHEL 5

I want to upgrade to the latest 3.2 ,can I do it directly ?
I will appreciate if there is a guide provided.
thanks

Find more posts tagged with

Comments

yahoon

I put my upgrade setps here ,waiting for someone's help

1.backup 2.1
I make a cold backup of 2.1 ,including alf_data and database 'alfresco'

2. clean the database :
delete the database 'alfresco' and mysql user 'alfresco'

3 install the 3.2
In X window ,I run the binnary file 'Alfresco-Community-3.2-Linux-x86-Install'
followed the steps.
there is a error showing ' no database selected ' while database configuration after I input the root password for mysql
I was requested to create database manually –so I excute the sql file /opt/Alfresco/extras/databases/mysql/db_setup.sql

5.start the 3.2.
the process runs well. I login the web to test ,it's OK

6. stop 3.2 and restore
I stopped the 3.2 ,replace the dir " alf_data"
problems comes when do database restore:

because the schema structure is very different between these 2 versions, I can't import the 2.1's database into current 3.2 directly. that gives a error about table creation.
I delete current 3.2's database , and then create a new empty database 'alfresco'
then import 2.1's data into it.

7 start 3.2 again to check
run ./alfresco start
here is the error log in catalina.out

CompilerOracle: exclude org/apache/lucene/index/IndexReader$1.doBody
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeIndexes
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeDeletions
Jul 8, 2009 12:55:03 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Jul 8, 2009 12:55:03 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 2241 ms
Jul 8, 2009 12:55:03 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jul 8, 2009 12:55:03 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
Jul 8, 2009 12:55:09 PM org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
12:55:24,252 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
12:55:24,262 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
12:55:24,262 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/opt/Alfresco/tomcat/shared/classes/alfresco-global.properties]
12:55:24,467 INFO [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
12:56:10,229 INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
12:56:12,157 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-4529000446093758889.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-2.2-ACL.sql).
12:56:12,563 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-425328895680704456.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-0-create-missing-tables.sql).
12:56:12,653 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-6258796912318052683.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-from-2.1.sql).
12:56:54,667 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-1451674242560880216.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-Person.sql).
12:56:55,789 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-5247906010772112227.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-3.2-LockTables.sql).
12:56:55,842 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-1414440673678517107.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-3.2-ContentTables.sql).
12:56:57,053 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-4756328473060002574.sql (Generated).
12:56:57,185 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-8317864838983384164.sql (Copied from classpath:alfresco/dbscripts/upgrade/1.4/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-1.4-TxnCommitTimeIndex.sql).
12:56:57,216 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-3380248966631796380.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.0/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-2.0-ContentUrls.sql).
12:56:57,275 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-1246807474960636357.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.1/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-2.1-RemoveWcmSubmittedAspect.sql).
12:56:57,303 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-5835782037585690276.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoSchemaUpdate-2.1-AuditPathIndex.sql).
12:56:57,350 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-15304077666539594.sql (Copied from classpath:alfresco/dbscripts/create/3.0/org.hibernate.dialect.MySQLInnoDBDialect/create-activities-extras.sql).
12:56:57,497 INFO [domain.schema.SchemaBootstrap] Executing database script /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2744271062741261225.sql (Copied from classpath:alfresco/dbscripts/upgrade/3.2/org.hibernate.dialect.MySQLInnoDBDialect/remove-AVM-issuer.sql).
12:56:57,625 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
   SQL: drop table avm_issuer_ids
   Error: Unknown table 'avm_issuer_ids'
   File: /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2744271062741261225.sql
   Line: 45
12:56:57,627 ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'avm_issuer_ids'
   …

Jul 8, 2009 12:56:57 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Jul 8, 2009 12:56:57 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
Jul 8, 2009 12:57:02 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
12:57:10,149 INFO [web.site.FrameworkHelper] Successfully Initialized Web Framework

the result is that
when I open the url http://localhost:8080/alfresco/
it shows
[img]http://crm.infonaligy.com/a.jpg[/img]

if there is any problem ,pls tell me , thanks.

mikeh

The problem is evident in the log file:

SQL: drop table avm_issuer_ids
Error: Unknown table 'avm_issuer_ids'‍‍

Try manually creating the table and restarting Alfresco again. You *may* need to also drop an alf_bootstrap_lock table.

Thanks,
Mike

yahoon

thanks for your reply
but there comes another error.

I repeat steps 1-6 above.
then I created an empty table 'avm_issuer_ids' as you indicate
there isn't an alf_bootstrap_lock table existing to delete,so I did nothing about this.

then I start the program.

here is the error log from catalina.out:

14:48:55,475 Userystem INFO [admin.patch.PatchExecuter]      Applying patch 'patch.redeployInvitationProcess' (Re-deploy Invitation Process Definitions.).
14:48:56,064 Userystem INFO [admin.patch.PatchExecuter]      Applying patch 'patch.authorityMigration' (Copies any old authorities from the user store to the spaces store.).
14:49:00,327 Userystem INFO [admin.patch.PatchExecuter]      Applying patch 'patch.authorityDefaultZonesPatch' (Adds groups and people to the appropriate zones for wcm, share and everything else.).
14:49:00,900 Userystem ERROR [admin.patch.PatchExecuter] 06090002 java.lang.IllegalStateException: Non-unique path: found : /app:company_home/app:user_homes 0
    …

14:49:01,433 Userystem ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 06090003 Not all patches could be applied
        at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:124)
        at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:132)
       …
Jul 9, 2009 2:49:01 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Jul 9, 2009 2:49:01 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
Jul 9, 2009 2:49:08 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
14:49:18,109 INFO [web.site.FrameworkHelper] Successfully Initialized Web Framework
…

I got the same error in the web page.

it seems there is some error when applying the patch patch.authorityDefaultZonesPatch . what should I do ?

mikeh

It looks like you've deleted the User Homes space at some point on your v2.1 install - and the patch expects it to be there.

What happens if you just restart the app again? If it still fails, then you'll have to write a quick script to create the User Homes space again (with the app:user_homes type) and try the upgrade again.

Thanks,
Mike

yahoon

thanks for your reply
It fails again while restarting ,here is the log:

14:46:17,666 INFO [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/opt/Alfresco/tomcat/shared/classes/alfresco-global.properties]
14:46:17,818 INFO [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:46:52,055 INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
14:46:57,630 INFO [domain.schema.SchemaBootstrap] No changes were made to the schema.
14:47:05,315 Userystem WARN [node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.
14:47:06,088 Userystem INFO [management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [default]
14:47:06,133 Userystem INFO [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:47:10,044 Userystem WARN [alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
14:47:10,048 Userystem INFO [management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [default] complete
14:47:10,594 Userystem INFO [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /opt/Alfresco/alf_data
14:47:10,922 Userystem INFO [admin.patch.PatchExecuter] Checking for patches to apply …
14:47:11,592 Userystem INFO [admin.patch.PatchExecuter]      Applying patch 'patch.authorityDefaultZonesPatch' (Adds groups and people to the appropriate zones for wcm, share and everything else.).
14:47:14,247 Userystem ERROR [admin.patch.PatchExecuter] 06100000 java.lang.IllegalStateException: Non-unique path: found : /app:company_home/app:user_homes 0
        at org.alfresco.repo.security.person.AbstractHomeFolderProvider.resolvePath(AbstractHomeFolderProvider.java:259)
…….

14:47:15,981 Userystem ERROR [admin.patch.PatchExecuter]
=== Failed to apply patch         ===
ID: patch.authorityDefaultZonesPatch
RESULT:
06100000 java.lang.IllegalStateException: Non-unique path: found : /app:company_home/app:user_homes 0
        at org.alfresco.repo.security.person.AbstractHomeFolderProvider.resolvePath(AbstractHomeFolderProvider.java:259)
    ……

14:47:15,985 Userystem ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 06100001 Not all patches could be applied
        at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:124)
……

Jul 10, 2009 2:47:15 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Jul 10, 2009 2:47:16 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
Jul 10, 2009 2:47:21 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
14:47:28,074 INFO [web.site.FrameworkHelper] Successfully Initialized Web

[size=150]1[/size]
14:47:05,315 Userystem WARN [node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.
I don't know why it comes and whether ti's a problem to cause the error.

[size=150]2[/size]
14:47:14,247 Userystem ERROR [admin.patch.PatchExecuter] 06100000 java.lang.IllegalStateException: Non-unique path: found : /app:company_home/app:user_homes 0
in my 2.1 I can access "Company Home > User Homes " in the browser,and see the users under it. why it fails here?
if I have to write the script as you referred, I have no idea about this.is it a shell script or java script? when and where it should be run? more important ,how to write , is there a guide or example of script?

[size=150]3[/size]
My 2.1 was in /usr/local/alfresco , 3.2 is installed in the default /opt/Alfresco, does this affect ?

it looks to be my final problem to complete it, thanks so much for you help~

yahoon

can someone help me or give some ideas ?

_sax

3.) Should not interfere with your installation.
2.) Can only work, if you have a backup of your 2.1 installation (alf_data and database dump required).
You then could rebuild your user_homes directory with a http://wiki.alfresco.com/wiki/JavaScript_API JavaScript, I guess.
This is runable from within Alfresco and is the only way to let a space of the special type app:user_homes type be created.
But if you have those folders in 2.1 it means, that the problem lies somewhere else.

4.)

I tried an upgrade from 2.9b and ran into the 'avm_issuer_ids' problem, which I fixed through creating such a table

use alfresco;
create table avm_issuer_ids (columnwithoutaname char(50));

After starting a freshly copied alf_data and database with that enhancement, i got
[…]

18:10:42,813 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Normalized schema (pre-bootstrap) dumped to file /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-4194886369618814342-Startup.xml.
18:10:42,813 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Normalized schema (post-bootstrap) dumped to file /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-8438334930975435407.xml.
18:10:45,894 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 06140000 Reindex failure for org.alfresco.repo.node.index.FullIndexRecoveryComponent
[…]
Caused by: java.lang.RuntimeException: Error during run with lock.
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2273)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo.<init>(IndexInfo.java:575)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo.getIndexInfo(IndexInfo.java:365)
        at org.alfresco.repo.search.impl.lucene.AbstractLuceneBase.initialise(AbstractLuceneBase.java:106)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.getSearcher(ADMLuceneSearcherImpl.java:147)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerAndSearcherFactory.getSearcher(ADMLuceneIndexerAndSearcherFactory.java:119)
        at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory.getSearcher(AbstractLuceneIndexerAndSearcherFactory.java:467)
        at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory.getSearcher(AbstractLuceneIndexerAndSearcherFactory.java:89)
        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.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
        at $Proxy34.getSearcher(Unknown Source)
        at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:83)
        at org.alfresco.repo.node.index.AbstractReindexComponent.isTxnIdPresentInIndex(AbstractReindexComponent.java:450)
        at org.alfresco.repo.node.index.AbstractReindexComponent.isTxnPresentInIndex(AbstractReindexComponent.java:375)
        at org.alfresco.repo.node.index.AbstractReindexComponent.areTxnsInIndex(AbstractReindexComponent.java:539)
        at org.alfresco.repo.node.index.FullIndexRecoveryComponent.reindexImpl(FullIndexRecoveryComponent.java:194)
        at org.alfresco.repo.node.index.AbstractReindexComponent$1.execute(AbstractReindexComponent.java:256)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:252)
        at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:262)
        … 36 more
Caused by: java.io.IOException: read past EOF
[…]

Could that be connected with the re-indexing that was mentioned with yahoons 2.1 installation?

_sax

I suspect that it's an integrity problem with the database.
Another upgrade of a newly populated 2.9b went straight to 3.2 even with CIFS, LDAP and NTLM activated.
So these problems often are ones of a special installation having had issues before (under the hood).

jarregui

Hi,

I solved the user_homes problem modifying the database. This should be rather trivial for an Alfresco developer used to dig into the database. For me, it was the first time I had a look at it, so it took some time to understand what to do…

As I read in https://issues.alfresco.com/jira/browse/ETWOONE-10 , the problem is that after renaming the User Homes folder, the node is linked to model/content instead of model/application . And the patch to be applied in the migration is searching for /app:company_home/app:user_homes. So, what I did:

- I first located the node, looking at alf_node_properties and searching for the new caption I assigned to the folder ('Areas Personales'). I also took into account only the first created nodes (<1000) to avoid a long query to the database. In a fresh 2.1 installation, the node_id is 22 . This is the conflicting node.

mysql>set names utf8;
mysql> select  * from alf_node_properties where node_id < 1000 and string_value = 'Áreas Personales';
+———+———-+———–+————+—————+——————+—————+————+————-+————–+——————-+——————–+
| node_id | qname_id | locale_id | list_index | actual_type_n | persisted_type_n | boolean_value | long_value | float_value | double_value | string_value      | serializable_value |
+———+———-+———–+————+—————+——————+—————+————+————-+————–+——————-+——————–+
|      22 |       60 |         1 |         -1 |             6 |                6 |               |          0 |           0 |            0 | Áreas Personales | NULL               | 
|      22 |       72 |         2 |         -1 |             6 |                6 |               |          0 |           0 |            0 | Áreas Personales | NULL               | 
+———+———-+———–+————+—————+——————+—————+————+————-+————–+——————-+——————–+
‍‍‍‍‍‍‍‍‍

- I searched for the child association in the table alf_child_assoc where the child is node 22, and updated the critical columns. To understand what I had to change, I compared with its parent, Company Home:

mysql> select *from alf_child_assoc where child_node_id = 22;
+—–+———+—————-+—————+———————+—————–+—————+————-+—————–+————+————-+
| id  | version | parent_node_id | type_qname_id | child_node_name_crc | child_node_name | child_node_id | qname_ns_id | qname_localname | is_primary | assoc_index |
+—–+———+—————-+—————+———————+—————–+—————+————-+—————–+————+————-+
| 604 |       1 |             13 |            39 |           665133697 | áreas personales      |            22 |           4 | Áreas Personales |            |  2147483647 | 
+—–+———+—————-+—————+———————+—————–+—————+————-+—————–+————+————-+
1 row in set (0.01 sec)

mysql> select *from alf_child_assoc where child_node_id = 13;
+—-+———+—————-+—————+———————+————————————–+—————+————-+—————–+————+————-+
| id | version | parent_node_id | type_qname_id | child_node_name_crc | child_node_name                      | child_node_id | qname_ns_id | qname_localname | is_primary | assoc_index |
+—-+———+—————-+—————+———————+————————————–+—————+————-+—————–+————+————-+
|  8 |       1 |             12 |           102 |                  -1 | 6befb495-8b41-11de-9d42-4de9cdccc441 |            13 |           2 | company_home    |            |  2147483647 | 
+—-+———+—————-+—————+———————+————————————–+—————+————-+—————–+————+————-+
1 row in set (0.04 sec)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Looking at the DB structure, I checked in the table alf_namespace that qname_ns_id = 2 refers to the correct http://www.alfresco.org/model/application/1.0 , but qname_ns_id = 4 refers to the wrong http://www.alfresco.org/model/content/1.0 , as expected.

Then, I did the update:

mysql> update alf_child_assoc set qname_ns_id = 2, child_node_name = 'user_homes', qname_localname = 'user_homes'  where child_node_id = 22;‍

And it worked! The migration continued and all the pending patches applied successfully.

I hope this information can help somebody.

Javier