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

Assertion `0' failed in mysql_execute_command on SET STATEMENT keycache1.key_buffer_size=.. FOR

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • N/A
    • 10.1.2
    • OTHER
    • None

    Description

      SET STATEMENT keycache1.key_buffer_size=1024 FOR SELECT 1;

      mysqld: sql/sql_parse.cc:2693: int mysql_execute_command(THD*): Assertion `0' failed.

      #6  0x00007f11828cc6f1 in *__GI___assert_fail (assertion=0x7f1185af5f48 "0", file=<optimized out>, line=2693, function=0x7f1185af8e20 "int mysql_execute_command(THD*)") at assert.c:81
      #7  0x00007f11851e0ab8 in mysql_execute_command (thd=0x7f1169350070) at /sql/sql_parse.cc:2693
      #8  0x00007f11851edffb in mysql_parse (thd=0x7f1169350070, rawbuf=0x7f1169080088 "SET statement keycache1.key_buffer_size=1024 for select 1", length=57, parser_state=0x7f1184ca0210) at /sql/sql_parse.cc:7046
      #9  0x00007f11851dd898 in dispatch_command (command=COM_QUERY, thd=0x7f1169350070, packet=0x7f116905f071 "SET statement keycache1.key_buffer_size=1024 for select 1", packet_length=57) at /sql/sql_parse.cc:1466
      #10 0x00007f11851dc6b6 in do_command (thd=0x7f1169350070) at /sql/sql_parse.cc:1095
      #11 0x00007f118530ab77 in do_handle_one_connection (thd_arg=0x7f1169350070) at /sql/sql_connect.cc:1351
      #12 0x00007f118530a8bc in handle_one_connection (arg=0x7f1169350070) at /sql/sql_connect.cc:1262
      #13 0x00007f11848e6b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      #14 0x00007f118297d20d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
      #15 0x0000000000000000 in ?? ()

      Stack trace from

      commit 3a3f88e789a41b309cfe902f4823c9c7ebbce6ca
      Author: Oleksandr Byelkin <sanja@mariadb.com>
      Date:   Fri Oct 24 10:13:08 2014 +0200
       
          MDEV-5231: Per query variables from Percona Server (rewritten)

      Percona server correctly produces an error:

      MySQL [test]> SET statement keycache1.key_buffer_size=1024 for select 1;
      ERROR 1229 (HY000): Variable 'key_buffer_size' is a GLOBAL variable and should be set with SET GLOBAL

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.