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

GET_BIT variables crash in SET STATEMENT

    XMLWordPrintable

Details

    Description

      set statement explicit_defaults_for_timestamp=off for create table t (ts timestamp);
       
      # Cleanup
      drop table if exists t;
      

      bb-10.10-MDEV-28632 c4407143a2

      mariadbd: /data/src/preview-10.10-timestamp/sql/sql_parse.cc:3364: bool run_set_statement_if_requested(THD*, LEX*): Assertion `0' failed.
      220710  0:18:19 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007ff0c608f662 in __GI___assert_fail (assertion=assertion@entry=0x5588d69c3560 "0", file=file@entry=0x5588d69c3d80 "/data/src/preview-10.10-timestamp/sql/sql_parse.cc", line=line@entry=3364, function=function@entry=0x5588d69c8380 "bool run_set_statement_if_requested(THD*, LEX*)") at assert.c:101
      No locals.
      #8  0x00005588d13fc92b in run_set_statement_if_requested (thd=thd@entry=0x62b00007e218, lex=lex@entry=0x62b000082560) at /data/src/preview-10.10-timestamp/sql/sql_parse.cc:3364
              o = 0x0
              v = 0x6290000e6668
              backup = {_vptr.Query_arena = <optimized out>, free_list = <optimized out>, mem_root = <optimized out>, is_backup_arena = <optimized out>, is_reprepared = <optimized out>, state = <optimized out>}
              it = {<base_list_iterator> = {list = <optimized out>, el = <optimized out>, prev = <optimized out>, current = <optimized out>}, <No data fields>}
              var = 0x6290000e6668
              mem_root = 0x6060000486e0
              __PRETTY_FUNCTION__ = "bool run_set_statement_if_requested(THD*, LEX*)"
      #9  0x00005588d145f29c in mysql_execute_command (thd=thd@entry=0x62b00007e218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/src/preview-10.10-timestamp/sql/sql_parse.cc:3708
              res = 0
              up_result = 0
              lex = 0x62b000082560
              select_lex = 0x62b000082e38
              first_table = 0x6290000e67e0
              all_tables = <optimized out>
              unit = 0x62b000082638
              have_table_map_for_update = false
              rpl_filter = <optimized out>
              _db_stack_frame_ = {func = <optimized out>, file = <optimized out>, level = <optimized out>, line = <optimized out>, prev = <optimized out>}
              __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*, bool)"
              ots = {ctx = <optimized out>, traceable = <optimized out>}
              orig_binlog_format = <optimized out>
              orig_current_stmt_binlog_format = <optimized out>
      #10 0x00005588d14940f1 in mysql_parse (thd=thd@entry=0x62b00007e218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7ff0bbcd8ba0) at /data/src/preview-10.10-timestamp/sql/sql_parse.cc:8034
              found_semicolon = 0x0
              error = <optimized out>
              lex = 0x62b000082560
              err = <optimized out>
              _db_stack_frame_ = {func = <optimized out>, file = <optimized out>, level = <optimized out>, line = <optimized out>, prev = <optimized out>}
              __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)"
      #11 0x00005588d14a5ed6 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62b00007e218, packet=packet@entry=0x62900025d219 "set statement explicit_defaults_for_timestamp=off for create table t (ts timestamp)", packet_length=packet_length@entry=83, blocking=blocking@entry=true) at /data/src/preview-10.10-timestamp/sql/sql_parse.cc:1894
              packet_end = 0x6290000e6433 ""
              parser_state = {m_lip = {lookahead_token = <optimized out>, lookahead_yylval = <optimized out>, m_thd = <optimized out>, m_ptr = <optimized out>, m_tok_start = <optimized out>, m_tok_end = <optimized out>, m_end_of_query = <optimized out>, m_tok_start_prev = <optimized out>, m_buf = <optimized out>, m_buf_length = <optimized out>, m_echo = <optimized out>, m_echo_saved = <optimized out>, m_cpp_buf = <optimized out>, m_cpp_ptr = <optimized out>, m_cpp_tok_start = <optimized out>, m_cpp_tok_start_prev = <optimized out>, m_cpp_tok_end = <optimized out>, m_body_utf8 = <optimized out>, m_body_utf8_ptr = <optimized out>, m_cpp_utf8_processed_ptr = <optimized out>, next_state = <optimized out>, found_semicolon = <optimized out>, ignore_space = <optimized out>, stmt_prepare_mode = <optimized out>, multi_statements = <optimized out>, yylineno = <optimized out>, m_digest = <optimized out>, in_comment = <optimized out>, in_comment_saved = <optimized out>, m_cpp_text_start = <optimized out>, m_cpp_text_end = <optimized out>, m_underscore_cs = <optimized out>}, m_yacc = {yacc_yyss = <optimized out>, yacc_yyvs = <optimized out>, m_set_signal_info = {m_item = {<optimized out> <repeats 13 times>}}, m_lock_type = <optimized out>, m_mdl_type = <optimized out>}, m_digest_psi = <optimized out>}
              net = 0x62b00007e550
              error = false
              do_end_of_statement = true
              _db_stack_frame_ = {func = <optimized out>, file = <optimized out>, level = <optimized out>, line = <optimized out>, prev = <optimized out>}
              drop_more_results = false
              __PRETTY_FUNCTION__ = "dispatch_command_return dispatch_command(enum_server_command, THD*, char*, uint, bool)"
              __FUNCTION__ = "dispatch_command"
              res = <optimized out>
      #12 0x00005588d14ba08f in do_command (thd=0x62b00007e218, blocking=blocking@entry=true) at /data/src/preview-10.10-timestamp/sql/sql_parse.cc:1407
              return_value = <optimized out>
              packet = 0x62900025d218 "\003set statement explicit_defaults_for_timestamp=off for create table t (ts timestamp)"
              packet_length = 84
              net = 0x62b00007e550
              command = COM_QUERY
              _db_stack_frame_ = {func = <optimized out>, file = <optimized out>, level = <optimized out>, line = <optimized out>, prev = <optimized out>}
              __PRETTY_FUNCTION__ = "dispatch_command_return do_command(THD*, bool)"
              __FUNCTION__ = "do_command"
      #13 0x00005588d1ff5e71 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x608000003fb8, put_in_cache=put_in_cache@entry=true) at /data/src/preview-10.10-timestamp/sql/sql_connect.cc:1418
              create_user = true
              thr_create_utime = 3823611805301
              thd = <optimized out>
              __PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*, bool)"
      #14 0x00005588d1ff7959 in handle_one_connection (arg=0x608000003fb8) at /data/src/preview-10.10-timestamp/sql/sql_connect.cc:1312
              connect = 0x608000003fb8
      #15 0x00005588d4926483 in pfs_spawn_thread (arg=0x617000004698) at /data/src/preview-10.10-timestamp/storage/perfschema/pfs.cc:2201
              typed_arg = 0x617000004698
              user_arg = 0x608000003fb8
              user_start_routine = 0x5588d1ff776b <handle_one_connection(void*)>
              pfs = <optimized out>
              klass = <optimized out>
      #16 0x00007ff0c6ec5ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
              ret = <optimized out>
              pd = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140671919695616, 1764612544888467309, 140732387508766, 140732387508767, 140671919693568, 1060864, -1757426015605985427, -1757349322521022611}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = 0
      #17 0x00007ff0c6158def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              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.