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

Assertion `opt_bootstrap || mysql_parse_status || thd->lex->select_stack_top == 0' failed in parse_sql upon DELETE HISTORY under ORACLE mode

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4(EOL)
    • 10.4.2
    • Parser
    • None

    Description

      SET SQL_MODE= ORACLE;
      --error ER_VERS_NOT_VERSIONED
      DELETE HISTORY FROM mysql.user;
      

      10.4 8cf7e3459d73

      mysqld: /data/src/10.4-travis/sql/sql_parse.cc:10122: bool parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool): Assertion `opt_bootstrap || mysql_parse_status || thd->lex->select_stack_top == 0' failed.
      181210 12:34:32 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fc2b0288ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055e6244161de in parse_sql (thd=0x7fc298000b00, parser_state=0x7fc2aa41a600, creation_ctx=0x0, do_pfs_digest=true) at /data/src/10.4-travis/sql/sql_parse.cc:10121
      #9  0x000055e62441121c in mysql_parse (thd=0x7fc298000b00, rawbuf=0x7fc298014db8 "DELETE HISTORY FROM mysql.user", length=30, parser_state=0x7fc2aa41a600, is_com_multi=false, is_next_command=false) at /data/src/10.4-travis/sql/sql_parse.cc:8056
      #10 0x000055e6243fe5e6 in dispatch_command (command=COM_QUERY, thd=0x7fc298000b00, packet=0x7fc29800b421 "DELETE HISTORY FROM mysql.user", packet_length=30, is_com_multi=false, is_next_command=false) at /data/src/10.4-travis/sql/sql_parse.cc:1850
      #11 0x000055e6243fd00a in do_command (thd=0x7fc298000b00) at /data/src/10.4-travis/sql/sql_parse.cc:1395
      #12 0x000055e624568dd6 in do_handle_one_connection (connect=0x55e627b17b90) at /data/src/10.4-travis/sql/sql_connect.cc:1402
      #13 0x000055e624568b5a in handle_one_connection (arg=0x55e627b17b90) at /data/src/10.4-travis/sql/sql_connect.cc:1308
      #14 0x000055e624a21890 in pfs_spawn_thread (arg=0x55e627c105d0) at /data/src/10.4-travis/storage/perfschema/pfs.cc:1862
      #15 0x00007fc2b1d44494 in start_thread (arg=0x7fc2aa41b700) at pthread_create.c:333
      #16 0x00007fc2b034593f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Oddly, not reproducible on 10.3.

      Attachments

        Activity

          People

            bar Alexander Barkov
            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.