Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-17080

Oracle Lock table maintenances in share mode

    XMLWordPrintable

    Details

    • Team:
      Team A
    • Sprint:
      Sprint 60 (Jan 2020)
    • Story Points:
      0.5

      Description

        1665:20191210:172019.299 slow query: 290.653173 sec, "lock table maintenances in share mode"
        1664:20191210:172019.299 slow query: 287.644316 sec, "lock table maintenances in share mode"
        1662:20191210:172019.299 slow query: 293.398638 sec, "lock table maintenances in share mode"
        1663:20191210:172019.299 slow query: 291.391157 sec, "lock table maintenances in share mode"
      
        1664:20191210:172022.893 [Z3007] query failed: [-1] ORA-00060: deadlock detected while waiting for resource
        1663:20191210:172023.019 [Z3007] query failed: [-1] ORA-00060: deadlock detected while waiting for resource
        1665:20191210:172023.181 [Z3007] query failed: [-1] ORA-00060: deadlock detected while waiting for resource
      

        Attachments

          Activity

            People

            Assignee:
            vso Vladislavs Sokurenko
            Reporter:
            dmitrijs.lamberts Dmitrijs Lamberts
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: