[MDEV-32083] Maraidb server crashes with empty backtrace log Created: 2023-09-04  Updated: 2023-11-28

Status: Confirmed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.4, 10.5, 10.6, 10.9, 10.10, 10.11, 11.0, 10.11.5
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1

Type: Bug Priority: Major
Reporter: jiaqi Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-29210 Assertion `param->field_count > (uint... Confirmed

 Description   

How to trigger

CREATE TABLE t0 ( c0 MIDDLEINT PRIMARY KEY ) WITH SYSTEM VERSIONING ;
 
REPLACE INTO t0 SELECT ( SELECT MIN( ra4 . ca3 ) ca1 FROM ( SELECT FOUND_ROWS( ) ca3 FROM t0 ra3 ) ra4 ORDER BY c0 , ra4 . ca3  ) AS ca2 FROM t0 ;

The server failed to log the backtrace when it crashed.

 Comments   
Comment by Alice Sherepa [ 2023-09-04 ]

Thanks!
I repeated on 10.4-11.3, with InnoDB, not repeatable with Myisam/Aria

Version: '10.4.32-MariaDB-debug-log'  
mysqld: /10.4/src/sql/sql_select.cc:25665: bool setup_copy_fields(THD*, TMP_TABLE_PARAM*, Ref_ptr_array, List<Item>&, List<Item>&, uint, List<Item>&): Assertion `param->field_count > (uint) (copy - copy_start)' failed.
 
230904 11:40:54 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 10.4.32-MariaDB-debug-log source revision: 02878f128e12448f995efd2551be65dc13c458a5
 
 
 
mysys/stacktrace.c:174(my_print_stacktrace)[0x5580dda2f975]
 
sql/signal_handler.cc:238(handle_fatal_signal)[0x5580dc5d1225]
 
sql/sql_select.cc:25666(setup_copy_fields(THD*, TMP_TABLE_PARAM*, Bounds_checked_array<Item*>, List<Item>&, List<Item>&, unsigned int, List<Item>&))[0x5580dbf82d03]
 
sql/sql_select.cc:3732(JOIN::make_aggr_tables_info())[0x5580dbee12a3]
 
sql/sql_select.cc:3108(JOIN::optimize_stage2())[0x5580dbed9f68]
 
sql/sql_select.cc:2394(JOIN::optimize_inner())[0x5580dbed27bc]
 
sql/sql_select.cc:1711(JOIN::optimize())[0x5580dbecb4c7]
 
sql/sql_lex.cc:4236(st_select_lex::optimize_unflattened_subqueries(bool))[0x5580dbda400e]
 
sql/opt_subselect.cc:5603(JOIN::optimize_unflattened_subqueries())[0x5580dc315235]
 
sql/sql_select.cc:2942(JOIN::optimize_stage2())[0x5580dbed8845]
 
sql/sql_select.cc:2394(JOIN::optimize_inner())[0x5580dbed27bc]
 
sql/sql_select.cc:1711(JOIN::optimize())[0x5580dbecb4c7]
 
sql/sql_select.cc:4812(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5580dbeec4b9]
 
sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5580dbebd258]
 
sql/sql_parse.cc:4727(mysql_execute_command(THD*))[0x5580dbe1b616]
 
sql/sql_parse.cc:8010(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5580dbe3253d]
 
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5580dbe0899f]
 
sql/sql_parse.cc:1378(do_command(THD*))[0x5580dbe054ca]
 
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x5580dc212dcf]
 
sql/sql_connect.cc:1325(handle_one_connection)[0x5580dc212673]
 
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x5580dcebbe00]
 
nptl/pthread_create.c:478(start_thread)[0x7fe7a537d609]
 
 
 
Query (0x62b0000a1290): REPLACE INTO t0 SELECT ( SELECT MIN( ra4 . ca3 ) ca1 FROM ( SELECT FOUND_ROWS( ) ca3 FROM t0 ra3 ) ra4 ORDER BY c0 , ra4 . ca3  ) AS ca2 FROM t0


 
 
230904 11:37:59 [ERROR] mysqld got signal 11 ;
 
 
 
Server version: 10.4.31-MariaDB source revision: 2aea9387497cecb5668ef605b8f80886f9de812c
 
 
 
sql/signal_handler.cc:238(handle_fatal_signal)[0x5564ee8fd627]
 
sigaction.c:0(__restore_rt)[0x7ff600a9e420]
 
sql/sql_select.cc:25831(JOIN::make_sum_func_list(List<Item>&, List<Item>&, bool, bool))[0x5564ee7428c2]
 
sql/sql_select.cc:3747(JOIN::make_aggr_tables_info())[0x5564ee750864]
 
sql/sql_select.cc:3108(JOIN::optimize_stage2())[0x5564ee75d6d9]
 
sql/sql_select.cc:2394(JOIN::optimize_inner())[0x5564ee75eef5]
 
sql/sql_select.cc:1713(JOIN::optimize())[0x5564ee76183d]
 
sql/sql_lex.cc:4236(st_select_lex::optimize_unflattened_subqueries(bool))[0x5564ee6ef670]
 
sql/sql_select.cc:2942(JOIN::optimize_stage2())[0x5564ee75d4cc]
 
sql/sql_select.cc:2394(JOIN::optimize_inner())[0x5564ee75eef5]
 
sql/sql_select.cc:1713(JOIN::optimize())[0x5564ee76183d]
 
sql/sql_select.cc:4812(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5564ee761951]
 
sql/sql_select.cc:454(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5564ee762577]
 
sql/sql_parse.cc:4727(mysql_execute_command(THD*))[0x5564ee708818]
 
sql/sql_parse.cc:8010(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5564ee709e72]
 
sql/sql_parse.cc:1919(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5564ee70cac2]
 
sql/sql_parse.cc:1379(do_command(THD*))[0x5564ee70dbe2]
 
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x5564ee7f2602]
 
sql/sql_connect.cc:1326(handle_one_connection)[0x5564ee7f26ed]
 
nptl/pthread_create.c:478(start_thread)[0x7ff600a92609]
 
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7ff60067e133]
 
 
 
Query (0x7ff590010300): REPLACE INTO t0 SELECT ( SELECT MIN( ra4 . ca3 ) ca1 FROM ( SELECT FOUND_ROWS( ) ca3 FROM t0 ra3 ) ra4 ORDER BY c0 , ra4 . ca3  ) AS ca2 FROM t0


--source include/have_innodb.inc
 
 
 
CREATE TABLE t0 ( i int) engine=innodb ;
 
INSERT INTO t0
 
	SELECT (SELECT min(dt.a) FROM (SELECT 1 a FROM t0) dt ORDER BY i, dt.a) FROM t0 tb;


mysqld: /10.4/src/sql/sql_select.cc:25665: bool setup_copy_fields(THD*, TMP_TABLE_PARAM*, Ref_ptr_array, List<Item>&, List<Item>&, uint, List<Item>&): Assertion `param->field_count > (uint) (copy - copy_start)' failed.
 
230904 12:51:58 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 10.4.32-MariaDB-debug-log source revision: 02878f128e12448f995efd2551be65dc13c458a5
 
 
 
sql/signal_handler.cc:238(handle_fatal_signal)[0x55a51c05f225]
 
sigaction.c:0(__restore_rt)[0x7f0c4e323420]
 
sql/sql_select.cc:25666(setup_copy_fields(THD*, TMP_TABLE_PARAM*, Bounds_checked_array<Item*>, List<Item>&, List<Item>&, unsigned int, List<Item>&))[0x55a51ba10d03]
 
sql/sql_select.cc:3732(JOIN::make_aggr_tables_info())[0x55a51b96f2a3]
 
sql/sql_select.cc:3108(JOIN::optimize_stage2())[0x55a51b967f68]
 
sql/sql_select.cc:2394(JOIN::optimize_inner())[0x55a51b9607bc]
 
sql/sql_select.cc:1711(JOIN::optimize())[0x55a51b9594c7]
 
sql/sql_lex.cc:4236(st_select_lex::optimize_unflattened_subqueries(bool))[0x55a51b83200e]
 
sql/opt_subselect.cc:5603(JOIN::optimize_unflattened_subqueries())[0x55a51bda3235]
 
sql/sql_select.cc:2942(JOIN::optimize_stage2())[0x55a51b966845]
 
sql/sql_select.cc:2394(JOIN::optimize_inner())[0x55a51b9607bc]
 
sql/sql_select.cc:1711(JOIN::optimize())[0x55a51b9594c7]
 
sql/sql_select.cc:4812(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55a51b97a4b9]
 
sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55a51b94b258]
 
sql/sql_parse.cc:4727(mysql_execute_command(THD*))[0x55a51b8a9616]
 
sql/sql_parse.cc:8010(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55a51b8c053d]
 
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55a51b89699f]
 
sql/sql_parse.cc:1378(do_command(THD*))[0x55a51b8934ca]
 
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x55a51bca0dcf]
 
sql/sql_connect.cc:1325(handle_one_connection)[0x55a51bca0673]
 
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55a51c949e00]
 
nptl/pthread_create.c:478(start_thread)[0x7f0c4e317609]
 
 
 
Query (0x62b0000a1290): INSERT INTO t0
 
SELECT (SELECT min(dt.a) FROM (SELECT 1 a FROM t0) dt ORDER BY i, dt.a) FROM t0 tb

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