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.

Failed to update the CRC32 value for node ID

kaiou

Hallo

upgrade 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 User:System INFO  [patch.impl.FixNameCrcValuesPatch$HibernateHelper] FixNameCrcValuesPatch: Commencing batch of 20023 entries
10:25:49,922  INFO  [patch.impl.FixNameCrcValuesPatch$HibernateHelper] FixNameCrcValuesPatch: Processed 1000 entries out of 20023. 5% complete. Rate: 200 per second. 0 failures detected.
10:25:51,233  WARN  [patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 1.553: 
   Node name: contratto 
   name CRC old: -8.658 
   name CRC new: 70.795.465 
   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#8658]   
10:25:51,300  WARN  [patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 1.572: 
   Node name: contratto 
   name CRC old: -8.710 
   name CRC new: 70.795.465 
   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#8710]   
10:25:51,400  WARN  [patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 1.553: 
   Node name: contratto 
   name CRC old: -8.658 
   name CRC new: 70.795.465 
   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#8658]   
10:25:51,425  WARN  [patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 1.572: 
   Node name: contratto 
   name CRC old: -8.710 
   name CRC new: 70.795.465 
   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#8710]   
10:25:51,536  WARN  [patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 1.553: 
   Node name: contratto 
   name CRC old: -8.658 
   name CRC new: 70.795.465 
   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#8658]   
10:25:51,560  WARN  [patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 1.572: 
   Node name: contratto 
   name CRC old: -8.710 
   name CRC new: 70.795.465 
   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#8710]   
10:25:51,669  WARN  [patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 1.553: 
   Node name: contratto 
   name CRC old: -8.658 
   name CRC new: 70.795.465 
   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#8658]   
10:25:51,699  WARN  [patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 1.572: 
   Node name: contratto 
   name CRC old: -8.710 
   name CRC new: 70.795.465 
   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#8710]   
10:25:51,934  WARN  [patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 1.553: 
   Node name: contratto 
   name CRC old: -8.658 
   name CRC new: 70.795.465 
   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#8658]   
10:25:52,028  WARN  [patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 1.572: 
   Node name: contratto 
   name CRC old: -8.710 
   name CRC new: 70.795.465 
   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#8710]   
10:25:52,287  WARN  [patch.impl.FixNameCrcValuesPatch$HibernateHelper] Failed to update the CRC32 value for node ID 1.553: 
   Node name: contratto 
   name CRC old: -8.658 
   name CRC new: 70.795.465 
   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#8658]   
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

my filesystem have many documents to import.

after this big exception list, if there are not other errors, on 3.2r2, the system it's work ok, but this errors are very strange..

please, help!
i use postgresql on mac osx leopard and snow leopard

Thanks

Find more posts tagged with

Comments

derek

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

kaiou

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

derek

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

walid

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

derek

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.

walid

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