[MDEV-25700] Server crashed on query Created: 2021-05-17  Updated: 2021-05-19

Status: Open
Project: MariaDB Server
Component/s: Data Manipulation - Subquery
Affects Version/s: 10.5.3
Fix Version/s: None

Type: Bug Priority: Major
Reporter: gobeline killer Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Windows 64 bits


Attachments: File DESKTOP-CIAQJBR.err     File my.ini     File request.sql    

 Description   

Server crashed on query

SHOW TABLES AS `tables` WHERE tables_in_<nom de la bdd> NOT IN ('F_11O8SCR4UN','F_159','F_1DRHC7V9UK','F_UTILISATEUR',....);

You can find the query in pj.

The query works on other environnements (linux).

Also in pj the crashe report and the my.ini



 Comments   
Comment by Alice Sherepa [ 2021-05-19 ]

Is it possible for you to upgrade to the recent version and check if the bug is reproducible there?
from the log:

210419 18:24:06 [ERROR] mysqld got exception 0xc0000005 ;
 
Server version: 10.5.3-MariaDB
 
server.dll!heap_rkey()[hp_rkey.c:23]
server.dll!h()[ha_heap.cc:293]
server.dll!handler::ha_index_read_map()[handler.cc:3048]
server.dll!subselect_indexsubquery_engine::exec()[item_subselect.cc:4314]
server.dll!Item_subselect::exec()[item_subselect.cc:748]
server.dll!Item_in_subselect::val_bool()[item_subselect.cc:1806]
server.dll!Item_in_optimizer::val_int()[item_cmpfunc.cc:1656]
server.dll!Item_cache_int::cache_value()[item.cc:9808]
server.dll!Item_cache_wrapper::val_bool()[item.cc:8766]
server.dll!Item_func_not::val_int()[item_cmpfunc.cc:203]
server.dll!Type_handler_int_result::Item_val_bool()[sql_type.cc:4915]
server.dll!Item_cond_and::val_int()[item_cmpfunc.cc:5403]
server.dll!evaluate_join_record()[sql_select.cc:20716]
server.dll!sub_select()[sql_select.cc:20615]
server.dll!do_select()[sql_select.cc:20149]
server.dll!JOIN::exec_inner()[sql_select.cc:4464]
server.dll!JOIN::exec()[sql_select.cc:4246]
server.dll!mysql_select()[sql_select.cc:4671]
server.dll!handle_select()[sql_select.cc:417]
server.dll!execute_sqlcom_select()[sql_parse.cc:6172]
server.dll!mysql_execute_command()[sql_parse.cc:3901]
server.dll!mysql_parse()[sql_parse.cc:7961]
server.dll!dispatch_command()[sql_parse.cc:1842]
server.dll!do_command()[sql_parse.cc:1358]
server.dll!threadpool_process_request()[threadpool_common.cc:354]
server.dll!tp_callback()[threadpool_common.cc:194]
ntdll.dll!TpAllocPool()
ntdll.dll!TpReleaseCleanupGroupMembers()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()
 
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x2346987d150): SHOW TABLES where tables_in_bpi REGEXP '^(F_|R_|OLD_).*$' AND tables_in_bpi NOT IN ('F_11O8SCR4UN','F_159','F_1DRHC7V9UK','F_UTILISATEUR',....

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