handle_fatal_signal (sig=11) in Table_node::Table_node | sql/sql_base.cc:10101

[Ramesh Sivaraman]

GDB info

#0 __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
#1 0x000000000199cfa7 in my_write_core (sig=11) at /qa/mytest/PS-5.7.19_dbg/mysys/stacktrace.c:249
#2 0x0000000000f16d8e in handle_fatal_signal (sig=11) at /qa/mytest/PS-5.7.19_dbg/sql/signal_handler.cc:223
#3 <signal handler called>
#4 0x00000000015afe7f in Table_node::Table_node (this=0x7f6a134b4678, table_arg=0x0) at /qa/mytest/PS-5.7.19_dbg/sql/sql_base.cc:10101
#5 0x00000000015b01b4 in Const_ordered_table_node::Const_ordered_table_node (this=0x7f6a134b4638, table_arg=0x0) at /qa/mytest/PS-5.7.19_dbg/sql/sql_base.cc:10181
#6 0x00000000015b3e44 in Join_node::add_table (this=0x7f6a84806550, table=0x0) at /qa/mytest/PS-5.7.19_dbg/sql/sql_base.cc:10236
#7 0x00000000015b40d9 in Join_node::Join_node (this=0x7f6a84806550, table=0x7f6a13455018, cond=0x7f6a134557f8, order=0x0) at /qa/mytest/PS-5.7.19_dbg/sql/sql_base.cc:10256
#8 0x00000000015b0bcb in is_order_deterministic (table=0x7f6a13455018, cond=0x7f6a134557f8, order=0x0) at /qa/mytest/PS-5.7.19_dbg/sql/sql_base.cc:10481
#9 0x0000000001909487 in THD::issue_unsafe_warnings (this=0x7f6a13012000) at /qa/mytest/PS-5.7.19_dbg/sql/binlog.cc:11976
#10 0x0000000001909846 in THD::binlog_query (this=0x7f6a13012000, qtype=THD::ROW_QUERY_TYPE, query_arg=0x7f6a13454030 "update v2 set a=10 where a=200 limit 1", query_len=38, is_trans=true, direct=false, suppress_use=false, errcode=0) at /qa/mytest/PS-5.7.19_dbg/sql/binlog.cc:12175
#11 0x00000000016fd73f in mysql_update (thd=0x7f6a13012000, fields=..., values=..., limit=1, handle_duplicates=DUP_ERROR, found_return=0x7f6a848081d8, updated_return=0x7f6a848081e0) at /qa/mytest/PS-5.7.19_dbg/sql/sql_update.cc:1059
#12 0x0000000001703962 in Sql_cmd_update::try_single_table_update (this=0x7f6a13454fe8, thd=0x7f6a13012000, switch_to_multitable=0x7f6a84808277) at /qa/mytest/PS-5.7.19_dbg/sql/sql_update.cc:2889
#13 0x0000000001703e8a in Sql_cmd_update::execute (this=0x7f6a13454fe8, thd=0x7f6a13012000) at /qa/mytest/PS-5.7.19_dbg/sql/sql_update.cc:3016
#14 0x00000000016343a0 in mysql_execute_command (thd=0x7f6a13012000, first_level=true) at /qa/mytest/PS-5.7.19_dbg/sql/sql_parse.cc:3758
#15 0x000000000163a9b8 in mysql_parse (thd=0x7f6a13012000, parser_state=0x7f6a848094a0) at /qa/mytest/PS-5.7.19_dbg/sql/sql_parse.cc:5891
#16 0x000000000162e947 in dispatch_command (thd=0x7f6a13012000, com_data=0x7f6a84809da0, command=COM_QUERY) at /qa/mytest/PS-5.7.19_dbg/sql/sql_parse.cc:1493
#17 0x000000000162d6e8 in do_command (thd=0x7f6a13012000) at /qa/mytest/PS-5.7.19_dbg/sql/sql_parse.cc:1021
#18 0x000000000177ff26 in handle_connection (arg=0x7f6a13011040) at /qa/mytest/PS-5.7.19_dbg/sql/conn_handler/connection_handler_per_thread.cc:312
#19 0x0000000001e79a9d in pfs_spawn_thread (arg=0x7f6a767d4120) at /qa/mytest/PS-5.7.19_dbg/storage/perfschema/pfs.cc:2188
#20 0x00007f6a82f046ba in start_thread (arg=0x7f6a8480a700) at pthread_create.c:333
#21 0x00007f6a823993dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Testcase

** startup

/qa/mytest/PS260817-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysqld --no-defaults --server-id=201 --log-bin=mysql-bin --core-file --basedir=/qa/mytest/PS260817-percona-server-5.7.19-17-linux-x86_64-debug --tmpdir=/qa/mytest/PS260817-percona-server-5.7.19-17-linux-x86_64-debug/data --datadir=/qa/mytest/PS260817-percona-server-5.7.19-17-linux-x86_64-debug/data --plugin-load-add=tokudb=ha_tokudb.so --tokudb-check-jemalloc=0 --socket=/qa/mytest/PS260817-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --port=19220 --log-error=/qa/mytest/PS260817-percona-server-5.7.19-17-linux-x86_64-debug/log/master.err 2>&1 &

** SQL

set @@binlog_format=statement;
SET @@session.default_storage_engine=INNODB;
create table t2(a int key);
create view v2(a)as select a from t2;
update v2 set a=10 where a=200 limit 1;

PS : Count not reproduce with upstream mysql

[Laurynas Biveinis (laurynas-biveinis)]

Likely related to bug 1204849

[Roel Van de Paar (roel11)]

Ref PS-290

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-290