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

Upgrade to 23.02.18 | stuck query

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 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

        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:
              Resolved:

              Git Integration

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