Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.3(EOL), 10.4(EOL)
-
None
Description
--source include/have_partition.inc
|
|
CREATE TABLE t1 (a INT, KEY(a)) PARTITION BY HASH(a); |
HANDLER t1 OPEN h; |
HANDLER h READ a NEXT; |
HANDLER h READ a NEXT; |
|
# Cleanup
|
HANDLER h CLOSE; |
DROP TABLE t1; |
10.3 f6d0d309 |
mysqld: /data/src/10.3/sql/ha_partition.cc:7278: int ha_partition::handle_unordered_next(uchar*, bool): Assertion `0' failed.
|
190728 1:47:00 [ERROR] mysqld got signal 6 ;
|
|
#6 0x00007f66e6e6de67 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x56038105c669 "0", file=file@entry=0x56038105bc38 "/data/src/10.3/sql/ha_partition.cc", line=line@entry=7278, function=function@entry=0x560381060440 <ha_partition::handle_unordered_next(unsigned char*, bool)::__PRETTY_FUNCTION__> "int ha_partition::handle_unordered_next(uchar*, bool)") at assert.c:92
|
#7 0x00007f66e6e6df12 in __GI___assert_fail (assertion=0x56038105c669 "0", file=0x56038105bc38 "/data/src/10.3/sql/ha_partition.cc", line=7278, function=0x560381060440 <ha_partition::handle_unordered_next(unsigned char*, bool)::__PRETTY_FUNCTION__> "int ha_partition::handle_unordered_next(uchar*, bool)") at assert.c:101
|
#8 0x0000560380c091d5 in ha_partition::handle_unordered_next (this=0x7f66d0095ab8, buf=0x7f66d0006b00 "\377", is_next_same=false) at /data/src/10.3/sql/ha_partition.cc:7278
|
#9 0x0000560380c049c3 in ha_partition::index_next (this=0x7f66d0095ab8, buf=0x7f66d0006b00 "\377") at /data/src/10.3/sql/ha_partition.cc:5831
|
#10 0x00005603804a4fcb in handler::ha_index_next (this=0x7f66d0095ab8, buf=0x7f66d0006b00 "\377") at /data/src/10.3/sql/handler.cc:2947
|
#11 0x000056038015f424 in mysql_ha_read (thd=0x7f66d0000b00, tables=0x7f66d0012980, mode=RNEXT, keyname=0x7f66d0012fc8 "a", key_expr=0xa5a5a5a5a5a5a5a5, ha_rkey_mode=HA_READ_KEY_EXACT, cond=0x0, select_limit_cnt=1, offset_limit_cnt=0) at /data/src/10.3/sql/sql_handler.cc:892
|
#12 0x00005603801a8390 in mysql_execute_command (thd=0x7f66d0000b00) at /data/src/10.3/sql/sql_parse.cc:5493
|
#13 0x00005603801af3f0 in mysql_parse (thd=0x7f66d0000b00, rawbuf=0x7f66d0012818 "HANDLER h READ a NEXT", length=21, parser_state=0x7f66e106c5f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7829
|
#14 0x000056038019cfee in dispatch_command (command=COM_QUERY, thd=0x7f66d0000b00, packet=0x7f66d0008c71 "", packet_length=21, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1856
|
#15 0x000056038019ba11 in do_command (thd=0x7f66d0000b00) at /data/src/10.3/sql/sql_parse.cc:1401
|
#16 0x00005603803050a2 in do_handle_one_connection (connect=0x560383a4a120) at /data/src/10.3/sql/sql_connect.cc:1403
|
#17 0x0000560380304e04 in handle_one_connection (arg=0x560383a4a120) at /data/src/10.3/sql/sql_connect.cc:1308
|
#18 0x0000560380be02a8 in pfs_spawn_thread (arg=0x560383a650a0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#19 0x00007f66e89e24a4 in start_thread (arg=0x7f66e106d700) at pthread_create.c:456
|
#20 0x00007f66e6f2ad0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
No obvious effect on a non-debug build.
The test case is not applicable to 10.2 (HANDLER doesn't work with partitioning).
Reproducible on previous 10.3.x releases.
Attachments
Issue Links
- relates to
-
MDEV-23167 Server crashes upon HANDLER READ from partitioned table
- Confirmed