[MDEV-20666] Assertion failures prebuilt->sql_stat_start ... in row_search / index_read upon concurrent INSERT and CREATE .. SELECT - Jira

XML

Word

Printable

Details

Type: Bug
Status: Stalled (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 10.5, 10.6, 5.5(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.7(EOL)
Fix Version/s: 10.5, 10.6, 10.11
Component/s: Data Definition - Create Table, Data Manipulation - Insert, Storage Engine - InnoDB
Labels:
None

Description

Note: The assertion failures described here look similar (although not identical) to those in ~~MDEV-14846~~. However, in ~~MDEV-14846~~, thiru's analysis revealed that the problem was due to the server ignoring HA_ERR_LOCK_DEADLOCK. In this case, however, there is no deadlock, so it might be a different problem. If it turns out to be the same after all, feel free to close, but please make sure that the fix is verified with all provided test cases, including this one.

Note: The test case is non-deterministic, run with --repeat=N. It fails fairly quickly for me at the moment, usually within 10 attempts on 10.2-10.4 and within 20 attempts on 5.5-10.1, but it can vary on different machines and builds. Also I recommend running with --mem, the problem is repeatable both in shm and on disk, but multiple repetitions of the test run much faster in memory.

--source include/have_innodb.inc

--connect (con1,localhost,root,,test)

CREATE  TABLE t1 (id INT, KEY(id)) ENGINE=InnoDB;

INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL);

--send

INSERT INTO t1 SELECT * FROM t1;

--connection default

CREATE TABLE t2 SELECT DISTINCT id FROM t1 WHERE id BETWEEN 1 AND 2;

# Cleanup

--connection con1

--reap

--disconnect con1

--connection default

DROP TABLE IF EXISTS t2, t1;

10.4 a39c4b5f
mysqld: /data/src/10.4/storage/innobase/row/row0sel.cc:4485: dberr_t row_search_mvcc(byte, page_cur_mode_t, row_prebuilt_t, ulint, ulint): Assertion `prebuilt->sql_stat_start \|\| trx->state == TRX_STATE_ACTIVE \|\| (prebuilt->table->no_rollback() && trx->state == TRX_STATE_NOT_STARTED)' failed.
190925 14:51:43 [ERROR] mysqld got signal 6 ;

#7 0x00007f62c8a80f12 in __GI___assert_fail (assertion=0x55bc3186ab10 "prebuilt->sql_stat_start \|\| trx->state == TRX_STATE_ACTIVE \|\| (prebuilt->table->no_rollback() && trx->state == TRX_STATE_NOT_STARTED)", file=0x55bc31869828 "/data/src/10.4/storage/innobase/row/row0sel.cc", line=4485, function=0x55bc3186dd40 <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 0x000055bc31084b8b in row_search_mvcc (buf=0x7f6270081a40 "\377", mode=PAGE_CUR_GE, prebuilt=0x7f62701a6ed8, match_mode=0, direction=0) at /data/src/10.4/storage/innobase/row/row0sel.cc:4485
#9 0x000055bc30e9c870 in ha_innobase::index_read (this=0x7f627000ac08, buf=0x7f6270081a40 "\377", key_ptr=0x7f62701ab2f8 "", key_len=5, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:9306
#10 0x000055bc30c61fdc in handler::index_read_map (this=0x7f627000ac08, buf=0x7f6270081a40 "\377", key=0x7f62701ab2f8 "", keypart_map=1, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/10.4/sql/handler.h:3599
#11 0x000055bc30c522ec in handler::ha_index_read_map (this=0x7f627000ac08, buf=0x7f6270081a40 "\377", key=0x7f62701ab2f8 "", keypart_map=1, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/10.4/sql/handler.cc:2883
#12 0x000055bc30c5abee in handler::read_range_first (this=0x7f627000ac08, start_key=0x7f62bde2cd10, end_key=0x7f62bde2cd30, eq_range_arg=false, sorted=true) at /data/src/10.4/sql/handler.cc:5831
#13 0x000055bc30de36c8 in QUICK_RANGE_SELECT::get_next_prefix (this=0x7f627014f780, prefix_length=5, group_key_parts=1, cur_prefix=0x0) at /data/src/10.4/sql/opt_range.cc:12253
#14 0x000055bc30dea52f in QUICK_GROUP_MIN_MAX_SELECT::next_prefix (this=0x7f6270143600) at /data/src/10.4/sql/opt_range.cc:15087
#15 0x000055bc30de9d65 in QUICK_GROUP_MIN_MAX_SELECT::get_next (this=0x7f6270143600) at /data/src/10.4/sql/opt_range.cc:14829
#16 0x000055bc30df6819 in rr_quick (info=0x7f6270017c88) at /data/src/10.4/sql/records.cc:361
#17 0x000055bc30840287 in READ_RECORD::read_record (this=0x7f6270017c88) at /data/src/10.4/sql/records.h:69
#18 0x000055bc309719d7 in join_init_read_record (tab=0x7f6270017bc0) at /data/src/10.4/sql/sql_select.cc:21129
#19 0x000055bc3096f5ba in sub_select (join=0x7f62700155a8, join_tab=0x7f6270017bc0, end_of_records=false) at /data/src/10.4/sql/sql_select.cc:20185
#20 0x000055bc3096eaab in do_select (join=0x7f62700155a8, procedure=0x0) at /data/src/10.4/sql/sql_select.cc:19726
#21 0x000055bc30943c17 in JOIN::exec_inner (this=0x7f62700155a8) at /data/src/10.4/sql/sql_select.cc:4386
#22 0x000055bc30942d54 in JOIN::exec (this=0x7f62700155a8) at /data/src/10.4/sql/sql_select.cc:4168
#23 0x000055bc30944469 in mysql_select (thd=0x7f6270000b00, tables=0x7f6270014050, wild_num=0, fields=..., conds=0x7f6270014960, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184065, result=0x7f62700154b0, unit=0x7f6270004a30, select_lex=0x7f6270013a88) at /data/src/10.4/sql/sql_select.cc:4600
#24 0x000055bc309343ec in handle_select (thd=0x7f6270000b00, lex=0x7f6270004968, result=0x7f62700154b0, setup_tables_done_option=0) at /data/src/10.4/sql/sql_select.cc:420
#25 0x000055bc309e65cb in Sql_cmd_create_table_like::execute (this=0x7f6270013370, thd=0x7f6270000b00) at /data/src/10.4/sql/sql_table.cc:11384
#26 0x000055bc308f997b in mysql_execute_command (thd=0x7f6270000b00) at /data/src/10.4/sql/sql_parse.cc:6094
#27 0x000055bc308ff04f in mysql_parse (thd=0x7f6270000b00, rawbuf=0x7f6270013280 "CREATE TABLE t2 SELECT DISTINCT id FROM t1 WHERE id BETWEEN 1 AND 2", length=67, parser_state=0x7f62bde2e170, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7912
#28 0x000055bc308ea2e2 in dispatch_command (command=COM_QUERY, thd=0x7f6270000b00, packet=0x7f627019dc51 "CREATE TABLE t2 SELECT DISTINCT id FROM t1 WHERE id BETWEEN 1 AND 2", packet_length=67, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1841
#29 0x000055bc308e896f in do_command (thd=0x7f6270000b00) at /data/src/10.4/sql/sql_parse.cc:1359
#30 0x000055bc30a6fdef in do_handle_one_connection (connect=0x55bc34cb57c0) at /data/src/10.4/sql/sql_connect.cc:1412
#31 0x000055bc30a6fb3e in handle_one_connection (arg=0x55bc34cb57c0) at /data/src/10.4/sql/sql_connect.cc:1316
#32 0x000055bc3146f2ed in pfs_spawn_thread (arg=0x55bc34c34120) at /data/src/10.4/storage/perfschema/pfs.cc:1862
#33 0x00007f62ca5f54a4 in start_thread (arg=0x7f62bde2f700) at pthread_create.c:456
#34 0x00007f62c8b3dd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

10.3 b6bb64e5 (same as on 10.4)
mysqld: /data/src/10.3/storage/innobase/row/row0sel.cc:4503: dberr_t row_search_mvcc(byte, page_cur_mode_t, row_prebuilt_t, ulint, ulint): Assertion `prebuilt->sql_stat_start \|\| trx->state == TRX_STATE_ACTIVE \|\| (prebuilt->table->no_rollback() && trx->state == TRX_STATE_NOT_STARTED)' failed.
190925 14:53:00 [ERROR] mysqld got signal 6 ;

#7 0x00007f5331d03f12 in __GI___assert_fail (assertion=0x56272ec30860 "prebuilt->sql_stat_start \|\| trx->state == TRX_STATE_ACTIVE \|\| (prebuilt->table->no_rollback() && trx->state == TRX_STATE_NOT_STARTED)", file=0x56272ec2f550 "/data/src/10.3/storage/innobase/row/row0sel.cc", line=4503, function=0x56272ec33c80 <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 0x000056272e4b2dc3 in row_search_mvcc (buf=0x7f52e0006af0 "\377", mode=PAGE_CUR_GE, prebuilt=0x7f52e0160698, match_mode=0, direction=0) at /data/src/10.3/storage/innobase/row/row0sel.cc:4503
#9 0x000056272e2d9d1e in ha_innobase::index_read (this=0x7f52e015fee8, buf=0x7f52e0006af0 "\377", key_ptr=0x7f52e0181d78 "", key_len=5, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:9316
#10 0x000056272e0bbe08 in handler::index_read_map (this=0x7f52e015fee8, buf=0x7f52e0006af0 "\377", key=0x7f52e0181d78 "", keypart_map=1, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/10.3/sql/handler.h:3474
#11 0x000056272e0adace in handler::ha_index_read_map (this=0x7f52e015fee8, buf=0x7f52e0006af0 "\377", key=0x7f52e0181d78 "", keypart_map=1, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/10.3/sql/handler.cc:2897
#12 0x000056272e0b61fe in handler::read_range_first (this=0x7f52e015fee8, start_key=0x7f532c1014e0, end_key=0x7f532c101500, eq_range_arg=false, sorted=true) at /data/src/10.3/sql/handler.cc:5816
#13 0x000056272e22cf96 in QUICK_RANGE_SELECT::get_next_prefix (this=0x7f52e00a7750, prefix_length=5, group_key_parts=1, cur_prefix=0x0) at /data/src/10.3/sql/opt_range.cc:11595
#14 0x000056272e2338c3 in QUICK_GROUP_MIN_MAX_SELECT::next_prefix (this=0x7f52e00a7600) at /data/src/10.3/sql/opt_range.cc:14325
#15 0x000056272e2330eb in QUICK_GROUP_MIN_MAX_SELECT::get_next (this=0x7f52e00a7600) at /data/src/10.3/sql/opt_range.cc:14067
#16 0x000056272e23e9f7 in rr_quick (info=0x7f52e0016558) at /data/src/10.3/sql/records.cc:361
#17 0x000056272dcf1897 in READ_RECORD::read_record (this=0x7f52e0016558) at /data/src/10.3/sql/records.h:69
#18 0x000056272de0bb28 in join_init_read_record (tab=0x7f52e0016490) at /data/src/10.3/sql/sql_select.cc:20463
#19 0x000056272de096e5 in sub_select (join=0x7f52e0013f50, join_tab=0x7f52e0016490, end_of_records=false) at /data/src/10.3/sql/sql_select.cc:19524
#20 0x000056272de08bd1 in do_select (join=0x7f52e0013f50, procedure=0x0) at /data/src/10.3/sql/sql_select.cc:19067
#21 0x000056272dddfad9 in JOIN::exec_inner (this=0x7f52e0013f50) at /data/src/10.3/sql/sql_select.cc:4040
#22 0x000056272dddeeac in JOIN::exec (this=0x7f52e0013f50) at /data/src/10.3/sql/sql_select.cc:3834
#23 0x000056272dde01bd in mysql_select (thd=0x7f52e0000b00, tables=0x7f52e0013268, wild_num=0, fields=..., conds=0x7f52e0013b18, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184065, result=0x7f52e0013e58, unit=0x7f52e00049d0, select_lex=0x7f52e0005150) at /data/src/10.3/sql/sql_select.cc:4239
#24 0x000056272ddd1c44 in handle_select (thd=0x7f52e0000b00, lex=0x7f52e0004908, result=0x7f52e0013e58, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:370
#25 0x000056272de7c1d1 in Sql_cmd_create_table_like::execute (this=0x7f52e0012a90, thd=0x7f52e0000b00) at /data/src/10.3/sql/sql_table.cc:11150
#26 0x000056272dd9854a in mysql_execute_command (thd=0x7f52e0000b00) at /data/src/10.3/sql/sql_parse.cc:6023
#27 0x000056272dd9dcbd in mysql_parse (thd=0x7f52e0000b00, rawbuf=0x7f52e0012960 "CREATE TABLE t2 SELECT DISTINCT id FROM t1 WHERE id BETWEEN 1 AND 2", length=67, parser_state=0x7f532c1025e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7829
#28 0x000056272dd8a8f7 in dispatch_command (command=COM_QUERY, thd=0x7f52e0000b00, packet=0x7f52e0008c71 "CREATE TABLE t2 SELECT DISTINCT id FROM t1 WHERE id BETWEEN 1 AND 2", packet_length=67, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1855
#29 0x000056272dd8923f in do_command (thd=0x7f52e0000b00) at /data/src/10.3/sql/sql_parse.cc:1400
#30 0x000056272deffba4 in do_handle_one_connection (connect=0x5627312a8310) at /data/src/10.3/sql/sql_connect.cc:1403
#31 0x000056272deff906 in handle_one_connection (arg=0x5627312a8310) at /data/src/10.3/sql/sql_connect.cc:1308
#32 0x000056272e8aa528 in pfs_spawn_thread (arg=0x5627311ed9b0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
#33 0x00007f53338784a4 in start_thread (arg=0x7f532c103700) at pthread_create.c:456
#34 0x00007f5331dc0d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

10.2 102bc7be
mysqld: /data/src/10.2/storage/innobase/row/row0sel.cc:4579: dberr_t row_search_mvcc(byte, page_cur_mode_t, row_prebuilt_t, ulint, ulint): Assertion `prebuilt->sql_stat_start \|\| trx->state == TRX_STATE_ACTIVE' failed.
190925 14:54:06 [ERROR] mysqld got signal 6 ;

#7 0x00007f32a5d5df12 in __GI___assert_fail (assertion=0x557d615d4da8 "prebuilt->sql_stat_start \|\| trx->state == TRX_STATE_ACTIVE", file=0x557d615d3a68 "/data/src/10.2/storage/innobase/row/row0sel.cc", line=4579, function=0x557d615d8260 <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 0x0000557d60fad66d in row_search_mvcc (buf=0x7f324c0e56f0 "\377", mode=PAGE_CUR_GE, prebuilt=0x7f324c0c1fc8, match_mode=0, direction=0) at /data/src/10.2/storage/innobase/row/row0sel.cc:4579
#9 0x0000557d60e3db13 in ha_innobase::index_read (this=0x7f324c09a418, buf=0x7f324c0e56f0 "\377", key_ptr=0x7f324c0bd678 "", key_len=5, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:9471
#10 0x0000557d60c39c4e in handler::index_read_map (this=0x7f324c09a418, buf=0x7f324c0e56f0 "\377", key=0x7f324c0bd678 "", keypart_map=1, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/10.2/sql/handler.h:3136
#11 0x0000557d60c2fe2b in handler::ha_index_read_map (this=0x7f324c09a418, buf=0x7f324c0e56f0 "\377", key=0x7f324c0bd678 "", keypart_map=1, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/10.2/sql/handler.cc:2711
#12 0x0000557d60c36a64 in handler::read_range_first (this=0x7f324c09a418, start_key=0x7f32a03a8ea0, end_key=0x7f32a03a8ec0, eq_range_arg=false, sorted=true) at /data/src/10.2/sql/handler.cc:5458
#13 0x0000557d60d88e19 in QUICK_RANGE_SELECT::get_next_prefix (this=0x7f324c1870a0, prefix_length=5, group_key_parts=1, cur_prefix=0x0) at /data/src/10.2/sql/opt_range.cc:11570
#14 0x0000557d60d8f20d in QUICK_GROUP_MIN_MAX_SELECT::next_prefix (this=0x7f324c00add0) at /data/src/10.2/sql/opt_range.cc:14299
#15 0x0000557d60d8eb07 in QUICK_GROUP_MIN_MAX_SELECT::get_next (this=0x7f324c00add0) at /data/src/10.2/sql/opt_range.cc:14041
#16 0x0000557d60d99a04 in rr_quick (info=0x7f324c015fd8) at /data/src/10.2/sql/records.cc:365
#17 0x0000557d60a1d690 in join_init_read_record (tab=0x7f324c015f10) at /data/src/10.2/sql/sql_select.cc:19780
#18 0x0000557d60a1b42e in sub_select (join=0x7f324c013b08, join_tab=0x7f324c015f10, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18851
#19 0x0000557d60a1aa17 in do_select (join=0x7f324c013b08, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:18398
#20 0x0000557d609f440b in JOIN::exec_inner (this=0x7f324c013b08) at /data/src/10.2/sql/sql_select.cc:3623
#21 0x0000557d609f38c6 in JOIN::exec (this=0x7f324c013b08) at /data/src/10.2/sql/sql_select.cc:3418
#22 0x0000557d609f4a7c in mysql_select (thd=0x7f324c000b00, tables=0x7f324c012e70, wild_num=0, fields=..., conds=0x7f324c0136d8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184065, result=0x7f324c013a18, unit=0x7f324c004700, select_lex=0x7f324c004e40) at /data/src/10.2/sql/sql_select.cc:3818
#23 0x0000557d609e8ce8 in handle_select (thd=0x7f324c000b00, lex=0x7f324c004638, result=0x7f324c013a18, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:361
#24 0x0000557d60a86ef2 in Sql_cmd_create_table::execute (this=0x7f324c0126e0, thd=0x7f324c000b00) at /data/src/10.2/sql/sql_table.cc:10851
#25 0x0000557d609b2c6a in mysql_execute_command (thd=0x7f324c000b00) at /data/src/10.2/sql/sql_parse.cc:5972
#26 0x0000557d609b7d64 in mysql_parse (thd=0x7f324c000b00, rawbuf=0x7f324c0125b0 "CREATE TABLE t2 SELECT DISTINCT id FROM t1 WHERE id BETWEEN 1 AND 2", length=67, parser_state=0x7f32a03aa200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7759
#27 0x0000557d609a606d in dispatch_command (command=COM_QUERY, thd=0x7f324c000b00, packet=0x7f324c096371 "CREATE TABLE t2 SELECT DISTINCT id FROM t1 WHERE id BETWEEN 1 AND 2", packet_length=67, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1831
#28 0x0000557d609a49c1 in do_command (thd=0x7f324c000b00) at /data/src/10.2/sql/sql_parse.cc:1384
#29 0x0000557d60af9c19 in do_handle_one_connection (connect=0x557d6354aff0) at /data/src/10.2/sql/sql_connect.cc:1336
#30 0x0000557d60af9984 in handle_one_connection (arg=0x557d6354aff0) at /data/src/10.2/sql/sql_connect.cc:1241
#31 0x0000557d6132a7fa in pfs_spawn_thread (arg=0x557d6356e2a0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
#32 0x00007f32a78d24a4 in start_thread (arg=0x7f32a03ab700) at pthread_create.c:456
#33 0x00007f32a5e1ad0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

10.1 5f118b26
2019-09-25 14:55:01 7f52feec8700 InnoDB: Assertion failure in thread 139994440959744 in file row0sel.cc line 4191
InnoDB: Failing assertion: prebuilt->sql_stat_start \|\| trx->state == TRX_STATE_ACTIVE
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
190925 14:55:01 [ERROR] mysqld got signal 6 ;

#5 0x00007f52fd4b742a in __GI_abort () at abort.c:89
#6 0x00005576bfb8b2ad in row_search_for_mysql (buf=0x7f52f16e8b88 "\377", mode=2, prebuilt=0x7f52e7881878, match_mode=0, direction=0) at /data/src/10.1/storage/xtradb/row/row0sel.cc:4191
#7 0x00005576bfa4b69a in ha_innobase::index_read (this=0x7f52e78ae088, buf=0x7f52f16e8b88 "\377", key_ptr=0x7f52e79cb148 "", key_len=5, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/10.1/storage/xtradb/handler/ha_innodb.cc:9980
#8 0x00005576bf710ec6 in handler::index_read_map (this=0x7f52e78ae088, buf=0x7f52f16e8b88 "\377", key=0x7f52e79cb148 "", keypart_map=1, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/10.1/sql/handler.h:3080
#9 0x00005576bf7079dd in handler::ha_index_read_map (this=0x7f52e78ae088, buf=0x7f52f16e8b88 "\377", key=0x7f52e79cb148 "", keypart_map=1, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/10.1/sql/handler.cc:2690
#10 0x00005576bf70de30 in handler::read_range_first (this=0x7f52e78ae088, start_key=0x7f52feec5eb0, end_key=0x7f52feec5ed0, eq_range_arg=false, sorted=true) at /data/src/10.1/sql/handler.cc:5388
#11 0x00005576bf8363db in QUICK_RANGE_SELECT::get_next_prefix (this=0x7f52e79c4280, prefix_length=5, group_key_parts=1, cur_prefix=0x0) at /data/src/10.1/sql/opt_range.cc:11349
#12 0x00005576bf83c5a1 in QUICK_GROUP_MIN_MAX_SELECT::next_prefix (this=0x7f52e79c4140) at /data/src/10.1/sql/opt_range.cc:14071
#13 0x00005576bf83beef in QUICK_GROUP_MIN_MAX_SELECT::get_next (this=0x7f52e79c4140) at /data/src/10.1/sql/opt_range.cc:13813
#14 0x00005576bf846173 in rr_quick (info=0x7f52e79168b0) at /data/src/10.1/sql/records.cc:350
#15 0x00005576bf52a5d0 in join_init_read_record (tab=0x7f52e79167f0) at /data/src/10.1/sql/sql_select.cc:19504
#16 0x00005576bf52847c in sub_select (join=0x7f52e7914590, join_tab=0x7f52e79167f0, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:18587
#17 0x00005576bf527d33 in do_select (join=0x7f52e7914590, fields=0x7f52e7914990, table=0x0, procedure=0x0) at /data/src/10.1/sql/sql_select.cc:18245
#18 0x00005576bf50182a in JOIN::exec_inner (this=0x7f52e7914590) at /data/src/10.1/sql/sql_select.cc:3277
#19 0x00005576bf4feabd in JOIN::exec (this=0x7f52e7914590) at /data/src/10.1/sql/sql_select.cc:2564
#20 0x00005576bf50204b in mysql_select (thd=0x7f52f16f0070, rref_pointer_array=0x7f52f16f4570, tables=0x7f52e7913920, wild_num=0, fields=..., conds=0x7f52e7914160, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184065, result=0x7f52e79144b0, unit=0x7f52f16f3bc0, select_lex=0x7f52f16f42c8) at /data/src/10.1/sql/sql_select.cc:3501
#21 0x00005576bf4f7722 in handle_select (thd=0x7f52f16f0070, lex=0x7f52f16f3af8, result=0x7f52e79144b0, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:377
#22 0x00005576bf58b4a4 in Sql_cmd_create_table::execute (this=0x7f52e79131b8, thd=0x7f52f16f0070) at /data/src/10.1/sql/sql_table.cc:10366
#23 0x00005576bf4c59c9 in mysql_execute_command (thd=0x7f52f16f0070) at /data/src/10.1/sql/sql_parse.cc:5442
#24 0x00005576bf4ca59f in mysql_parse (thd=0x7f52f16f0070, rawbuf=0x7f52e7913088 "CREATE TABLE t2 SELECT DISTINCT id FROM t1 WHERE id BETWEEN 1 AND 2", length=67, parser_state=0x7f52feec71e0) at /data/src/10.1/sql/sql_parse.cc:7209
#25 0x00005576bf4b9751 in dispatch_command (command=COM_QUERY, thd=0x7f52f16f0070, packet=0x7f52f6677071 "CREATE TABLE t2 SELECT DISTINCT id FROM t1 WHERE id BETWEEN 1 AND 2", packet_length=67) at /data/src/10.1/sql/sql_parse.cc:1499
#26 0x00005576bf4b850f in do_command (thd=0x7f52f16f0070) at /data/src/10.1/sql/sql_parse.cc:1131
#27 0x00005576bf5f57e3 in do_handle_one_connection (thd_arg=0x7f52f16f0070) at /data/src/10.1/sql/sql_connect.cc:1331
#28 0x00005576bf5f5514 in handle_one_connection (arg=0x7f52f16f0070) at /data/src/10.1/sql/sql_connect.cc:1242
#29 0x00005576bfa2a966 in pfs_spawn_thread (arg=0x7f52f1647670) at /data/src/10.1/storage/perfschema/pfs.cc:1861
#30 0x00007f52feb554a4 in start_thread (arg=0x7f52feec8700) at pthread_create.c:456
#31 0x00007f52fd56bd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

5.5 67b0faa2
190925 14:56:31 InnoDB: Assertion failure in thread 140617657390848 in file row0sel.c line 3802
InnoDB: Failing assertion: prebuilt->sql_stat_start \|\| trx->conc_state == 1

#5 0x00007fe417de642a in __GI_abort () at abort.c:89
#6 0x00007fe4130fbf12 in row_search_for_mysql (buf=0x7fe409456a78 "\377", mode=2, prebuilt=0x7fe4094a5278, match_mode=0, direction=0) at /data/src/5.5/storage/innobase/row/row0sel.c:3802
#7 0x00007fe4130a67db in ha_innodb::index_read (this=0x7fe409557078, buf=0x7fe409456a78 "\377", key_ptr=0x7fe4096600b0 "", key_len=5, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/5.5/storage/innobase/handler/ha_innodb.cc:6072
#8 0x00007fe4130b1a48 in handler::index_read_map (this=0x7fe409557078, buf=0x7fe409456a78 "\377", key=0x7fe4096600b0 "", keypart_map=1, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/5.5/sql/handler.h:2129
#9 0x00005557507e4262 in handler::ha_index_read_map (this=0x7fe409557078, buf=0x7fe409456a78 "\377", key=0x7fe4096600b0 "", keypart_map=1, find_flag=HA_READ_KEY_OR_NEXT) at /data/src/5.5/sql/sql_class.h:4246
#10 0x0000555750a066c9 in handler::read_range_first (this=0x7fe409557078, start_key=0x7fe4198478f0, end_key=0x7fe419847910, eq_range_arg=false, sorted=true) at /data/src/5.5/sql/handler.cc:4638
#11 0x0000555750b11f33 in QUICK_RANGE_SELECT::get_next_prefix (this=0x7fe409422340, prefix_length=5, group_key_parts=1, cur_prefix=0x0) at /data/src/5.5/sql/opt_range.cc:11310
#12 0x0000555750b17ac2 in QUICK_GROUP_MIN_MAX_SELECT::next_prefix (this=0x7fe409422200) at /data/src/5.5/sql/opt_range.cc:13969
#13 0x0000555750b17432 in QUICK_GROUP_MIN_MAX_SELECT::get_next (this=0x7fe409422200) at /data/src/5.5/sql/opt_range.cc:13711
#14 0x0000555750b20aa3 in rr_quick (info=0x7fe4097690f8) at /data/src/5.5/sql/records.cc:347
#15 0x00005557508a790c in join_init_read_record (tab=0x7fe409769048) at /data/src/5.5/sql/sql_select.cc:18083
#16 0x00005557508a57bb in sub_select (join=0x7fe409553518, join_tab=0x7fe409769048, end_of_records=false) at /data/src/5.5/sql/sql_select.cc:17183
#17 0x00005557508a507c in do_select (join=0x7fe409553518, fields=0x7fe4095538f8, table=0x0, procedure=0x0) at /data/src/5.5/sql/sql_select.cc:16848
#18 0x0000555750882471 in JOIN::exec (this=0x7fe409553518) at /data/src/5.5/sql/sql_select.cc:2914
#19 0x0000555750882c47 in mysql_select (thd=0x7fe41278f060, rref_pointer_array=0x7fe412792d10, tables=0x7fe4095528e8, wild_num=0, fields=..., conds=0x7fe409553128, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184065, result=0x7fe409553440, unit=0x7fe412792388, select_lex=0x7fe412792a70) at /data/src/5.5/sql/sql_select.cc:3135
#20 0x0000555750879214 in handle_select (thd=0x7fe41278f060, lex=0x7fe4127922d8, result=0x7fe409553440, setup_tables_done_option=0) at /data/src/5.5/sql/sql_select.cc:312
#21 0x000055575084b73f in mysql_execute_command (thd=0x7fe41278f060) at /data/src/5.5/sql/sql_parse.cc:2610
#22 0x00005557508545ef in mysql_parse (thd=0x7fe41278f060, rawbuf=0x7fe409552078 "CREATE TABLE t2 SELECT DISTINCT id FROM t1 WHERE id BETWEEN 1 AND 2", length=67, parser_state=0x7fe419848620) at /data/src/5.5/sql/sql_parse.cc:5929
#23 0x0000555750847eab in dispatch_command (command=COM_QUERY, thd=0x7fe41278f060, packet=0x7fe4115bb061 "CREATE TABLE t2 SELECT DISTINCT id FROM t1 WHERE id BETWEEN 1 AND 2", packet_length=67) at /data/src/5.5/sql/sql_parse.cc:1067
#24 0x00005557508470bb in do_command (thd=0x7fe41278f060) at /data/src/5.5/sql/sql_parse.cc:793
#25 0x000055575094d311 in do_handle_one_connection (thd_arg=0x7fe41278f060) at /data/src/5.5/sql/sql_connect.cc:1268
#26 0x000055575094d080 in handle_one_connection (arg=0x7fe41278f060) at /data/src/5.5/sql/sql_connect.cc:1184
#27 0x0000555750cd1d0e in pfs_spawn_thread (arg=0x7fe4127b1a80) at /data/src/5.5/storage/perfschema/pfs.cc:1015
#28 0x00007fe4194844a4 in start_thread (arg=0x7fe419849700) at pthread_create.c:456
#29 0x00007fe417e9ad0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

No obvious problem on a non-debug build.

Attachments

Issue Links

duplicates

MDEV-14846 InnoDB: assertion on trx->state because of deadlock error ignored

Closed

MDEV-15013 [Draft] Assertion `prebuilt->sql_stat_start || trx->state == TRX_STATE_ACTIVE || (prebuilt->table->no_rollback() && trx->state == TRX_STATE_NOT_STARTED)' failed in row_search_mvcc

Closed

relates to

MDEV-21987 Assertion failure in file lock0lock.cc line 6901 / DeadlockChecker::check_and_resolve

Confirmed

MDEV-23101 SIGSEGV in lock_rec_unlock() when Galera is enabled

Closed

MDEV-14846 InnoDB: assertion on trx->state because of deadlock error ignored

Closed

MDEV-23939 Crash with mariadb 10.4: storage/innobase/row/row0sel.cc:4480: row_search_mvcc Assertion `prebuilt->sql_stat_start || trx->state == TRX_STATE_ACTIVE || (prebuilt->table->no_rollback() && trx->state == TRX_STATE_NOT_STARTED)’ failed.

Closed

MDEV-29120 Assertion `prebuilt->sql_stat_start || prebuilt->table->no_rollback()' failed at row0sel.cc:4618

Confirmed

(2 relates to)

Activity

People

Assignee:: Oleksandr Byelkin

Reporter:: Elena Stepanova

Votes:: 1 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2019-09-25 12:00

Updated:: 2024-09-10 15:06

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.