Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4825

query with limit continues to run on PrimProc after query is done.

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 6.1.1
    • Fix Version/s: Icebox
    • Component/s: ExeMgr
    • Labels:
      None

      Description

      When a query with limit is executed, it aborts the query once the limit is satisfied. During this abort, it doesn't call BatchPrimitiveProcessorJL::destroyBPP(). This leaves unexecuted jobsteps in the prioritythreadpool's queue on PrimProc. The jobsteps have nothing to work on anymore, so they do nothing.

      Since the thing they're trying to work on is missing, the code doesn't know if it's never going to be created, so it reschedules the jobsteps. Prioritythreadpool then spins trying to get these tasks completed, rescheduling over and over until a timer pops to make it give up.

      If other queries arrive, there's likely no noticeable impact, but cpu cycles are being wasted.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            David.Hall David Hall
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration