Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.3(EOL), 10.4(EOL)
-
None
Description
--source include/have_innodb.inc
|
--source include/have_partition.inc
|
|
CREATE TABLE t1 (pk int NOT NULL PRIMARY KEY, d1 decimal(10,0), KEY (d1)) ENGINE=InnoDB PARTITION BY KEY (pk) PARTITIONS 2; |
INSERT INTO t1 VALUES (1,0),(3,0); |
 |
HANDLER t1 OPEN AS a1; |
HANDLER a1 READ d1 <= ( 76 ); |
HANDLER a1 READ `PRIMARY` = ( 6 ); |
HANDLER a1 READ `PRIMARY` PREV ; |
10.3 8a0944080c950349aaf7c81bc |
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#5 0x00007f71ce99e535 in __GI_abort () at abort.c:79
|
#6 0x00007f71ce99e40f in __assert_fail_base (fmt=0x7f71ceb00ee0 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55bca30fdf70 "btr_page_get_index_id(btr_pcur_get_page(pcur)) == index->id", file=0x55bca30fc8b8 "/10.3/storage/innobase/row/row0sel.cc", line=4837, function=<optimized out>) at assert.c:92
|
#7 0x00007f71ce9ac102 in __GI___assert_fail (assertion=0x55bca30fdf70 "btr_page_get_index_id(btr_pcur_get_page(pcur)) == index->id", file=0x55bca30fc8b8 "/10.3/storage/innobase/row/row0sel.cc", line=4837, function=0x55bca3100f20 <row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long)::__PRETTY_FUNCTION__> "dberr_t row_search_mvcc(byte*, page_cur_mode_t, row_prebuilt_t*, ulint, ulint)") at assert.c:101
|
#8 0x000055bca29131da in row_search_mvcc (buf=0xa5a5a5a5a5a5a5a7 <error: Cannot access memory at address 0xa5a5a5a5a5a5a5a7>, mode=PAGE_CUR_LE, prebuilt=0x7f71780b31c0, match_mode=0, direction=2) at /10.3/storage/innobase/row/row0sel.cc:4837
|
#9 0x000055bca273a422 in ha_innobase::general_fetch (this=0x7f71781682f8, buf=0xa5a5a5a5a5a5a5a7 <error: Cannot access memory at address 0xa5a5a5a5a5a5a5a7>, direction=2, match_mode=0) at /10.3/storage/innobase/handler/ha_innodb.cc:9549
|
#10 0x000055bca273a702 in ha_innobase::index_prev (this=0x7f71781682f8, buf=0xa5a5a5a5a5a5a5a7 <error: Cannot access memory at address 0xa5a5a5a5a5a5a5a7>) at /10.3/storage/innobase/handler/ha_innodb.cc:9643
|
#11 0x000055bca250eeb6 in handler::ha_index_prev (this=0x7f71781682f8, buf=0xa5a5a5a5a5a5a5a7 <error: Cannot access memory at address 0xa5a5a5a5a5a5a5a7>) at /10.3/sql/handler.cc:2975
|
#12 0x000055bca2d2a496 in ha_partition::handle_ordered_prev (this=0x7f7178167a98, buf=0x7f717803b158 "\245\006") at /10.3/sql/ha_partition.cc:8033
|
#13 0x000055bca2d235de in ha_partition::index_prev (this=0x7f7178167a98, buf=0x7f717803b158 "\245\006") at /10.3/sql/ha_partition.cc:5938
|
#14 0x000055bca250ee64 in handler::ha_index_prev (this=0x7f7178167a98, buf=0x7f717803b158 "\245\006") at /10.3/sql/handler.cc:2975
|
#15 0x000055bca21a9d47 in mysql_ha_read (thd=0x7f7178000d50, tables=0x7f7178012bf0, mode=RPREV, keyname=0x7f7178013250 "PRIMARY", key_expr=0x7f7178013270, ha_rkey_mode=HA_READ_KEY_EXACT, cond=0x0, select_limit_cnt=1, offset_limit_cnt=0) at /10.3/sql/sql_handler.cc:922
|
#16 0x000055bca21f5ed0 in mysql_execute_command (thd=0x7f7178000d50) at /10.3/sql/sql_parse.cc:5492
|
#17 0x000055bca21fd5ca in mysql_parse (thd=0x7f7178000d50, rawbuf=0x7f7178012a78 "HANDLER a1 READ `PRIMARY` PREV", length=30, parser_state=0x7f71c83b85c0, is_com_multi=false, is_next_command=false) at /10.3/sql/sql_parse.cc:7810
|
#18 0x000055bca21e9f0c in dispatch_command (command=COM_QUERY, thd=0x7f7178000d50, packet=0x7f7178008ed1 "", packet_length=31, is_com_multi=false, is_next_command=false) at /10.3/sql/sql_parse.cc:1847
|
#19 0x000055bca21e882f in do_command (thd=0x7f7178000d50) at /10.3/sql/sql_parse.cc:1393
|
#20 0x000055bca236046a in do_handle_one_connection (connect=0x55bca6118100) at /10.3/sql/sql_connect.cc:1403
|
#21 0x000055bca23601cc in handle_one_connection (arg=0x55bca6118100) at /10.3/sql/sql_connect.cc:1308
|
#22 0x000055bca2cfb2d1 in pfs_spawn_thread (arg=0x55bca6396bf0) at /10.3/storage/perfschema/pfs.cc:1869
|
#23 0x00007f71cf0f1fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486
|
#24 0x00007f71cea754cf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Attachments
Issue Links
- relates to
-
MDEV-23167 Server crashes upon HANDLER READ from partitioned table
- Confirmed