Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-3961

Improve fix for PS-255: print blocking query when possible

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 5.6, 5.7, 8.0
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Fix for PS-255 is not complete: it does not print blocking query even if it is still available inside InnoDB.

      Current output after PS-255 is implemented while blocking query is still running:

      Requested thread id: 4
      Requested trx id: 1800
      Requested query: DELETE FROM t WHERE i = 1 
      Total blocking transactions count: 1
      Blocking transaction number: 1
      Blocking thread id: 3
      Blocking query id: 12
      Blocking trx id: 42182421819267

      Required output:

      Requested thread id: 4
      Requested trx id: 1800
      Requested query: DELETE FROM t WHERE i = 1 
      Total blocking transactions count: 1
      Blocking transaction number: 1
      Blocking thread id: 3
      Blocking query id: 12
      Blocking query: SELECT *, sleep(2) FROM t WHERE i = 1 LOCK IN SHARE MODE
      Blocking trx id: 421824218192672

      I understand we cannot always pring "Blocking query", but if we can, please, print.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  vladislav.lesin Vladislav Lesin (Inactive)
                  Reporter:
                  sveta.smirnova Sveta Smirnova
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  7 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Time Tracking

                    Estimated:
                    Original Estimate - 0 minutes
                    0m
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 4 hours, 35 minutes
                    4h 35m