Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.4
Description
CREATE TABLE t1 (a INT AUTO_INCREMENT, b VARCHAR(1024), UNIQUE (b,a)) ENGINE=MyISAM; |
INSERT INTO t1 () VALUES (); |
|
# Cleanup
|
DROP TABLE t1; |
10.4 a17a327f |
#3 <signal handler called>
|
#4 0x0000560f03088abe in key_copy (to_key=0x7fbae4a47ce9 "\230\202\003\017V", from_record=0x7fbad412a0f8 "\377", key_info=0x7fbad400bc88, key_length=1016, with_zerofill=false) at /data/src/10.4/sql/key.cc:150
|
#5 0x0000560f036ed3e8 in ha_myisam::get_auto_increment (this=0x7fbad4132b78, offset=1, increment=1, nb_desired_values=1, first_value=0x7fbae4a48108, nb_reserved_values=0x7fbae4a48110) at /data/src/10.4/storage/myisam/ha_myisam.cc:2306
|
#6 0x0000560f02f727d1 in handler::update_auto_increment (this=0x7fbad4132b78) at /data/src/10.4/sql/handler.cc:3377
|
#7 0x0000560f036e8958 in ha_myisam::write_row (this=0x7fbad4132b78, buf=0x7fbad412a0f8 "\377") at /data/src/10.4/storage/myisam/ha_myisam.cc:946
|
#8 0x0000560f02f7bdaa in handler::ha_write_row (this=0x7fbad4132b78, buf=0x7fbad412a0f8 "\377") at /data/src/10.4/sql/handler.cc:6675
|
#9 0x0000560f02bc125c in write_record (thd=0x7fbad4000af0, table=0x7fbad400ae20, info=0x7fbae4a48490) at /data/src/10.4/sql/sql_insert.cc:2056
|
#10 0x0000560f02bbe1c7 in mysql_insert (thd=0x7fbad4000af0, table_list=0x7fbad4013280, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.4/sql/sql_insert.cc:1078
|
#11 0x0000560f02c0c6dd in mysql_execute_command (thd=0x7fbad4000af0) at /data/src/10.4/sql/sql_parse.cc:4528
|
#12 0x0000560f02c18e67 in mysql_parse (thd=0x7fbad4000af0, rawbuf=0x7fbad4013198 "INSERT INTO t1 () VALUES ()", length=27, parser_state=0x7fbae4a49160, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7900
|
#13 0x0000560f02c0404a in dispatch_command (command=COM_QUERY, thd=0x7fbad4000af0, packet=0x7fbad4136221 "INSERT INTO t1 () VALUES ()", packet_length=27, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1842
|
#14 0x0000560f02c026d7 in do_command (thd=0x7fbad4000af0) at /data/src/10.4/sql/sql_parse.cc:1360
|
#15 0x0000560f02d8b943 in do_handle_one_connection (connect=0x560f05898ce0) at /data/src/10.4/sql/sql_connect.cc:1412
|
#16 0x0000560f02d8b692 in handle_one_connection (arg=0x560f05898ce0) at /data/src/10.4/sql/sql_connect.cc:1316
|
#17 0x0000560f03792585 in pfs_spawn_thread (arg=0x560f058b4c80) at /data/src/10.4/storage/perfschema/pfs.cc:1869
|
#18 0x00007fbaec8284a4 in start_thread (arg=0x7fbae4a4a700) at pthread_create.c:456
|
#19 0x00007fbaea95cd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
Reproducible on 10.4, 10.5. Upd: Fixed in 10.5, but not in 10.4
Reproducible on all of debug, ASAN, and non-debug with similarly looking stack traces. On non-debug build the crash is sporadic, though.
The failure appeared in 10.4 tree with this commit:
commit bd7f7b14163d0696aa92c90deeab16d63ae6bbd6
|
Author: Sergei Golubchik
|
Date: Thu Feb 21 22:42:00 2019 +0100
|
|
MDEV-371 Unique Index for long columns
|
Attachments
Issue Links
- is caused by
-
MDEV-22747 Backport update_handler fix for long unique from 10.5 to 10.4
- Stalled