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

Certain window function queries crash mysqld

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.2.5
    • 1.2.6
    • MariaDB Server
    • None
    • 2019-06

    Description

      In sql_select.cc optimize_stage2() line 2433, Columnstore has added:

        // @InfiniDB We don't need tmp table for vtable create phase. Plus
      		 
        // to build tmp table may corrupt some field table_name & db_name (for some reason)
      		 
        if (thd->infinidb_vtable.vtable_state == THD::INFINIDB_CREATE_VTABLE)
      		 
      	need_tmp = false;

      Removing this allows the query to run against InnoDB correcty. Investigating other things.

      Attachments

        Issue Links

          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19364 Server crashes on certain window function usage

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            David Hall (Inactive) made transition -
            Open In Progress
            		2m 57s 1
            David Hall (Inactive) made transition -
            In Progress Stalled
            		3d 20h 54m 1
            David Hall (Inactive) made transition -
            Stalled In Progress
            		3d 22h 41m 1
            David Hall (Inactive) made transition -
            In Progress In Review
            		3d 7h 25m 1
            Andrew Hutchings (Inactive) made transition -
            In Review In Testing
            		14h 55m 1
            Daniel Lee (Inactive) made transition -
            In Testing Closed
            		105d 2h 9m 1

            People

              dleeyh Daniel Lee (Inactive)
              David.Hall David Hall (Inactive)
              Votes:
              1 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.