[MDEV-26973] Assertion `anc_page->org_size == anc_page->size' failed in d_search upon query with EXCEPT Created: 2021-11-04  Updated: 2023-11-28

Status: Confirmed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0
Fix Version/s: 10.5, 10.6, 10.11, 11.0

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

Attachments: File 1_my.test    
Issue Links:
Relates
relates to MDEV-16659 Assertion `anc_page->org_size == anc_... Stalled

 Description   

reproducible on 10.5-10.7, with Myisam/InnoDB.
maybe exists also on earlier version, but dependent on dataset/..

10.5 a8ded395578ccab9c256b9be

 
Version: '10.5.13-MariaDB-debug-log'  
mariadbd: /10.5/src/storage/maria/ma_delete.c:507: d_search: Assertion `anc_page->org_size == anc_page->size' failed.
 
211104 16:26:02 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 10.5.13-MariaDB-debug-log
 
 
 
??:0(__assert_fail)[0x7f327e738f36]
 
maria/ma_delete.c:509(d_search)[0x5577eb6cc0cf]
 
maria/ma_delete.c:422(d_search)[0x5577eb6cb579]
 
maria/ma_delete.c:235(_ma_ck_real_delete)[0x5577eb6c952d]
 
maria/ma_delete.c:184(_ma_ck_delete)[0x5577eb6c89af]
 
maria/ma_delete.c:88(maria_delete)[0x5577eb6c7306]
 
maria/ha_maria.cc:2411(ha_maria::delete_row(unsigned char const*))[0x5577eb5583cd]
 
sql/sql_class.h:7065(handler::ha_delete_tmp_row(unsigned char*))[0x5577ea9a2a83]
 
sql/sql_union.cc:516(select_unit::delete_record())[0x5577ea98a179]
 
sql/sql_union.cc:169(select_unit::send_data(List<Item>&))[0x5577ea987191]
 
sql/sql_class.h:5341(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x5577ea83b613]
 
sql/sql_select.cc:22085(end_send(JOIN*, st_join_table*, bool))[0x5577ea7f63a6]
 
sql/sql_select.cc:21103(evaluate_join_record(JOIN*, st_join_table*, int))[0x5577ea7ee691]
 
sql/sql_select.cc:29246(AGGR_OP::end_send())[0x5577ea82cf24]
 
sql/sql_select.cc:20583(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x5577ea7ebd8e]
 
sql/sql_select.cc:20818(sub_select(JOIN*, st_join_table*, bool))[0x5577ea7ec741]
 
sql/sql_select.cc:20409(do_select(JOIN*, Procedure*))[0x5577ea7eb162]
 
sql/sql_select.cc:4516(JOIN::exec_inner())[0x5577ea776e87]
 
sql/sql_select.cc:4297(JOIN::exec())[0x5577ea774496]
 
sql/sql_union.cc:2238(st_select_lex_unit::exec())[0x5577ea99b0f9]
 
sql/sql_union.cc:42(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long))[0x5577ea985cf0]
 
sql/sql_select.cc:434(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5577ea749af9]
 
sql/sql_parse.cc:6314(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5577ea6b2149]
 
sql/sql_parse.cc:4005(mysql_execute_command(THD*))[0x5577ea6a10ea]
 
sql/sql_parse.cc:8100(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5577ea6bd4a2]
 
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5577ea693363]
 
sql/sql_parse.cc:1370(do_command(THD*))[0x5577ea68fca2]
 
sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x5577eaada1a3]
 
sql/sql_connect.cc:1314(handle_one_connection)[0x5577eaad99bc]
 
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5577eb7f3b95]
 
nptl/pthread_create.c:478(start_thread)[0x7f327ec51609]
 
??:0(clone)[0x7f327e824293]
 
 
 
Query (0x62b0000852a8): (SELECT a1 FROM t1 GROUP BY pk) EXCEPT (SELECT a1 FROM t1 GROUP BY pk)



 Comments   
Comment by Alice Sherepa [ 2023-03-17 ]

on 11.0:

mariadbd: /storage/maria/ma_delete.c:507: d_search: Assertion `anc_page->org_size == anc_page->size' failed.
 
Server version: 11.0.2-MariaDB-debug-log source revision: 090e5d8b945bb2d0dfad1193c23cdc1bd271344e
 
230317 14:41:49 [ERROR] mysqld got signal 6 ;
 
 
 
 
 
??:0(__assert_fail)[0x7f1d9f05bfd6]
 
maria/ma_delete.c:509(d_search)[0x55b8dcbaf414]
 
maria/ma_delete.c:422(d_search)[0x55b8dcbae8be]
 
maria/ma_delete.c:235(_ma_ck_real_delete)[0x55b8dcbac86d]
 
maria/ma_delete.c:184(_ma_ck_delete)[0x55b8dcbabd14]
 
maria/ma_delete.c:88(maria_delete)[0x55b8dcbaa66b]
 
maria/ha_maria.cc:2514(ha_maria::delete_row(unsigned char const*))[0x55b8dca3b469]
 
sql/sql_class.h:7526(handler::ha_delete_tmp_row(unsigned char*))[0x55b8dbf622d9]
 
sql/sql_union.cc:533(select_unit::delete_record())[0x55b8dbf49db3]
 
sql/sql_union.cc:169(select_unit::send_data(List<Item>&))[0x55b8dbf46d25]
 
sql/sql_class.h:5748(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x55b8dbdf0d13]
 
sql/sql_select.cc:24302(end_send(JOIN*, st_join_table*, bool))[0x55b8dbdaae28]
 
sql/sql_select.cc:23269(evaluate_join_record(JOIN*, st_join_table*, int))[0x55b8dbda2c18]
 
sql/sql_select.cc:31533(AGGR_OP::end_send())[0x55b8dbde1161]
 
sql/sql_select.cc:22733(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x55b8dbda002b]
 
sql/sql_select.cc:22970(sub_select(JOIN*, st_join_table*, bool))[0x55b8dbda09de]
 
sql/sql_select.cc:22570(do_select(JOIN*, Procedure*))[0x55b8dbd9f314]
 
sql/sql_select.cc:4895(JOIN::exec_inner())[0x55b8dbd2002f]
 
sql/sql_select.cc:4672(JOIN::exec())[0x55b8dbd1d3e0]
 
sql/sql_union.cc:2248(st_select_lex_unit::exec())[0x55b8dbf5ab10]
 
sql/sql_union.cc:42(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long long))[0x55b8dbf45884]
 
sql/sql_select.cc:601(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x55b8dbcf140f]
 
sql/sql_parse.cc:6267(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55b8dbc1399d]
 
sql/sql_parse.cc:3949(mysql_execute_command(THD*, bool))[0x55b8dbc0224c]
 
sql/sql_parse.cc:7999(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55b8dbc1e720]
 
sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55b8dbbf4976]
 
sql/sql_parse.cc:1407(do_command(THD*, bool))[0x55b8dbbf16b2]
 
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55b8dc0be745]
 
sql/sql_connect.cc:1320(handle_one_connection)[0x55b8dc0be0a2]
 
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55b8dccd6e2e]
 
nptl/pthread_create.c:478(start_thread)[0x7f1d9f576609]

Generated at Thu Feb 08 09:49:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.