Details
Description
CREATE OR REPLACE TABLE t1 (a INT, b INT, PRIMARY KEY (a), UNIQUE(b)); |
INSERT INTO t1 VALUES (1,1); |
CREATE OR REPLACE TABLE t2 (c INT); |
CREATE OR REPLACE VIEW v AS SELECT t1.* FROM t1 JOIN t2; |
SELECT a, b FROM t1 INTO OUTFILE '15645.data'; |
LOAD DATA INFILE '15645.data' IGNORE INTO TABLE v (a,b); |
LOAD DATA INFILE '15645.data' REPLACE INTO TABLE v (a,b); |
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at raise.c:51
|
#1 __GI_abort () at abort.c:90
|
#2 __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x1633a98 "table", file=file@entry=0x14ac53f "/work/mariadb/sql/sql_base.cc", line=line@entry=1010, function=function@entry=0x14ae051 "TABLE_LIST *find_dup_table(THD *, TABLE_LIST *, TABLE_LIST *, bool)") at assert.c:92
|
#3 __GI___assert_fail (assertion=0x1633a98 "table", file=0x14ac53f "/work/mariadb/sql/sql_base.cc", line=1010, function=0x14ae051 "TABLE_LIST *find_dup_table(THD *, TABLE_LIST *, TABLE_LIST *, bool)") at assert.c:101
|
#4 find_dup_table (thd=0x7fffa0000ce8, table=0x0, table_list=0x7fffa0016d18, check_alias=false) at sql_base.cc:1010
|
#5 unique_table (thd=0x7fffa0000ce8, table=0x7fffa0014138, table_list=0x7fffa0016d18, check_alias=false) at sql_base.cc:1139
|
#6 mysql_load (thd=0x7fffa0000ce8, ex=0x7fffa00140b0, table_list=0x7fffa0014138, fields_vars=List<Item> with 2 elements, set_fields=List<Item> with 0 elements, set_values=List<Item> with 0 elements, handle_duplicates=DUP_ERROR, ignore=true, read_file_from_client=false) at sql_load.cc:421
|
#7 mysql_execute_command (thd=0x7fffa0000ce8) at sql_parse.cc:5122
|
#8 mysql_parse (thd=0x7fffa0000ce8, rawbuf=0x7fffa0013fc0 "LOAD DATA INFILE '15645.data' IGNORE INTO TABLE v (a,b)", length=55, parser_state=0x7fffedca0400, is_com_multi=false, is_next_command=false) at sql_parse.cc:8001
|
#9 dispatch_command (command=COM_QUERY, thd=0x7fffa0000ce8, packet=0x7fffa000ab19 "LOAD DATA INFILE '15645.data' IGNORE INTO TABLE v (a,b)", packet_length=55, is_com_multi=false, is_next_command=false) at sql_parse.cc:1845
|
#10 do_command (thd=0x7fffa0000ce8) at sql_parse.cc:1390
|
#11 do_handle_one_connection (connect=0x2c96bb8) at sql_connect.cc:1402
|
#12 handle_one_connection (arg=0x2c96bb8) at sql_connect.cc:1308
|
#13 pfs_spawn_thread (arg=0x2ca3858) at pfs.cc:1862
|
#14 start_thread (arg=0x7fffedca1700) at pthread_create.c:465
|
#15 clone () at clone.S:95
|
Attachments
Issue Links
- blocks
-
MDEV-15645 Assertion `table->insert_values' failed in write_record upon REPLACE into a view with underlying versioned table
-
- Closed
-
In 5.5 crash looks like this:
Thread 18 "mysqld" received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7ffff7f7b700 (LWP 31005)]
0x00000000005e4be8 in handler::increment_statistics (this=0x7fffe6451818, offset=&system_status_var::ha_write_count) at sql_class.h:4230
4230 status_var_increment(table->in_use->status_var.*offset);
(gdb) bt
#0 handler::increment_statistics (this=0x7fffe6451818, offset=&system_status_var::ha_write_count) at sql_class.h:4230
#1 handler::ha_write_row (this=0x7fffe6451818, buf=0x7fffe6467548 "\377") at handler.cc:5202
#2 write_record (thd=0x7ffff17e8000, table=0x7fffe64fb018, info=0x7ffff7f783e8) at sql_insert.cc:1844
#3 read_sep_field (thd=0x7ffff17e8000, info=..., table_list=0x7fffe658a190, fields_vars=List<Item> with 2 elements, set_fields=List<Item> with 0 elements, set_values=List<Item> with 0 elements, read_info=..., enclosed=String 0xec69e8 "" length 0, skip_lines=0, ignore_check_option_errors=true) at sql_load.cc:1125
#4 mysql_load (thd=0x7ffff17e8000, ex=0x7fffe658a108, table_list=0x7fffe658a190, fields_vars=List<Item> with 2 elements, set_fields=List<Item> with 0 elements, set_values=List<Item> with 0 elements, handle_duplicates=DUP_ERROR, ignore=true, read_file_from_client=false) at sql_load.cc:520
#5 mysql_execute_command (thd=0x7ffff17e8000) at sql_parse.cc:3233
#6 mysql_parse (thd=0x7ffff17e8000, rawbuf=0x7fffe658a018 "LOAD DATA INFILE '15645.data' IGNORE INTO TABLE v (a,b)", length=55, parser_state=0x7ffff7f7a7c8) at sql_parse.cc:5923
#7 dispatch_command (command=COM_QUERY, thd=0x7ffff17e8000, packet=0x7ffff17f8001 "LOAD DATA INFILE '15645.data' IGNORE INTO TABLE v (a,b)", packet_length=55) at sql_parse.cc:1066
#8 do_command (thd=0x7ffff17e8000) at sql_parse.cc:793
#9 do_handle_one_connection (thd_arg=0x7ffff17e8000) at sql_connect.cc:1268
#10 handle_one_connection (arg=0x7ffff17e8000) at sql_connect.cc:1184
#11 pfs_spawn_thread (arg=0x7ffff2bff250) at pfs.cc:1015
#12 start_thread (arg=0x7ffff7f7b700) at pthread_create.c:465
#13 clone () at clone.S:95
(gdb) p table
$1 = (TABLE *) 0x0