Advertisement
Guest User

Log

a guest
Mar 4th, 2022
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 59.56 KB | None | 0 0
  1. 2022-03-02 10:05:34,460 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-9] Failed to update cm:modified date for node: 1555716
  2. 2022-03-02 10:05:31,178 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  3. 2022-03-02 10:05:40,901 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-7] Retrying http-nio-8080-exec-7: count 0; wait: 10ms; msg:
  4. ### Error updating database. Cause: java.sql.SQLTransactionRollbackException: (conn=761584) Deadlock: wsrep aborted transaction
  5. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  6. ### The error occurred while setting parameters
  7. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  8. ### Cause: java.sql.SQLTransactionRollbackException: (conn=761584) Deadlock: wsrep aborted transaction
  9. ; (conn=761584) Deadlock: wsrep aborted transaction; nested exception is java.sql.SQLTransactionRollbackException: (conn=761584) Deadlock: wsrep aborted transaction; exception: (org.springframework.dao.DeadlockLoserDataAccessException)
  10. 2022-03-02 10:05:40,920 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-7] Retrying http-nio-8080-exec-7: count 1; wait: 10ms; msg: FK violation updating primary parent association:ChildAssocEntity[ ID=null, typeQNameId=407, childNodeNameCrc=3315723071, childNodeName=01bb1f1c-40f1-4f8a-8506-fb8a54bd7648, qnameNamespaceId=14, qnameLocalName=01bb1f1c-40f1-4f8a-8506-fb8a54bd7648, qnameCrc=2240661961, parentNode=NodeEntity[ ID=29, version=1, store=workspace://version2Store, uuid=eb8a9f90-1964-4154-bc20-30403869da57, typeQNameId=2, localeId=2, aclId=17, transaction=TransactionEntity[ ID=11, server=null, changeTxnId=b66cc04f-f48b-43a2-8398-cec6a9bd964c, commitTimeMs=null], auditProps=null, shardKey=null], childNode=NodeEntity[ ID=1610182, version=1, store=workspace://version2Store, uuid=06af04b8-fa39-4828-86ab-52886ce96789, typeQNameId=407, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=154891, server=ServerEntity[ ID=11, ipAddress=null], changeTxnId=67af50e7-fcb1-474b-a672-ccd2641d933f, commitTimeMs=1646215540834], auditProps=AuditablePropertiesEntity[ auditCreator=john.john@john.com, auditCreated=2022-03-02T10:05:40.893Z, auditModifier=john.john@john.com, auditModified=2022-03-02T10:05:40.893Z], shardKey=null]]; nested exception is org.springframework.dao.DataIntegrityViolationException:
  11. ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`))
  12. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  13. ### The error occurred while setting parameters
  14. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  15. ### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`))
  16. ; (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`)); exception: (org.springframework.dao.ConcurrencyFailureException)
  17. 2022-03-02 10:05:40,932 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-7] Retrying http-nio-8080-exec-7: count 2; wait: 10ms; msg: FK violation updating primary parent association:ChildAssocEntity[ ID=null, typeQNameId=407, childNodeNameCrc=3315723071, childNodeName=01bb1f1c-40f1-4f8a-8506-fb8a54bd7648, qnameNamespaceId=14, qnameLocalName=01bb1f1c-40f1-4f8a-8506-fb8a54bd7648, qnameCrc=2240661961, parentNode=NodeEntity[ ID=29, version=1, store=workspace://version2Store, uuid=eb8a9f90-1964-4154-bc20-30403869da57, typeQNameId=2, localeId=2, aclId=17, transaction=TransactionEntity[ ID=11, server=null, changeTxnId=b66cc04f-f48b-43a2-8398-cec6a9bd964c, commitTimeMs=null], auditProps=null, shardKey=null], childNode=NodeEntity[ ID=1610182, version=1, store=workspace://version2Store, uuid=06af04b8-fa39-4828-86ab-52886ce96789, typeQNameId=407, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=154891, server=ServerEntity[ ID=11, ipAddress=null], changeTxnId=67af50e7-fcb1-474b-a672-ccd2641d933f, commitTimeMs=1646215540834], auditProps=AuditablePropertiesEntity[ auditCreator=john.john@john.com, auditCreated=2022-03-02T10:05:40.893Z, auditModifier=john.john@john.com, auditModified=2022-03-02T10:05:40.893Z], shardKey=null]]; nested exception is org.springframework.dao.DataIntegrityViolationException:
  18. ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`))
  19. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  20. ### The error occurred while setting parameters
  21. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  22. ### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`))
  23. ; (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`)); exception: (org.springframework.dao.ConcurrencyFailureException)
  24. 2022-03-02 10:05:40,944 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-7] Retrying http-nio-8080-exec-7: count 3; wait: 10ms; msg: FK violation updating primary parent association:ChildAssocEntity[ ID=null, typeQNameId=407, childNodeNameCrc=3315723071, childNodeName=01bb1f1c-40f1-4f8a-8506-fb8a54bd7648, qnameNamespaceId=14, qnameLocalName=01bb1f1c-40f1-4f8a-8506-fb8a54bd7648, qnameCrc=2240661961, parentNode=NodeEntity[ ID=29, version=1, store=workspace://version2Store, uuid=eb8a9f90-1964-4154-bc20-30403869da57, typeQNameId=2, localeId=2, aclId=17, transaction=TransactionEntity[ ID=11, server=null, changeTxnId=b66cc04f-f48b-43a2-8398-cec6a9bd964c, commitTimeMs=null], auditProps=null, shardKey=null], childNode=NodeEntity[ ID=1610182, version=1, store=workspace://version2Store, uuid=06af04b8-fa39-4828-86ab-52886ce96789, typeQNameId=407, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=154891, server=ServerEntity[ ID=11, ipAddress=null], changeTxnId=67af50e7-fcb1-474b-a672-ccd2641d933f, commitTimeMs=1646215540834], auditProps=AuditablePropertiesEntity[ auditCreator=john.john@john.com, auditCreated=2022-03-02T10:05:40.893Z, auditModifier=john.john@john.com, auditModified=2022-03-02T10:05:40.893Z], shardKey=null]]; nested exception is org.springframework.dao.DataIntegrityViolationException:
  25. ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`))
  26. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  27. ### The error occurred while setting parameters
  28. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  29. ### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`))
  30. ; (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`)); exception: (org.springframework.dao.ConcurrencyFailureException)
  31. 2022-03-02 10:05:40,960 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-7] Retrying http-nio-8080-exec-7: count 4; wait: 10ms; msg: FK violation updating primary parent association:ChildAssocEntity[ ID=null, typeQNameId=407, childNodeNameCrc=3315723071, childNodeName=01bb1f1c-40f1-4f8a-8506-fb8a54bd7648, qnameNamespaceId=14, qnameLocalName=01bb1f1c-40f1-4f8a-8506-fb8a54bd7648, qnameCrc=2240661961, parentNode=NodeEntity[ ID=29, version=1, store=workspace://version2Store, uuid=eb8a9f90-1964-4154-bc20-30403869da57, typeQNameId=2, localeId=2, aclId=17, transaction=TransactionEntity[ ID=11, server=null, changeTxnId=b66cc04f-f48b-43a2-8398-cec6a9bd964c, commitTimeMs=null], auditProps=null, shardKey=null], childNode=NodeEntity[ ID=1610182, version=1, store=workspace://version2Store, uuid=06af04b8-fa39-4828-86ab-52886ce96789, typeQNameId=407, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=154891, server=ServerEntity[ ID=11, ipAddress=null], changeTxnId=67af50e7-fcb1-474b-a672-ccd2641d933f, commitTimeMs=1646215540834], auditProps=AuditablePropertiesEntity[ auditCreator=john.john@john.com, auditCreated=2022-03-02T10:05:40.893Z, auditModifier=john.john@john.com, auditModified=2022-03-02T10:05:40.893Z], shardKey=null]]; nested exception is org.springframework.dao.DataIntegrityViolationException:
  32. ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`))
  33. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  34. ### The error occurred while setting parameters
  35. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  36. ### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`))
  37. ; (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=761584) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_cnode` FOREIGN KEY (`child_node_id`) REFERENCES `alf_node` (`id`)); exception: (org.springframework.dao.ConcurrencyFailureException)
  38. 2022-03-02 10:06:00,925 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  39. 2022-03-02 10:06:31,067 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  40. 2022-03-02 10:06:32,550 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-15] Failed to update cm:modified date for node: 1555961
  41. 2022-03-02 10:06:34,557 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-12] Failed to update cm:modified date for node: 1555716
  42. 2022-03-02 10:07:00,983 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  43. 2022-03-02 10:07:08,996 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-7] Retrying http-nio-8080-exec-7: count 0; wait: 10ms; msg:
  44. ### Error updating database. Cause: java.sql.SQLTransactionRollbackException: (conn=758887) Deadlock: wsrep aborted transaction
  45. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  46. ### The error occurred while setting parameters
  47. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  48. ### Cause: java.sql.SQLTransactionRollbackException: (conn=758887) Deadlock: wsrep aborted transaction
  49. ; (conn=758887) Deadlock: wsrep aborted transaction; nested exception is java.sql.SQLTransactionRollbackException: (conn=758887) Deadlock: wsrep aborted transaction; exception: (org.springframework.dao.DeadlockLoserDataAccessException)
  50. 2022-03-02 10:07:09,025 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-7] Retrying http-nio-8080-exec-7: count 1; wait: 10ms; msg: FK violation updating primary parent association:ChildAssocEntity[ ID=null, typeQNameId=413, childNodeNameCrc=-3882232075, childNodeName=900846d6-5578-4e98-813b-28e76627789e, qnameNamespaceId=14, qnameLocalName=version-0, qnameCrc=3486964613, parentNode=NodeEntity[ ID=1612636, version=1, store=workspace://version2Store, uuid=eaa9cb34-3f48-4eed-8a39-b080380acc2f, typeQNameId=407, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=155878, server=ServerEntity[ ID=9, ipAddress=null], changeTxnId=3d578836-b423-4ed6-81f0-201aab577f1d, commitTimeMs=1646215628943], auditProps=AuditablePropertiesEntity[ auditCreator=admin, auditCreated=2022-03-02T10:07:08.980Z, auditModifier=admin, auditModified=2022-03-02T10:07:08.980Z], shardKey=null], childNode=NodeEntity[ ID=1612639, version=1, store=workspace://version2Store, uuid=29bf0428-13ac-424a-b067-df9cc92fcdac, typeQNameId=152, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=155878, server=ServerEntity[ ID=9, ipAddress=null], changeTxnId=3d578836-b423-4ed6-81f0-201aab577f1d, commitTimeMs=1646215628943], auditProps=AuditablePropertiesEntity[ auditCreator=admin, auditCreated=2022-03-02T10:07:08.989Z, auditModifier=admin, auditModified=2022-03-02T10:07:08.989Z], shardKey=null]]; nested exception is org.springframework.dao.DataIntegrityViolationException:
  51. ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  52. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  53. ### The error occurred while setting parameters
  54. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  55. ### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  56. ; (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); exception: (org.springframework.dao.ConcurrencyFailureException)
  57. 2022-03-02 10:07:09,037 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-7] Retrying http-nio-8080-exec-7: count 2; wait: 10ms; msg: FK violation updating primary parent association:ChildAssocEntity[ ID=null, typeQNameId=413, childNodeNameCrc=-3882232075, childNodeName=900846d6-5578-4e98-813b-28e76627789e, qnameNamespaceId=14, qnameLocalName=version-0, qnameCrc=3486964613, parentNode=NodeEntity[ ID=1612636, version=1, store=workspace://version2Store, uuid=eaa9cb34-3f48-4eed-8a39-b080380acc2f, typeQNameId=407, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=155878, server=ServerEntity[ ID=9, ipAddress=null], changeTxnId=3d578836-b423-4ed6-81f0-201aab577f1d, commitTimeMs=1646215628943], auditProps=AuditablePropertiesEntity[ auditCreator=admin, auditCreated=2022-03-02T10:07:08.980Z, auditModifier=admin, auditModified=2022-03-02T10:07:08.980Z], shardKey=null], childNode=NodeEntity[ ID=1612639, version=1, store=workspace://version2Store, uuid=29bf0428-13ac-424a-b067-df9cc92fcdac, typeQNameId=152, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=155878, server=ServerEntity[ ID=9, ipAddress=null], changeTxnId=3d578836-b423-4ed6-81f0-201aab577f1d, commitTimeMs=1646215628943], auditProps=AuditablePropertiesEntity[ auditCreator=admin, auditCreated=2022-03-02T10:07:08.989Z, auditModifier=admin, auditModified=2022-03-02T10:07:08.989Z], shardKey=null]]; nested exception is org.springframework.dao.DataIntegrityViolationException:
  58. ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  59. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  60. ### The error occurred while setting parameters
  61. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  62. ### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  63. ; (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); exception: (org.springframework.dao.ConcurrencyFailureException)
  64. 2022-03-02 10:07:09,050 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-7] Retrying http-nio-8080-exec-7: count 3; wait: 10ms; msg: FK violation updating primary parent association:ChildAssocEntity[ ID=null, typeQNameId=413, childNodeNameCrc=-3882232075, childNodeName=900846d6-5578-4e98-813b-28e76627789e, qnameNamespaceId=14, qnameLocalName=version-0, qnameCrc=3486964613, parentNode=NodeEntity[ ID=1612636, version=1, store=workspace://version2Store, uuid=eaa9cb34-3f48-4eed-8a39-b080380acc2f, typeQNameId=407, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=155878, server=ServerEntity[ ID=9, ipAddress=null], changeTxnId=3d578836-b423-4ed6-81f0-201aab577f1d, commitTimeMs=1646215628943], auditProps=AuditablePropertiesEntity[ auditCreator=admin, auditCreated=2022-03-02T10:07:08.980Z, auditModifier=admin, auditModified=2022-03-02T10:07:08.980Z], shardKey=null], childNode=NodeEntity[ ID=1612639, version=1, store=workspace://version2Store, uuid=29bf0428-13ac-424a-b067-df9cc92fcdac, typeQNameId=152, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=155878, server=ServerEntity[ ID=9, ipAddress=null], changeTxnId=3d578836-b423-4ed6-81f0-201aab577f1d, commitTimeMs=1646215628943], auditProps=AuditablePropertiesEntity[ auditCreator=admin, auditCreated=2022-03-02T10:07:08.989Z, auditModifier=admin, auditModified=2022-03-02T10:07:08.989Z], shardKey=null]]; nested exception is org.springframework.dao.DataIntegrityViolationException:
  65. ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  66. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  67. ### The error occurred while setting parameters
  68. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  69. ### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  70. ; (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); exception: (org.springframework.dao.ConcurrencyFailureException)
  71. 2022-03-02 10:07:09,062 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-7] Retrying http-nio-8080-exec-7: count 4; wait: 10ms; msg: FK violation updating primary parent association:ChildAssocEntity[ ID=null, typeQNameId=413, childNodeNameCrc=-3882232075, childNodeName=900846d6-5578-4e98-813b-28e76627789e, qnameNamespaceId=14, qnameLocalName=version-0, qnameCrc=3486964613, parentNode=NodeEntity[ ID=1612636, version=1, store=workspace://version2Store, uuid=eaa9cb34-3f48-4eed-8a39-b080380acc2f, typeQNameId=407, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=155878, server=ServerEntity[ ID=9, ipAddress=null], changeTxnId=3d578836-b423-4ed6-81f0-201aab577f1d, commitTimeMs=1646215628943], auditProps=AuditablePropertiesEntity[ auditCreator=admin, auditCreated=2022-03-02T10:07:08.980Z, auditModifier=admin, auditModified=2022-03-02T10:07:08.980Z], shardKey=null], childNode=NodeEntity[ ID=1612639, version=1, store=workspace://version2Store, uuid=29bf0428-13ac-424a-b067-df9cc92fcdac, typeQNameId=152, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=155878, server=ServerEntity[ ID=9, ipAddress=null], changeTxnId=3d578836-b423-4ed6-81f0-201aab577f1d, commitTimeMs=1646215628943], auditProps=AuditablePropertiesEntity[ auditCreator=admin, auditCreated=2022-03-02T10:07:08.989Z, auditModifier=admin, auditModified=2022-03-02T10:07:08.989Z], shardKey=null]]; nested exception is org.springframework.dao.DataIntegrityViolationException:
  72. ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  73. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  74. ### The error occurred while setting parameters
  75. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  76. ### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  77. ; (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=758887) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); exception: (org.springframework.dao.ConcurrencyFailureException)
  78. 2022-03-02 10:07:09,455 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-7] Failed to update cm:modified date for node: 1555961
  79. 2022-03-02 10:07:31,097 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  80. 2022-03-02 10:07:34,357 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-7] Failed to update cm:modified date for node: 1555716
  81. 2022-03-02 10:07:46,193 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-11] Failed to update cm:modified date for node: 1555716
  82. 2022-03-02 10:08:00,910 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  83. 2022-03-02 10:08:28,724 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-5] Failed to update cm:modified date for node: 1555961
  84. 2022-03-02 10:08:31,171 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  85. 2022-03-02 10:09:00,957 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  86. 2022-03-02 10:09:01,481 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-9] Failed to update cm:modified date for node: 1555716
  87. 2022-03-02 10:09:30,971 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  88. 2022-03-02 10:10:01,560 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  89. 2022-03-02 10:10:03,274 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-12] Failed to update cm:modified date for node: 1555716
  90. 2022-03-02 10:10:17,156 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-8] Failed to update cm:modified date for node: 1555961
  91. 2022-03-02 10:10:29,552 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-3] Failed to update cm:modified date for node: 1555716
  92. 2022-03-02 10:10:31,296 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  93. 2022-03-02 10:10:41,461 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-10] Failed to update cm:modified date for node: 1555961
  94. 2022-03-02 10:10:55,988 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-10] Failed to update cm:modified date for node: 1555961
  95. 2022-03-02 10:11:01,263 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  96. 2022-03-02 10:11:21,511 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-13] Failed to update cm:modified date for node: 1555961
  97. 2022-03-02 10:11:30,973 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  98. 2022-03-02 10:11:32,367 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-10] Failed to update cm:modified date for node: 1555716
  99. 2022-03-02 10:12:01,018 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  100. 2022-03-02 10:12:29,902 ERROR [repo.activities.ActivityServiceImpl] [http-nio-8080-exec-15] org.alfresco.error.AlfrescoRuntimeException: 020220115 Failed to post activity: org.springframework.dao.DeadlockLoserDataAccessException:
  101. ### Error updating database. Cause: java.sql.SQLTransactionRollbackException: (conn=753608) Deadlock: wsrep aborted transaction
  102. ### The error may involve alfresco.activities.insert.insert_activity_post-Inline
  103. ### The error occurred while setting parameters
  104. ### SQL: insert into alf_activity_post (status, activity_data, post_user_id, post_date, activity_type, site_network, app_tool, job_task_node, last_modified) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
  105. ### Cause: java.sql.SQLTransactionRollbackException: (conn=753608) Deadlock: wsrep aborted transaction
  106. ; (conn=753608) Deadlock: wsrep aborted transaction; nested exception is java.sql.SQLTransactionRollbackException: (conn=753608) Deadlock: wsrep aborted transaction
  107. 2022-03-02 10:12:31,418 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  108. 2022-03-02 10:12:27,158 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-3] Failed to update cm:modified date for node: 1555716
  109. 2022-03-02 10:12:38,029 ERROR [framework.webscripts.ResourceWebScriptPost] [http-nio-8080-exec-3] d928ae42-0cdb-496f-bd8a-93db9ccba353 : [org.alfresco.repo.domain.node.AbstractNodeDAOImpl.newNodeAssoc(AbstractNodeDAOImpl.java:2942), org.alfresco.repo.node.db.DbNodeServiceImpl.createAssociation_aroundBody86(DbNodeServiceImpl.java:2027), org.alfresco.repo.node.db.DbNodeServiceImpl$AjcClosure87.run(DbNodeServiceImpl.java:1), org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149), org.alfresco.traitextender.RouteExtensions.intercept(RouteExtensions.java:100), org.alfresco.repo.node.db.DbNodeServiceImpl.createAssociation(DbNodeServiceImpl.java:2014), jdk.internal.reflect.GeneratedMethodAccessor853.invoke(Unknown Source), java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43), java.base/java.lang.reflect.Method.invoke(Method.java:566), org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343), org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198), org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163), org.alfresco.repo.lock.mem.LockableAspectInterceptor.invoke(LockableAspectInterceptor.java:244), org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186), org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212), com.sun.proxy.$Proxy40.createAssociation(Unknown Source), jdk.internal.reflect.GeneratedMethodAccessor853.invoke(Unknown Source), java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43), java.base/java.lang.reflect.Method.invoke(Method.java:566), org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343), org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198), org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163), org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:111), org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186), org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212), com.sun.proxy.$Proxy40.createAssociation(Unknown Source), org.alfresco.repo.version.Version2ServiceImpl.createVersion(Version2ServiceImpl.java:318), org.alfresco.repo.version.Version2ServiceImpl.createVersion_aroundBody2(Version2ServiceImpl.java:141), org.alfresco.repo.version.Version2ServiceImpl$AjcClosure3.run(Version2ServiceImpl.java:1), org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149), org.alfresco.traitextender.RouteExtensions.intercept(RouteExtensions.java:100), org.alfresco.repo.version.Version2ServiceImpl.createVersion(Version2ServiceImpl.java:125), jdk.internal.reflect.GeneratedMethodAccessor912.invoke(Unknown Source), java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43), java.base/java.lang.reflect.Method.invoke(Method.java:566), org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343), org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198), org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163), org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:41), org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186), org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:53), org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186), org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:166), org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186), org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294), org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98), org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186), org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212), com.sun.proxy.$Proxy178.createVersion(Unknown Source), org.alfresco.rest.api.impl.NodesImpl.createVersion(NodesImpl.java:2836), org.alfresco.rest.api.impl.NodesImpl.createNewFile(NodesImpl.java:3047), org.alfresco.rest.api.impl.NodesImpl.upload(NodesImpl.java:2994), jdk.internal.reflect.GeneratedMethodAccessor908.invoke(Unknown Source), java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43), java.base/java.lang.reflect.Method.invoke(Method.java:566), org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343), org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198), org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163), org.alfresco.rest.api.impl.ExceptionInterceptor.invoke(ExceptionInterceptor.java:57), org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186), org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212), com.sun.proxy.$Proxy179.upload(Unknown Source), org.alfresco.rest.api.nodes.NodeChildrenRelation.create(NodeChildrenRelation.java:128), org.alfresco.rest.api.nodes.NodeChildrenRelation.create(NodeChildrenRelation.java:55), org.alfresco.rest.framework.webscripts.ResourceWebScriptPost.executeAction(ResourceWebScriptPost.java:315), org.alfresco.rest.framework.webscripts.AbstractResourceWebScript$2.execute(AbstractResourceWebScript.java:176), org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:450), org.alfresco.rest.framework.webscripts.AbstractResourceWebScript.execute(AbstractResourceWebScript.java:169), org.alfresco.rest.framework.webscripts.AbstractResourceWebScript.execute(AbstractResourceWebScript.java:102), org.alfresco.rest.framework.webscripts.ApiWebScript.execute(ApiWebScript.java:113), org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:467), org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:656), org.alfresco.repo.web.scripts.RepositoryContainer.executeScriptInternal(RepositoryContainer.java:428), org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:308), org.alfresco.rest.api.PublicApiRepositoryContainer.access$001(PublicApiRepositoryContainer.java:47), org.alfresco.rest.api.PublicApiRepositoryContainer$1.doWork(PublicApiRepositoryContainer.java:84), org.alfresco.repo.tenant.TenantUtil.runAsWork(TenantUtil.java:126), org.alfresco.repo.tenant.TenantUtil.runAsTenant(TenantUtil.java:95), org.alfresco.rest.api.PublicApiRepositoryContainer.executeScript(PublicApiRepositoryContainer.java:80), org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:399), org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:210), org.alfresco.repo.web.scripts.TenantWebScriptServlet.service(TenantWebScriptServlet.java:82), javax.servlet.http.HttpServlet.service(HttpServlet.java:742), org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231), org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166), org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52), org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193), org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166), org.alfresco.module.aosmodule.service.ContextRootFilter.doFilter(ContextRootFilter.java:93), org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193), org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166), org.alfresco.web.app.servlet.ServletMetricsFilter.doFilter(ServletMetricsFilter.java:178), org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:89), org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193), org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166), org.alfresco.repo.web.filter.beans.NullFilter.doFilter(NullFilter.java:75), jdk.internal.reflect.GeneratedMethodAccessor752.invoke(Unknown Source), java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43), java.base/java.lang.reflect.Method.invoke(Method.java:566), org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:132), org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186), org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212), com.sun.proxy.$Proxy172.doFilter(Unknown Source), org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:89), org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193), org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166), com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:198), com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244), org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193), org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166), org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:53), org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193), org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166), org.alfresco.web.app.servlet.ClearSecurityContextFilter.doFilter(ClearSecurityContextFilter.java:53), org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193), org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166), org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198), org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96), org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493), org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140), org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81), org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650), org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87), org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342), org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800), org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66), org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806), org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498), org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49), java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128), java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628), org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61), java.base/java.lang.Thread.run(Thread.java:834)]
  110. 2022-03-02 10:12:49,643 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-2] Failed to update cm:modified date for node: 1555716
  111. 2022-03-02 10:13:01,038 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  112. 2022-03-02 10:13:31,138 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  113. 2022-03-02 10:14:01,406 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  114. 2022-03-02 10:14:22,513 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-9] Failed to update cm:modified date for node: 1555961
  115. 2022-03-02 10:14:31,067 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  116. 2022-03-02 10:14:55,404 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-9] Retrying http-nio-8080-exec-9: count 0; wait: 10ms; msg:
  117. ### Error updating database. Cause: java.sql.SQLTransactionRollbackException: (conn=750578) Deadlock: wsrep aborted transaction
  118. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  119. ### The error occurred while setting parameters
  120. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  121. ### Cause: java.sql.SQLTransactionRollbackException: (conn=750578) Deadlock: wsrep aborted transaction
  122. ; (conn=750578) Deadlock: wsrep aborted transaction; nested exception is java.sql.SQLTransactionRollbackException: (conn=750578) Deadlock: wsrep aborted transaction; exception: (org.springframework.dao.DeadlockLoserDataAccessException)
  123. 2022-03-02 10:14:55,425 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-9] Retrying http-nio-8080-exec-9: count 1; wait: 10ms; msg: FK violation updating primary parent association:ChildAssocEntity[ ID=null, typeQNameId=413, childNodeNameCrc=-2123974638, childNodeName=671d7bcf-29de-4de8-a182-d6324a255253, qnameNamespaceId=14, qnameLocalName=version-0, qnameCrc=3486964613, parentNode=NodeEntity[ ID=1625576, version=1, store=workspace://version2Store, uuid=4eee3ed5-feaa-4e1b-91af-ac63ea1ebd2e, typeQNameId=407, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=160901, server=ServerEntity[ ID=11, ipAddress=null], changeTxnId=a4f510fc-39dd-46cb-8c09-6e77e19f9e8e, commitTimeMs=1646216095299], auditProps=AuditablePropertiesEntity[ auditCreator=john.john@john.com, auditCreated=2022-03-02T10:14:55.382Z, auditModifier=john.john@john.com, auditModified=2022-03-02T10:14:55.382Z], shardKey=null], childNode=NodeEntity[ ID=1625579, version=1, store=workspace://version2Store, uuid=7e7b4f67-27e1-48ea-9f33-8af056c53c19, typeQNameId=152, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=160901, server=ServerEntity[ ID=11, ipAddress=null], changeTxnId=a4f510fc-39dd-46cb-8c09-6e77e19f9e8e, commitTimeMs=1646216095299], auditProps=AuditablePropertiesEntity[ auditCreator=john.john@john.com, auditCreated=2022-03-02T10:14:55.394Z, auditModifier=john.john@john.com, auditModified=2022-03-02T10:14:55.394Z], shardKey=null]]; nested exception is org.springframework.dao.DataIntegrityViolationException:
  124. ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  125. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  126. ### The error occurred while setting parameters
  127. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  128. ### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  129. ; (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); exception: (org.springframework.dao.ConcurrencyFailureException)
  130. 2022-03-02 10:14:55,437 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-9] Retrying http-nio-8080-exec-9: count 2; wait: 10ms; msg: FK violation updating primary parent association:ChildAssocEntity[ ID=null, typeQNameId=413, childNodeNameCrc=-2123974638, childNodeName=671d7bcf-29de-4de8-a182-d6324a255253, qnameNamespaceId=14, qnameLocalName=version-0, qnameCrc=3486964613, parentNode=NodeEntity[ ID=1625576, version=1, store=workspace://version2Store, uuid=4eee3ed5-feaa-4e1b-91af-ac63ea1ebd2e, typeQNameId=407, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=160901, server=ServerEntity[ ID=11, ipAddress=null], changeTxnId=a4f510fc-39dd-46cb-8c09-6e77e19f9e8e, commitTimeMs=1646216095299], auditProps=AuditablePropertiesEntity[ auditCreator=john.john@john.com, auditCreated=2022-03-02T10:14:55.382Z, auditModifier=john.john@john.com, auditModified=2022-03-02T10:14:55.382Z], shardKey=null], childNode=NodeEntity[ ID=1625579, version=1, store=workspace://version2Store, uuid=7e7b4f67-27e1-48ea-9f33-8af056c53c19, typeQNameId=152, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=160901, server=ServerEntity[ ID=11, ipAddress=null], changeTxnId=a4f510fc-39dd-46cb-8c09-6e77e19f9e8e, commitTimeMs=1646216095299], auditProps=AuditablePropertiesEntity[ auditCreator=john.john@john.com, auditCreated=2022-03-02T10:14:55.394Z, auditModifier=john.john@john.com, auditModified=2022-03-02T10:14:55.394Z], shardKey=null]]; nested exception is org.springframework.dao.DataIntegrityViolationException:
  131. ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  132. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  133. ### The error occurred while setting parameters
  134. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  135. ### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  136. ; (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); exception: (org.springframework.dao.ConcurrencyFailureException)
  137. 2022-03-02 10:14:55,449 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-9] Retrying http-nio-8080-exec-9: count 3; wait: 10ms; msg: FK violation updating primary parent association:ChildAssocEntity[ ID=null, typeQNameId=413, childNodeNameCrc=-2123974638, childNodeName=671d7bcf-29de-4de8-a182-d6324a255253, qnameNamespaceId=14, qnameLocalName=version-0, qnameCrc=3486964613, parentNode=NodeEntity[ ID=1625576, version=1, store=workspace://version2Store, uuid=4eee3ed5-feaa-4e1b-91af-ac63ea1ebd2e, typeQNameId=407, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=160901, server=ServerEntity[ ID=11, ipAddress=null], changeTxnId=a4f510fc-39dd-46cb-8c09-6e77e19f9e8e, commitTimeMs=1646216095299], auditProps=AuditablePropertiesEntity[ auditCreator=john.john@john.com, auditCreated=2022-03-02T10:14:55.382Z, auditModifier=john.john@john.com, auditModified=2022-03-02T10:14:55.382Z], shardKey=null], childNode=NodeEntity[ ID=1625579, version=1, store=workspace://version2Store, uuid=7e7b4f67-27e1-48ea-9f33-8af056c53c19, typeQNameId=152, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=160901, server=ServerEntity[ ID=11, ipAddress=null], changeTxnId=a4f510fc-39dd-46cb-8c09-6e77e19f9e8e, commitTimeMs=1646216095299], auditProps=AuditablePropertiesEntity[ auditCreator=john.john@john.com, auditCreated=2022-03-02T10:14:55.394Z, auditModifier=john.john@john.com, auditModified=2022-03-02T10:14:55.394Z], shardKey=null]]; nested exception is org.springframework.dao.DataIntegrityViolationException:
  138. ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  139. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  140. ### The error occurred while setting parameters
  141. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  142. ### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  143. ; (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); exception: (org.springframework.dao.ConcurrencyFailureException)
  144. 2022-03-02 10:14:55,462 INFO [alfresco.ibatis.RetryingCallbackHelper] [http-nio-8080-exec-9] Retrying http-nio-8080-exec-9: count 4; wait: 10ms; msg: FK violation updating primary parent association:ChildAssocEntity[ ID=null, typeQNameId=413, childNodeNameCrc=-2123974638, childNodeName=671d7bcf-29de-4de8-a182-d6324a255253, qnameNamespaceId=14, qnameLocalName=version-0, qnameCrc=3486964613, parentNode=NodeEntity[ ID=1625576, version=1, store=workspace://version2Store, uuid=4eee3ed5-feaa-4e1b-91af-ac63ea1ebd2e, typeQNameId=407, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=160901, server=ServerEntity[ ID=11, ipAddress=null], changeTxnId=a4f510fc-39dd-46cb-8c09-6e77e19f9e8e, commitTimeMs=1646216095299], auditProps=AuditablePropertiesEntity[ auditCreator=john.john@john.com, auditCreated=2022-03-02T10:14:55.382Z, auditModifier=john.john@john.com, auditModified=2022-03-02T10:14:55.382Z], shardKey=null], childNode=NodeEntity[ ID=1625579, version=1, store=workspace://version2Store, uuid=7e7b4f67-27e1-48ea-9f33-8af056c53c19, typeQNameId=152, localeId=4, aclId=13616, transaction=TransactionEntity[ ID=160901, server=ServerEntity[ ID=11, ipAddress=null], changeTxnId=a4f510fc-39dd-46cb-8c09-6e77e19f9e8e, commitTimeMs=1646216095299], auditProps=AuditablePropertiesEntity[ auditCreator=john.john@john.com, auditCreated=2022-03-02T10:14:55.394Z, auditModifier=john.john@john.com, auditModified=2022-03-02T10:14:55.394Z], shardKey=null]]; nested exception is org.springframework.dao.DataIntegrityViolationException:
  145. ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  146. ### The error may involve alfresco.node.insert.insert_ChildAssoc-Inline
  147. ### The error occurred while setting parameters
  148. ### SQL: insert into alf_child_assoc ( version, parent_node_id, child_node_id, type_qname_id, child_node_name_crc, child_node_name, qname_ns_id, qname_localname, qname_crc, is_primary, assoc_index ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
  149. ### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`))
  150. ; (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=750578) Cannot add or update a child row: a foreign key constraint fails (`rap_dev_coreregtest_ecmdb`.`alf_child_assoc`, CONSTRAINT `fk_alf_cass_pnode` FOREIGN KEY (`parent_node_id`) REFERENCES `alf_node` (`id`)); exception: (org.springframework.dao.ConcurrencyFailureException)
  151. 2022-03-02 10:15:01,049 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  152. 2022-03-02 10:15:26,205 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-2] Failed to update cm:modified date for node: 1555716
  153. 2022-03-02 10:15:31,039 WARN [org.alfresco.userToAuthorityTransactionalCache] [LocalFeedGenerator1] Transactional update cache 'org.alfresco.userToAuthorityTransactionalCache' is full (100).
  154. 2022-03-02 10:15:32,811 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-8] Failed to update cm:modified date for node: 1555716
  155. 2022-03-02 10:15:44,166 INFO [node.db.DbNodeServiceImpl] [http-nio-8080-exec-10] Failed to update cm:modified date for node: 1555716
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement