Updated recently

More than one value stored for custom field Time in Status

Description

Summary

Customer is seeing Duplicate values are created in the Time in Status custom field in the logs.
The steps so trigger the Duplication in the Time in Status Field have not yet been fully identified and cannot be reliably reproduced.
The error is logged and the duplicate value is not corrected.
At many cases, when we check the customer customfieldvalue table, we don't see any duplicate, which implies that we might be seeing a race condition scenario.

Steps to Reproduce

  1. Action to cause Duplicate Unknown

  2. Once Duplication occurs trigger a workflow transition on the affected issue

Expected Results

When Duplicate is detected it is deleted and correct value applied to time in status.
The custom field value shouldn't be changes by more than 1 thread in the same time.

Actual Results

The follow 3 error exceptions are thrown in the atlassian-jira.log file and the Duplicate value is not removed and time in status is not updated with new value:

1 2 3 4 5 automation-event-serializer:thread-2 ERROR testuser 1247x646x1 bszk9o <IP_Address> /secure/WorkflowUIDispatcher.jspa [c.a.j.e.charting.field.TimeInStatusCFType] More than one value stored for custom field id'customfield_#####'. Values [XXX, XXX] automation-event-serializer:thread-2 ERROR testuser 1247x646x1 bszk9o <IP_Address> /secure/WorkflowUIDispatcher.jspa [c.a.j.e.charting.field.TimeInStatusCFType] More than one value stored for custom field id'customfield_#####'. Values [XXX, XXX] http-nio-8080-exec-15 ERROR testuser 1277x1156x1 bszk9o <IP_Address> /secure/WorkflowUIDispatcher.jspa [c.a.j.e.charting.field.TimeInStatusCFType] More than one value stored for custom field id'customfield_#####'. Values [XXX, XXX]

eventually we don't find the duplicates in the database, but the JIRA performance is impacted and at cases indexing speed gets very slow.

Workaround

None.

Environment

JIRA 7.6.3

Testing Notes

None

Status

Assignee

Unassigned

Reporter

Sherif Abdelfattah

Labels

None

Add-on Type

Server

Team

None

CC

None

Risk factor

1 - low

QA Kickoff Status

None

QA Demo Status

None

Components

Priority

Minor