topic can 2.1 upgrade to lastest 3.2 directly ? in Alfresco Archive

can 2.1 upgrade to lastest 3.2 directly ?

yahoon — Wed, 08 Jul 2009 02:28:38 GMT

my alfresco is 2.1 ,running on RHEL 5I want to upgrade to the latest 3.2 ,can I do it directly ?I will appreciate if there is a guide provided.thanks

Re: can 2.1 upgrade to lastest 3.2 directly ?

yahoon — Wed, 08 Jul 2009 07:40:10 GMT

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.

Re: can 2.1 upgrade to lastest 3.2 directly ?

mikeh — Wed, 08 Jul 2009 07:51:42 GMT

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

Re: can 2.1 upgrade to lastest 3.2 directly ?

yahoon — Thu, 09 Jul 2009 07:37:22 GMT

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 ?

Re: can 2.1 upgrade to lastest 3.2 directly ?

mikeh — Thu, 09 Jul 2009 19:15:17 GMT

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

Re: can 2.1 upgrade to lastest 3.2 directly ?

yahoon — Fri, 10 Jul 2009 02:01:21 GMT

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~

Re: can 2.1 upgrade to lastest 3.2 directly ?

yahoon — Mon, 13 Jul 2009 00:03:17 GMT

can someone help me or give some ideas ?

Re: can 2.1 upgrade to lastest 3.2 directly ?

_sax — Tue, 14 Jul 2009 16:30:16 GMT

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?

Re: can 2.1 upgrade to lastest 3.2 directly ?

_sax — Wed, 15 Jul 2009 18:51:34 GMT

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).

Re: can 2.1 upgrade to lastest 3.2 directly ?

jarregui — Wed, 19 Aug 2009 10:44:07 GMT

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