Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17873

MyRocks-Gap-Lock: lock wait doesn't set correct STATE

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • N/A
    • 10.2(EOL)
    • OTHER
    • None

    Description

      When a query is waiting for row lock, it does not have waiting for row lock status in I_S.PROCESSLIST.

      This is a property of TokuDB, as well. Example of a TokuDB query waiting for a row lock: 

                   ID: 8
      		 
                 USER: root
      		 
                 HOST: localhost
      		 
                   DB: test
      		 
              COMMAND: Query
      		 
                 TIME: 3
      		 
                STATE: Statistics
      		 
                 INFO: select * from t1 where pk=1 for update
      		 
              TIME_MS: 3683.455
      		 
                STAGE: 0
      		 
            MAX_STAGE: 0
      		 
             PROGRESS: 0.000
      		 
          MEMORY_USED: 78480
      		 
      MAX_MEMORY_USED: 80488
      		 
        EXAMINED_ROWS: 0
      		 
             QUERY_ID: 20
      		 
          INFO_BINARY: select * from t1 where pk=1 for update
      		 
                  TID: 30172

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-15603 Gap Lock support in MyRocks

          • Major - Major loss of function.
          • Stalled

          Activity

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.