Database Deadlock and Error Conflict

[savidudu]

Hello All,

Could you please assist me why this is happening ?

2021-12-18T04:02:07,421 ERROR [scheduler-TaskQueueEngine-thread-10] service.ScheduledTaskManagerImpl - execution of task Protection Workspace Data Collection failed
com.mcafee.orion.core.cmd.CommandException: 1 subtask had an error:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PWS_ComplianceDrillDownMT_LeafNodeID". The conflict occurred in database "ePO_Database", table "dbo.EPOLeafNodeMT", column 'AutoID'

2021-12-18T04:01:57,921 ERROR [scheduler-TaskQueueEngine-thread-10] tasks.MasterDataCollectionServerTask - Task class com.mcafee.protectionworkspace.tasks.ProductCoverageTaskCommand threw execption
java.sql.SQLException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PWS_ComplianceDrillDownMT_LeafNodeID". The conflict occurred in database "ePO_Database", table "dbo.EPOLeafNodeMT", column 'AutoID'.

2021-12-18T10:00:49,075 ERROR [scheduler-TaskQueueEngine-thread-5] propertytranslator.FCFWClientRuleProcessor - Failed to cleanup rules for tenant: 1.
java.sql.SQLException: Transaction (Process ID 249) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.


Thanks

[aguevara]

If the deadlock issue can be reproduced by running the Firewall Property translator server task then please collect the data from the below article and open a Service request with support:

https://kc.mcafee.com/corporate/index?page=content&id=KB93378

Regards

Alejandro

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?