0.2 parts I and II: VTQ update

[midenok]

DROP TABLE t1;CREATE TABLE t1(x INT UNSIGNED, y INT UNSIGNED, Sys_start TIMESTAMP(6) GENERATED ALWAYS AS ROW START, Sys_end TIMESTAMP(6) GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME (Sys_start, Sys_end)) WITH SYSTEM VERSIONING ENGINE InnoDB;

Single-statement transaction

INSERT INTO t1(x, y) VALUES(8001, 9001);

#0  mtr_commit (mtr=0x7fa9d9bc4530) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/mtr/mtr0mtr.cc:315
#1  0x0000000000c526a4 in trx_commit_low (trx=0x7fa9b0101678, mtr=0x7fa9d9bc4530) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1645
#2  0x0000000000c5275d in trx_commit (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1673
#3  0x0000000000c5312a in trx_commit_for_mysql (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1937
#4  0x0000000000aac1d4 in innobase_commit_low (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4342
#5  0x0000000000aac4d2 in innobase_commit_ordered_2 (trx=0x7fa9b0101678, thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4486
#6  0x0000000000aac8dc in innobase_commit (hton=0x7fa9d6c5a870, thd=0x7fa9b0016070, commit_trx=0x0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4623
#7  0x00000000008e7097 in commit_one_phase_2 (thd=0x7fa9b0016070, all=0x0, trans=0x7fa9b00191d0, is_real_trans=0x1) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1552
#8  0x00000000008e6f93 in ha_commit_one_phase (thd=0x7fa9b0016070, all=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1533
#9  0x00000000008e686d in ha_commit_trans (thd=0x7fa9b0016070, all=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1400
#10 0x00000000007e24e8 in trans_commit_stmt (thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/sql/transaction.cc:434
#11 0x000000000069ad86 in mysql_execute_command (thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:6135
#12 0x000000000069f205 in mysql_parse (thd=0x7fa9b0016070, rawbuf=0x7fa9b005e088 "INSERT INTO t1(x, y) VALUES(8001, 9001)", length=0x27, parser_state=0x7fa9d9bc5f70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:7789

Multi-statement transaction

start transaction; INSERT INTO t1(x, y) VALUES(8001, 9001); commit;

#0  mtr_commit (mtr=0x7fa9d9bc4530) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/mtr/mtr0mtr.cc:315
#1  0x0000000000c526a4 in trx_commit_low (trx=0x7fa9b0101678, mtr=0x7fa9d9bc4530) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1645
#2  0x0000000000c5275d in trx_commit (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1673
#3  0x0000000000c5312a in trx_commit_for_mysql (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1937
#4  0x0000000000aac1d4 in innobase_commit_low (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4342
#5  0x0000000000aac4d2 in innobase_commit_ordered_2 (trx=0x7fa9b0101678, thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4486
#6  0x0000000000aac8dc in innobase_commit (hton=0x7fa9d6c5a870, thd=0x7fa9b0016070, commit_trx=0x1) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4623
#7  0x00000000008e7097 in commit_one_phase_2 (thd=0x7fa9b0016070, all=0x1, trans=0x7fa9b00191b8, is_real_trans=0x1) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1552
#8  0x00000000008e6f93 in ha_commit_one_phase (thd=0x7fa9b0016070, all=0x1) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1533
#9  0x00000000008e686d in ha_commit_trans (thd=0x7fa9b0016070, all=0x1) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1400
#10 0x00000000007e1c50 in trans_commit (thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/sql/transaction.cc:236
#11 0x000000000069811e in mysql_execute_command (thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:5412
#12 0x000000000069f205 in mysql_parse (thd=0x7fa9b0016070, rawbuf=0x7fa9b005e088 "commit", length=0x6, parser_state=0x7fa9d9bc5f70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:7789

Two-phase transaction

xa start 'xyz'; INSERT INTO t1(x, y) VALUES(8001, 9001); xa end 'xyz'; xa prepare 'xyz'; xa commit 'xyz';

#0  mtr_commit (mtr=0x7fa9d9bc45c0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/mtr/mtr0mtr.cc:315
#1  0x0000000000c526a4 in trx_commit_low (trx=0x7fa9b0101678, mtr=0x7fa9d9bc45c0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1645
#2  0x0000000000c5275d in trx_commit (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1673
#3  0x0000000000c5312a in trx_commit_for_mysql (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1937
#4  0x0000000000aac1d4 in innobase_commit_low (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4342
#5  0x0000000000aac4d2 in innobase_commit_ordered_2 (trx=0x7fa9b0101678, thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4486
#6  0x0000000000aac8dc in innobase_commit (hton=0x7fa9d6c5a870, thd=0x7fa9b0016070, commit_trx=0x1) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4623
#7  0x00000000008e7097 in commit_one_phase_2 (thd=0x7fa9b0016070, all=0x1, trans=0x7fa9b00191b8, is_real_trans=0x1) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1552
#8  0x00000000008e6f93 in ha_commit_one_phase (thd=0x7fa9b0016070, all=0x1) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1533
#9  0x00000000007e38a4 in trans_xa_commit (thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/sql/transaction.cc:895
#10 0x0000000000699f20 in mysql_execute_command (thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:5951
#11 0x000000000069f205 in mysql_parse (thd=0x7fa9b0016070, rawbuf=0x7fa9b005e088 "xa commit 'xyz'", length=0xf, parser_state=0x7fa9d9bc5f70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:7789

[midenok]

INSERT INTO t1(x, y) VALUES(8001, 9001);

#0  mlog_write_initial_log_record (ptr=0x7f46fc380000 "`\240\256|", type=0x18, mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/mtr/mtr0log.cc:78
#1  0x0000000000c57d77 in trx_undo_insert_header_reuse_log (undo_page=0x7f46fc380000 "`\240\256|", trx_id=0xbc08, mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtra
db/trx/trx0undo.cc:698
#2  0x0000000000c58006 in trx_undo_insert_header_reuse (undo_page=0x7f46fc380000 "`\240\256|", trx_id=0xbc08, mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/t
rx/trx0undo.cc:801
#3  0x0000000000c5a16d in trx_undo_reuse_cached (trx=0x7f46e2901678, rseg=0x7f470986d478, type=0x1, trx_id=0xbc08, xid=0x7f46e2901810, mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/ha
grid/src/storage/xtradb/trx/trx0undo.cc:1684
#4  0x0000000000c5a4c7 in trx_undo_assign_undo (trx=0x7f46e2901678, type=0x1) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:1784
#5  0x0000000000c403fb in trx_undo_report_row_operation (flags=0x0, op_type=0x1, thr=0x7f46e2917838, index=0x7f46e28f8f78, clust_entry=0x7f46e28e8ff8, update=0x0, cmpl_info=0x0, rec=0x0,
 offsets=0x0, roll_ptr=0x7f470c623d70) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0rec.cc:1262
#6  0x0000000000c87ae9 in btr_cur_ins_lock_and_undo (flags=0x0, cursor=0x7f470c623f50, entry=0x7f46e28e8ff8, thr=0x7f46e2917838, mtr=0x7f470c623fd0, inherit=0x7f470c623e08) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/btr/btr0cur.cc:1331
#7  0x0000000000c88216 in btr_cur_optimistic_insert (flags=0x0, cursor=0x7f470c623f50, offsets=0x7f470c623f08, heap=0x7f470c623f18, entry=0x7f46e28e8ff8, rec=0x7f470c623f20, big_rec=0x7f470c623f10, n_ext=0x0, thr=0x7f46e2917838, mtr=0x7f470c623fd0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/btr/btr0cur.cc:1555
#8  0x0000000000bad884 in row_ins_clust_index_entry_low (flags=0x0, mode=0x2, index=0x7f46e28f8f78, n_uniq=0x0, entry=0x7f46e28e8ff8, n_ext=0x0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:2558
#9  0x0000000000baea1c in row_ins_clust_index_entry (index=0x7f46e28f8f78, entry=0x7f46e28e8ff8, thr=0x7f46e2917838, n_ext=0x0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3001
#10 0x0000000000baed2c in row_ins_index_entry (index=0x7f46e28f8f78, entry=0x7f46e28e8ff8, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3099
#11 0x0000000000baeff0 in row_ins_index_entry_step (node=0x7f46e29175c0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3176
#12 0x0000000000baf312 in row_ins (node=0x7f46e29175c0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3316
#13 0x0000000000baf66c in row_ins_step (thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3441
#14 0x0000000000bc8416 in row_insert_for_mysql (mysql_rec=0x7f46e281e988 "\371A\037", prebuilt=0x7f46e2917078) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0mysql.cc:1375
#15 0x0000000000ab3b2b in ha_innobase::write_row (this=0x7f46e28a8088, record=0x7f46e281e988 "\371A\037") at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:8502
#16 0x00000000008f23bb in handler::ha_write_row (this=0x7f46e28a8088, buf=0x7f46e281e988 "\371A\037") at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:5891
#17 0x00000000006704fc in write_record (thd=0x7f46e2816070, table=0x7f46e28c8870, info=0x7f470c624e20) at /home/midenok/src/mariadb/hagrid/src/sql/sql_insert.cc:1949
#18 0x000000000066dbb9 in mysql_insert (thd=0x7f46e2816070, table_list=0x7f46e285e180, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_insert.cc:998
#19 0x0000000000693bab in mysql_execute_command (thd=0x7f46e2816070) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:4289
#20 0x000000000069f205 in mysql_parse (thd=0x7f46e2816070, rawbuf=0x7f46e285e088 "INSERT INTO t1(x, y) VALUES(8001, 9001)", length=0x27, parser_state=0x7f470c625f70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:7789

#0  mlog_catenate_ull_compressed (mtr=0x7f470c6232a0, val=0xbc08) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/include/mtr0log.ic:157
#1  0x0000000000c57d8a in trx_undo_insert_header_reuse_log (undo_page=0x7f46fc380000 "`\240\256|", trx_id=0xbc08, mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:700
#2  0x0000000000c58006 in trx_undo_insert_header_reuse (undo_page=0x7f46fc380000 "`\240\256|", trx_id=0xbc08, mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:801
#3  0x0000000000c5a16d in trx_undo_reuse_cached (trx=0x7f46e2901678, rseg=0x7f470986d478, type=0x1, trx_id=0xbc08, xid=0x7f46e2901810, mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:1684
#4  0x0000000000c5a4c7 in trx_undo_assign_undo (trx=0x7f46e2901678, type=0x1) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:1784
#5  0x0000000000c403fb in trx_undo_report_row_operation (flags=0x0, op_type=0x1, thr=0x7f46e2917838, index=0x7f46e28f8f78, clust_entry=0x7f46e28e8ff8, update=0x0, cmpl_info=0x0, rec=0x0, offsets=0x0, roll_ptr=0x7f470c623d70) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0rec.cc:1262
#6  0x0000000000c87ae9 in btr_cur_ins_lock_and_undo (flags=0x0, cursor=0x7f470c623f50, entry=0x7f46e28e8ff8, thr=0x7f46e2917838, mtr=0x7f470c623fd0, inherit=0x7f470c623e08) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/btr/btr0cur.cc:1331
#7  0x0000000000c88216 in btr_cur_optimistic_insert (flags=0x0, cursor=0x7f470c623f50, offsets=0x7f470c623f08, heap=0x7f470c623f18, entry=0x7f46e28e8ff8, rec=0x7f470c623f20, big_rec=0x7f470c623f10, n_ext=0x0, thr=0x7f46e2917838, mtr=0x7f470c623fd0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/btr/btr0cur.cc:1555
#8  0x0000000000bad884 in row_ins_clust_index_entry_low (flags=0x0, mode=0x2, index=0x7f46e28f8f78, n_uniq=0x0, entry=0x7f46e28e8ff8, n_ext=0x0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:2558
#9  0x0000000000baea1c in row_ins_clust_index_entry (index=0x7f46e28f8f78, entry=0x7f46e28e8ff8, thr=0x7f46e2917838, n_ext=0x0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3001
#10 0x0000000000baed2c in row_ins_index_entry (index=0x7f46e28f8f78, entry=0x7f46e28e8ff8, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3099
#11 0x0000000000baeff0 in row_ins_index_entry_step (node=0x7f46e29175c0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3176
#12 0x0000000000baf312 in row_ins (node=0x7f46e29175c0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3316
#13 0x0000000000baf66c in row_ins_step (thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3441
#14 0x0000000000bc8416 in row_insert_for_mysql (mysql_rec=0x7f46e281e988 "\371A\037", prebuilt=0x7f46e2917078) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0mysql.cc:1375
#15 0x0000000000ab3b2b in ha_innobase::write_row (this=0x7f46e28a8088, record=0x7f46e281e988 "\371A\037") at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:8502
#16 0x00000000008f23bb in handler::ha_write_row (this=0x7f46e28a8088, buf=0x7f46e281e988 "\371A\037") at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:5891
#17 0x00000000006704fc in write_record (thd=0x7f46e2816070, table=0x7f46e28c8870, info=0x7f470c624e20) at /home/midenok/src/mariadb/hagrid/src/sql/sql_insert.cc:1949
#18 0x000000000066dbb9 in mysql_insert (thd=0x7f46e2816070, table_list=0x7f46e285e180, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_insert.cc:998
#19 0x0000000000693bab in mysql_execute_command (thd=0x7f46e2816070) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:4289
#20 0x000000000069f205 in mysql_parse (thd=0x7f46e2816070, rawbuf=0x7f46e285e088 "INSERT INTO t1(x, y) VALUES(8001, 9001)", length=0x27, parser_state=0x7f470c625f70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:7789

#0  mlog_write_ulint (ptr=0x7f46fc380028 "", val=0x110, type=0x2, mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/mtr/mtr0log.cc:265
#1  0x0000000000c57d0b in trx_undo_header_add_space_for_xid (undo_page=0x7f46fc380000 "`\240\256|", log_hdr=0x7f46fc380056 "", mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:679
#2  0x0000000000c5a1a4 in trx_undo_reuse_cached (trx=0x7f46e2901678, rseg=0x7f470986d478, type=0x1, trx_id=0xbc08, xid=0x7f46e2901810, mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:1688
#3  0x0000000000c5a4c7 in trx_undo_assign_undo (trx=0x7f46e2901678, type=0x1) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:1784
#4  0x0000000000c403fb in trx_undo_report_row_operation (flags=0x0, op_type=0x1, thr=0x7f46e2917838, index=0x7f46e28f8f78, clust_entry=0x7f46e28e8ff8, update=0x0, cmpl_info=0x0, rec=0x0, offsets=0x0, roll_ptr=0x7f470c623d70) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0rec.cc:1262
#5  0x0000000000c87ae9 in btr_cur_ins_lock_and_undo (flags=0x0, cursor=0x7f470c623f50, entry=0x7f46e28e8ff8, thr=0x7f46e2917838, mtr=0x7f470c623fd0, inherit=0x7f470c623e08) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/btr/btr0cur.cc:1331
#6  0x0000000000c88216 in btr_cur_optimistic_insert (flags=0x0, cursor=0x7f470c623f50, offsets=0x7f470c623f08, heap=0x7f470c623f18, entry=0x7f46e28e8ff8, rec=0x7f470c623f20, big_rec=0x7f470c623f10, n_ext=0x0, thr=0x7f46e2917838, mtr=0x7f470c623fd0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/btr/btr0cur.cc:1555
#7  0x0000000000bad884 in row_ins_clust_index_entry_low (flags=0x0, mode=0x2, index=0x7f46e28f8f78, n_uniq=0x0, entry=0x7f46e28e8ff8, n_ext=0x0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:2558
#8  0x0000000000baea1c in row_ins_clust_index_entry (index=0x7f46e28f8f78, entry=0x7f46e28e8ff8, thr=0x7f46e2917838, n_ext=0x0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3001
#9  0x0000000000baed2c in row_ins_index_entry (index=0x7f46e28f8f78, entry=0x7f46e28e8ff8, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3099
#10 0x0000000000baeff0 in row_ins_index_entry_step (node=0x7f46e29175c0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3176
#11 0x0000000000baf312 in row_ins (node=0x7f46e29175c0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3316
#12 0x0000000000baf66c in row_ins_step (thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3441
#13 0x0000000000bc8416 in row_insert_for_mysql (mysql_rec=0x7f46e281e988 "\371A\037", prebuilt=0x7f46e2917078) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0mysql.cc:1375
#14 0x0000000000ab3b2b in ha_innobase::write_row (this=0x7f46e28a8088, record=0x7f46e281e988 "\371A\037") at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:8502
#15 0x00000000008f23bb in handler::ha_write_row (this=0x7f46e28a8088, buf=0x7f46e281e988 "\371A\037") at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:5891
#16 0x00000000006704fc in write_record (thd=0x7f46e2816070, table=0x7f46e28c8870, info=0x7f470c624e20) at /home/midenok/src/mariadb/hagrid/src/sql/sql_insert.cc:1949
#17 0x000000000066dbb9 in mysql_insert (thd=0x7f46e2816070, table_list=0x7f46e285e180, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_insert.cc:998
#18 0x0000000000693bab in mysql_execute_command (thd=0x7f46e2816070) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:4289
#19 0x000000000069f205 in mysql_parse (thd=0x7f46e2816070, rawbuf=0x7f46e285e088 "INSERT INTO t1(x, y) VALUES(8001, 9001)", length=0x27, parser_state=0x7f470c625f70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:7789

#0  mlog_write_ulint (ptr=0x7f46fc38002a "", val=0x110, type=0x2, mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/mtr/mtr0log.cc:265
#1  0x0000000000c57d2b in trx_undo_header_add_space_for_xid (undo_page=0x7f46fc380000 "`\240\256|", log_hdr=0x7f46fc380056 "", mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:682
#2  0x0000000000c5a1a4 in trx_undo_reuse_cached (trx=0x7f46e2901678, rseg=0x7f470986d478, type=0x1, trx_id=0xbc08, xid=0x7f46e2901810, mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:1688
#3  0x0000000000c5a4c7 in trx_undo_assign_undo (trx=0x7f46e2901678, type=0x1) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:1784
#4  0x0000000000c403fb in trx_undo_report_row_operation (flags=0x0, op_type=0x1, thr=0x7f46e2917838, index=0x7f46e28f8f78, clust_entry=0x7f46e28e8ff8, update=0x0, cmpl_info=0x0, rec=0x0, offsets=0x0, roll_ptr=0x7f470c623d70) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0rec.cc:1262
#5  0x0000000000c87ae9 in btr_cur_ins_lock_and_undo (flags=0x0, cursor=0x7f470c623f50, entry=0x7f46e28e8ff8, thr=0x7f46e2917838, mtr=0x7f470c623fd0, inherit=0x7f470c623e08) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/btr/btr0cur.cc:1331
#6  0x0000000000c88216 in btr_cur_optimistic_insert (flags=0x0, cursor=0x7f470c623f50, offsets=0x7f470c623f08, heap=0x7f470c623f18, entry=0x7f46e28e8ff8, rec=0x7f470c623f20, big_rec=0x7f470c623f10, n_ext=0x0, thr=0x7f46e2917838, mtr=0x7f470c623fd0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/btr/btr0cur.cc:1555
#7  0x0000000000bad884 in row_ins_clust_index_entry_low (flags=0x0, mode=0x2, index=0x7f46e28f8f78, n_uniq=0x0, entry=0x7f46e28e8ff8, n_ext=0x0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:2558
#8  0x0000000000baea1c in row_ins_clust_index_entry (index=0x7f46e28f8f78, entry=0x7f46e28e8ff8, thr=0x7f46e2917838, n_ext=0x0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3001
#9  0x0000000000baed2c in row_ins_index_entry (index=0x7f46e28f8f78, entry=0x7f46e28e8ff8, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3099
#10 0x0000000000baeff0 in row_ins_index_entry_step (node=0x7f46e29175c0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3176
#11 0x0000000000baf312 in row_ins (node=0x7f46e29175c0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3316
#12 0x0000000000baf66c in row_ins_step (thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3441
#13 0x0000000000bc8416 in row_insert_for_mysql (mysql_rec=0x7f46e281e988 "\371A\037", prebuilt=0x7f46e2917078) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0mysql.cc:1375
#14 0x0000000000ab3b2b in ha_innobase::write_row (this=0x7f46e28a8088, record=0x7f46e281e988 "\371A\037") at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:8502
#15 0x00000000008f23bb in handler::ha_write_row (this=0x7f46e28a8088, buf=0x7f46e281e988 "\371A\037") at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:5891
#16 0x00000000006704fc in write_record (thd=0x7f46e2816070, table=0x7f46e28c8870, info=0x7f470c624e20) at /home/midenok/src/mariadb/hagrid/src/sql/sql_insert.cc:1949
#17 0x000000000066dbb9 in mysql_insert (thd=0x7f46e2816070, table_list=0x7f46e285e180, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_insert.cc:998
#18 0x0000000000693bab in mysql_execute_command (thd=0x7f46e2816070) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:4289
#19 0x000000000069f205 in mysql_parse (thd=0x7f46e2816070, rawbuf=0x7f46e285e088 "INSERT INTO t1(x, y) VALUES(8001, 9001)", length=0x27, parser_state=0x7f470c625f70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:7789

#0  mlog_write_ulint (ptr=0x7f46fc380068 "", val=0x110, type=0x2, mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/mtr/mtr0log.cc:265
#1  0x0000000000c57d4b in trx_undo_header_add_space_for_xid (undo_page=0x7f46fc380000 "`\240\256|", log_hdr=0x7f46fc380056 "", mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src
/storage/xtradb/trx/trx0undo.cc:685
#2  0x0000000000c5a1a4 in trx_undo_reuse_cached (trx=0x7f46e2901678, rseg=0x7f470986d478, type=0x1, trx_id=0xbc08, xid=0x7f46e2901810, mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/ha
grid/src/storage/xtradb/trx/trx0undo.cc:1688
#3  0x0000000000c5a4c7 in trx_undo_assign_undo (trx=0x7f46e2901678, type=0x1) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:1784
#4  0x0000000000c403fb in trx_undo_report_row_operation (flags=0x0, op_type=0x1, thr=0x7f46e2917838, index=0x7f46e28f8f78, clust_entry=0x7f46e28e8ff8, update=0x0, cmpl_info=0x0, rec=0x0,
 offsets=0x0, roll_ptr=0x7f470c623d70) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0rec.cc:1262
#5  0x0000000000c87ae9 in btr_cur_ins_lock_and_undo (flags=0x0, cursor=0x7f470c623f50, entry=0x7f46e28e8ff8, thr=0x7f46e2917838, mtr=0x7f470c623fd0, inherit=0x7f470c623e08) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/btr/btr0cur.cc:1331
#6  0x0000000000c88216 in btr_cur_optimistic_insert (flags=0x0, cursor=0x7f470c623f50, offsets=0x7f470c623f08, heap=0x7f470c623f18, entry=0x7f46e28e8ff8, rec=0x7f470c623f20, big_rec=0x7f470c623f10, n_ext=0x0, thr=0x7f46e2917838, mtr=0x7f470c623fd0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/btr/btr0cur.cc:1555
#7  0x0000000000bad884 in row_ins_clust_index_entry_low (flags=0x0, mode=0x2, index=0x7f46e28f8f78, n_uniq=0x0, entry=0x7f46e28e8ff8, n_ext=0x0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:2558
#8  0x0000000000baea1c in row_ins_clust_index_entry (index=0x7f46e28f8f78, entry=0x7f46e28e8ff8, thr=0x7f46e2917838, n_ext=0x0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3001
#9  0x0000000000baed2c in row_ins_index_entry (index=0x7f46e28f8f78, entry=0x7f46e28e8ff8, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3099
#10 0x0000000000baeff0 in row_ins_index_entry_step (node=0x7f46e29175c0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3176
#11 0x0000000000baf312 in row_ins (node=0x7f46e29175c0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3316
#12 0x0000000000baf66c in row_ins_step (thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3441
#13 0x0000000000bc8416 in row_insert_for_mysql (mysql_rec=0x7f46e281e988 "\371A\037", prebuilt=0x7f46e2917078) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0mysql.cc:1375
#14 0x0000000000ab3b2b in ha_innobase::write_row (this=0x7f46e28a8088, record=0x7f46e281e988 "\371A\037") at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:8502
#15 0x00000000008f23bb in handler::ha_write_row (this=0x7f46e28a8088, buf=0x7f46e281e988 "\371A\037") at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:5891
#16 0x00000000006704fc in write_record (thd=0x7f46e2816070, table=0x7f46e28c8870, info=0x7f470c624e20) at /home/midenok/src/mariadb/hagrid/src/sql/sql_insert.cc:1949
#17 0x000000000066dbb9 in mysql_insert (thd=0x7f46e2816070, table_list=0x7f46e285e180, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_insert.cc:998
#18 0x0000000000693bab in mysql_execute_command (thd=0x7f46e2816070) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:4289
#19 0x000000000069f205 in mysql_parse (thd=0x7f46e2816070, rawbuf=0x7f46e285e088 "INSERT INTO t1(x, y) VALUES(8001, 9001)", length=0x27, parser_state=0x7f470c625f70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:7789

#0  mlog_catenate_ulint (mtr=0x7f470c6232a0, val=0x1f, type=0x1) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/include/mtr0log.ic:91
#1  0x0000000000b4977e in mtr_log_reserve_and_write (mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/mtr/mtr0mtr.cc:252
#2  0x0000000000b49a82 in mtr_commit (mtr=0x7f470c6232a0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/mtr/mtr0mtr.cc:327
#3  0x0000000000c5a67b in trx_undo_assign_undo (trx=0x7f46e2901678, type=0x1) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:1811
#4  0x0000000000c403fb in trx_undo_report_row_operation (flags=0x0, op_type=0x1, thr=0x7f46e2917838, index=0x7f46e28f8f78, clust_entry=0x7f46e28e8ff8, update=0x0, cmpl_info=0x0, rec=0x0, offsets=0x0, roll_ptr=0x7f470c623d70) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0rec.cc:1262
#5  0x0000000000c87ae9 in btr_cur_ins_lock_and_undo (flags=0x0, cursor=0x7f470c623f50, entry=0x7f46e28e8ff8, thr=0x7f46e2917838, mtr=0x7f470c623fd0, inherit=0x7f470c623e08) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/btr/btr0cur.cc:1331
#6  0x0000000000c88216 in btr_cur_optimistic_insert (flags=0x0, cursor=0x7f470c623f50, offsets=0x7f470c623f08, heap=0x7f470c623f18, entry=0x7f46e28e8ff8, rec=0x7f470c623f20, big_rec=0x7f470c623f10, n_ext=0x0, thr=0x7f46e2917838, mtr=0x7f470c623fd0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/btr/btr0cur.cc:1555
#7  0x0000000000bad884 in row_ins_clust_index_entry_low (flags=0x0, mode=0x2, index=0x7f46e28f8f78, n_uniq=0x0, entry=0x7f46e28e8ff8, n_ext=0x0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:2558
#8  0x0000000000baea1c in row_ins_clust_index_entry (index=0x7f46e28f8f78, entry=0x7f46e28e8ff8, thr=0x7f46e2917838, n_ext=0x0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3001
#9  0x0000000000baed2c in row_ins_index_entry (index=0x7f46e28f8f78, entry=0x7f46e28e8ff8, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3099
#10 0x0000000000baeff0 in row_ins_index_entry_step (node=0x7f46e29175c0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3176
#11 0x0000000000baf312 in row_ins (node=0x7f46e29175c0, thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3316
#12 0x0000000000baf66c in row_ins_step (thr=0x7f46e2917838) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0ins.cc:3441
#13 0x0000000000bc8416 in row_insert_for_mysql (mysql_rec=0x7f46e281e988 "\371A\037", prebuilt=0x7f46e2917078) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/row/row0mysql.cc:1375
#14 0x0000000000ab3b2b in ha_innobase::write_row (this=0x7f46e28a8088, record=0x7f46e281e988 "\371A\037") at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:8502
#15 0x00000000008f23bb in handler::ha_write_row (this=0x7f46e28a8088, buf=0x7f46e281e988 "\371A\037") at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:5891
#16 0x00000000006704fc in write_record (thd=0x7f46e2816070, table=0x7f46e28c8870, info=0x7f470c624e20) at /home/midenok/src/mariadb/hagrid/src/sql/sql_insert.cc:1949
#17 0x000000000066dbb9 in mysql_insert (thd=0x7f46e2816070, table_list=0x7f46e285e180, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_insert.cc:998
#18 0x0000000000693bab in mysql_execute_command (thd=0x7f46e2816070) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:4289
#19 0x000000000069f205 in mysql_parse (thd=0x7f46e2816070, rawbuf=0x7f46e285e088 "INSERT INTO t1(x, y) VALUES(8001, 9001)", length=0x27, parser_state=0x7f470c625f70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:7789

#0  mlog_write_ulint (ptr=0x7f46fc380038 "", val=0x2, type=0x2, mtr=0x7f470c624530) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/mtr/mtr0log.cc:265
#1  0x0000000000c5a7e8 in trx_undo_set_state_at_finish (undo=0x7f4709840e38, mtr=0x7f470c624530) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0undo.cc:1859
#2  0x0000000000c51570 in trx_write_serialisation_history (trx=0x7f46e2901678, mtr=0x7f470c624530) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1231
#3  0x0000000000c52698 in trx_commit_low (trx=0x7f46e2901678, mtr=0x7f470c624530) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1626
#4  0x0000000000c5275d in trx_commit (trx=0x7f46e2901678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1673
#5  0x0000000000c5312a in trx_commit_for_mysql (trx=0x7f46e2901678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1937
#6  0x0000000000aac1d4 in innobase_commit_low (trx=0x7f46e2901678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4342
#7  0x0000000000aac4d2 in innobase_commit_ordered_2 (trx=0x7f46e2901678, thd=0x7f46e2816070) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4486
#8  0x0000000000aac8dc in innobase_commit (hton=0x7f470985a870, thd=0x7f46e2816070, commit_trx=0x0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4623
#9  0x00000000008e7097 in commit_one_phase_2 (thd=0x7f46e2816070, all=0x0, trans=0x7f46e28191d0, is_real_trans=0x1) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1552
#10 0x00000000008e6f93 in ha_commit_one_phase (thd=0x7f46e2816070, all=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1533
#11 0x00000000008e686d in ha_commit_trans (thd=0x7f46e2816070, all=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1400
#12 0x00000000007e24e8 in trans_commit_stmt (thd=0x7f46e2816070) at /home/midenok/src/mariadb/hagrid/src/sql/transaction.cc:434
#13 0x000000000069ad86 in mysql_execute_command (thd=0x7f46e2816070) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:6135
#14 0x000000000069f205 in mysql_parse (thd=0x7f46e2816070, rawbuf=0x7f46e285e088 "INSERT INTO t1(x, y) VALUES(8001, 9001)", length=0x27, parser_state=0x7f470c625f70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:7789

[midenok]

TODO:

1. check that vers_vtq_table is closed on mysql_execute_command end;
2. check that memory for vers_vtq is freed on mysql_execute_command end;

[midenok]

#0  ha_innobase::ha_innobase (this=0x7fc9870a7888, hton=0x7fc9ad45a870, table_arg=0x7fc987096a88) at /home/midenok/src/mariadb/midenok/src/storage/innobase/handler/ha_innodb.cc:2740
#1  0x0000000000bed14b in innobase_create_handler (hton=0x7fc9ad45a870, table=0x7fc987096a88, mem_root=0x7fc987096af8) at /home/midenok/src/mariadb/midenok/src/storage/innobase/handler/ha_innodb.cc:1485
#2  0x00000000008e4c9c in get_new_handler (share=0x7fc987096a88, alloc=0x7fc987096af8, db_type=0x7fc9ad45a870) at /home/midenok/src/mariadb/midenok/src/sql/handler.cc:256
#3  0x00000000007856b5 in TABLE_SHARE::init_from_binary_frm_image (this=0x7fc987096a88, thd=0x7fc987016070, write=0x0, frm_image=0x7fc98701da70 "\376\001\t\f\030", frm_length=0x3f8) at /home/midenok/src/mariadb/midenok/src/sql/table.cc:1451
#4  0x000000000078307f in open_table_def (thd=0x7fc987016070, share=0x7fc987096a88, flags=0xb) at /home/midenok/src/mariadb/midenok/src/sql/table.cc:662
#5  0x000000000086857f in tdc_acquire_share (thd=0x7fc987016070, tl=0x7fc9b0125f70, flags=0x3, out_table=0x7fc9b0125618) at /home/midenok/src/mariadb/midenok/src/sql/table_cache.cc:779
#6  0x00000000006246c0 in open_table (thd=0x7fc987016070, table_list=0x7fc9b0125f70, ot_ctx=0x7fc9b0125c20) at /home/midenok/src/mariadb/midenok/src/sql/sql_base.cc:2388
#7  0x00000000006275b1 in open_and_process_table (thd=0x7fc987016070, lex=0x7fc987019a00, tables=0x7fc9b0125f70, counter=0x7fc9b0125cec, flags=0x400, prelocking_strategy=0x7fc9b0125cf0, has_prelocking_list=0x0, ot_ctx=0x7fc9b0125c20) at /home/midenok/src/mariadb/midenok/src/sql/sql_base.cc:4055
#8  0x00000000006286c6 in open_tables (thd=0x7fc987016070, options=..., start=0x7fc9b0125cd0, counter=0x7fc9b0125cec, flags=0x400, prelocking_strategy=0x7fc9b0125cf0) at /home/midenok/src/mariadb/midenok/src/sql/sql_base.cc:4566
#9  0x000000000061fd35 in open_tables (thd=0x7fc987016070, tables=0x7fc9b0125cd0, counter=0x7fc9b0125cec, flags=0x400, prelocking_strategy=0x7fc9b0125cf0) at /home/midenok/src/mariadb/midenok/src/sql/sql_base.h:251
#10 0x0000000000629b84 in open_normal_and_derived_tables (thd=0x7fc987016070, tables=0x7fc9b0125f70, flags=0x400, dt_phases=0x22) at /home/midenok/src/mariadb/midenok/src/sql/sql_base.cc:5291
#11 0x000000000071f0dc in mysqld_list_fields (thd=0x7fc987016070, table_list=0x7fc9b0125f70, wild=0x7fc98705e0a8 "") at /home/midenok/src/mariadb/midenok/src/sql/sql_show.cc:1384
#12 0x000000000068dac2 in dispatch_command (command=COM_FIELD_LIST, thd=0x7fc987016070, packet=0x7fc987052074 "", packet_length=0x3, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:1983
#13 0x000000000068bad2 in do_command (thd=0x7fc987016070) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:1351
#14 0x00000000007cce22 in do_handle_one_connection (connect=0x7fc9ad437ad0) at /home/midenok/src/mariadb/midenok/src/sql/sql_connect.cc:1358
#15 0x00000000007ccb93 in handle_one_connection (arg=0x7fc9ad437ad0) at /home/midenok/src/mariadb/midenok/src/sql/sql_connect.cc:1264
#16 0x00007fc9ae9a26fa in start_thread (arg=0x7fc9b0127700) at pthread_create.c:333
#17 0x00007fc9ae04fb5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

[midenok]

#0  mlog_write_ulint (ptr=0x7f3e78058028 "", val=0x110, type=0x2, mtr=0x7f3e903652a0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/mtr/mtr0log.cc:265
#1  0x0000000000d86573 in trx_undo_header_add_space_for_xid (undo_page=0x7f3e78058000 "#\231Ҋ", log_hdr=0x7f3e78058056 "", mtr=0x7f3e903652a0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/trx/trx0undo.cc:679
#2  0x0000000000d88a02 in trx_undo_reuse_cached (trx=0x7f3e67497078, rseg=0x7f3e8d440e38, type=0x1, trx_id=0xa506, xid=0x7f3e67497208, mtr=0x7f3e903652a0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/trx/trx0undo.cc:1688
#3  0x0000000000d88d20 in trx_undo_assign_undo (trx=0x7f3e67497078, type=0x1) at /home/midenok/src/mariadb/midenok/src/storage/innobase/trx/trx0undo.cc:1784
#4  0x0000000000d6fff2 in trx_undo_report_row_operation (flags=0x0, op_type=0x1, thr=0x7f3e67491858, index=0x7f3e6c03dff8, clust_entry=0x7f3e6750b5f8, update=0x0, cmpl_info=0x0, rec=0x0, offsets=0x0, roll_ptr=0x7f3e90365d70) at /home/midenok/src/mariadb/midenok/src/storage/innobase/trx/trx0rec.cc:1262
#5  0x0000000000db5343 in btr_cur_ins_lock_and_undo (flags=0x0, cursor=0x7f3e90365f50, entry=0x7f3e6750b5f8, thr=0x7f3e67491858, mtr=0x7f3e90365fd0, inherit=0x7f3e90365e08) at /home/midenok/src/mariadb/midenok/src/storage/innobase/btr/btr0cur.cc:1228
#6  0x0000000000db5a00 in btr_cur_optimistic_insert (flags=0x0, cursor=0x7f3e90365f50, offsets=0x7f3e90365f10, heap=0x7f3e90365f20, entry=0x7f3e6750b5f8, rec=0x7f3e90365f28, big_rec=0x7f3e90365f18, n_ext=0x0, thr=0x7f3e67491858, mtr=0x7f3e90365fd0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/btr/btr0cur.cc:1448
#7  0x0000000000ce296e in row_ins_clust_index_entry_low (flags=0x0, mode=0x2, index=0x7f3e6c03dff8, n_uniq=0x2, entry=0x7f3e6750b5f8, n_ext=0x0, thr=0x7f3e67491858) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:2517
#8  0x0000000000ce39f3 in row_ins_clust_index_entry (index=0x7f3e6c03dff8, entry=0x7f3e6750b5f8, thr=0x7f3e67491858, n_ext=0x0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:2928
#9  0x0000000000ce3d03 in row_ins_index_entry (index=0x7f3e6c03dff8, entry=0x7f3e6750b5f8, thr=0x7f3e67491858) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:3026
#10 0x0000000000ce3fc7 in row_ins_index_entry_step (node=0x7f3e674915e0, thr=0x7f3e67491858) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:3103
#11 0x0000000000ce42e9 in row_ins (node=0x7f3e674915e0, thr=0x7f3e67491858) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:3243
#12 0x0000000000ce4643 in row_ins_step (thr=0x7f3e67491858) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:3368
#13 0x0000000000cfc2cc in row_insert_for_mysql (mysql_rec=0x7f3e6741da88 "\375A\037", prebuilt=0x7f3e67491078) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0mysql.cc:1376
#14 0x0000000000bf8426 in ha_innobase::write_row (this=0x7f3e674a8088, record=0x7f3e6741da88 "\375A\037") at /home/midenok/src/mariadb/midenok/src/storage/innobase/handler/ha_innodb.cc:8156
#15 0x00000000008f291d in handler::ha_write_row (this=0x7f3e674a8088, buf=0x7f3e6741da88 "\375A\037") at /home/midenok/src/mariadb/midenok/src/sql/handler.cc:5891
#16 0x00000000006705c0 in write_record (thd=0x7f3e67416070, table=0x7f3e674c8870, info=0x7f3e90366e20) at /home/midenok/src/mariadb/midenok/src/sql/sql_insert.cc:1961
#17 0x000000000066dc1f in mysql_insert (thd=0x7f3e67416070, table_list=0x7f3e6745e180, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=0x0) at /home/midenok/src/mariadb/midenok/src/sql/sql_insert.cc:1004
#18 0x0000000000693dc1 in mysql_execute_command (thd=0x7f3e67416070) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:4289
#19 0x000000000069f41b in mysql_parse (thd=0x7f3e67416070, rawbuf=0x7f3e6745e088 "INSERT INTO t2(x, y) VALUES(8001, 9001)", length=0x27, parser_state=0x7f3e90367f70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:7789

[midenok]

TODO:

• VTQ for multi-update

[midenok]

Delete:

#0  mtr_commit (mtr=0x7f3187a37b40) at /home/midenok/src/mariadb/midenok/src/storage/innobase/mtr/mtr0mtr.cc:312
#1  0x0000000000d3a8f7 in row_upd_clust_rec (node=0x7f315ec927f8, index=0x7f315eca6878, offsets=0x7f3187a37820, offsets_heap=0x7f3187a377d8, thr=0x7f315ec92ad0, mtr=0x7f3187a37b40) at /h
ome/midenok/src/mariadb/midenok/src/storage/innobase/row/row0upd.cc:2379
#2  0x0000000000d3b4d2 in row_upd_clust_step (node=0x7f315ec927f8, thr=0x7f315ec92ad0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0upd.cc:2723
#3  0x0000000000d3b745 in row_upd (node=0x7f315ec927f8, thr=0x7f315ec92ad0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0upd.cc:2813
#4  0x0000000000d3bbbb in row_upd_step (thr=0x7f315ec92ad0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0upd.cc:2965
#5  0x0000000000cfc953 in row_update_for_mysql (mysql_rec=0x7f315ec1c1a0 "\375\001", prebuilt=0x7f315ec92078) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0mysql.cc:1
812
#6  0x0000000000bf93d4 in ha_innobase::update_row (this=0x7f315ecaf088, old_row=0x7f315ec1c1a0 "\375\001", new_row=0x7f315ec1c188 "\375\001") at /home/midenok/src/mariadb/midenok/src/sto
rage/innobase/handler/ha_innodb.cc:8750
#7  0x00000000008f285d in handler::ha_update_row (this=0x7f315ecaf088, old_data=0x7f315ec1c1a0 "\375\001", new_data=0x7f315ec1c188 "\375\001") at /home/midenok/src/mariadb/midenok/src/sq
l/handler.cc:5923
#8  0x0000000000a5ae4b in TABLE::delete_row (this=0x7f315eccfc70) at /home/midenok/src/mariadb/midenok/src/sql/sql_delete.cc:226
#9  0x0000000000a58586 in mysql_delete (thd=0x7f315ec16070, table_list=0x7f315ec5e150, conds=0x0, order_list=0x7f315ec1a448, limit=0xffffffffffffffff, options=0x0, result=0x0) at /home/m
idenok/src/mariadb/midenok/src/sql/sql_delete.cc:607
#10 0x00000000006946cf in mysql_execute_command (thd=0x7f315ec16070) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:4484
#11 0x000000000069f1cd in mysql_parse (thd=0x7f315ec16070, rawbuf=0x7f315ec5e088 "delete from t1", length=0xe, parser_state=0x7f3187a39f70, is_com_multi=0x0, is_next_command=0x0) at /hom
e/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:7789

Commit:

#0  mtr_commit (mtr=0x7f3187a38530) at /home/midenok/src/mariadb/midenok/src/storage/innobase/mtr/mtr0mtr.cc:312
#1  0x0000000000d80cc9 in trx_commit_low (trx=0x7f315ec97078, mtr=0x7f3187a38530) at /home/midenok/src/mariadb/midenok/src/storage/innobase/trx/trx0trx.cc:1422
#2  0x0000000000d80d82 in trx_commit (trx=0x7f315ec97078) at /home/midenok/src/mariadb/midenok/src/storage/innobase/trx/trx0trx.cc:1450
#3  0x0000000000d81510 in trx_commit_for_mysql (trx=0x7f315ec97078) at /home/midenok/src/mariadb/midenok/src/storage/innobase/trx/trx0trx.cc:1672
#4  0x0000000000bf073d in innobase_commit_low (trx=0x7f315ec97078) at /home/midenok/src/mariadb/midenok/src/storage/innobase/handler/ha_innodb.cc:4064
#5  0x0000000000bf0a3b in innobase_commit_ordered_2 (trx=0x7f315ec97078, thd=0x7f315ec16070) at /home/midenok/src/mariadb/midenok/src/storage/innobase/handler/ha_innodb.cc:4168
#6  0x0000000000bf0db7 in innobase_commit (hton=0x7f3184c5a870, thd=0x7f315ec16070, commit_trx=0x0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/handler/ha_innodb.cc:4280
#7  0x00000000008e724b in commit_one_phase_2 (thd=0x7f315ec16070, all=0x0, trans=0x7f315ec191d0, is_real_trans=0x1) at /home/midenok/src/mariadb/midenok/src/sql/handler.cc:1552
#8  0x00000000008e7147 in ha_commit_one_phase (thd=0x7f315ec16070, all=0x0) at /home/midenok/src/mariadb/midenok/src/sql/handler.cc:1533
#9  0x00000000008e6a21 in ha_commit_trans (thd=0x7f315ec16070, all=0x0) at /home/midenok/src/mariadb/midenok/src/sql/handler.cc:1400
#10 0x00000000007e2676 in trans_commit_stmt (thd=0x7f315ec16070) at /home/midenok/src/mariadb/midenok/src/sql/transaction.cc:434
#11 0x000000000069ad4e in mysql_execute_command (thd=0x7f315ec16070) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:6135
#12 0x000000000069f1cd in mysql_parse (thd=0x7f315ec16070, rawbuf=0x7f315ec5e088 "delete from t1", length=0xe, parser_state=0x7f3187a39f70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:7789

[midenok]

thr->state = QUE_THR_RUNNING;

#0  que_thr_move_to_run_state_for_mysql (thr=0x7fffce9427f0, trx=0x7fffce869878) at /home/midenok/src/mariadb/midenok/src/storage/innobase/que/que0que.cc:859
#1  0x0000000000cfbeef in row_insert_for_mysql (mysql_rec=0x7fffce81c188 "\375\002", prebuilt=0x7fffce942078) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0mysql.cc:1370
#2  0x0000000000bf7e7a in ha_innobase::write_row (this=0x7fffce879088, record=0x7fffce81c188 "\375\002") at /home/midenok/src/mariadb/midenok/src/storage/innobase/handler/ha_innodb.cc:8153
#3  0x00000000008f256f in handler::ha_write_row (this=0x7fffce879088, buf=0x7fffce81c188 "\375\002") at /home/midenok/src/mariadb/midenok/src/sql/handler.cc:5891
#4  0x00000000006704be in write_record (thd=0x7fffce8ba070, table=0x7fffce899870, info=0x7ffff7f7be20) at /home/midenok/src/mariadb/midenok/src/sql/sql_insert.cc:1951
#5  0x000000000066db7b in mysql_insert (thd=0x7fffce8ba070, table_list=0x7fffce910168, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=0x0) at /home/midenok/src/mariadb/midenok/src/sql/sql_insert.cc:999
#6  0x0000000000693b73 in mysql_execute_command (thd=0x7fffce8ba070) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:4289
#7  0x000000000069f1cd in mysql_parse (thd=0x7fffce8ba070, rawbuf=0x7fffce910088 "insert into t1 values (2)", length=0x19, parser_state=0x7ffff7f7cf70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:7789

thr->state = QUE_THR_COMPLETED;

#0  que_thr_stop_for_mysql_no_error (thr=0x7f77700fd7f0, trx=0x7f7770097078) at /home/midenok/src/mariadb/midenok/src/storage/innobase/que/que0que.cc:890
#1  0x0000000000cfc1b9 in row_insert_for_mysql (mysql_rec=0x7f777001e488 "\375\002", prebuilt=0x7f77700fd078) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0mysql.cc:1460
#2  0x0000000000bf7e7a in ha_innobase::write_row (this=0x7f77700a8088, record=0x7f777001e488 "\375\002") at /home/midenok/src/mariadb/midenok/src/storage/innobase/handler/ha_innodb.cc:8153
#3  0x00000000008f256f in handler::ha_write_row (this=0x7f77700a8088, buf=0x7f777001e488 "\375\002") at /home/midenok/src/mariadb/midenok/src/sql/handler.cc:5891
#4  0x00000000006704be in write_record (thd=0x7f7770016070, table=0x7f77700c8870, info=0x7f77991bae20) at /home/midenok/src/mariadb/midenok/src/sql/sql_insert.cc:1951
#5  0x000000000066db7b in mysql_insert (thd=0x7f7770016070, table_list=0x7f777005e168, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=0x0) at /home/midenok/src/mariadb/midenok/src/sql/sql_insert.cc:999
#6  0x0000000000693b73 in mysql_execute_command (thd=0x7f7770016070) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:4289
#7  0x000000000069f1cd in mysql_parse (thd=0x7f7770016070, rawbuf=0x7f777005e088 "insert into t1 values (2)", length=0x19, parser_state=0x7f77991bbf70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:7789

[midenok]

Insert tuple into clustered index:

        *rec = page_cur_tuple_insert(page_cursor, entry, index,
                         offsets, heap, n_ext, mtr);

[midenok]

Write field to clustered index:

#0  rec_convert_dtuple_to_rec_old (buf=0x7fffce8fe1b8 "\377\377\377\377\377\377\017\377\370\r", '\377' <repeats 35 times>, dtuple=0x7fffce8e99f8, n_ext=0x0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/rem/rem0rec.cc:1088
#1  0x0000000000cc2dc8 in rec_convert_dtuple_to_rec (buf=0x7fffce8fe1b8 "\377\377\377\377\377\377\017\377\370\r", '\377' <repeats 35 times>, index=0x7fffdf2ff4f8, dtuple=0x7fffce8e99f8, n_ext=0x0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/rem/rem0rec.cc:1351
#2  0x0000000000db17b1 in page_cur_tuple_insert (cursor=0x7ffff7f7af58, tuple=0x7fffce8e99f8, index=0x7fffdf2ff4f8, offsets=0x7ffff7f7af10, heap=0x7ffff7f7af20, n_ext=0x0, mtr=0x7ffff7f7afd0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/include/page0cur.ic:282
#3  0x0000000000db5845 in btr_cur_optimistic_insert (flags=0x0, cursor=0x7ffff7f7af50, offsets=0x7ffff7f7af10, heap=0x7ffff7f7af20, entry=0x7fffce8e99f8, rec=0x7ffff7f7af28, big_rec=0x7ffff7f7af18, n_ext=0x0, thr=0x7fffce8fd7f0, mtr=0x7ffff7f7afd0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/btr/btr0cur.cc:1461
#4  0x0000000000ce24f6 in row_ins_clust_index_entry_low (flags=0x0, mode=0x2, index=0x7fffdf2ff4f8, n_uniq=0x1, entry=0x7fffce8e99f8, n_ext=0x0, thr=0x7fffce8fd7f0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:2517
#5  0x0000000000ce357b in row_ins_clust_index_entry (index=0x7fffdf2ff4f8, entry=0x7fffce8e99f8, thr=0x7fffce8fd7f0, n_ext=0x0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:2928
#6  0x0000000000ce388b in row_ins_index_entry (index=0x7fffdf2ff4f8, entry=0x7fffce8e99f8, thr=0x7fffce8fd7f0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:3026
#7  0x0000000000ce3b4f in row_ins_index_entry_step (node=0x7fffce8fd8a0, thr=0x7fffce8fd7f0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:3103
#8  0x0000000000ce3e71 in row_ins (node=0x7fffce8fd8a0, thr=0x7fffce8fd7f0) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:3243
#9  0x0000000000ce438a in vers_notify_vtq (thr=0x7fffce8fd7f0, heap=0x7fffce8fd000) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:3438
#10 0x0000000000cfc0ca in row_insert_for_mysql (mysql_rec=0x7fffce81e488 "\375\005", prebuilt=0x7fffce8fd078) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0mysql.cc:1405
#11 0x0000000000bf7e7a in ha_innobase::write_row (this=0x7fffce8a8088, record=0x7fffce81e488 "\375\005") at /home/midenok/src/mariadb/midenok/src/storage/innobase/handler/ha_innodb.cc:8153
#12 0x00000000008f256f in handler::ha_write_row (this=0x7fffce8a8088, buf=0x7fffce81e488 "\375\005") at /home/midenok/src/mariadb/midenok/src/sql/handler.cc:5891
#13 0x00000000006704be in write_record (thd=0x7fffce816070, table=0x7fffce8c8870, info=0x7ffff7f7be20) at /home/midenok/src/mariadb/midenok/src/sql/sql_insert.cc:1951
#14 0x000000000066db7b in mysql_insert (thd=0x7fffce816070, table_list=0x7fffce85e168, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=0x0) at /home/midenok/src/mariadb/midenok/src/sql/sql_insert.cc:999
#15 0x0000000000693b73 in mysql_execute_command (thd=0x7fffce816070) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:4289
#16 0x000000000069f1cd in mysql_parse (thd=0x7fffce816070, rawbuf=0x7fffce85e088 "insert into t1 values (5)", length=0x19, parser_state=0x7ffff7f7cf70, is_com_multi=0x0, is_next_command=0x0) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:7789