Failed to update the CRC32 value for node ID

kaiou — Mon, 19 Apr 2010 08:47:17 GMT

Halloupgrade process of 3.2.0 alfresco installation to 3.2r2 or 3.3 give me this error..10:25:39,493 INFO [admin.patch.PatchExecuter] Applying patch 'patch.fixNameCrcValues-2' (Fixes name and qname CRC32 values to match UTF-8 encoding.).10:25:44,941 Userystem INFO [patch.impl.FixNameCrcValue

Re: Failed to update the CRC32 value for node ID

derek — Wed, 21 Apr 2010 21:01:33 GMT

Hi,
It looks like a problem with 2 nodes and is probably something that can be manually fixed before rerunning the patch. But first, we need the root cause of the problem. Run the patch again (perhaps on a staging environment) with the following debug:

log4j.logger.org.alfresco.repo.admin.patch.impl.FixNameCrcValuesPatch=DEBUG‍

. This should dump full stack traces of the problems causing the update to fail.
Regards

Re: Failed to update the CRC32 value for node ID

kaiou — Mon, 26 Apr 2010 09:32:38 GMT

Hallo

thanks for reply

i have added this attribute into log4j.properties, but after relaunch migration process, the output is the same..

11:15:37,424 WARN  [org.alfresco.repo.admin.patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 16.663: 
   Node name: LOCAZIONE MAGAZZINO 120107 
   name CRC old: -17.380 
   name CRC new: 2.958.191.274 
   Node qname: {http://www.alfresco.org/model/system/1.0}archivedItem 
   qname CRC old: 0 
   qname CRC new: 3.449.115.622 
   Error: could not update: [org.alfresco.repo.domain.hibernate.ChildAssocImpl#17380]   
11:15:37,756 WARN  [org.alfresco.repo.admin.patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 23.865: 
   Node name: CMTA80_THEBODYSHOP 
   name CRC old: -24.080 
   name CRC new: 3.036.699.582 
   Node qname: {http://www.alfresco.org/model/system/1.0}archivedItem 
   qname CRC old: 0 
   qname CRC new: 3.449.115.622 
   Error: could not update: [org.alfresco.repo.domain.hibernate.ChildAssocImpl#24080]   
11:15:39,426 WARN  [org.alfresco.repo.admin.patch.impl.FixNameCrcValuesPatch$HibernateHelper] FixNameCrcValuesPatch: Failed to process entry "22503".
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not load an entity: [org.alfresco.repo.domain.hibernate.ChildAssocImpl#10334]; uncategorized SQLException for SQL [select childassoc0_.id as id5_0_, childassoc0_.version as version5_0_, childassoc0_.parent_node_id as parent3_5_0_, childassoc0_.type_qname_id as type4_5_0_, childassoc0_.child_node_name_crc as child5_5_0_, childassoc0_.child_node_name as child6_5_0_, childassoc0_.child_node_id as child7_5_0_, childassoc0_.qname_ns_id as qname8_5_0_, childassoc0_.qname_localname as qname9_5_0_, childassoc0_.qname_crc as qname10_5_0_, childassoc0_.is_primary as is11_5_0_, childassoc0_.assoc_index as assoc12_5_0_ from alf_child_assoc childassoc0_ where childassoc0_.id=?]; 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:83)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
   at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
   at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
   at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
   at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
   at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:512)
   at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:506)
   at org.alfresco.repo.admin.patch.impl.FixNameCrcValuesPatch$HibernateHelper$1.process(FixNameCrcValuesPatch.java:203)
   at org.alfresco.repo.admin.patch.impl.FixNameCrcValuesPatch$HibernateHelper$1.process(FixNameCrcValuesPatch.java:255)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.execute(BatchProcessor.java:599)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:321)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.run(BatchProcessor.java:645)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
   at java.lang.Thread.run(Thread.java:637)
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:2062)
   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
   at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
   at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
   at org.hibernate.loader.Loader.doQuery(Loader.java:674)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
   at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
   at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
   at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
   at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3049)
   at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:399)
   at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
   at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
   at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
   at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
   at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
   at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
   at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
   at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:519)
   at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
   … 11 more
11:15:39,779 WARN  [org.alfresco.repo.admin.patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 23.865: 
   Node name: CMTA80_THEBODYSHOP 
   name CRC old: -24.080 
   name CRC new: 3.036.699.582 
   Node qname: {http://www.alfresco.org/model/system/1.0}archivedItem 
   qname CRC old: 0 
   qname CRC new: 3.449.115.622 
   Error: could not update: [org.alfresco.repo.domain.hibernate.ChildAssocImpl#24080]   
11:15:41,120 INFO  [org.alfresco.repo.admin.patch.impl.FixNameCrcValuesPatch$HibernateHelper] FixNameCrcValuesPatch: Processed 34000 entries out of 34674. 98% complete. Rate: 54 per second. 31 failures detected.
11:15:41,196 WARN  [org.alfresco.repo.admin.patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 23.865: 
   Node name: CMTA80_THEBODYSHOP 
   name CRC old: -24.080 
   name CRC new: 3.036.699.582 
   Node qname: {http://www.alfresco.org/model/system/1.0}archivedItem 
   qname CRC old: 0 
   qname CRC new: 3.449.115.622 
   Error: could not update: [org.alfresco.repo.domain.hibernate.ChildAssocImpl#24080]   
11:15:41,944 WARN  [org.alfresco.repo.admin.patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 23.865: 
   Node name: CMTA80_THEBODYSHOP 
   name CRC old: -24.080 
   name CRC new: 3.036.699.582 
   Node qname: {http://www.alfresco.org/model/system/1.0}archivedItem 
   qname CRC old: 0 
   qname CRC new: 3.449.115.622 
   Error: could not update: [org.alfresco.repo.domain.hibernate.ChildAssocImpl#24080]   ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

i have found another information..

into the error list, sometimes appear this exception.
Olso after this error the application run ok..

Re: Failed to update the CRC32 value for node ID

derek — Mon, 26 Apr 2010 10:22:18 GMT

Hi,
The worst case would be that you would be able to create a duplicately-named folder for the ones that failed. The exception you are getting needs to be dealt with; it is a PostgreSQL-specific problem and requires the use of Savepoint to fix.
https://issues.alfresco.com/jira/browse/ALF-2591
Regards

Re: Failed to update the CRC32 value for node ID

walid — Wed, 16 Mar 2011 14:28:38 GMT

Hello,
i'm an Alfresco newbie,
You're talking here about running the patch again and this is exactly my problem.
i'm using AMP module, first time i installed the module i saw patches executing, but after that, it's like there is no patch.
I don't know exactly what informations i have to post to be more clear, so please don't hesitate to ask me.

Best regards

Re: Failed to update the CRC32 value for node ID

derek — Wed, 16 Mar 2011 15:53:43 GMT

Patches only run once. They are really patches. If you have an AMP, you can write components that implement org.alfresco.repo.module.ModuleComponent (AbstractModuleComponent). The module startup code calls these when the module is started.

Re: Failed to update the CRC32 value for node ID

walid — Wed, 16 Mar 2011 16:30:30 GMT

thanks for your replay,
i just found the solution :
using org.alfresco.repo.module.ImporterModuleComponent to write a bean in module-context.xml and set the property executeOnceOnly to false.
in fact http://forums.alfresco.com/en/viewtopic.php?t=6448 helped me a lot,
but my question is, how developer test patches if it runs only once ? if i modify the patch how would i test it ?

thanks again

topic Re: Failed to update the CRC32 value for node ID in Alfresco Archive

Failed to update the CRC32 value for node ID

Re: Failed to update the CRC32 value for node ID

Re: Failed to update the CRC32 value for node ID

Re: Failed to update the CRC32 value for node ID

Re: Failed to update the CRC32 value for node ID

Re: Failed to update the CRC32 value for node ID

Re: Failed to update the CRC32 value for node ID