[#MDEV-28467] [ERROR] mysqld got exception 0xc0000005

[MDEV-28467] [ERROR] mysqld got exception 0xc0000005 Created: 2022-05-04 Updated: 2023-10-05
Status:	Confirmed
Project:	MariaDB Server
Component/s:	Data Definition - Procedure, Storage Engine - Connect
Affects Version/s:	10.5.15, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s:	10.4

Type:

Bug

Priority:

Major

Reporter:

HyeonSoon Jang

Assignee:

Olivier Bertrand

Resolution:

Unresolved

Votes:

Labels:

None

Environment:

Window Server 2016
MariaDB 10.5.15 (Innodb, Connect Storage Engine)

Description

*1. Error LOG*

220504 14:43:43 [ERROR] mysqld got exception 0xc0000005 ;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against is corrupt, improperly built,

or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help

diagnose the problem, but since we have already crashed,

something is definitely wrong and this may fail.

Server version: 10.5.15-MariaDB-log

key_buffer_size=134217728

read_buffer_size=8388608

max_used_connections=11

max_threads=65537

thread_count=13

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1073902023 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x2631f66ab28

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...

ha_connect.dll!TDBJGL::`vftable'()

ha_connect.dll!DTVAL::FormatValue()

ha_connect.dll!TDBASE::MakeIndex()

ha_connect.dll!TYPVAL<unsigned short>::MaxVal()

server.dll!handler::ha_rnd_next()[handler.cc:3080]

server.dll!rr_sequential()[records.cc:519]

server.dll!sub_select()[sql_select.cc:20910]

server.dll!do_select()[sql_select.cc:20445]

server.dll!JOIN::exec_inner()[sql_select.cc:4538]

server.dll!JOIN::exec()[sql_select.cc:4319]

server.dll!mysql_select()[sql_select.cc:4797]

server.dll!handle_select()[sql_select.cc:444]

server.dll!execute_sqlcom_select()[sql_parse.cc:6314]

server.dll!mysql_execute_command()[sql_parse.cc:4005]

server.dll!sp_instr_stmt::exec_core()[sp_head.cc:3775]

server.dll!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:3499]

server.dll!sp_instr_stmt::execute()[sp_head.cc:3679]

server.dll!sp_head::execute()[sp_head.cc:1437]

server.dll!sp_head::execute_function()[sp_head.cc:2166]

server.dll!Item_sp::execute_impl()[item.cc:2879]

server.dll!Item_sp::execute()[item.cc:2793]

server.dll!Item_func_sp::execute()[item_func.cc:6648]

server.dll!Item_func_sp::val_int()[item_func.h:3485]

server.dll!Type_handler::Item_send_long()[sql_type.cc:7488]

server.dll!Protocol::send_result_set_row()[protocol.cc:1087]

server.dll!select_send::send_data()[sql_class.cc:3081]

server.dll!end_send()[sql_select.cc:22124]

server.dll!evaluate_join_record()[sql_select.cc:21144]

server.dll!sub_select()[sql_select.cc:20952]

server.dll!do_select()[sql_select.cc:20445]

server.dll!JOIN::exec_inner()[sql_select.cc:4538]

server.dll!JOIN::exec()[sql_select.cc:4319]

server.dll!mysql_select()[sql_select.cc:4797]

server.dll!handle_select()[sql_select.cc:444]

server.dll!execute_sqlcom_select()[sql_parse.cc:6314]

server.dll!mysql_execute_command()[sql_parse.cc:4005]

server.dll!mysql_parse()[sql_parse.cc:8104]

server.dll!dispatch_command()[sql_parse.cc:1894]

server.dll!do_command()[sql_parse.cc:1370]

server.dll!threadpool_process_request()[threadpool_common.cc:370]

server.dll!tp_callback()[threadpool_common.cc:194]

ntdll.dll!RtlReleaseSRWLockExclusive()

ntdll.dll!RtlReleaseSRWLockExclusive()

KERNEL32.DLL!BaseThreadInitThunk()

ntdll.dll!RtlUserThreadStart()

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0x2631f81afe8): select

		count(closing_status) into vCloseCnt

	from CBO_EA_AP_PERIOD_V

	where  NAME_CONST('pPOST_DT',_utf8'20200115' COLLATE 'utf8_general_ci') >= date_format(start_date,'%Y%m%d')

	 and  NAME_CONST('pPOST_DT',_utf8'20200115' COLLATE 'utf8_general_ci') <= date_Format(end_date,'%Y%m%d')

	 and period_num <> 13

	 and closing_status <> 'O'

Connection ID (thread ID): 5

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

The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains

information that should help you find out what is causing the crash.

Writing a core file at D:\MariaDB_DIAEACCT_NEW\MariaDB_DATA\

Minidump written to D:\MariaDB_DIAEACCT_NEW\MariaDB_DATA\mysqld.dmp

*2. Test*

*  -- Connect Table Create*

CREATE TABLE `cbo_ea_ap_period_v` (

  `PERIOD_NAME` varchar(15) NOT NULL,

  `CLOSING_STATUS` varchar(1) NOT NULL,

  `START_DATE` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),

  `END_DATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',

  `PERIOD_YEAR` decimal(17,0) NOT NULL,

  `PERIOD_NUM` decimal(17,0) NOT NULL)

ENGINE=CONNECT DEFAULT CHARSET=euckr CONNECTION='DSN=TDIA_DIAT;UID=cboeacct;PWD=cboeacct' `TABLE_TYPE`='ODBC' `TABNAME`='CBO_EA_AP_PERIOD_V' `DBNAME`='APPS' `OPTION_LIST`='memory=2';

*  -- Function Create*

CREATE or replace DEFINER=``@`%` FUNCTION `fn_ap_close_test`(pPOST_DT varchar(8)

) RETURNS int(11)

begin

    DECLARE vCloseCnt  int;

    select

		count(closing_status) into vCloseCnt

	from CBO_EA_AP_PERIOD_V

	where pPOST_DT >= date_format(start_date,'%Y%m%d')

	 and pPOST_DT <= date_Format(end_date,'%Y%m%d')

	 and period_num <> 13

	 and closing_status <> 'O'

    RETURN vCloseCnt;

end

* -- Select Function*

	select  fn_ap_close_test(GR.post_dt)

		from TB_SLIP_GR GR

		where GR_SLIP_NO in ('GR202001-02892')

		;  <<= 1row Select Success

	select  fn_ap_close_test(GR.post_dt)

		from TB_SLIP_GR GR

		where GR_SLIP_NO in ('GR202001-02892','GR202001-02858')

    	        ;  *<<= Crash if check more than 2 lines+

Comments

Comment by Alice Sherepa [ 2022-05-04 ]

Could you please add the table definition for TB_SLIP_GR. Or maybe provide the full test case to demonstrate the problem.

Comment by HyeonSoon Jang [ 2022-05-06 ]

*environment : *

Window Server 2016
MariaDB 10.5.15 x64 (innodb Engine, Connect Engine)
odbc x64 / Oracle Client 11g x64
Oracle Database 9i

Test Case 1

1. Oracle Database

CREATE TABLE ORACLE_TABLE
(
PERIOD_NAME VARCHAR2(15) NOT NULL,
CLOSING_STATUS VARCHAR2(1) NOT NULL,
START_DATE DATE NOT NULL,
END_DATE DATE NOT NULL,
PERIOD_YEAR NUMBER(15) NOT NULL,
PERIOD_NUM NUMBER(15) NOT NULL
);
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('1월-20','C','01-JAN-20','31-JAN-20','2020','1');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('2월-20','C','01-FEB-20','29-FEB-20','2020','2');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('3월-20','C','01-MAR-20','31-MAR-20','2020','3');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('4월-20','C','01-APR-20','30-APR-20','2020','4');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('5월-20','C','01-MAY-20','31-MAY-20','2020','5');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('6월-20','C','01-JUN-20','30-JUN-20','2020','6');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('7월-20','C','01-JUL-20','31-JUL-20','2020','7');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('8월-20','C','01-AUG-20','31-AUG-20','2020','8');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('9월-20','C','01-SEP-20','30-SEP-20','2020','9');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('10월-20','C','01-OCT-20','31-OCT-20','2020','10');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('11월-20','C','01-NOV-20','30-NOV-20','2020','11');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('12월-20','C','01-DEC-20','31-DEC-20','2020','12');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('12월조정-20','N','01-DEC-20','31-DEC-20','2020','13');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('1월-22','C','01-JAN-22','31-JAN-22','2022','1');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('2월-22','C','01-FEB-22','28-FEB-22','2022','2');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('3월-22','C','01-MAR-22','31-MAR-22','2022','3');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('4월-22','O','01-APR-22','30-APR-22','2022','4');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('5월-22','N','01-MAY-22','31-MAY-22','2022','5');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('6월-22','N','01-JUN-22','30-JUN-22','2022','6');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('7월-22','N','01-JUL-22','31-JUL-22','2022','7');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('8월-22','N','01-AUG-22','31-AUG-22','2022','8');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('9월-22','N','01-SEP-22','30-SEP-22','2022','9');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('10월-22','N','01-OCT-22','31-OCT-22','2022','10');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('11월-22','N','01-NOV-22','30-NOV-22','2022','11');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('12월-22','N','01-DEC-22','31-DEC-22','2022','12');
Insert into ORACLE_TABLE (PERIOD_NAME,CLOSING_STATUS,START_DATE,END_DATE,PERIOD_YEAR,PERIOD_NUM) values ('12월조정-22','N','01-DEC-22','31-DEC-22','2022','13');
commit;

2. MariaDB 10.5.15
– CREATE : Connect Engine Table
CREATE TABLE `oracle_table` (
`PERIOD_NAME` varchar(15) NOT NULL,
`CLOSING_STATUS` varchar(1) NOT NULL,
`START_DATE` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`END_DATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`PERIOD_YEAR` decimal(17,0) NOT NULL,
`PERIOD_NUM` decimal(17,0) NOT NULL)
ENGINE=CONNECT DEFAULT CHARSET=euckr CONNECTION='DSN=TDIA_DIAT;UID=infradba2;PWD=db_2q_2022!' `TABLE_TYPE`='ODBC' `TABNAME`='ORACLE_TABLE' `DBNAME`='INFRADBA2' `OPTION_LIST`='memory=2';

– CREATE : Function
CREATE or replace DEFINER=`root`@`%` FUNCTION `function_test`(pPOST_DT varchar(8)
) RETURNS int(11)
begin
DECLARE vCloseCnt int;
select
count(closing_status) into vCloseCnt
from ORACLE_TABLE
where pPOST_DT >= date_format(start_date,'%Y%m%d')
and pPOST_DT <= date_Format(end_date,'%Y%m%d')
and period_num <> 13
and closing_status <> 'O'
;
RETURN vCloseCnt;

end

– CREATE : MariaDB Innodb TABLE
CREATE TABLE IF NOT EXISTS `tb_slip_gr_DBATEST` (
`GR_SLIP_NO` varchar(20) NOT NULL COMMENT '그룹전표번호',
`COMP_CD` varchar(10) NOT NULL COMMENT '회사코드',
`ELEC_APPR_ID` varchar(50) DEFAULT NULL COMMENT '전자결재ID',
`GR_APPR_STAT_CD` varchar(10) DEFAULT NULL COMMENT '그룹결재상태코드(not used)',
`TOT_AMT` decimal(15,3) NOT NULL COMMENT '총금액',
`SLIP_CNT` smallint(6) NOT NULL COMMENT '전표수',
`ELEC_APPR_DTM` datetime DEFAULT NULL COMMENT '전자결재 기안일시',
`APPR_REQ_EMP` varchar(20) DEFAULT NULL COMMENT '전자결재 기안자사번',
`APPR_RSN` varchar(2000) DEFAULT NULL COMMENT '전자결재 의견(반려사유)',
`POST_DT` varchar(8) NOT NULL COMMENT '회계일자(전표일자)',
`SLIP_TYPE_CD` varchar(10) NOT NULL COMMENT '전표유형코드',
`SLIP_STAT_CD` varchar(100) NOT NULL COMMENT '전표상태코드(진행상태)',
`WRT_DEPT_CD` varchar(10) DEFAULT NULL COMMENT '작성부서코드(신청부서)',
`WRT_ID` varchar(20) DEFAULT NULL COMMENT '작성자(신청직원)',
`PAY_TERM_CD` varchar(5) DEFAULT NULL COMMENT '지급조건',
`EVD_CUST_CD` varchar(10) DEFAULT NULL COMMENT '증빙거래처코드',
`PAY_CUST_CD` varchar(10) DEFAULT NULL COMMENT '지급거래처코드',
`CUST_ACCT_NO` varchar(64) DEFAULT NULL COMMENT '거래처계좌번호',
`LIABILITY_ACCOUNT_CD` varchar(100) DEFAULT NULL COMMENT '부채계정',
`SUP_AMT` decimal(15,3) DEFAULT NULL COMMENT '공급가액',
`VAT_AMT` decimal(15,3) DEFAULT NULL COMMENT '부가세액',
`CUR_CD` varchar(3) DEFAULT NULL COMMENT '통화코드',
`EXC_RT` decimal(10,5) DEFAULT NULL COMMENT '환율',
`HD_SGTXT` varchar(200) DEFAULT NULL COMMENT '적요',
`REG_ID` varchar(20) NOT NULL COMMENT '등록자ID',
`REG_DTM` datetime NOT NULL DEFAULT current_timestamp() COMMENT '등록일시',
`CHG_ID` varchar(20) NOT NULL COMMENT '수정자ID',
`CHG_DTM` datetime NOT NULL DEFAULT current_timestamp() COMMENT '수정일시',
PRIMARY KEY (`GR_SLIP_NO`),
UNIQUE KEY `PK_TB_APPR_GR` (`GR_SLIP_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='전표그룹결재 -> 전자전표 마스터';

INSERT INTO `tb_slip_gr_dbatest` (`GR_SLIP_NO`, `COMP_CD`, `ELEC_APPR_ID`, `GR_APPR_STAT_CD`, `TOT_AMT`, `SLIP_CNT`, `ELEC_APPR_DTM`, `APPR_REQ_EMP`, `APPR_RSN`, `POST_DT`, `SLIP_TYPE_CD`, `SLIP_STAT_CD`, `WRT_DEPT_CD`, `WRT_ID`, `PAY_TERM_CD`, `EVD_CUST_CD`, `PAY_CUST_CD`, `CUST_ACCT_NO`, `LIABILITY_ACCOUNT_CD`, `SUP_AMT`, `VAT_AMT`, `CUR_CD`, `EXC_RT`, `HD_SGTXT`, `REG_ID`, `REG_DTM`, `CHG_ID`, `CHG_DTM`) VALUES
('GR202001-02892', '102', 'AP202001-00285', NULL, 90000.000, 1, '2020-01-15 08:25:50', NULL, ',', '20200115', 'E2', '70', 'O000000118', '360236', '10194', '1207', '1207', '11_039-01-254178', '21006001', 90000.000, NULL, 'KRW', 1.00000, 'test', '360236', '2020-01-15 08:24:00', '390264', '2020-01-21 15:45:40'),
('GR202001-02858', '102', 'AP202001-00278', NULL, 6380.000, 1, '2020-01-13 21:23:19', NULL, '승인합니다.', '20200113', 'E1', '70', 'O000000166', '311193', '10195', '24967', '24967', '779-20-525200', '21003001', 5800.000, 580.000, 'KRW', NULL, 'test', '311193', '2020-01-13 21:22:45', '360385', '2020-01-17 08:48:02')
;

3. TEST( Check )
– MariaDB 10.5.15 Check
select function_test(GR.post_dt)
from TB_SLIP_GR_DBATEST GR
where GR_SLIP_NO in ('GR202001-02892')
; <<= 1row Select Success

select function_test(GR.post_dt)
from TB_SLIP_GR_DBATEST GR
where GR_SLIP_NO in ('GR202001-02892','GR202001-02858')
; <<= Crash if check more than 2 lines+

– MariaDB 10.3.10 Check
select function_test(GR.post_dt)
from TB_SLIP_GR_DBATEST GR
where GR_SLIP_NO in ('GR202001-02892','GR202001-02858')
; <<= Select Success

Comment by HyeonSoon Jang [ 2022-05-06 ]

I uploaded the test case.

Comment by Alice Sherepa [ 2022-05-06 ]

Thank you!
I repeated the crash on 10.3-10.8

let $port= select @@port;

CREATE TABLE t1 (closing_status varchar(1), d1 varchar(30), d2 varchar(30), period_num int(15));

insert into t1 values ('c','01-jan-20','31-jan-20','1'),('c','01-feb-20','29-feb-20','2'),('c','01-mar-20','31-mar-20','3');

CREATE TABLE t2 (closing_status varchar(1), d1 TIMESTAMP, d2 TIMESTAMP, period_num decimal(17,0))

engine=connect table_type=mysql option_list='host=localhost,user=root,port=$port' dbname='test' tabname='t1';

CREATE TABLE t3 ( dt varchar(8));

insert into t3 values ('20200115'),('20200113');

delimiter //;

CREATE FUNCTION f1 (x varchar(8)) RETURNS int(11)

BEGIN

declare y int;

SELECT count(closing_status) INTO y

FROM t2

WHERE x >= date_format(d1,'%y%m%d') AND x <= date_format(d2,'%y%m%d')

 AND period_num <> 13

 AND closing_status <> 'o';

RETURN y;

END//

delimiter ;//

select f1(dt) from t3 ;

10.3 9614fde1aac6ffa474
220506 11:16:18 [ERROR] mysqld got signal 11 ;

Server version: 10.3.35-MariaDB-debug-log

sql/signal_handler.cc:221(handle_fatal_signal)[0x560afd9ddf3e]
sigaction.c:0(__restore_rt)[0x7f53dc1013c0]
connect/ha_connect.cc:2272(ha_connect::MakeRecord(char*))[0x7f53d3c17a7e]
connect/ha_connect.cc:4218(ha_connect::rnd_next(unsigned char*))[0x7f53d3c26a3d]
sql/handler.cc:2858(handler::ha_rnd_next(unsigned char*))[0x560afd9f3a0a]
sql/records.cc:485(rr_sequential(READ_RECORD*))[0x560afddefacf]
sql/records.h:70(READ_RECORD::read_record())[0x560afd0d4900]
sql/sql_select.cc:20826(join_init_read_record(st_join_table*))[0x560afd3a448c]
sql/sql_select.cc:19881(sub_select(JOIN, st_join_table, bool))[0x560afd39d6a3]
sql/sql_select.cc:19422(do_select(JOIN, Procedure))[0x560afd39b81e]
sql/sql_select.cc:4151(JOIN::exec_inner())[0x560afd32e469]
sql/sql_select.cc:3946(JOIN::exec())[0x560afd32bde6]
sql/sql_select.cc:4356(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))[0x560afd32f8e4]
sql/sql_select.cc:372(handle_select(THD, LEX, select_result*, unsigned long))[0x560afd305e45]
sql/sql_parse.cc:6339(execute_sqlcom_select(THD, TABLE_LIST))[0x560afd276cdd]
sql/sql_parse.cc:3870(mysql_execute_command(THD*))[0x560afd264d18]
sql/sp_head.cc:3708(sp_instr_stmt::exec_core(THD, unsigned int))[0x560afd046034]
sql/sp_head.cc:3438(sp_lex_keeper::reset_lex_and_exec_core(THD, unsigned int, bool, sp_instr*))[0x560afd0447b1]
sql/sp_head.cc:3614(sp_instr_stmt::execute(THD, unsigned int))[0x560afd0457ba]
sql/sp_head.cc:1377(sp_head::execute(THD*, bool))[0x560afd036f8e]
sql/sp_head.cc:2122(sp_head::execute_function(THD, Item, unsigned int, Field, sp_rcontext*, Query_arena))[0x560afd03b0fc]
sql/item.cc:3060(Item_sp::execute_impl(THD, Item*, unsigned int))[0x560afda3ebe5]
sql/item.cc:2975(Item_sp::execute(THD, bool, Item**, unsigned int))[0x560afda3e173]
sql/item_func.cc:6417(Item_func_sp::execute())[0x560afdb69937]
sql/item_func.h:2927(Item_func_sp::val_int())[0x560afdb782c2]
sql/sql_type.cc:5440(Type_handler::Item_send_long(Item, Protocol, st_value*) const)[0x560afd77fe2c]
sql/sql_type.h:2463(Type_handler_long::Item_send(Item, Protocol, st_value*) const)[0x560afd789332]
sql/item.h:885(Item::send(Protocol, st_value))[0x560afcfd244c]
sql/protocol.cc:1000(Protocol::send_result_set_row(List<Item>*))[0x560afcfc4bc1]
sql/sql_class.cc:3049(select_send::send_data(List<Item>&))[0x560afd160487]
sql/sql_select.cc:21070(end_send(JOIN, st_join_table, bool))[0x560afd3a6aa8]
sql/sql_select.cc:20111(evaluate_join_record(JOIN, st_join_table, int))[0x560afd39ef47]
sql/sql_select.cc:19923(sub_select(JOIN, st_join_table, bool))[0x560afd39dee2]
sql/sql_select.cc:19422(do_select(JOIN, Procedure))[0x560afd39b81e]
sql/sql_select.cc:4151(JOIN::exec_inner())[0x560afd32e469]
sql/sql_select.cc:3946(JOIN::exec())[0x560afd32bde6]
sql/sql_select.cc:4356(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))[0x560afd32f8e4]
sql/sql_select.cc:372(handle_select(THD, LEX, select_result*, unsigned long))[0x560afd305e45]
sql/sql_parse.cc:6339(execute_sqlcom_select(THD, TABLE_LIST))[0x560afd276cdd]
sql/sql_parse.cc:3870(mysql_execute_command(THD*))[0x560afd264d18]
sql/sql_parse.cc:7870(mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool))[0x560afd280a3a]
sql/sql_parse.cc:1855(dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool))[0x560afd257917]
sql/sql_parse.cc:1398(do_command(THD*))[0x560afd25445a]
sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x560afd627a47]
sql/sql_connect.cc:1309(handle_one_connection)[0x560afd627301]
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x560afec56dcd]
nptl/pthread_create.c:478(start_thread)[0x7f53dc0f5609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f53dc018163]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x625000159290): SELECT count(closing_status) INTO y
FROM t2
WHERE NAME_CONST('x',_latin1'20200113' COLLATE 'latin1_swedish_ci') >= date_format(d1,'%y%m%d') AND NAME_CONST('x',_latin1'20200113' COLLATE 'latin1_swedish_ci') <= date_format(d2,'%y%m%d')
AND period_num <> 13
AND closing_status <> 'o'

10.5 1421d1f2967f1546d2f3
220506 11:06:06 [ERROR] mysqld got signal 11 ;
Server version: 10.5.16-MariaDB-debug-log

sql/signal_handler.cc:225(handle_fatal_signal)[0x556cb2dc23cb]
sigaction.c:0(__restore_rt)[0x7fce07b2c3c0]
connect/value.cpp:1705(TYPVAL<char>::Compute(_global, VALUE**, int, OPVAL))[0x7fcdffbd8894]
connect/value.cpp:2880(DTVAL::FormatValue(VALUE, char const))[0x7fcdffbe121d]
connect/ha_connect.cc:2269(ha_connect::MakeRecord(char*))[0x7fcdffa429be]
connect/ha_connect.cc:4218(ha_connect::rnd_next(unsigned char*))[0x7fcdffa5192b]
sql/handler.cc:3096(handler::ha_rnd_next(unsigned char*))[0x556cb2ddbfad]
sql/records.cc:519(rr_sequential(READ_RECORD*))[0x556cb3239bb6]
sql/records.h:80(READ_RECORD::read_record())[0x556cb23ea442]
sql/sql_select.cc:21880(join_init_read_record(st_join_table*))[0x556cb270279b]
sql/sql_select.cc:20913(sub_select(JOIN, st_join_table, bool))[0x556cb26fb8bd]
sql/sql_select.cc:20448(do_select(JOIN, Procedure))[0x556cb26f99a6]
sql/sql_select.cc:4540(JOIN::exec_inner())[0x556cb268537c]
sql/sql_select.cc:4321(JOIN::exec())[0x556cb2682986]
sql/sql_select.cc:4799(mysql_select(THD, TABLE_LIST, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex))[0x556cb2686dcb]
sql/sql_select.cc:444(handle_select(THD, LEX, select_result*, unsigned long))[0x556cb26580bd]
sql/sql_parse.cc:6330(execute_sqlcom_select(THD, TABLE_LIST))[0x556cb25bfd52]
sql/sql_parse.cc:4021(mysql_execute_command(THD*))[0x556cb25aed47]
sql/sp_head.cc:3774(sp_instr_stmt::exec_core(THD, unsigned int))[0x556cb2356894]
sql/sp_head.cc:3499(sp_lex_keeper::reset_lex_and_exec_core(THD, unsigned int, bool, sp_instr*))[0x556cb2354dfc]
sql/sp_head.cc:3680(sp_instr_stmt::execute(THD, unsigned int))[0x556cb2355ff9]
sql/sp_head.cc:1437(sp_head::execute(THD*, bool))[0x556cb2346dfc]
sql/sp_head.cc:2166(sp_head::execute_function(THD, Item, unsigned int, Field, sp_rcontext*, Query_arena))[0x556cb234b5d1]
sql/item.cc:2894(Item_sp::execute_impl(THD, Item*, unsigned int))[0x556cb2e329f3]
sql/item.cc:2808(Item_sp::execute(THD, bool, Item**, unsigned int))[0x556cb2e31f57]
sql/item_func.cc:6638(Item_func_sp::execute())[0x556cb2f6110f]
sql/item_func.h:3485(Item_func_sp::val_int())[0x556cb2f726ec]
sql/sql_type.cc:7487(Type_handler::Item_send_long(Item, Protocol, st_value*) const)[0x556cb2b82a54]
sql/sql_type.h:5693(Type_handler_long::Item_send(Item, Protocol, st_value*) const)[0x556cb2ba0b08]
sql/item.h:1067(Item::send(Protocol, st_value))[0x556cb22df2ce]
sql/protocol.cc:1087(Protocol::send_result_set_row(List<Item>*))[0x556cb22cfb79]
sql/sql_class.cc:3134(select_send::send_data(List<Item>&))[0x556cb248361c]
sql/sql_class.h:5353(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x556cb274a2e9]
sql/sql_select.cc:22127(end_send(JOIN, st_join_table, bool))[0x556cb2704e80]
sql/sql_select.cc:21146(evaluate_join_record(JOIN, st_join_table, int))[0x556cb26fd1b4]
sql/sql_select.cc:20955(sub_select(JOIN, st_join_table, bool))[0x556cb26fc0eb]
sql/sql_select.cc:20448(do_select(JOIN, Procedure))[0x556cb26f99a6]
sql/sql_select.cc:4540(JOIN::exec_inner())[0x556cb268537c]
sql/sql_select.cc:4321(JOIN::exec())[0x556cb2682986]
sql/sql_select.cc:4799(mysql_select(THD, TABLE_LIST, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex))[0x556cb2686dcb]
sql/sql_select.cc:444(handle_select(THD, LEX, select_result*, unsigned long))[0x556cb26580bd]
sql/sql_parse.cc:6330(execute_sqlcom_select(THD, TABLE_LIST))[0x556cb25bfd52]
sql/sql_parse.cc:4021(mysql_execute_command(THD*))[0x556cb25aed47]
sql/sql_parse.cc:8116(mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool))[0x556cb25cb0ac]
sql/sql_parse.cc:1910(dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool))[0x556cb25a0fbb]
sql/sql_parse.cc:1375(do_command(THD*))[0x556cb259d73a]
sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x556cb29eb21f]
sql/sql_connect.cc:1314(handle_one_connection)[0x556cb29eaa38]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x556cb3717280]
nptl/pthread_create.c:478(start_thread)[0x7fce07b20609]
??:0(clone)[0x7fce076f1163]

Query (0x62500014a2a8): SELECT count(closing_status) INTO y
FROM t2
WHERE NAME_CONST('x',_latin1'20200113' COLLATE 'latin1_swedish_ci') >= date_format(d1,'%y%m%d') AND NAME_CONST('x',_latin1'20200113' COLLATE 'latin1_swedish_ci') <= date_format(d2,'%y%m%d')
AND period_num <> 13
AND closing_status <> 'o'

Comment by Alice Sherepa [ 2023-10-05 ]

not reproducible on current 10.4(50a2e8b1892b6b8a276d4bd75a1a0) -11.2

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

[MDEV-28467] [ERROR] mysqld got exception 0xc0000005 Created: 2022-05-04 Updated: 2023-10-05