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

Crash the server by a UPDATE statement

    XMLWordPrintable

Details

    Description

      How to repeat:
      First, initialize an empty database by the file `init_by_me.txt`.
      Second, run the following statement:

      UPDATE IGNORE t49 SET c1 = 'h' WHERE (NULL LIKE c1) IS NOT TRUE;
      

      I got the following trace

      2024-05-13 00:48:40 Server version: 11.3.2-MariaDB-1:11.3.2+maria~ubu2204 source revision: 068a6819eb63bcb01fdfa037c9bf3bf63c33ee42
      2024-05-13 00:48:40 key_buffer_size=134217728
      2024-05-13 00:48:40 read_buffer_size=131072
      2024-05-13 00:48:40 max_used_connections=1
      2024-05-13 00:48:40 max_threads=153
      2024-05-13 00:48:40 thread_count=1
      2024-05-13 00:48:40 It is possible that mysqld could use up to 
      2024-05-13 00:48:40 key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468064 K  bytes of memory
      2024-05-13 00:48:40 Hope that's ok; if not, decrease some variables in the equation.
      2024-05-13 00:48:40 
      2024-05-13 00:48:40 Thread pointer: 0x7f7408000c68
      2024-05-13 00:48:40 Attempting backtrace. You can use the following information to find out
      2024-05-13 00:48:40 where mysqld died. If you see no messages after this, something went
      2024-05-13 00:48:40 terribly wrong...
      2024-05-13 00:48:40 stack_bottom = 0x7f745015cc38 thread_stack 0x49000
      2024-05-13 00:48:40 Printing to addr2line failed
      2024-05-13 00:48:40 mariadbd(my_print_stacktrace+0x32)[0x5571b6e7a8a2]
      2024-05-13 00:48:40 mariadbd(handle_fatal_signal+0x478)[0x5571b694b488]
      2024-05-13 00:48:40 /lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7f7453cb8520]
      2024-05-13 00:48:40 /lib/x86_64-linux-gnu/libc.so.6(pthread_kill+0x12c)[0x7f7453d0c9fc]
      2024-05-13 00:48:40 /lib/x86_64-linux-gnu/libc.so.6(raise+0x16)[0x7f7453cb8476]
      2024-05-13 00:48:40 /lib/x86_64-linux-gnu/libc.so.6(abort+0xd3)[0x7f7453c9e7f3]
      2024-05-13 00:48:40 mariadbd(+0x6d115e)[0x5571b654815e]
      2024-05-13 00:48:40 mariadbd(+0x6e84bc)[0x5571b655f4bc]
      2024-05-13 00:48:40 mariadbd(+0xf63aa3)[0x5571b6ddaaa3]
      2024-05-13 00:48:40 mariadbd(+0xe65b64)[0x5571b6cdcb64]
      2024-05-13 00:48:40 mariadbd(+0xe9664a)[0x5571b6d0d64a]
      2024-05-13 00:48:40 mariadbd(+0xe99be6)[0x5571b6d10be6]
      2024-05-13 00:48:40 mariadbd(+0xe9b690)[0x5571b6d12690]
      2024-05-13 00:48:40 mariadbd(+0xe78582)[0x5571b6cef582]
      2024-05-13 00:48:40 mariadbd(+0xdc4e53)[0x5571b6c3be53]
      2024-05-13 00:48:40 mariadbd(_ZN7handler13ha_update_rowEPKhS1_+0x272)[0x5571b695b8a2]
      2024-05-13 00:48:40 mariadbd(_ZN14Sql_cmd_update19update_single_tableEP3THD+0x1ec9)[0x5571b67b5f99]
      2024-05-13 00:48:40 mariadbd(_ZN14Sql_cmd_update13execute_innerEP3THD+0x10d)[0x5571b67b682d]
      2024-05-13 00:48:40 mariadbd(_ZN11Sql_cmd_dml7executeEP3THD+0xc3)[0x5571b6704d73]
      2024-05-13 00:48:40 mariadbd(_Z21mysql_execute_commandP3THDb+0x4911)[0x5571b66cdb11]
      2024-05-13 00:48:40 mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x5571b66ceb77]
      2024-05-13 00:48:40 mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x14cd)[0x5571b66d136d]
      2024-05-13 00:48:40 mariadbd(_Z10do_commandP3THDb+0x138)[0x5571b66d3278]
      2024-05-13 00:48:40 mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x5571b67ff7cf]
      2024-05-13 00:48:40 mariadbd(handle_one_connection+0x5d)[0x5571b67ffb1d]
      2024-05-13 00:48:40 mariadbd(+0xd05f86)[0x5571b6b7cf86]
      2024-05-13 00:48:40 /lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7f7453d0aac3]
      2024-05-13 00:48:40 /lib/x86_64-linux-gnu/libc.so.6(+0x126850)[0x7f7453d9c850]
      2024-05-13 00:48:40 
      2024-05-13 00:48:40 Trying to get some variables.
      2024-05-13 00:48:40 Some pointers may be invalid and cause the dump to abort.
      2024-05-13 00:48:40 Query (0x7f7408010b40): UPDATE IGNORE t49 SET c1 = 'h' WHERE (NULL LIKE c1) IS NOT TRUE
      2024-05-13 00:48:40 
      2024-05-13 00:48:40 Connection ID (thread ID): 3
      2024-05-13 00:48:40 Status: NOT_KILLED
      2024-05-13 00:48:40 
      2024-05-13 00:48:40 Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=on,cset_narrowing=off,sargable_casefold=on
      

      Attachments

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              John Jove John Jove
              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.