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

Upgrade to 23.02.18 | stuck query

    XMLWordPrintable

Details

    • Task
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 23.02.18
    • N/A
    • PrimProc
    • None
    • 2026-4

    Description

      Customer claims a new behavior of stuck query, need to investigate

      SELECT
       case when (NVL(TAUOK,0) + TAUFAILURES + NVL(TAUUNKNOWN_COUNT,0)) > 0 then
       case when (NVL(TAUOK,0) + TAUFAILURES + NVL(TAUUNKNOWN_COUNT,0))  > TAUFAILURES then ( TAUFAILURES / (NVL(TAUOK,0) + TAUFAILURES + NVL(TAUUNKNOWN_COUNT,0)))*100
       else 100 end else 0 end exp1,
             exp2 exp2
      FROM 
      (       
       SELECT Sum( LTECTCellStats.TAUOK ) TAUOK,
                    Sum( LTECTCellStats.TAUFAILURES ) TAUFAILURES,
                    Sum( LTECTCellStats.TAUUNKNOWN_COUNT ) TAUUNKNOWN_COUNT,
                    Sum( LTECTCellStats.TAUFAILURES ) exp2
             FROM   (SELECT TAUFAILURES, TAUOK, TAUUNKNOWN_COUNT
                     FROM LTE_SPOT_CELLSTATS_HOURLY s
                     WHERE (s.date >= DATE('2026-03-04') AND s.hour >= 2)
                       AND (s.date <= DATE('2026-03-04') AND s.hour <= 23)
                       AND ServingSectorHandle IN (376238616)  AND DeviceID IN (4, 7) ) LTECTCellStats) subquery 
             WHERE  nvl(TAUFAILURES,0) > 0
      

      Attachments

        Issue Links

          Activity

            People

              alexey.antipovsky Aleksei Antipovskii
              allen.herrera Allen Herrera
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 10d Original Estimate - 10d
                  10d
                  Remaining:
                  Time Spent - 16d Remaining Estimate - 5d
                  5d
                  Logged:
                  Time Spent - 16d Remaining Estimate - 5d
                  16d

                  Git Integration

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