{"action":"created","issue":{"url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/8","repository_url":"https://api.github.com/repos/natsys/mariadb_10.2","labels_url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/8/labels{/name}","comments_url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/8/comments","events_url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/8/events","html_url":"https://github.com/natsys/mariadb_10.2/issues/8","id":175753933,"number":8,"title":"VTQ update","user":{"login":"midenok","id":3307037,"avatar_url":"https://avatars.githubusercontent.com/u/3307037?v=3","gravatar_id":"","url":"https://api.github.com/users/midenok","html_url":"https://github.com/midenok","followers_url":"https://api.github.com/users/midenok/followers","following_url":"https://api.github.com/users/midenok/following{/other_user}","gists_url":"https://api.github.com/users/midenok/gists{/gist_id}","starred_url":"https://api.github.com/users/midenok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/midenok/subscriptions","organizations_url":"https://api.github.com/users/midenok/orgs","repos_url":"https://api.github.com/users/midenok/repos","events_url":"https://api.github.com/users/midenok/events{/privacy}","received_events_url":"https://api.github.com/users/midenok/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/natsys/mariadb_10.2/labels/task","name":"task","color":"0e8a16"}],"state":"open","locked":false,"assignee":{"login":"midenok","id":3307037,"avatar_url":"https://avatars.githubusercontent.com/u/3307037?v=3","gravatar_id":"","url":"https://api.github.com/users/midenok","html_url":"https://github.com/midenok","followers_url":"https://api.github.com/users/midenok/followers","following_url":"https://api.github.com/users/midenok/following{/other_user}","gists_url":"https://api.github.com/users/midenok/gists{/gist_id}","starred_url":"https://api.github.com/users/midenok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/midenok/subscriptions","organizations_url":"https://api.github.com/users/midenok/orgs","repos_url":"https://api.github.com/users/midenok/repos","events_url":"https://api.github.com/users/midenok/events{/privacy}","received_events_url":"https://api.github.com/users/midenok/received_events","type":"User","site_admin":false},"assignees":[{"login":"midenok","id":3307037,"avatar_url":"https://avatars.githubusercontent.com/u/3307037?v=3","gravatar_id":"","url":"https://api.github.com/users/midenok","html_url":"https://github.com/midenok","followers_url":"https://api.github.com/users/midenok/followers","following_url":"https://api.github.com/users/midenok/following{/other_user}","gists_url":"https://api.github.com/users/midenok/gists{/gist_id}","starred_url":"https://api.github.com/users/midenok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/midenok/subscriptions","organizations_url":"https://api.github.com/users/midenok/orgs","repos_url":"https://api.github.com/users/midenok/repos","events_url":"https://api.github.com/users/midenok/events{/privacy}","received_events_url":"https://api.github.com/users/midenok/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/natsys/mariadb_10.2/milestones/2","html_url":"https://github.com/natsys/mariadb_10.2/milestones/0.2%20VTQ%20Table","labels_url":"https://api.github.com/repos/natsys/mariadb_10.2/milestones/2/labels","id":2002255,"number":2,"title":"0.2 VTQ Table","description":"","creator":{"login":"midenok","id":3307037,"avatar_url":"https://avatars.githubusercontent.com/u/3307037?v=3","gravatar_id":"","url":"https://api.github.com/users/midenok","html_url":"https://github.com/midenok","followers_url":"https://api.github.com/users/midenok/followers","following_url":"https://api.github.com/users/midenok/following{/other_user}","gists_url":"https://api.github.com/users/midenok/gists{/gist_id}","starred_url":"https://api.github.com/users/midenok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/midenok/subscriptions","organizations_url":"https://api.github.com/users/midenok/orgs","repos_url":"https://api.github.com/users/midenok/repos","events_url":"https://api.github.com/users/midenok/events{/privacy}","received_events_url":"https://api.github.com/users/midenok/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":0,"state":"open","created_at":"2016-09-13T19:16:47Z","updated_at":"2016-09-13T19:18:42Z","due_on":"2016-09-30T00:00:00Z","closed_at":null},"comments":4,"created_at":"2016-09-08T13:30:07Z","updated_at":"2016-09-17T15:14:54Z","closed_at":null,"body":"```\r\nDROP 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;\r\n```\r\n#### Single-statement transaction\r\n```\r\nINSERT INTO t1(x, y) VALUES(8001, 9001);\r\n```\r\n```\r\n#0  mtr_commit (mtr=0x7fa9d9bc4530) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/mtr/mtr0mtr.cc:315\r\n#1  0x0000000000c526a4 in trx_commit_low (trx=0x7fa9b0101678, mtr=0x7fa9d9bc4530) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1645\r\n#2  0x0000000000c5275d in trx_commit (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1673\r\n#3  0x0000000000c5312a in trx_commit_for_mysql (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1937\r\n#4  0x0000000000aac1d4 in innobase_commit_low (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4342\r\n#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\r\n#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\r\n#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\r\n#8  0x00000000008e6f93 in ha_commit_one_phase (thd=0x7fa9b0016070, all=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1533\r\n#9  0x00000000008e686d in ha_commit_trans (thd=0x7fa9b0016070, all=0x0) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1400\r\n#10 0x00000000007e24e8 in trans_commit_stmt (thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/sql/transaction.cc:434\r\n#11 0x000000000069ad86 in mysql_execute_command (thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:6135\r\n#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\r\n```\r\n\r\n#### Multi-statement transaction\r\n```\r\nstart transaction; INSERT INTO t1(x, y) VALUES(8001, 9001); commit;\r\n```\r\n```\r\n#0  mtr_commit (mtr=0x7fa9d9bc4530) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/mtr/mtr0mtr.cc:315\r\n#1  0x0000000000c526a4 in trx_commit_low (trx=0x7fa9b0101678, mtr=0x7fa9d9bc4530) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1645\r\n#2  0x0000000000c5275d in trx_commit (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1673\r\n#3  0x0000000000c5312a in trx_commit_for_mysql (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1937\r\n#4  0x0000000000aac1d4 in innobase_commit_low (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4342\r\n#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\r\n#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\r\n#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\r\n#8  0x00000000008e6f93 in ha_commit_one_phase (thd=0x7fa9b0016070, all=0x1) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1533\r\n#9  0x00000000008e686d in ha_commit_trans (thd=0x7fa9b0016070, all=0x1) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1400\r\n#10 0x00000000007e1c50 in trans_commit (thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/sql/transaction.cc:236\r\n#11 0x000000000069811e in mysql_execute_command (thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:5412\r\n#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\r\n```\r\n\r\n#### Two-phase transaction\r\n```\r\nxa start 'xyz'; INSERT INTO t1(x, y) VALUES(8001, 9001); xa end 'xyz'; xa prepare 'xyz'; xa commit 'xyz';\r\n```\r\n```\r\n#0  mtr_commit (mtr=0x7fa9d9bc45c0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/mtr/mtr0mtr.cc:315\r\n#1  0x0000000000c526a4 in trx_commit_low (trx=0x7fa9b0101678, mtr=0x7fa9d9bc45c0) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1645\r\n#2  0x0000000000c5275d in trx_commit (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1673\r\n#3  0x0000000000c5312a in trx_commit_for_mysql (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/trx/trx0trx.cc:1937\r\n#4  0x0000000000aac1d4 in innobase_commit_low (trx=0x7fa9b0101678) at /home/midenok/src/mariadb/hagrid/src/storage/xtradb/handler/ha_innodb.cc:4342\r\n#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\r\n#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\r\n#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\r\n#8  0x00000000008e6f93 in ha_commit_one_phase (thd=0x7fa9b0016070, all=0x1) at /home/midenok/src/mariadb/hagrid/src/sql/handler.cc:1533\r\n#9  0x00000000007e38a4 in trans_xa_commit (thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/sql/transaction.cc:895\r\n#10 0x0000000000699f20 in mysql_execute_command (thd=0x7fa9b0016070) at /home/midenok/src/mariadb/hagrid/src/sql/sql_parse.cc:5951\r\n#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\r\n```"},"comment":{"url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/comments/247780176","html_url":"https://github.com/natsys/mariadb_10.2/issues/8#issuecomment-247780176","issue_url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/8","id":247780176,"user":{"login":"midenok","id":3307037,"avatar_url":"https://avatars.githubusercontent.com/u/3307037?v=3","gravatar_id":"","url":"https://api.github.com/users/midenok","html_url":"https://github.com/midenok","followers_url":"https://api.github.com/users/midenok/followers","following_url":"https://api.github.com/users/midenok/following{/other_user}","gists_url":"https://api.github.com/users/midenok/gists{/gist_id}","starred_url":"https://api.github.com/users/midenok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/midenok/subscriptions","organizations_url":"https://api.github.com/users/midenok/orgs","repos_url":"https://api.github.com/users/midenok/repos","events_url":"https://api.github.com/users/midenok/events{/privacy}","received_events_url":"https://api.github.com/users/midenok/received_events","type":"User","site_admin":false},"created_at":"2016-09-17T15:14:54Z","updated_at":"2016-09-17T15:14:54Z","body":"```\r\n#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\r\n#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\r\n#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\r\n#3  0x0000000000d88d20 in trx_undo_assign_undo (trx=0x7f3e67497078, type=0x1) at /home/midenok/src/mariadb/midenok/src/storage/innobase/trx/trx0undo.cc:1784\r\n#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\r\n#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\r\n#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\r\n#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\r\n#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\r\n#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\r\n#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\r\n#11 0x0000000000ce42e9 in row_ins (node=0x7f3e674915e0, thr=0x7f3e67491858) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:3243\r\n#12 0x0000000000ce4643 in row_ins_step (thr=0x7f3e67491858) at /home/midenok/src/mariadb/midenok/src/storage/innobase/row/row0ins.cc:3368\r\n#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\r\n#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\r\n#15 0x00000000008f291d in handler::ha_write_row (this=0x7f3e674a8088, buf=0x7f3e6741da88 \"\\375A\\037\") at /home/midenok/src/mariadb/midenok/src/sql/handler.cc:5891\r\n#16 0x00000000006705c0 in write_record (thd=0x7f3e67416070, table=0x7f3e674c8870, info=0x7f3e90366e20) at /home/midenok/src/mariadb/midenok/src/sql/sql_insert.cc:1961\r\n#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\r\n#18 0x0000000000693dc1 in mysql_execute_command (thd=0x7f3e67416070) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:4289\r\n#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\r\n```"}}
{"actor":{"display_login":"midenok"}}