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

Problem with database - Deadlock on T_CORE_FIELD_VAL table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • prod/bigpicture/jiraserver/2020/12/29/8.0.18, prod/bigpicture/jiracloud/2021/01/07/11_30, prod/bigpicture/jiracloud/2021/01/08/12_30
    • None
    • None
    • No
    • 564cedf21f8451471c29e5bc4d9ce0d6977b81ab7cc7295f9f10ccddd05da8e60890eb7f826f78348fd5c7925480b3837469dbf11d381f0db4d705a271dd3570
    • Tree
    • BigPicture
    • JIRA cloud
    • 52
    • 39
    • 3
    • 2
    • $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";}
    • 8 weeks, 3 days, 17 hours, 58 minutes, 29 seconds
    • 2 days, 4 hours, 7 minutes, 24 seconds
    • 11 weeks, 5 days, 18 hours, 13 minutes, 29 seconds
    • 1 day, 1 hour, 56 minutes, 42 seconds
    • 0
    • 0
    • 0

    Description

       

      Prerequisites:
      N/A

      Reproduction steps:

      1. Add value to the database using the query: 
       insert into "T_CORE_FIELD_VAL" ("CREATE_DATE", "UPDATE_DATE", "TASK_FIELD_DEF_ID", "TASK_ID", "VALUE", "TECH_UNIQUENESS") values ($1, $2, $3, $4, $5, $6)

      Actual result: Deadlock on database T_CORE_FIELD_VAL table during execution sql statement which adds empty value to value column in T_CORE_FIELD_VAL table

      Expected result:  Deadlock on database T_CORE_FIELD_VAL table doesn't occur during execution statement 
       
      Workaround:
      N/A

       

       

      Attachments

        Issue Links

          Activity

            People

              rafal.staskiewicz Rafał Staśkiewicz
              michal.mrozowski Michal Mrozowski
              mateusz.filipek Mateusz Filipek , rafal.staskiewicz Rafał Staśkiewicz , igor.szymanczyk Igor Szymanczyk , kamila.kornatko Kamila Kornatko , maciej.bartylak Maciej Bartylak , tomasz.jaskiewicz Tomasz Jaśkiewicz , marcin.hareza Marcin Hareza , rafal.zalewski Rafał Zalewski (Inactive) , system.jenkins Jenkins , marta.gniadek Marta Gniadek (Inactive) , dariusz.dudek Dariusz Dudek , marcin.koman Marcin Koman , grzegorz.duzy Grzegorz Duży , lukasz.romaniuk Łukasz Romaniuk , aneta.wojcik Aneta Wójcik , katarzyna.rajchert Katarzyna Rajchert , evgeny.frolov Evgeny Frolov (Inactive) , pawel.nowicki Paweł Nowicki , radoslaw.rachuba Radosław Rachuba , tomasz.ruszel Tomasz Ruszel , tomasz.szymanski Tomasz Szymański , martyna.turowska Martyna Turowska , michal.dranicki Michał Dranicki (Inactive) , anna.kicior Anna Kicior , szymon.zimecki Szymon Zimecki (Inactive) , system.gerrit Gerrit , michal.mrozowski Michal Mrozowski
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: