Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
11.2.3
-
Ubuntu 20.04.6 LTS
Description
This query crashes my database:
DELETE indeclaratievoortgangsuggestie FROM indeclaratievoortgangsuggestie inner join inregel on inregel.inrgl_id=indeclaratievoortgangsuggestie.inrgl_id WHERE indeclaratievoortgangsuggestie.taak_id=38514483 and inregel.inbst_id=476
7788
A select * FROM indeclaratievoortgangsuggestie inner join inregel on inregel.inrgl_id=indeclaratievoortgangsuggestie.inrgl_id WHERE indeclaratievoortgangsuggestie.taak_id=38514483 and inregel.inbst_id=476
7788
Works fine and returns one record.
Server version: 11.2.3-MariaDB-1:11.2.3+maria~ubu2204-log source revision: 79580f4f96fc2547711f674eb8dd514abd312b4a
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=241
max_threads=802
thread_count=241
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1897788 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x7ee1ac000c68
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7ee4b445fc38 thread_stack 0x49000
/usr/sbin/mariadbd(my_print_stacktrace+0x32)[0x5582d20d6d02]
/usr/sbin/mariadbd(handle_fatal_signal+0x478)[0x5582d1ba9968]
/lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7f45d6242520]
/usr/sbin/mariadbd(handler_rowid_filter_check+0x58)[0x5582d1bb7a38]
/usr/sbin/mariadbd(+0xe82984)[0x5582d1f5f984]
/usr/sbin/mariadbd(+0xe861c7)[0x5582d1f631c7]
/usr/sbin/mariadbd(+0xdc12ac)[0x5582d1e9e2ac]
/usr/sbin/mariadbd(ZN7handler10ha_rnd_posEPhS0+0x2da)[0x5582d1bb169a]
/usr/sbin/mariadbd(_Z16rr_from_pointersP11READ_RECORD+0x3c)[0x5582d185607c]
/usr/sbin/mariadbd(_ZN12multi_delete16do_table_deletesEP5TABLEP9SORT_INFOb+0x98)[0x5582d18df048]
/usr/sbin/mariadbd(_ZN12multi_delete10do_deletesEv+0x88)[0x5582d18df308]
/usr/sbin/mariadbd(_ZN12multi_delete8send_eofEv+0x75)[0x5582d18df3e5]
/usr/sbin/mariadbd(_ZN4JOIN10exec_innerEv+0xf8a)[0x5582d19abe6a]
/usr/sbin/mariadbd(_ZN4JOIN4execEv+0x3f)[0x5582d19ac31f]
/usr/sbin/mariadbd(_ZN11Sql_cmd_dml13execute_innerEP3THD+0x7a)[0x5582d19ac44a]
/usr/sbin/mariadbd(_ZN14Sql_cmd_delete13execute_innerEP3THD+0x2a)[0x5582d18decea]
/usr/sbin/mariadbd(_ZN11Sql_cmd_dml7executeEP3THD+0xc3)[0x5582d1963f23]
/usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x4672)[0x5582d192ce22]
/usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x5582d192ddb7]
/usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x14cd)[0x5582d19305ad]
/usr/sbin/mariadbd(_Z10do_commandP3THDb+0x138)[0x5582d19324b8]
/usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x5582d1a5e8ff]
/usr/sbin/mariadbd(handle_one_connection+0x5d)[0x5582d1a5ec4d]
/usr/sbin/mariadbd(+0xcfce26)[0x5582d1dd9e26]
/lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7f45d6294ac3]
nptl/pthread_create.c:442(start_thread)[0x7f45d6326850]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7ee1ac011650): DELETE indeclaratievoortgangsuggestie FROM indeclaratievoortgangsuggestie inner join inregel on inregel.inrgl_id=indeclaratievoortgangsuggestie.inrgl_id WHERE indeclaratievoortgangsuggestie.taak_id=38514483 and inregel.inbst_id=4767788
Connection ID (thread ID): 6923
Status: NOT_KILLED
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=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
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /intel1/mydata/data
Resource Limits:
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 8388608 unlimited bytes
Max core file size 0 unlimited bytes
Max resident set unlimited unlimited bytes
Max processes 2062195 2062195 processes
Max open files 100000 100000 files
Max locked memory 524288 524288 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 2062195 2062195 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us
Core pattern: |/usr/share/apport/apport -p%p -s%s -c%c -d%d -P%P -u%u -g%g – %E
Kernel version: Linux version 6.2.0-39-generic (buildd@lcy02-amd64-045) (x86_64-linux-gnu-gcc-11 (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #40~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Thu Nov 16 10:53:04 UTC 2
Attachments
Issue Links
- duplicates
-
MDEV-33533 Crash at execution of DELETE when trying to use rowid filter
- Closed