vitess.io/vitess@v0.16.2/go/vt/vtexplain/testdata/twopc-output/updatesharded-output.txt (about) 1 ---------------------------------------------------------------------- 2 update user set nickname='alice' where id=1 3 4 1 ks_sharded/-40: begin 5 1 ks_sharded/-40: update user set nickname = 'alice' where id in (1) /* vtgate:: keyspace_id:166b40b44aba4bd6 */ 6 2 ks_sharded/-40: commit 7 8 ---------------------------------------------------------------------- 9 update user set nickname='alice' where name='alice' 10 11 1 ks_sharded/40-80: begin 12 1 ks_sharded/40-80: select user_id from name_user_map where name = 'alice' limit 10001 13 2 ks_sharded/-40: begin 14 2 ks_sharded/-40: select id from user where name = 'alice' limit 10001 for update /* vtgate:: keyspace_id:166b40b44aba4bd6 */ 15 2 ks_sharded/-40: update user set nickname = 'alice' where id in (1) /* vtgate:: keyspace_id:166b40b44aba4bd6 */ 16 3 ks_sharded/40-80: begin 17 3 ks_sharded/40-80: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:40-80:1515392388086929116', 1, 1515392388148775408) 18 3 ks_sharded/40-80: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:40-80:1515392388086929116', 1, 'ks_sharded', '-40') 19 3 ks_sharded/40-80: commit 20 4 ks_sharded/-40: begin 21 4 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:40-80:1515392388086929116', 1, 1515392388159901825) 22 4 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:40-80:1515392388086929116', 1, 'update user set nickname = \'alice\' where id in (1) /* vtgate:: keyspace_id:166b40b44aba4bd6 */') 23 4 ks_sharded/-40: commit 24 5 ks_sharded/40-80: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:40-80:1515392388086929116' and state = 1 25 5 ks_sharded/40-80: commit 26 6 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:40-80:1515392388086929116' 27 6 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:40-80:1515392388086929116' 28 6 ks_sharded/-40: commit 29 7 ks_sharded/40-80: begin 30 7 ks_sharded/40-80: delete from `_vt`.dt_state where dtid = 'ks_sharded:40-80:1515392388086929116' 31 7 ks_sharded/40-80: delete from `_vt`.dt_participant where dtid = 'ks_sharded:40-80:1515392388086929116' 32 7 ks_sharded/40-80: commit 33 34 ---------------------------------------------------------------------- 35 update user set pet='fido' where id=1 36 37 1 ks_sharded/-40: begin 38 1 ks_sharded/-40: update user set pet = 'fido' where id in (1) /* vtgate:: keyspace_id:166b40b44aba4bd6 */ 39 2 ks_sharded/-40: commit 40 41 ---------------------------------------------------------------------- 42 update user set name='alicia' where id=1 43 44 1 ks_sharded/-40: begin 45 1 ks_sharded/-40: select name from user where id = 1 limit 10001 for update 46 2 ks_sharded/80-c0: begin 47 2 ks_sharded/80-c0: delete from name_user_map where (name = 'name_val_1' and user_id = 1) /* vtgate:: keyspace_id:a6e89b54b129c33051b76db219595660 */ 48 3 ks_sharded/c0-: begin 49 3 ks_sharded/c0-: insert into name_user_map(name, user_id) values ('alicia', 1) /* vtgate:: keyspace_id:e2821261367fbee90bb5cf72955146c6 */ 50 4 ks_sharded/-40: update user set name = 'alicia' where id in (1) /* vtgate:: keyspace_id:166b40b44aba4bd6 */ 51 5 ks_sharded/-40: begin 52 5 ks_sharded/-40: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:-40:1515392388084762368', 1, 1515392388286298317) 53 5 ks_sharded/-40: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:-40:1515392388084762368', 1, 'ks_sharded', '80-c0'), ('ks_sharded:-40:1515392388084762368', 2, 'ks_sharded', 'c0-') 54 5 ks_sharded/-40: commit 55 6 ks_sharded/80-c0: begin 56 6 ks_sharded/80-c0: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:-40:1515392388084762368', 1, 1515392388298778400) 57 6 ks_sharded/80-c0: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:-40:1515392388084762368', 1, 'delete from name_user_map where (name = \'name_val_1\' and user_id = 1) /* vtgate:: keyspace_id:a6e89b54b129c33051b76db219595660 */') 58 6 ks_sharded/80-c0: commit 59 6 ks_sharded/c0-: begin 60 6 ks_sharded/c0-: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:-40:1515392388084762368', 1, 1515392388298735516) 61 6 ks_sharded/c0-: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:-40:1515392388084762368', 1, 'insert into name_user_map(name, user_id) values (\'alicia\', 1) /* vtgate:: keyspace_id:e2821261367fbee90bb5cf72955146c6 */') 62 6 ks_sharded/c0-: commit 63 7 ks_sharded/-40: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:-40:1515392388084762368' and state = 1 64 7 ks_sharded/-40: commit 65 8 ks_sharded/80-c0: delete from `_vt`.redo_state where dtid = 'ks_sharded:-40:1515392388084762368' 66 8 ks_sharded/80-c0: delete from `_vt`.redo_statement where dtid = 'ks_sharded:-40:1515392388084762368' 67 8 ks_sharded/80-c0: commit 68 8 ks_sharded/c0-: delete from `_vt`.redo_state where dtid = 'ks_sharded:-40:1515392388084762368' 69 8 ks_sharded/c0-: delete from `_vt`.redo_statement where dtid = 'ks_sharded:-40:1515392388084762368' 70 8 ks_sharded/c0-: commit 71 9 ks_sharded/-40: begin 72 9 ks_sharded/-40: delete from `_vt`.dt_state where dtid = 'ks_sharded:-40:1515392388084762368' 73 9 ks_sharded/-40: delete from `_vt`.dt_participant where dtid = 'ks_sharded:-40:1515392388084762368' 74 9 ks_sharded/-40: commit 75 76 ---------------------------------------------------------------------- 77 update user set name='alicia' where name='alice' 78 79 1 ks_sharded/40-80: begin 80 1 ks_sharded/40-80: select user_id from name_user_map where name = 'alice' limit 10001 81 2 ks_sharded/-40: begin 82 2 ks_sharded/-40: select name from user where name = 'alice' limit 10001 for update 83 3 ks_sharded/80-c0: begin 84 3 ks_sharded/80-c0: delete from name_user_map where (name = 'name_val_1' and user_id = 1) /* vtgate:: keyspace_id:a6e89b54b129c33051b76db219595660 */ 85 4 ks_sharded/c0-: begin 86 4 ks_sharded/c0-: insert into name_user_map(name, user_id) values ('alicia', 1) /* vtgate:: keyspace_id:e2821261367fbee90bb5cf72955146c6 */ 87 5 ks_sharded/-40: select id from user where name = 'alice' limit 10001 for update /* vtgate:: keyspace_id:166b40b44aba4bd6 */ 88 5 ks_sharded/-40: update user set name = 'alicia' where id in (1) /* vtgate:: keyspace_id:166b40b44aba4bd6 */ 89 6 ks_sharded/40-80: begin 90 6 ks_sharded/40-80: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:40-80:1515392388086929119', 1, 1515392388407716332) 91 6 ks_sharded/40-80: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:40-80:1515392388086929119', 1, 'ks_sharded', '-40'), ('ks_sharded:40-80:1515392388086929119', 2, 'ks_sharded', '80-c0'), ('ks_sharded:40-80:1515392388086929119', 3, 'ks_sharded', 'c0-') 92 6 ks_sharded/40-80: commit 93 7 ks_sharded/-40: begin 94 7 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:40-80:1515392388086929119', 1, 1515392388418784416) 95 7 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:40-80:1515392388086929119', 1, 'update user set name = \'alicia\' where id in (1) /* vtgate:: keyspace_id:166b40b44aba4bd6 */') 96 7 ks_sharded/-40: commit 97 7 ks_sharded/80-c0: begin 98 7 ks_sharded/80-c0: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:40-80:1515392388086929119', 1, 1515392388418767663) 99 7 ks_sharded/80-c0: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:40-80:1515392388086929119', 1, 'delete from name_user_map where (name = \'name_val_1\' and user_id = 1) /* vtgate:: keyspace_id:a6e89b54b129c33051b76db219595660 */') 100 7 ks_sharded/80-c0: commit 101 7 ks_sharded/c0-: begin 102 7 ks_sharded/c0-: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:40-80:1515392388086929119', 1, 1515392388418767689) 103 7 ks_sharded/c0-: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:40-80:1515392388086929119', 1, 'insert into name_user_map(name, user_id) values (\'alicia\', 1) /* vtgate:: keyspace_id:e2821261367fbee90bb5cf72955146c6 */') 104 7 ks_sharded/c0-: commit 105 8 ks_sharded/40-80: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:40-80:1515392388086929119' and state = 1 106 8 ks_sharded/40-80: commit 107 9 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:40-80:1515392388086929119' 108 9 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:40-80:1515392388086929119' 109 9 ks_sharded/-40: commit 110 9 ks_sharded/80-c0: delete from `_vt`.redo_state where dtid = 'ks_sharded:40-80:1515392388086929119' 111 9 ks_sharded/80-c0: delete from `_vt`.redo_statement where dtid = 'ks_sharded:40-80:1515392388086929119' 112 9 ks_sharded/80-c0: commit 113 9 ks_sharded/c0-: delete from `_vt`.redo_state where dtid = 'ks_sharded:40-80:1515392388086929119' 114 9 ks_sharded/c0-: delete from `_vt`.redo_statement where dtid = 'ks_sharded:40-80:1515392388086929119' 115 9 ks_sharded/c0-: commit 116 10 ks_sharded/40-80: begin 117 10 ks_sharded/40-80: delete from `_vt`.dt_state where dtid = 'ks_sharded:40-80:1515392388086929119' 118 10 ks_sharded/40-80: delete from `_vt`.dt_participant where dtid = 'ks_sharded:40-80:1515392388086929119' 119 10 ks_sharded/40-80: commit 120 121 ----------------------------------------------------------------------