[MDEV-3415] LP:693747 - Assertion multi_range_read.cc:908: int DsMrr_impl::dsmrr_init(handler*, RANGE_SEQ_IF*, void*, uint, uint, HANDLER_BUFFER*): Assertion `primary_file->inited == handler::INDEX' failed with join_cache_level=8 , join_buffer_size=10K Created: 2010-12-23  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Philip Stoev (Inactive) Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug693747.xml    

 Description   

In maria-5.3 , maria-5.3-mwl128-dsmrr-cpk but NOT in maria-5.3-mwl128 , the test case below asserts as follows:

mysqld: multi_range_read.cc:908: int DsMrr_impl::dsmrr_init(handler*, RANGE_SEQ_IF*, void*, uint, uint, HANDLER_BUFFER*): Assertion `primary_file->inited == handler::INDEX' failed.

Test case:

SET SESSION join_cache_level=8;
SET SESSION join_buffer_size=10000;

CREATE TABLE t1 (f1 int(11), f2 varchar(32) COLLATE latin1_swedish_ci, f3 int(11), f4 varchar(1024) COLLATE utf8_bin, f5 varchar(1024) COLLATE latin1_bin, KEY (f5)) ENGINE=Aria TRANSACTIONAL=0 ;
INSERT IGNORE INTO t1 VALUES ('0','cueikuirqr','0','okay','hcueikuirqrzflno'),('2009','her','0','ULWAH','ehcueikuirqrzfln'),('0','YKAOE','0','of','qieehcueikuirqrz'),('2009','you\'re','0','k','nkqieehcueikuirq'),('2003','b','0','bgsnkqieehcueiku','the'),('0','MGUDG','0','p','m'),('0','UXAGU','0','elfhjawbwbgsnkqi','HZXVA'),('2004','bwbgsnkqie','0','x','something'),('2007','s','0','okay','slelfhjawbwbgsnk'),('2007','the','0','or','if'),('2008','TDLKE','0','mean','MGWNJ'),('2006','do','0','KGFVV','see'),('2001','why','0','a','mean'),(NULL,'THKCG','0','no','YFLDY'),(NULL,'x','0','mean','e'),('2007','yncitaeysb','0','WDOSC','tgyncitaeysbgucs'),(NULL,'ZEOXX','0','awbwbgsnkqieehcu','jawbwbgsnkqieehc'),('2006','hjawbwbgsn','0','just','fhjawbwbgsnkqiee'),('0','all','0','k','sbgucsgqslelfhja'),('2009','the','0','f','would'),('2005','mtgyncitae','0','w','ISNQQ'),('2003','KNCUI','0','r','want'),('2006','is','0','j','i'),('2000','out','0','o','jvcmjlmtgyncitae'),('2001','it','0','txyjvcmjlmtgynci','you'),('2008','LHDIH','0','ZKFJK','txmtxyjvcmjlmtgy'),('0','z','0','the','ntxmtxyjvcmjlmtg'),(NULL,'vyhnmvgmcn','0','PWEYL','AIGQK'),('0','ytvyhnmvgm','0','gbytvyhnmvgmcntx','z'),('2002','t','0','just','on'),('2002','xqegbytvyh','0','to','ixqegbytvyhnmvgm'),('2004','WGVRU','0','GHBZB','h'),('0','b','0','yhnmvgmcntxmtxyj','z'),('2003','who','0','ddixqegbytvyhnmv','gddixqegbytvy'),('0','PMLFL','0','n','vgmcntxmtxyjvcmj'),(NULL,'back','0','FIXPA','n'),('2005','i','0','I\'ll','PZGUB'),('0','f','0','t','the'),(NULL,'PNXVP','0','t','v'),('2004','MAKKL','0','u','CGCWF'),('0','RMDAV','0','noypgddixqegbytv','v'),('0','l','0','ESAVW','n'),('2008','rhnoypgddi','0','s','VIZNE'),('2007','t','0','XZECS','a'),(NULL,'like','0','k','JSHPZ'),('2009','pskeywslmk','0','epskeywslmkdrhno','q'),(NULL,'QZZJJ','0','LOTFB','c'),('0','atlxepskey','0','b','YJRMA'),(NULL,'YUVOU','0','wslmkdrhnoypgddi','eywslmkdrhnoypgd'),('2006','some','0','can','r'),('2002','c','0','k','her'),(NULL,'o','0','ALBVZ','EMURT'),('0','if','0','okay','had'),('2006','when','0','e','CLVWT'),(NULL,'blfufrcdjm','0','ZAKUQ','IZCZN'),('2007','vutblfufrc','0','MPKMI','how'),(NULL,'why','0','UBUAG','I'),('2004','IXLYQ','0','ILPBE','weuwuvutblfufrcd'),('0','here','0','your','m'),(NULL,'ZOCTJ','0','GTPOO','IDSFD'),('0','kqsweuwuvu','0','CXQLW','oh'),('0','ykqsweuwuv','0','CLJWP','zykqsweuwuvutblf'),('0','zezykqsweu','0','had','t'),(NULL,'q','0','jisuzezykqsweuwu','o'),('2007','IBKAU','0','t','oh'),('0','ivjisuzezy','0','y','XHXKE'),('0','xsivjisuze','0','right','plxsivjisuzezykq'),('2009','have','0','so','uvplxsivjisuzezy'),('0','on','0','b','me'),('0','ijkfuvplxs','0','RZXDY','OGEHV'),('0','u','0','all','okay'),('0','i','0','s','pajzbbojshnijkfu'),('2001','of','0','xpajzbbojshnijkf','g'),('0','for','0','ITBAQ','I\'m'),('2006','or','0','now','ZOJHX'),('0','n','0','k','you'),(NULL,'that','0','suzezykqsweuwuvu','just'),('0','bbojshnijk','0','QGYOA','JYGSJ'),('2009','k','0','ajzbbojshnijkfuv','y'),('2007','k','0','affpegvavdgxpajz','y'),('2007','be','0','RCTIT','m'),('2000','fnbmxwicrk','0','lcfnbmxwicrkdyma','t'),('0','yaffpegvav','0','v','have'),('0','crkdymahya','0','icrkdymahyaffpeg','QQWQI'),('0','t','0','nijkfuvplxsivjis','hnijkfuvplxsivji'),('0','dgxpajzbbo','0','vdgxpajzbbojshni','vavdgxpajzbbojsh'),('2006','g','0','gvavdgxpajzbbojs','pegvavdgxpajzbbo'),('2007','I\'m','0','g','ffpegvavdgxpajzb');

SELECT alias2.f1 AS field1 , alias1.f2 AS field2
FROM t1 AS alias1
LEFT OUTER JOIN t1 AS alias2 ON alias1.f2 = alias2.f5
WHERE alias2.f3 > 'k'
AND alias2.f3 <= 'z'
OR alias2.f4 IN ('o', 'y')
AND alias2.f4 >= 'g' AND alias2.f4 < 'z' ;

 Comments   
Comment by Philip Stoev (Inactive) [ 2010-12-23 ]

Re: Assertion multi_range_read.cc:908: int DsMrr_impl::dsmrr_init(handler*, RANGE_SEQ_IF*, void*, uint, uint, HANDLER_BUFFER*): Assertion `primary_file->inited == handler::INDEX' failed with join_cache_level=8 , join_buffer_size=10K
PSergey, at the very least, can you please push the test case for this bug somewhere. I am concerned that the query plan in maria-5.3-mwl128 may have changed while the underlying issue is present in that tree as well.

Comment by Philip Stoev (Inactive) [ 2010-12-25 ]

Re: Assertion multi_range_read.cc:908: int DsMrr_impl::dsmrr_init(handler*, RANGE_SEQ_IF*, void*, uint, uint, HANDLER_BUFFER*): Assertion `primary_file->inited == handler::INDEX' failed with join_cache_level=8 , join_buffer_size=10K
Reproducible on maria-5.3 with the following revision:

revision-id: igor@askmonty.org-20101225002420-umx1c458zlybsmo8
date: 2010-12-24 16:24:20 -0800
build-date: 2010-12-25 17:25:18 +0200
revno: 2870
branch-nick: maria-5.3

that should include both wl128 and ds-mrr-cpk trees.

Comment by Philip Stoev (Inactive) [ 2010-12-25 ]

Re: Assertion multi_range_read.cc:908: int DsMrr_impl::dsmrr_init(handler*, RANGE_SEQ_IF*, void*, uint, uint, HANDLER_BUFFER*): Assertion `primary_file->inited == handler::INDEX' failed with join_cache_level=8 , join_buffer_size=10K
backtrace

  1. 2010-12-25T19:27:54 #8 0x00399d98 in __assert_fail () from /lib/libc.so.6
  2. 2010-12-25T19:27:54 #9 0x084a6763 in DsMrr_impl::dsmrr_init (this=0x913d9930, h_arg=0x913d95b0, seq_funcs=0x912b3034, seq_init_param=0x912b2f60, n_ranges=12, mode=129,
  3. 2010-12-25T19:27:54 buf=0x912b3050) at multi_range_read.cc:908
  4. 2010-12-25T19:27:54 #10 0x08545576 in ha_maria::multi_range_read_init (this=0x913d95b0, seq=0x912b3034, seq_init_param=0x912b2f60, n_ranges=12, mode=129, buf=0x912b3050)
  5. 2010-12-25T19:27:54 at ha_maria.cc:3627
  6. 2010-12-25T19:27:54 #11 0x082e4212 in JOIN_TAB_SCAN_MRR::open (this=0x912b3020) at sql_join_cache.cc:3668
  7. 2010-12-25T19:27:54 #12 0x082e24d7 in JOIN_CACHE::join_matching_records (this=0x912b2f60, skip_last=false) at sql_join_cache.cc:2138
  8. 2010-12-25T19:27:54 #13 0x082e219a in JOIN_CACHE::join_records (this=0x912b2f60, skip_last=false) at sql_join_cache.cc:1980
  9. 2010-12-25T19:27:54 #14 0x0832addf in sub_select_cache (join=0x913d1630, join_tab=0x913d6c68, end_of_records=false) at sql_select.cc:13268
  10. 2010-12-25T19:27:54 #15 0x082e284e in JOIN_CACHE::generate_full_extensions (this=0x912b2e00, rec_ptr=0x912b6ca6 "") at sql_join_cache.cc:2278
  11. 2010-12-25T19:27:54 #16 0x082e2610 in JOIN_CACHE::join_matching_records (this=0x912b2e00, skip_last=false) at sql_join_cache.cc:2172
  12. 2010-12-25T19:27:54 #17 0x082e219a in JOIN_CACHE::join_records (this=0x912b2e00, skip_last=false) at sql_join_cache.cc:1980
  13. 2010-12-25T19:27:54 #18 0x0832addf in sub_select_cache (join=0x913d1630, join_tab=0x913d6a90, end_of_records=false) at sql_select.cc:13268
  14. 2010-12-25T19:27:54 #19 0x0832b721 in evaluate_join_record (join=0x913d1630, join_tab=0x913d68b8, error=0) at sql_select.cc:13655
  15. 2010-12-25T19:27:54 #20 0x0832b1fb in sub_select (join=0x913d1630, join_tab=0x913d68b8, end_of_records=false) at sql_select.cc:13500
  16. 2010-12-25T19:27:54 #21 0x0832a4bd in do_select (join=0x913d1630, fields=0x0, table=0x913d88c0, procedure=0x0) at sql_select.cc:13004
  17. 2010-12-25T19:27:54 #22 0x0830e16f in JOIN::exec (this=0x913d1630) at sql_select.cc:1974
  18. 2010-12-25T19:27:54 #23 0x08310616 in mysql_select (thd=0xa28cdb0, rref_pointer_array=0xa28e84c, tables=0x9131b2c8, wild_num=0, fields=..., conds=0x9131cb90, og_num=1,
  19. 2010-12-25T19:27:54 order=0x911df438, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x913c2c50, unit=0xa28e4ac, select_lex=0xa28e748)
  20. 2010-12-25T19:27:54 at sql_select.cc:2621
  21. 2010-12-25T19:27:54 #24 0x08308b1d in handle_select (thd=0xa28cdb0, lex=0xa28e450, result=0x913c2c50, setup_tables_done_option=0) at sql_select.cc:286
  22. 2010-12-25T19:27:54 #25 0x082a3cdc in execute_sqlcom_select (thd=0xa28cdb0, all_tables=0x9131b2c8) at sql_parse.cc:5070
  23. 2010-12-25T19:27:54 #26 0x0829a6f7 in mysql_execute_command (thd=0xa28cdb0) at sql_parse.cc:2234
  24. 2010-12-25T19:27:54 #27 0x082a627a in mysql_parse (thd=0xa28cdb0,
  25. 2010-12-25T19:27:54 rawbuf=0x9131ad00 "SELECT table1 . `col_int` AS field1 , table2 . `col_varchar_10_latin1` AS field2 FROM E AS table1 LEFT JOIN vG_0 AS table2 LEFT JOIN H AS table3 ON table2 . `col_varchar_1024_latin1_key` = table3 . `col_varchar_1024_latin1_key` ON table1 . `col_varchar_1024_utf8` = table3 . `col_varchar_10_latin1_key` WHERE table1 . `col_int_key` > 'z' AND table1 . `col_int_key` <= 'i' OR table3 . `pk` IS NULL ORDER BY field2", length=426,
  26. 2010-12-25T19:27:54 found_semicolon=0x914e0228) at sql_parse.cc:6077
  27. 2010-12-25T19:27:54 #28 0x082981e0 in dispatch_command (command=COM_QUERY, thd=0xa28cdb0,
  28. 2010-12-25T19:27:54 packet=0xa28edb9 " SELECT table1 . `col_int` AS field1 , table2 . `col_varchar_10_latin1` AS field2 FROM E AS table1 LEFT JOIN vG_0 AS table2 LEFT JOIN H AS table3 ON table2 . `col_varchar_1024_latin1_key` = table3 . `col_varchar_1024_latin1_key` ON table1 . `col_varchar_1024_utf8` = table3 . `col_varchar_10_latin1_key` WHERE table1 . `col_int_key` > 'z' AND table1 . `col_int_key` <= 'i' OR table3 . `pk` IS NULL ORDER BY field2 ", packet_length=430)
  29. 2010-12-25T19:27:54 at sql_parse.cc:1210
  30. 2010-12-25T19:27:54 #29 0x0829764a in do_command (thd=0xa28cdb0) at sql_parse.cc:903
  31. 2010-12-25T19:27:54 #30 0x08294726 in handle_one_connection (arg=0xa28cdb0) at sql_connect.cc:1154
  32. 2010-12-25T19:27:54 #31 0x00821919 in start_thread () from /lib/libpthread.so.0
  33. 2010-12-25T19:27:54 #32 0x00453cce in clone () from /lib/libc.so.6

also reproducible with join_cache_level=6

Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 693747

Generated at Thu Feb 08 06:48:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.