/*insert 写redo之前*/
#0 mtr_t::Command::prepare_write (this=0x7ffe378b3510) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:792
#10x000000000196114e in mtr_t::Command::execute (this=0x7ffe378b3510) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:865
#20x000000000195fd1e in mtr_t::commit (this=0x7ffe378b3580) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:496
#30x0000000001ad8557 in trx_undo_assign_undo (trx=0x7fffd7bfe478, undo_ptr=0x7fffd7bfe7c0, type=1) at /data/mysql-5.7.32/storage/innobase/trx/trx0undo.cc:1838
#40x0000000001ab5862 in trx_undo_report_row_operation (flags=0, op_type=1, thr=0x7ffdfc01b400, index=0x7ffdfc023bf0, clust_entry=0x7ffdfc023060, update=0x0, cmpl_info=0, rec=0x0, offsets=0x0,
roll_ptr=0x7ffe378b4130) at /data/mysql-5.7.32/storage/innobase/trx/trx0rec.cc:1940
#50x0000000001b0b8db in btr_cur_ins_lock_and_undo (flags=0, cursor=0x7ffe378b45a0, entry=0x7ffdfc023060, thr=0x7ffdfc01b400, mtr=0x7ffe378b49d0, inherit=0x7ffe378b41b0) at /data/mysql-5.7.32/s
torage/innobase/btr/btr0cur.cc:2983
#60x0000000001b0c11f in btr_cur_optimistic_insert (flags=0, cursor=0x7ffe378b45a0, offsets=0x7ffe378b4ef0, heap=0x7ffe378b4ef8, entry=0x7ffdfc023060, rec=0x7ffe378b4ee8, big_rec=0x7ffe378b4f00, n_ext=0, thr=0x7ffdfc01b400, mtr=0x7ffe378b49d0) at /data/mysql-5.7.32/storage/innobase/btr/btr0cur.cc:3209
#70x00000000019daa62 in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7ffdfc023bf0, n_uniq=1, entry=0x7ffdfc023060, n_ext=0, thr=0x7ffdfc01b400, dup_chk_only=false) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:2615
#80x00000000019dc963 in row_ins_clust_index_entry (index=0x7ffdfc023bf0, entry=0x7ffdfc023060, thr=0x7ffdfc01b400, n_ext=0, dup_chk_only=false) at /data/mysql-5.7.32/storage/innobase/row/row0i
ns.cc:3301
#90x00000000019dce62 in row_ins_index_entry (index=0x7ffdfc023bf0, entry=0x7ffdfc023060, thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3437
#100x00000000019dd3a2 in row_ins_index_entry_step (node=0x7ffdfc01b160, thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3587
#110x00000000019dd702 in row_ins (node=0x7ffdfc01b160, thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3725
#120x00000000019ddb66 in row_ins_step (thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3861
#130x00000000019fbaf9 in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7ffdfc012038"\376c", prebuilt=0x7ffdfc01ab90) at /data/mysql-5.7.32/storage/innobase/row/row0mysql.cc:1746
#140x00000000019fc067 in row_insert_for_mysql (mysql_rec=0x7ffdfc012038"\376c", prebuilt=0x7ffdfc01ab90) at /data/mysql-5.7.32/storage/innobase/row/row0mysql.cc:1867
#150x00000000018a6238 in ha_innobase::write_row (this=0x7ffdfc011d40, record=0x7ffdfc012038"\376c") at /data/mysql-5.7.32/storage/innobase/handler/ha_innodb.cc:7627
#160x0000000000f18772 in handler::ha_write_row (this=0x7ffdfc011d40, buf=0x7ffdfc012038"\376c") at /data/mysql-5.7.32/sql/handler.cc:8107
#170x000000000173e598 in write_record (thd=0x7ffdfc000b70, table=0x7ffdfc011380, info=0x7ffe378b6070, update=0x7ffe378b60f0) at /data/mysql-5.7.32/sql/sql_insert.cc:1895
#180x000000000173b71e in Sql_cmd_insert::mysql_insert (this=0x7ffdfc006a28, thd=0x7ffdfc000b70, table_list=0x7ffdfc006498) at /data/mysql-5.7.32/sql/sql_insert.cc:776
#190x0000000001742094 in Sql_cmd_insert::execute (this=0x7ffdfc006a28, thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/sql_insert.cc:3142
#200x0000000001518eae in mysql_execute_command (thd=0x7ffdfc000b70, first_level=true) at /data/mysql-5.7.32/sql/sql_parse.cc:3606
#210x000000000151e6b1 in mysql_parse (thd=0x7ffdfc000b70, parser_state=0x7ffe378b7550) at /data/mysql-5.7.32/sql/sql_parse.cc:5584
#220x0000000001513f3b in dispatch_command (thd=0x7ffdfc000b70, com_data=0x7ffe378b7cb0, command=COM_QUERY) at /data/mysql-5.7.32/sql/sql_parse.cc:1491
#230x0000000001512da9 in do_command (thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/sql_parse.cc:1032
#240x00000000016451f8 in handle_connection (arg=0x160325b0) at /data/mysql-5.7.32/sql/conn_handler/connection_handler_per_thread.cc:313
#250x0000000001cd42de in pfs_spawn_thread (arg=0x1600e0a0) at /data/mysql-5.7.32/storage/perfschema/pfs.cc:2197
#260x00007ffff7bc6dd5 in start_thread () from /lib64/libpthread.so.0
#270x00007ffff61b7ead in clone () from /lib64/libc.so.6/*先写undo的redo日志*/
#0 log_reserve_and_write_fast (str=0x7ffe378b3820, len=34, start_lsn=0x7ffe378b3528) at /data/mysql-5.7.32/storage/innobase/include/log0log.ic:405
#10x0000000001960ffd in mtr_t::Command::finish_write (this=0x7ffe378b3510, len=34) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:819
#20x000000000196116c in mtr_t::Command::execute (this=0x7ffe378b3510) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:866
#30x000000000195fd1e in mtr_t::commit (this=0x7ffe378b3580) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:496
#40x0000000001ad8557 in trx_undo_assign_undo (trx=0x7fffd7bfe478, undo_ptr=0x7fffd7bfe7c0, type=1) at /data/mysql-5.7.32/storage/innobase/trx/trx0undo.cc:1838
#50x0000000001ab5862 in trx_undo_report_row_operation (flags=0, op_type=1, thr=0x7ffdfc01b400, index=0x7ffdfc023bf0, clust_entry=0x7ffdfc023060, update=0x0, cmpl_info=0, rec=0x0, offsets=0x0,
roll_ptr=0x7ffe378b4130) at /data/mysql-5.7.32/storage/innobase/trx/trx0rec.cc:1940
#60x0000000001b0b8db in btr_cur_ins_lock_and_undo (flags=0, cursor=0x7ffe378b45a0, entry=0x7ffdfc023060, thr=0x7ffdfc01b400, mtr=0x7ffe378b49d0, inherit=0x7ffe378b41b0) at /data/mysql-5.7.32/s
torage/innobase/btr/btr0cur.cc:2983
#70x0000000001b0c11f in btr_cur_optimistic_insert (flags=0, cursor=0x7ffe378b45a0, offsets=0x7ffe378b4ef0, heap=0x7ffe378b4ef8, entry=0x7ffdfc023060, rec=0x7ffe378b4ee8, big_rec=0x7ffe378b4f00, n_ext=0, thr=0x7ffdfc01b400, mtr=0x7ffe378b49d0) at /data/mysql-5.7.32/storage/innobase/btr/btr0cur.cc:3209
#80x00000000019daa62 in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7ffdfc023bf0, n_uniq=1, entry=0x7ffdfc023060, n_ext=0, thr=0x7ffdfc01b400, dup_chk_only=false) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:2615
#90x00000000019dc963 in row_ins_clust_index_entry (index=0x7ffdfc023bf0, entry=0x7ffdfc023060, thr=0x7ffdfc01b400, n_ext=0, dup_chk_only=false) at /data/mysql-5.7.32/storage/innobase/row/row0i
ns.cc:3301
#100x00000000019dce62 in row_ins_index_entry (index=0x7ffdfc023bf0, entry=0x7ffdfc023060, thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3437
#110x00000000019dd3a2 in row_ins_index_entry_step (node=0x7ffdfc01b160, thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3587
#120x00000000019dd702 in row_ins (node=0x7ffdfc01b160, thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3725
#130x00000000019ddb66 in row_ins_step (thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3861
#140x00000000019fbaf9 in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7ffdfc012038"\376e", prebuilt=0x7ffdfc01ab90) at /data/mysql-5.7.32/storage/innobase/row/row0mysql.cc:1746
#150x00000000019fc067 in row_insert_for_mysql (mysql_rec=0x7ffdfc012038"\376e", prebuilt=0x7ffdfc01ab90) at /data/mysql-5.7.32/storage/innobase/row/row0mysql.cc:1867
#160x00000000018a6238 in ha_innobase::write_row (this=0x7ffdfc011d40, record=0x7ffdfc012038"\376e") at /data/mysql-5.7.32/storage/innobase/handler/ha_innodb.cc:7627
#170x0000000000f18772 in handler::ha_write_row (this=0x7ffdfc011d40, buf=0x7ffdfc012038"\376e") at /data/mysql-5.7.32/sql/handler.cc:8107
#180x000000000173e598 in write_record (thd=0x7ffdfc000b70, table=0x7ffdfc011380, info=0x7ffe378b6070, update=0x7ffe378b60f0) at /data/mysql-5.7.32/sql/sql_insert.cc:1895
#190x000000000173b71e in Sql_cmd_insert::mysql_insert (this=0x7ffdfc006a28, thd=0x7ffdfc000b70, table_list=0x7ffdfc006498) at /data/mysql-5.7.32/sql/sql_insert.cc:776
#200x0000000001742094 in Sql_cmd_insert::execute (this=0x7ffdfc006a28, thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/sql_insert.cc:3142
#210x0000000001518eae in mysql_execute_command (thd=0x7ffdfc000b70, first_level=true) at /data/mysql-5.7.32/sql/sql_parse.cc:3606
#220x000000000151e6b1 in mysql_parse (thd=0x7ffdfc000b70, parser_state=0x7ffe378b7550) at /data/mysql-5.7.32/sql/sql_parse.cc:5584
#230x0000000001513f3b in dispatch_command (thd=0x7ffdfc000b70, com_data=0x7ffe378b7cb0, command=COM_QUERY) at /data/mysql-5.7.32/sql/sql_parse.cc:1491
#240x0000000001512da9 in do_command (thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/sql_parse.cc:1032
#250x00000000016451f8 in handle_connection (arg=0x160325b0) at /data/mysql-5.7.32/sql/conn_handler/connection_handler_per_thread.cc:313
#260x0000000001cd42de in pfs_spawn_thread (arg=0x1600e0a0) at /data/mysql-5.7.32/storage/perfschema/pfs.cc:2197
#270x00007ffff7bc6dd5 in start_thread () from /lib64/libpthread.so.0
#280x00007ffff61b7ead in clone () from /lib64/libc.so.6
#0 mtr_t::Command::execute (this=0x7ffe378b3a80) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:863
#10x000000000195fd1e in mtr_t::commit (this=0x7ffe378b3b20) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:496
#20x0000000001ab5c3e in trx_undo_report_row_operation (flags=0, op_type=1, thr=0x7ffdfc01b400, index=0x7ffdfc023bf0, clust_entry=0x7ffdfc023060, update=0x0, cmpl_info=0, rec=0x0, offsets=0x0,
roll_ptr=0x7ffe378b4130) at /data/mysql-5.7.32/storage/innobase/trx/trx0rec.cc:2037
#30x0000000001b0b8db in btr_cur_ins_lock_and_undo (flags=0, cursor=0x7ffe378b45a0, entry=0x7ffdfc023060, thr=0x7ffdfc01b400, mtr=0x7ffe378b49d0, inherit=0x7ffe378b41b0) at /data/mysql-5.7.32/s
torage/innobase/btr/btr0cur.cc:2983
#40x0000000001b0c11f in btr_cur_optimistic_insert (flags=0, cursor=0x7ffe378b45a0, offsets=0x7ffe378b4ef0, heap=0x7ffe378b4ef8, entry=0x7ffdfc023060, rec=0x7ffe378b4ee8, big_rec=0x7ffe378b4f00, n_ext=0, thr=0x7ffdfc01b400, mtr=0x7ffe378b49d0) at /data/mysql-5.7.32/storage/innobase/btr/btr0cur.cc:3209
#50x00000000019daa62 in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7ffdfc023bf0, n_uniq=1, entry=0x7ffdfc023060, n_ext=0, thr=0x7ffdfc01b400, dup_chk_only=false) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:2615
#60x00000000019dc963 in row_ins_clust_index_entry (index=0x7ffdfc023bf0, entry=0x7ffdfc023060, thr=0x7ffdfc01b400, n_ext=0, dup_chk_only=false) at /data/mysql-5.7.32/storage/innobase/row/row0i
ns.cc:3301
#70x00000000019dce62 in row_ins_index_entry (index=0x7ffdfc023bf0, entry=0x7ffdfc023060, thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3437
#80x00000000019dd3a2 in row_ins_index_entry_step (node=0x7ffdfc01b160, thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3587
#90x00000000019dd702 in row_ins (node=0x7ffdfc01b160, thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3725
#100x00000000019ddb66 in row_ins_step (thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3861
#110x00000000019fbaf9 in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7ffdfc012038"\376e", prebuilt=0x7ffdfc01ab90) at /data/mysql-5.7.32/storage/innobase/row/row0mysql.cc:1746
#120x00000000019fc067 in row_insert_for_mysql (mysql_rec=0x7ffdfc012038"\376e", prebuilt=0x7ffdfc01ab90) at /data/mysql-5.7.32/storage/innobase/row/row0mysql.cc:1867
#130x00000000018a6238 in ha_innobase::write_row (this=0x7ffdfc011d40, record=0x7ffdfc012038"\376e") at /data/mysql-5.7.32/storage/innobase/handler/ha_innodb.cc:7627
#140x0000000000f18772 in handler::ha_write_row (this=0x7ffdfc011d40, buf=0x7ffdfc012038"\376e") at /data/mysql-5.7.32/sql/handler.cc:8107
#150x000000000173e598 in write_record (thd=0x7ffdfc000b70, table=0x7ffdfc011380, info=0x7ffe378b6070, update=0x7ffe378b60f0) at /data/mysql-5.7.32/sql/sql_insert.cc:1895
#160x000000000173b71e in Sql_cmd_insert::mysql_insert (this=0x7ffdfc006a28, thd=0x7ffdfc000b70, table_list=0x7ffdfc006498) at /data/mysql-5.7.32/sql/sql_insert.cc:776
#170x0000000001742094 in Sql_cmd_insert::execute (this=0x7ffdfc006a28, thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/sql_insert.cc:3142
#180x0000000001518eae in mysql_execute_command (thd=0x7ffdfc000b70, first_level=true) at /data/mysql-5.7.32/sql/sql_parse.cc:3606
#190x000000000151e6b1 in mysql_parse (thd=0x7ffdfc000b70, parser_state=0x7ffe378b7550) at /data/mysql-5.7.32/sql/sql_parse.cc:5584
#200x0000000001513f3b in dispatch_command (thd=0x7ffdfc000b70, com_data=0x7ffe378b7cb0, command=COM_QUERY) at /data/mysql-5.7.32/sql/sql_parse.cc:1491
#210x0000000001512da9 in do_command (thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/sql_parse.cc:1032
#220x00000000016451f8 in handle_connection (arg=0x160325b0) at /data/mysql-5.7.32/sql/conn_handler/connection_handler_per_thread.cc:313
#230x0000000001cd42de in pfs_spawn_thread (arg=0x1600e0a0) at /data/mysql-5.7.32/storage/perfschema/pfs.cc:2197
#240x00007ffff7bc6dd5 in start_thread () from /lib64/libpthread.so.0
#250x00007ffff61b7ead in clone () from /lib64/libc.so.6/*再写数据的redo日志*/
#0 log_reserve_and_write_fast (str=0x7ffe378b4c70, len=34, start_lsn=0x7ffe378b44e8) at /data/mysql-5.7.32/storage/innobase/include/log0log.ic:405
#10x0000000001960ffd in mtr_t::Command::finish_write (this=0x7ffe378b44d0, len=34) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:819
#20x000000000196116c in mtr_t::Command::execute (this=0x7ffe378b44d0) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:866
#30x000000000195fd1e in mtr_t::commit (this=0x7ffe378b49d0) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:496
#40x00000000019dac66 in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7ffdfc023bf0, n_uniq=1, entry=0x7ffdfc023060, n_ext=0, thr=0x7ffdfc01b400, dup_chk_only=false) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:2664
#50x00000000019dc963 in row_ins_clust_index_entry (index=0x7ffdfc023bf0, entry=0x7ffdfc023060, thr=0x7ffdfc01b400, n_ext=0, dup_chk_only=false) at /data/mysql-5.7.32/storage/innobase/row/row0i
ns.cc:3301
#60x00000000019dce62 in row_ins_index_entry (index=0x7ffdfc023bf0, entry=0x7ffdfc023060, thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3437
#70x00000000019dd3a2 in row_ins_index_entry_step (node=0x7ffdfc01b160, thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3587
#80x00000000019dd702 in row_ins (node=0x7ffdfc01b160, thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3725
#90x00000000019ddb66 in row_ins_step (thr=0x7ffdfc01b400) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3861
#100x00000000019fbaf9 in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7ffdfc012038"\376e", prebuilt=0x7ffdfc01ab90) at /data/mysql-5.7.32/storage/innobase/row/row0mysql.cc:1746
#110x00000000019fc067 in row_insert_for_mysql (mysql_rec=0x7ffdfc012038"\376e", prebuilt=0x7ffdfc01ab90) at /data/mysql-5.7.32/storage/innobase/row/row0mysql.cc:1867
#120x00000000018a6238 in ha_innobase::write_row (this=0x7ffdfc011d40, record=0x7ffdfc012038"\376e") at /data/mysql-5.7.32/storage/innobase/handler/ha_innodb.cc:7627
#130x0000000000f18772 in handler::ha_write_row (this=0x7ffdfc011d40, buf=0x7ffdfc012038"\376e") at /data/mysql-5.7.32/sql/handler.cc:8107
#140x000000000173e598 in write_record (thd=0x7ffdfc000b70, table=0x7ffdfc011380, info=0x7ffe378b6070, update=0x7ffe378b60f0) at /data/mysql-5.7.32/sql/sql_insert.cc:1895
#150x000000000173b71e in Sql_cmd_insert::mysql_insert (this=0x7ffdfc006a28, thd=0x7ffdfc000b70, table_list=0x7ffdfc006498) at /data/mysql-5.7.32/sql/sql_insert.cc:776
#160x0000000001742094 in Sql_cmd_insert::execute (this=0x7ffdfc006a28, thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/sql_insert.cc:3142
#170x0000000001518eae in mysql_execute_command (thd=0x7ffdfc000b70, first_level=true) at /data/mysql-5.7.32/sql/sql_parse.cc:3606
#180x000000000151e6b1 in mysql_parse (thd=0x7ffdfc000b70, parser_state=0x7ffe378b7550) at /data/mysql-5.7.32/sql/sql_parse.cc:5584
#190x0000000001513f3b in dispatch_command (thd=0x7ffdfc000b70, com_data=0x7ffe378b7cb0, command=COM_QUERY) at /data/mysql-5.7.32/sql/sql_parse.cc:1491
#200x0000000001512da9 in do_command (thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/sql_parse.cc:1032
#210x00000000016451f8 in handle_connection (arg=0x160325b0) at /data/mysql-5.7.32/sql/conn_handler/connection_handler_per_thread.cc:313
#220x0000000001cd42de in pfs_spawn_thread (arg=0x1600e0a0) at /data/mysql-5.7.32/storage/perfschema/pfs.cc:2197
#230x00007ffff7bc6dd5 in start_thread () from /lib64/libpthread.so.0
#240x00007ffff61b7ead in clone () from /lib64/libc.so.6/*commit 写redo日志*/
#0 log_reserve_and_write_fast (str=0x7ffe378b5c80, len=172, start_lsn=0x7ffe378b5988) at /data/mysql-5.7.32/storage/innobase/include/log0log.ic:405
#10x0000000001960ffd in mtr_t::Command::finish_write (this=0x7ffe378b5970, len=172) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:819
#20x000000000196116c in mtr_t::Command::execute (this=0x7ffe378b5970) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:866
#30x000000000195fd1e in mtr_t::commit (this=0x7ffe378b59e0) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:496
#40x0000000001aca270 in trx_prepare_low (trx=0x7fffd7bfe478, undo_ptr=0x7fffd7bfe7c0, noredo_logging=false) at /data/mysql-5.7.32/storage/innobase/trx/trx0trx.cc:2797
#50x0000000001aca398 in trx_prepare (trx=0x7fffd7bfe478) at /data/mysql-5.7.32/storage/innobase/trx/trx0trx.cc:2829
#60x0000000001aca5fd in trx_prepare_for_mysql (trx=0x7fffd7bfe478) at /data/mysql-5.7.32/storage/innobase/trx/trx0trx.cc:2914
#70x00000000018b782f in innobase_xa_prepare (hton=0x2d62fc0, thd=0x7ffdfc000b70, prepare_trx=true) at /data/mysql-5.7.32/storage/innobase/handler/ha_innodb.cc:17156
#80x0000000000f0b077 in ha_prepare_low (thd=0x7ffdfc000b70, all=true) at /data/mysql-5.7.32/sql/handler.cc:2360
#90x00000000017c3886 in MYSQL_BIN_LOG::prepare (this=0x2cc6180<mysql_bin_log>, thd=0x7ffdfc000b70, all=true) at /data/mysql-5.7.32/sql/binlog.cc:8602
#100x0000000000f09e7a in ha_commit_trans (thd=0x7ffdfc000b70, all=true, ignore_global_read_lock=false) at /data/mysql-5.7.32/sql/handler.cc:1792
#110x000000000161721b in trans_commit (thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/transaction.cc:246
#120x000000000151b0de in mysql_execute_command (thd=0x7ffdfc000b70, first_level=true) at /data/mysql-5.7.32/sql/sql_parse.cc:4254
#130x000000000151e6b1 in mysql_parse (thd=0x7ffdfc000b70, parser_state=0x7ffe378b7550) at /data/mysql-5.7.32/sql/sql_parse.cc:5584
#140x0000000001513f3b in dispatch_command (thd=0x7ffdfc000b70, com_data=0x7ffe378b7cb0, command=COM_QUERY) at /data/mysql-5.7.32/sql/sql_parse.cc:1491
#150x0000000001512da9 in do_command (thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/sql_parse.cc:1032
#160x00000000016451f8 in handle_connection (arg=0x160325b0) at /data/mysql-5.7.32/sql/conn_handler/connection_handler_per_thread.cc:313
#170x0000000001cd42de in pfs_spawn_thread (arg=0x1600e0a0) at /data/mysql-5.7.32/storage/perfschema/pfs.cc:2197
#180x00007ffff7bc6dd5 in start_thread () from /lib64/libpthread.so.0
#190x00007ffff61b7ead in clone () from /lib64/libc.so.6(gdb)
#0 mtr_t::Command::finish_write (this=0x7ffe378b4920, len=15) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:827
#10x000000000196116c in mtr_t::Command::execute (this=0x7ffe378b4920) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:866
#20x000000000195fd1e in mtr_t::commit (this=0x7ffe378b49c0) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:496
#30x0000000001ac8d7c in trx_commit_low (trx=0x7fffd7bfe478, mtr=0x7ffe378b49c0) at /data/mysql-5.7.32/storage/innobase/trx/trx0trx.cc:2163
#40x0000000001ac8ee3 in trx_commit (trx=0x7fffd7bfe478) at /data/mysql-5.7.32/storage/innobase/trx/trx0trx.cc:2213
#50x0000000001ac95e7 in trx_commit_for_mysql (trx=0x7fffd7bfe478) at /data/mysql-5.7.32/storage/innobase/trx/trx0trx.cc:2432
#60x000000000189f315 in innobase_commit_low (trx=0x7fffd7bfe478) at /data/mysql-5.7.32/storage/innobase/handler/ha_innodb.cc:4274
#70x000000000189f800 in innobase_commit (hton=0x2d62fc0, thd=0x7ffdfc000b70, commit_trx=true) at /data/mysql-5.7.32/storage/innobase/handler/ha_innodb.cc:4436
#80x0000000000f0a271 in ha_commit_low (thd=0x7ffdfc000b70, all=true, run_after_commit=false) at /data/mysql-5.7.32/sql/handler.cc:1911
#90x00000000017c4ced in MYSQL_BIN_LOG::process_commit_stage_queue (this=0x2cc6180<mysql_bin_log>, thd=0x7ffdfc000b70, first=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/binlog.cc:9058
#100x00000000017c65b6 in MYSQL_BIN_LOG::ordered_commit (this=0x2cc6180<mysql_bin_log>, thd=0x7ffdfc000b70, all=true, skip_commit=false) at /data/mysql-5.7.32/sql/binlog.cc:9760
#110x00000000017c4632 in MYSQL_BIN_LOG::commit (this=0x2cc6180<mysql_bin_log>, thd=0x7ffdfc000b70, all=true) at /data/mysql-5.7.32/sql/binlog.cc:8870
#120x0000000000f09f50 in ha_commit_trans (thd=0x7ffdfc000b70, all=true, ignore_global_read_lock=false) at /data/mysql-5.7.32/sql/handler.cc:1807
#130x000000000161721b in trans_commit (thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/transaction.cc:246
#140x000000000151b0de in mysql_execute_command (thd=0x7ffdfc000b70, first_level=true) at /data/mysql-5.7.32/sql/sql_parse.cc:4254
#150x000000000151e6b1 in mysql_parse (thd=0x7ffdfc000b70, parser_state=0x7ffe378b7550) at /data/mysql-5.7.32/sql/sql_parse.cc:5584
#160x0000000001513f3b in dispatch_command (thd=0x7ffdfc000b70, com_data=0x7ffe378b7cb0, command=COM_QUERY) at /data/mysql-5.7.32/sql/sql_parse.cc:1491
#170x0000000001512da9 in do_command (thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/sql_parse.cc:1032
#180x00000000016451f8 in handle_connection (arg=0x160325b0) at /data/mysql-5.7.32/sql/conn_handler/connection_handler_per_thread.cc:313
#190x0000000001cd42de in pfs_spawn_thread (arg=0x1600e0a0) at /data/mysql-5.7.32/storage/perfschema/pfs.cc:2197
#200x00007ffff7bc6dd5 in start_thread () from /lib64/libpthread.so.0
#210x00007ffff61b7ead in clone () from /lib64/libc.so.6
#0 log_write_low (str=0x7ffe378b4c62"\201\033", str_len=13) at /data/mysql-5.7.32/storage/innobase/log/log0log.cc:461
#10x0000000001961df1 in mtr_write_log_t::operator()(this=0x7ffe378b48b7, block=0x7ffe378b4c50) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:393
#20x0000000001961e9f in dyn_buf_t<512ul>::for_each_block<mtr_write_log_t>(this=0x7ffe378b4c18, functor=...) at /data/mysql-5.7.32/storage/innobase/include/dyn0buf.h:357
#30x0000000001961046 in mtr_t::Command::finish_write (this=0x7ffe378b4920, len=15) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:830
#40x000000000196116c in mtr_t::Command::execute (this=0x7ffe378b4920) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:866
#50x000000000195fd1e in mtr_t::commit (this=0x7ffe378b49c0) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:496
#60x0000000001ac8d7c in trx_commit_low (trx=0x7fffd7bfe478, mtr=0x7ffe378b49c0) at /data/mysql-5.7.32/storage/innobase/trx/trx0trx.cc:2163
#70x0000000001ac8ee3 in trx_commit (trx=0x7fffd7bfe478) at /data/mysql-5.7.32/storage/innobase/trx/trx0trx.cc:2213
#80x0000000001ac95e7 in trx_commit_for_mysql (trx=0x7fffd7bfe478) at /data/mysql-5.7.32/storage/innobase/trx/trx0trx.cc:2432
#90x000000000189f315 in innobase_commit_low (trx=0x7fffd7bfe478) at /data/mysql-5.7.32/storage/innobase/handler/ha_innodb.cc:4274
#100x000000000189f800 in innobase_commit (hton=0x2d62fc0, thd=0x7ffdfc000b70, commit_trx=true) at /data/mysql-5.7.32/storage/innobase/handler/ha_innodb.cc:4436
#110x0000000000f0a271 in ha_commit_low (thd=0x7ffdfc000b70, all=true, run_after_commit=false) at /data/mysql-5.7.32/sql/handler.cc:1911
#120x00000000017c4ced in MYSQL_BIN_LOG::process_commit_stage_queue (this=0x2cc6180<mysql_bin_log>, thd=0x7ffdfc000b70, first=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/binlog.cc:9058
#130x00000000017c65b6 in MYSQL_BIN_LOG::ordered_commit (this=0x2cc6180<mysql_bin_log>, thd=0x7ffdfc000b70, all=true, skip_commit=false) at /data/mysql-5.7.32/sql/binlog.cc:9760
#140x00000000017c4632 in MYSQL_BIN_LOG::commit (this=0x2cc6180<mysql_bin_log>, thd=0x7ffdfc000b70, all=true) at /data/mysql-5.7.32/sql/binlog.cc:8870
#150x0000000000f09f50 in ha_commit_trans (thd=0x7ffdfc000b70, all=true, ignore_global_read_lock=false) at /data/mysql-5.7.32/sql/handler.cc:1807
#160x000000000161721b in trans_commit (thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/transaction.cc:246
#170x000000000151b0de in mysql_execute_command (thd=0x7ffdfc000b70, first_level=true) at /data/mysql-5.7.32/sql/sql_parse.cc:4254
#180x000000000151e6b1 in mysql_parse (thd=0x7ffdfc000b70, parser_state=0x7ffe378b7550) at /data/mysql-5.7.32/sql/sql_parse.cc:5584
#190x0000000001513f3b in dispatch_command (thd=0x7ffdfc000b70, com_data=0x7ffe378b7cb0, command=COM_QUERY) at /data/mysql-5.7.32/sql/sql_parse.cc:1491
#200x0000000001512da9 in do_command (thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/sql_parse.cc:1032
#210x00000000016451f8 in handle_connection (arg=0x160325b0) at /data/mysql-5.7.32/sql/conn_handler/connection_handler_per_thread.cc:313
#220x0000000001cd42de in pfs_spawn_thread (arg=0x1600e0a0) at /data/mysql-5.7.32/storage/perfschema/pfs.cc:2197
#230x00007ffff7bc6dd5 in start_thread () from /lib64/libpthread.so.0
#240x00007ffff61b7ead in clone () from /lib64/libc.so.6
/*赃页的添加*/
#0 ReleaseBlocks::add_dirty_page_to_flush_list (this=0x7ffe378b34a0, slot=0x7ffe378b35c8) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:264
#10x0000000001961cd1 in ReleaseBlocks::operator()(this=0x7ffe378b34a0, slot=0x7ffe378b35c8) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:283
#20x00000000019624e0 in Iterate<ReleaseBlocks>::operator()(this=0x7ffe378b3490, block=0x7ffe378b35b8) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:77
#30x0000000001962105 in dyn_buf_t<512ul>::for_each_block_in_reverse<Iterate<ReleaseBlocks>>(this=0x7ffe378b3580, functor=...) at /data/mysql-5.7.32/storage/innobase/include/dyn0buf.h:375
#40x00000000019610ff in mtr_t::Command::release_blocks (this=0x7ffe378b3510) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:855
#50x00000000019611fc in mtr_t::Command::execute (this=0x7ffe378b3510) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:880
#60x000000000195fd1e in mtr_t::commit (this=0x7ffe378b3580) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:496
#70x0000000001ad8557 in trx_undo_assign_undo (trx=0x7fffd7bfed08, undo_ptr=0x7fffd7bff050, type=1) at /data/mysql-5.7.32/storage/innobase/trx/trx0undo.cc:1838
#80x0000000001ab5862 in trx_undo_report_row_operation (flags=0, op_type=1, thr=0x7ffdfc01b750, index=0x7ffdfc011830, clust_entry=0x7ffdfc0110e0, update=0x0, cmpl_info=0, rec=0x0, offsets=0x0,
roll_ptr=0x7ffe378b4130) at /data/mysql-5.7.32/storage/innobase/trx/trx0rec.cc:1940
#90x0000000001b0b8db in btr_cur_ins_lock_and_undo (flags=0, cursor=0x7ffe378b45a0, entry=0x7ffdfc0110e0, thr=0x7ffdfc01b750, mtr=0x7ffe378b49d0, inherit=0x7ffe378b41b0) at /data/mysql-5.7.32/s
torage/innobase/btr/btr0cur.cc:2983
#100x0000000001b0c11f in btr_cur_optimistic_insert (flags=0, cursor=0x7ffe378b45a0, offsets=0x7ffe378b4ef0, heap=0x7ffe378b4ef8, entry=0x7ffdfc0110e0, rec=0x7ffe378b4ee8, big_rec=0x7ffe378b4f00, n_ext=0, thr=0x7ffdfc01b750, mtr=0x7ffe378b49d0) at /data/mysql-5.7.32/storage/innobase/btr/btr0cur.cc:3209
#110x00000000019daa62 in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7ffdfc011830, n_uniq=1, entry=0x7ffdfc0110e0, n_ext=0, thr=0x7ffdfc01b750, dup_chk_only=false) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:2615
#120x00000000019dc963 in row_ins_clust_index_entry (index=0x7ffdfc011830, entry=0x7ffdfc0110e0, thr=0x7ffdfc01b750, n_ext=0, dup_chk_only=false) at /data/mysql-5.7.32/storage/innobase/row/row0i
ns.cc:3301
#130x00000000019dce62 in row_ins_index_entry (index=0x7ffdfc011830, entry=0x7ffdfc0110e0, thr=0x7ffdfc01b750) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3437
#140x00000000019dd3a2 in row_ins_index_entry_step (node=0x7ffdfc01b4b0, thr=0x7ffdfc01b750) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3587
#150x00000000019dd702 in row_ins (node=0x7ffdfc01b4b0, thr=0x7ffdfc01b750) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3725
#160x00000000019ddb66 in row_ins_step (thr=0x7ffdfc01b750) at /data/mysql-5.7.32/storage/innobase/row/row0ins.cc:3861
#170x00000000019fbaf9 in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7ffdfc00f638"\376f", prebuilt=0x7ffdfc01a880) at /data/mysql-5.7.32/storage/innobase/row/row0mysql.cc:1746
#180x00000000019fc067 in row_insert_for_mysql (mysql_rec=0x7ffdfc00f638"\376f", prebuilt=0x7ffdfc01a880) at /data/mysql-5.7.32/storage/innobase/row/row0mysql.cc:1867
#190x00000000018a6238 in ha_innobase::write_row (this=0x7ffdfc00f340, record=0x7ffdfc00f638"\376f") at /data/mysql-5.7.32/storage/innobase/handler/ha_innodb.cc:7627
#200x0000000000f18772 in handler::ha_write_row (this=0x7ffdfc00f340, buf=0x7ffdfc00f638"\376f") at /data/mysql-5.7.32/sql/handler.cc:8107
#210x000000000173e598 in write_record (thd=0x7ffdfc000b70, table=0x7ffdfc00e980, info=0x7ffe378b6070, update=0x7ffe378b60f0) at /data/mysql-5.7.32/sql/sql_insert.cc:1895
#220x000000000173b71e in Sql_cmd_insert::mysql_insert (this=0x7ffdfc006a28, thd=0x7ffdfc000b70, table_list=0x7ffdfc006498) at /data/mysql-5.7.32/sql/sql_insert.cc:776
#230x0000000001742094 in Sql_cmd_insert::execute (this=0x7ffdfc006a28, thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/sql_insert.cc:3142
#240x0000000001518eae in mysql_execute_command (thd=0x7ffdfc000b70, first_level=true) at /data/mysql-5.7.32/sql/sql_parse.cc:3606
#250x000000000151e6b1 in mysql_parse (thd=0x7ffdfc000b70, parser_state=0x7ffe378b7550) at /data/mysql-5.7.32/sql/sql_parse.cc:5584
#260x0000000001513f3b in dispatch_command (thd=0x7ffdfc000b70, com_data=0x7ffe378b7cb0, command=COM_QUERY) at /data/mysql-5.7.32/sql/sql_parse.cc:1491
#270x0000000001512da9 in do_command (thd=0x7ffdfc000b70) at /data/mysql-5.7.32/sql/sql_parse.cc:1032
#280x00000000016451f8 in handle_connection (arg=0x15fafc90) at /data/mysql-5.7.32/sql/conn_handler/connection_handler_per_thread.cc:313
#290x0000000001cd42de in pfs_spawn_thread (arg=0x15ff4af0) at /data/mysql-5.7.32/storage/perfschema/pfs.cc:2197
#300x00007ffff7bc6dd5 in start_thread () from /lib64/libpthread.so.0
#310x00007ffff61b7ead in clone () from /lib64/libc.so.6
/*insert 写redo之前*/#0 mtr_t::Command::prepare_write (this=0x7ffe378b3510) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.cc:792#1 0x000000000196114e in mtr_t::Command::execute (this=0x7ffe378b3510) at /data/mysql-5.7.32/storage/innobase/mtr/mtr0mtr.