Overview

It is possible to encounter sporadic/unpredictable row-level SQL deadlocks on JiveTaskQueue and JiveAcclaim tables.
Examples of statements that entered deadlock are:

• UPDATE JiveTaskQueue SET lockingNode=NULL, lockTime=NULL WHERE lockTime < :1
• UPDATE JiveAcclaim SET modificationDate = :1 , score = :2 , scoreDisplay = :3 , visibility = :4 WHERE acclaimID = :5

This article provides information about the deadlock issue reported on the tables.

Information

The database deadlocks are considered by Jive to be well within acceptable limits and have no impact on the user experience. If in the future, a measurable degradation in performance is detected, a new ticket should be created into the Jive Support Portal.