Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-12796

Multiple values being stored for single value custom fields

    XMLWordPrintable

Details

    Description

      Customer is getting the following errors in the log file:

      [issue.customfields.impl.AbstractSingleFieldType] More than one value stored for custom field id'customfield_10081'.  Values [john.smith, john.smith, mary.brown]

      Here is the support case. The customer has 160,000 issues, and can have up to 300 concurrent requests. Several users can be modifying the same issue at the same time.

      The customer says that every few weeks he needs to go into the database and delete the multiple rows. I gave him the SQL to do this. Once he removes the multiple rows from the database he can re-index the issue, and once this is done it can be viewed again in JIRA. However the issue recurs.

      This issue has come up before - JRA-11382 - but in that case there was more than one thread of execution in an SOAP client modifying the same issue. The customer assures me that in his case does not have any software programs modifying issues.

      Cheers,
      Ian

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-66103 JIRA is adding multiple copies of values for single-value custom fields

          • Medium - Medium priority issues
          • Closed

          JDEV-25243 Loading...

          is related to

          Suggestion - JRASERVER-1917 Control Concurrency for Update Functions in JIRA

          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-67011 Duplicate value in "Time in Status" Field persists despite fix code in place

          • Highest - Our top priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-12868 Customfield User Picker "corrupted" after a user is deleted

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-30164 Updating the More than one value stored for custom field id ERROR to a WARNING Message

          • Low - Low priority issues
          • Closed

          Suggestion - JRASERVER-11382 Remote API concurrency issue

          • Closed
          mentioned in

          Page Loading...

          Activity

            People

              Unassigned Unassigned
              idaniel Ian Daniel [Atlassian]
              Votes:
              39 Vote for this issue
              Watchers:
              89 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: