Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33121

Assertion Failed at /mariadb-11.3.0/sql/filesort.cc:663

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.3.0, 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4, 11.5(EOL)
    • 11.4
    • Server
    • Ubuntu 20.04

    Description

      Run these queries in debug build:

      CREATE TABLE v0 ( v1 INT , v2 INT ) ;
      DELETE FROM v0 ORDER BY COUNT( v2 ) ;
      

      Will trigger Assertion Failed.
      GDB info:

      #0  0x00007ffff6c0c00b in raise () from /lib/x86_64-linux-gnu/libc.so.6
      #1  0x00007ffff6beb859 in abort () from /lib/x86_64-linux-gnu/libc.so.6
      #2  0x00007ffff6beb729 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
      #3  0x00007ffff6bfcfd6 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #4  0x0000555557afd502 in Filesort::make_sortorder (this=0x7fffd0e244e0, thd=0x62c0001e0288, join=0x0, first_table_bit=0)
          at /home/wx/mariadb-11.3.0/sql/filesort.cc:663
      #5  0x0000555557af94f8 in filesort (thd=0x62c0001e0288, table=0x61900006b908, filesort=0x7fffd0e244e0, tracker=0x6290000f72b8, join=0x0, first_table_bit=0)
          at /home/wx/mariadb-11.3.0/sql/filesort.cc:230
      #6  0x00005555570c30fa in Sql_cmd_delete::delete_from_single_table (this=0x6290000f6510, thd=0x62c0001e0288) at /home/wx/mariadb-11.3.0/sql/sql_delete.cc:659
      #7  0x00005555570ce6fe in Sql_cmd_delete::execute_inner (this=0x6290000f6510, thd=0x62c0001e0288) at /home/wx/mariadb-11.3.0/sql/sql_delete.cc:1800
      #8  0x00005555573a7f0d in Sql_cmd_dml::execute (this=0x6290000f6510, thd=0x62c0001e0288) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:33350
      #9  0x00005555571c1637 in mysql_execute_command (thd=0x62c0001e0288, is_called_from_prepared_stmt=false) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:4361
      #10 0x00005555571d95e2 in mysql_parse (thd=0x62c0001e0288, rawbuf=0x6290000f52a8 "DELETE FROM v0 ORDER BY COUNT( v2 )", length=35, parser_state=0x7fffd0e25870)
          at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:7734
      #11 0x00005555571b1237 in dispatch_command (command=COM_QUERY, thd=0x62c0001e0288, packet=0x6290000eb289 "DELETE FROM v0 ORDER BY COUNT( v2 )", 
          packet_length=35, blocking=true) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1893
      #12 0x00005555571adf7c in do_command (thd=0x62c0001e0288, blocking=true) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1406
      #13 0x000055555768e557 in do_handle_one_connection (connect=0x611000053e08, put_in_cache=true) at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1445
      #14 0x000055555768deb4 in handle_one_connection (arg=0x611000053e08) at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1347
      #15 0x00005555582fa350 in pfs_spawn_thread (arg=0x618000006908) at /home/wx/mariadb-11.3.0/storage/perfschema/pfs.cc:2201
      #16 0x00007ffff7115609 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #17 0x00007ffff6ce8133 in clone () from /lib/x86_64-linux-gnu/libc.so.6

      Attachments

        Issue Links

          Activity

            People

              oleg.smirnov Oleg Smirnov
              Xin Wen Xin Wen
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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