2023-09-13 mysql-代号m-insert select语句注册-问题分析

摘要:

2023-09-13 mysql-代号m-insert select语句注册-问题分析

上下文:

2023-09-11 mysql-代号m-0930阶段目标-任务列表-记录_财阀悟世的博客-CSDN博客

https://devops.aliyun.com/projex/project/36ed2d8a9a29e7f8407c6f5498/bug/fecdfdaf824803e72b79afa291

DDL:

表结构和数据:

drop table t1;
drop table t2;
 
create table t1(id int,name varchar(5));
 
insert into t1 values(1,'AAA'),(2,'BBB');
 
select * from t1;
 
create table t2(id int,name varchar(5));

insert select句子:

insert into t2 select * from t1;

核心函数:

ha_innobase::write_row

调用堆栈:

#0  ha_innobase::write_row (this=0x7f6404389c70, record=0x7f64042d6160 "\374\001") at /root/work/trunk/mysql-server-mysql-8.0.33/storage/innobase/handler/ha_innodb.cc:8974
#1  0x0000000003afb45a in handler::ha_write_row (this=0x7f6404389c70, buf=0x7f64042d6160 "\374\001") at /root/work/trunk/mysql-server-mysql-8.0.33/sql/handler.cc:8002
#2  0x0000000003e70606 in write_record (thd=0x7f6404011280, table=0x7f640437cdf0, info=0x7f640411b758, update=0x7f640411b7d0) at /root/work/trunk/mysql-server-mysql-8.0.33/sql/sql_insert.cc:2181
#3  0x0000000003e712b2 in Query_result_insert::send_data (this=0x7f640411b710, thd=0x7f6404011280, values=...) at /root/work/trunk/mysql-server-mysql-8.0.33/sql/sql_insert.cc:2404
#4  0x00000000037f84bb in Query_expression::ExecuteIteratorQuery (this=0x7f640438ead0, thd=0x7f6404011280) at /root/work/trunk/mysql-server-mysql-8.0.33/sql/sql_union.cc:1813
#5  0x00000000037f8706 in Query_expression::execute (this=0x7f640438ead0, thd=0x7f6404011280) at /root/work/trunk/mysql-server-mysql-8.0.33/sql/sql_union.cc:1852
#6  0x0000000003744eec in Sql_cmd_dml::execute_inner (this=0x7f640411aef8, thd=0x7f6404011280) at /root/work/trunk/mysql-server-mysql-8.0.33/sql/sql_select.cc:799
#7  0x0000000003744392 in Sql_cmd_dml::execute (this=0x7f640411aef8, thd=0x7f6404011280) at /root/work/trunk/mysql-server-mysql-8.0.33/sql/sql_select.cc:578
#8  0x00000000036bd376 in mysql_execute_command (thd=0x7f6404011280, first_level=true) at /root/work/trunk/mysql-server-mysql-8.0.33/sql/sql_parse.cc:3683
#9  0x00000000036c2987 in dispatch_sql_command (thd=0x7f6404011280, parser_state=0x7f64982658b0) at /root/work/trunk/mysql-server-mysql-8.0.33/sql/sql_parse.cc:5363
#10 0x00000000036b86d0 in dispatch_command (thd=0x7f6404011280, com_data=0x7f64982669a0, command=COM_QUERY) at /root/work/trunk/mysql-server-mysql-8.0.33/sql/sql_parse.cc:2050
#11 0x00000000036b6618 in do_command (thd=0x7f6404011280) at /root/work/trunk/mysql-server-mysql-8.0.33/sql/sql_parse.cc:1439
#12 0x000000000393b45a in handle_connection (arg=0xca5aa10) at /root/work/trunk/mysql-server-mysql-8.0.33/sql/conn_handler/connection_handler_per_thread.cc:302
#13 0x0000000005949155 in pfs_spawn_thread (arg=0xccab300) at /root/work/trunk/mysql-server-mysql-8.0.33/storage/perfschema/pfs.cc:3042
#14 0x00007f64c71711ca in start_thread () from /lib64/libpthread.so.0
#15 0x00007f64c5721e73 in clone () from /lib64/libc.so.6