[MDEV-29074] GET_BIT variables crash in SET STATEMENT Created: 2022-07-09  Updated: 2022-07-30  Resolved: 2022-07-26

Status: Closed
Project: MariaDB Server
Component/s: Variables
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s: 10.3.36, 10.4.26, 10.5.17, 10.6.9, 10.7.5, 10.8.4

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-18776 Assertion `0' failed in mysql_execute... Closed
Relates
relates to MDEV-29217 Assertion failure in Item_param::can_... Open

 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



 Comments   
Comment by Sergei Golubchik [ 2022-07-18 ]

set statement log_queries_not_using_indexes=1 for select @@log_queries_not_using_indexes;

Generated at Thu Feb 08 10:05:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.