Version: '10.4.32-MariaDB-debug-log'
|
mysqld: /sql/item.cc:5903: virtual bool Item_field::fix_fields(THD*, Item**): Assertion `context' failed.
|
231031 12:22:26 [ERROR] mysqld got signal 6 ;
|
|
Server version: 10.4.32-MariaDB-debug-log source revision: bf5c2512397b6bb44752528bff4315b06834cd7a
|
|
sql/signal_handler.cc:238(handle_fatal_signal)[0x558cef781209]
|
sigaction.c:0(__restore_rt)[0x7fa15028e420]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb)[0x7fa14fd7700b]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x12b)[0x7fa14fd56859]
|
sql/item.cc:5911(Item_field::fix_fields(THD*, Item**))[0x558cef80407c]
|
sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad]
|
sql/item_func.cc:355(Item_func::fix_fields(THD*, Item**))[0x558cef8de3a0]
|
sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad]
|
sql/item.h:970(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x558ceed225e7]
|
sql/item.h:975(Item::fix_fields_if_needed_for_bool(THD*, Item**))[0x558ceee5a9e5]
|
sql/item_cmpfunc.cc:4848(Item_cond::fix_fields(THD*, Item**))[0x558cef87bf26]
|
sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad]
|
sql/item_func.cc:355(Item_func::fix_fields(THD*, Item**))[0x558cef8de3a0]
|
sql/item_cmpfunc.cc:3145(Item_func_case::fix_fields(THD*, Item**))[0x558cef86cdab]
|
sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad]
|
sql/item_func.cc:355(Item_func::fix_fields(THD*, Item**))[0x558cef8de3a0]
|
sql/sql_lex.cc:10407(st_select_lex::pushdown_from_having_into_where(THD*, Item*))[0x558ceef826c8]
|
sql/sql_select.cc:2139(JOIN::optimize_inner())[0x558cef07f727]
|
sql/sql_select.cc:1711(JOIN::optimize())[0x558cef07aba7]
|
sql/sql_lex.cc:4236(st_select_lex::optimize_unflattened_subqueries(bool))[0x558ceef535a0]
|
sql/opt_subselect.cc:5603(JOIN::optimize_unflattened_subqueries())[0x558cef4c4b6f]
|
sql/sql_select.cc:3165(JOIN::optimize_stage2())[0x558cef089db4]
|
sql/sql_select.cc:2394(JOIN::optimize_inner())[0x558cef081e9c]
|
sql/sql_select.cc:1711(JOIN::optimize())[0x558cef07aba7]
|
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*))[0x558cef09bb99]
|
sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x558cef06c89e]
|
sql/sql_parse.cc:6475(execute_sqlcom_select(THD*, TABLE_LIST*))[0x558ceefd86a8]
|
sql/sql_parse.cc:3978(mysql_execute_command(THD*))[0x558ceefc5e1f]
|
sql/sql_parse.cc:8012(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558ceefe1b83]
|
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x558ceefb7fa9]
|
sql/sql_parse.cc:1378(do_command(THD*))[0x558ceefb4ad4]
|
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x558cef3c2709]
|
sql/sql_connect.cc:1325(handle_one_connection)[0x558cef3c1fad]
|
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x558cf006c1c8]
|
nptl/pthread_create.c:478(start_thread)[0x7fa150282609]
|
|
Query (0x62b0000a1290): SELECT * FROM v0 WHERE v1 NOT IN ( 10 + 49 , 0 >= ( SELECT v2 - 38 FROM v0 WHERE v1 IS NULL GROUP BY v2 , v2 HAVING ( CASE WHEN v2 IS NULL THEN v2 LIKE 'x' OR v1 = 'x' ELSE 127 END ) = -2147483648 ) ) GROUP BY v1 , v1 HAVING 86 = v1 ORDER BY v2
|
Thanks! Fixed by 73ef86d commit (
MDEV-29731):Version: '10.4.32-MariaDB-debug-log'
mysqld: /sql/item.cc:5903: virtual bool Item_field::fix_fields(THD*, Item**): Assertion `context' failed.
231031 12:22:26 [ERROR] mysqld got signal 6 ;
Server version: 10.4.32-MariaDB-debug-log source revision: bf5c2512397b6bb44752528bff4315b06834cd7a
sql/signal_handler.cc:238(handle_fatal_signal)[0x558cef781209]
sigaction.c:0(__restore_rt)[0x7fa15028e420]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb)[0x7fa14fd7700b]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x12b)[0x7fa14fd56859]
sql/item.cc:5911(Item_field::fix_fields(THD*, Item**))[0x558cef80407c]
sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad]
sql/item_func.cc:355(Item_func::fix_fields(THD*, Item**))[0x558cef8de3a0]
sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad]
sql/item.h:970(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x558ceed225e7]
sql/item.h:975(Item::fix_fields_if_needed_for_bool(THD*, Item**))[0x558ceee5a9e5]
sql/item_cmpfunc.cc:4848(Item_cond::fix_fields(THD*, Item**))[0x558cef87bf26]
sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad]
sql/item_func.cc:355(Item_func::fix_fields(THD*, Item**))[0x558cef8de3a0]
sql/item_cmpfunc.cc:3145(Item_func_case::fix_fields(THD*, Item**))[0x558cef86cdab]
sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad]
sql/item_func.cc:355(Item_func::fix_fields(THD*, Item**))[0x558cef8de3a0]
sql/sql_lex.cc:10407(st_select_lex::pushdown_from_having_into_where(THD*, Item*))[0x558ceef826c8]
sql/sql_select.cc:2139(JOIN::optimize_inner())[0x558cef07f727]
sql/sql_select.cc:1711(JOIN::optimize())[0x558cef07aba7]
sql/sql_lex.cc:4236(st_select_lex::optimize_unflattened_subqueries(bool))[0x558ceef535a0]
sql/opt_subselect.cc:5603(JOIN::optimize_unflattened_subqueries())[0x558cef4c4b6f]
sql/sql_select.cc:3165(JOIN::optimize_stage2())[0x558cef089db4]
sql/sql_select.cc:2394(JOIN::optimize_inner())[0x558cef081e9c]
sql/sql_select.cc:1711(JOIN::optimize())[0x558cef07aba7]
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*))[0x558cef09bb99]
sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x558cef06c89e]
sql/sql_parse.cc:6475(execute_sqlcom_select(THD*, TABLE_LIST*))[0x558ceefd86a8]
sql/sql_parse.cc:3978(mysql_execute_command(THD*))[0x558ceefc5e1f]
sql/sql_parse.cc:8012(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558ceefe1b83]
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x558ceefb7fa9]
sql/sql_parse.cc:1378(do_command(THD*))[0x558ceefb4ad4]
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x558cef3c2709]
sql/sql_connect.cc:1325(handle_one_connection)[0x558cef3c1fad]
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x558cf006c1c8]
nptl/pthread_create.c:478(start_thread)[0x7fa150282609]
Query (0x62b0000a1290): SELECT * FROM v0 WHERE v1 NOT IN ( 10 + 49 , 0 >= ( SELECT v2 - 38 FROM v0 WHERE v1 IS NULL GROUP BY v2 , v2 HAVING ( CASE WHEN v2 IS NULL THEN v2 LIKE 'x' OR v1 = 'x' ELSE 127 END ) = -2147483648 ) ) GROUP BY v1 , v1 HAVING 86 = v1 ORDER BY v2