Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.3.2, 10.4(EOL), 10.5, 10.6, 10.11, 11.1(EOL), 11.2, 11.3(EOL)
-
None
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
- duplicates
-
MDEV-30455 Assertion result != FTS_INVALID in fts_trx_row_get_new_state()
- Confirmed