Uploaded image for project: 'ONE'
  1. ONE
  2. ONE-30950

Missing index on database table T_CORE_FIELD_VAL_2 causes problem with CPU and database usage

    XMLWordPrintable

Details

    • Yes
    • Data Type
    • BigPicture, BigGantt
    • JIRA server, JIRA cloud
    • 32
    • 32
    • $i18n.getText("admin.common.words.hide")
      $i18n.getText("admin.common.words.show")
      var cfToHide1 = document.getElementById("rowForcustomfield_18501"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_18502"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19700"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_18400"); if(cfToHide4){cfToHide4.style.display="none";}
    • 1 minute, 54 seconds
    • 1 week, 1 day, 8 hours, 17 minutes, 10 seconds
    • 1 day, 19 minutes, 34 seconds
    • 6 minutes, 32 seconds
    • 5 minutes
    • 5 minutes, 1 second
    • 1 week, 1 day, 48 minutes, 23 seconds

    Description

      Prerequisites:
      N/A

      Reproduction steps:

      1. upgrade to 8.0.18

      Actual result: Index on column TASK_ID on table T_CORE_FIELD_VAL_2.
      High cpu and db usage.

      Expected result: There is an Index on column TASK_ID on table T_CORE_FIELD_VAL_2.
      Normal CPU and DB usage.
       
      Workaround:
      N/A

      Attachments

        Activity

          People

            evgeny.frolov Evgeny Frolov (Inactive)
            evgeny.frolov Evgeny Frolov (Inactive)
            bartosz.tybus Bartosz Tybus , pawel.guz Pawel Guz , jakub.zygmunt Jakub Zygmunt , system.jenkins Jenkins , lukasz.romaniuk Łukasz Romaniuk , maciej.bukrewicz Maciej Bukrewicz (Inactive) , adam.biedruna Adam Biedruna , dariusz.dudek Dariusz Dudek , monika.bialucha Monika Białucha , szymon.zimecki Szymon Zimecki (Inactive) , martyna.turowska Martyna Turowska , marcin.koman Marcin Koman , radoslaw.rachuba Radosław Rachuba , system.gerrit Gerrit , evgeny.frolov Evgeny Frolov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: