vitess.io/vitess@v0.16.2/go/vt/vtexplain/testdata/twopc-output/insertsharded-output.txt (about)

     1  ----------------------------------------------------------------------
     2  insert into user (id, name) values(1, 'alice')
     3  
     4  1 ks_sharded/40-80: begin
     5  1 ks_sharded/40-80: insert into name_user_map(name, user_id) values ('alice', 1) /* vtgate:: keyspace_id:475e26c086f437f36bd72ecd883504a7 */
     6  2 ks_sharded/-40: begin
     7  2 ks_sharded/-40: insert into user(id, name) values (1, 'alice') /* vtgate:: keyspace_id:166b40b44aba4bd6 */
     8  3 ks_sharded/40-80: begin
     9  3 ks_sharded/40-80: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:40-80:1515392387046738470', 1, 1515392387090538997)
    10  3 ks_sharded/40-80: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:40-80:1515392387046738470', 1, 'ks_sharded', '-40')
    11  3 ks_sharded/40-80: commit
    12  4 ks_sharded/-40: begin
    13  4 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:40-80:1515392387046738470', 1, 1515392387101086738)
    14  4 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:40-80:1515392387046738470', 1, 'insert into user(id, name) values (1, \'alice\') /* vtgate:: keyspace_id:166b40b44aba4bd6 */')
    15  4 ks_sharded/-40: commit
    16  5 ks_sharded/40-80: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:40-80:1515392387046738470' and state = 1
    17  5 ks_sharded/40-80: commit
    18  6 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:40-80:1515392387046738470'
    19  6 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:40-80:1515392387046738470'
    20  6 ks_sharded/-40: commit
    21  7 ks_sharded/40-80: begin
    22  7 ks_sharded/40-80: delete from `_vt`.dt_state where dtid = 'ks_sharded:40-80:1515392387046738470'
    23  7 ks_sharded/40-80: delete from `_vt`.dt_participant where dtid = 'ks_sharded:40-80:1515392387046738470'
    24  7 ks_sharded/40-80: commit
    25  
    26  ----------------------------------------------------------------------
    27  insert into user (id, name) values(2, 'bob')
    28  
    29  1 ks_sharded/c0-: begin
    30  1 ks_sharded/c0-: insert into name_user_map(name, user_id) values ('bob', 2) /* vtgate:: keyspace_id:da8a82595aa28154c17717955ffeed8b */
    31  2 ks_sharded/-40: begin
    32  2 ks_sharded/-40: insert into user(id, name) values (2, 'bob') /* vtgate:: keyspace_id:06e7ea22ce92708f */
    33  3 ks_sharded/c0-: begin
    34  3 ks_sharded/c0-: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859424', 1, 1515392387171740872)
    35  3 ks_sharded/c0-: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:c0-:1515392387053859424', 1, 'ks_sharded', '-40')
    36  3 ks_sharded/c0-: commit
    37  4 ks_sharded/-40: begin
    38  4 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859424', 1, 1515392387182475610)
    39  4 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:c0-:1515392387053859424', 1, 'insert into user(id, name) values (2, \'bob\') /* vtgate:: keyspace_id:06e7ea22ce92708f */')
    40  4 ks_sharded/-40: commit
    41  5 ks_sharded/c0-: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:c0-:1515392387053859424' and state = 1
    42  5 ks_sharded/c0-: commit
    43  6 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:c0-:1515392387053859424'
    44  6 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:c0-:1515392387053859424'
    45  6 ks_sharded/-40: commit
    46  7 ks_sharded/c0-: begin
    47  7 ks_sharded/c0-: delete from `_vt`.dt_state where dtid = 'ks_sharded:c0-:1515392387053859424'
    48  7 ks_sharded/c0-: delete from `_vt`.dt_participant where dtid = 'ks_sharded:c0-:1515392387053859424'
    49  7 ks_sharded/c0-: commit
    50  
    51  ----------------------------------------------------------------------
    52  insert ignore into user (id, name) values(2, 'bob')
    53  
    54  1 ks_sharded/c0-: begin
    55  1 ks_sharded/c0-: insert ignore into name_user_map(name, user_id) values ('bob', 2) /* vtgate:: keyspace_id:da8a82595aa28154c17717955ffeed8b */
    56  2 ks_sharded/c0-: select name from name_user_map where name = 'bob' and user_id = 2 limit 10001
    57  3 ks_sharded/-40: begin
    58  3 ks_sharded/-40: insert ignore into user(id, name) values (2, 'bob') /* vtgate:: keyspace_id:06e7ea22ce92708f */
    59  4 ks_sharded/c0-: begin
    60  4 ks_sharded/c0-: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859427', 1, 1515392387263209422)
    61  4 ks_sharded/c0-: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:c0-:1515392387053859427', 1, 'ks_sharded', '-40')
    62  4 ks_sharded/c0-: commit
    63  5 ks_sharded/-40: begin
    64  5 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859427', 1, 1515392387274980027)
    65  5 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:c0-:1515392387053859427', 1, 'insert ignore into user(id, name) values (2, \'bob\') /* vtgate:: keyspace_id:06e7ea22ce92708f */')
    66  5 ks_sharded/-40: commit
    67  6 ks_sharded/c0-: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:c0-:1515392387053859427' and state = 1
    68  6 ks_sharded/c0-: commit
    69  7 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:c0-:1515392387053859427'
    70  7 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:c0-:1515392387053859427'
    71  7 ks_sharded/-40: commit
    72  8 ks_sharded/c0-: begin
    73  8 ks_sharded/c0-: delete from `_vt`.dt_state where dtid = 'ks_sharded:c0-:1515392387053859427'
    74  8 ks_sharded/c0-: delete from `_vt`.dt_participant where dtid = 'ks_sharded:c0-:1515392387053859427'
    75  8 ks_sharded/c0-: commit
    76  
    77  ----------------------------------------------------------------------
    78  insert ignore into user (id, name, nickname) values(2, 'bob', 'bob')
    79  
    80  1 ks_sharded/c0-: begin
    81  1 ks_sharded/c0-: insert ignore into name_user_map(name, user_id) values ('bob', 2) /* vtgate:: keyspace_id:da8a82595aa28154c17717955ffeed8b */
    82  2 ks_sharded/c0-: select name from name_user_map where name = 'bob' and user_id = 2 limit 10001
    83  3 ks_sharded/-40: begin
    84  3 ks_sharded/-40: insert ignore into user(id, name, nickname) values (2, 'bob', 'bob') /* vtgate:: keyspace_id:06e7ea22ce92708f */
    85  4 ks_sharded/c0-: begin
    86  4 ks_sharded/c0-: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859430', 1, 1515392387360777113)
    87  4 ks_sharded/c0-: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:c0-:1515392387053859430', 1, 'ks_sharded', '-40')
    88  4 ks_sharded/c0-: commit
    89  5 ks_sharded/-40: begin
    90  5 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859430', 1, 1515392387372890757)
    91  5 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:c0-:1515392387053859430', 1, 'insert ignore into user(id, name, nickname) values (2, \'bob\', \'bob\') /* vtgate:: keyspace_id:06e7ea22ce92708f */')
    92  5 ks_sharded/-40: commit
    93  6 ks_sharded/c0-: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:c0-:1515392387053859430' and state = 1
    94  6 ks_sharded/c0-: commit
    95  7 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:c0-:1515392387053859430'
    96  7 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:c0-:1515392387053859430'
    97  7 ks_sharded/-40: commit
    98  8 ks_sharded/c0-: begin
    99  8 ks_sharded/c0-: delete from `_vt`.dt_state where dtid = 'ks_sharded:c0-:1515392387053859430'
   100  8 ks_sharded/c0-: delete from `_vt`.dt_participant where dtid = 'ks_sharded:c0-:1515392387053859430'
   101  8 ks_sharded/c0-: commit
   102  
   103  ----------------------------------------------------------------------
   104  insert into user (id, name, nickname) values(2, 'bob', 'bobby') on duplicate key update nickname='bobby'
   105  
   106  1 ks_sharded/c0-: begin
   107  1 ks_sharded/c0-: insert ignore into name_user_map(name, user_id) values ('bob', 2) /* vtgate:: keyspace_id:da8a82595aa28154c17717955ffeed8b */
   108  2 ks_sharded/c0-: select name from name_user_map where name = 'bob' and user_id = 2 limit 10001
   109  3 ks_sharded/-40: begin
   110  3 ks_sharded/-40: insert into user(id, name, nickname) values (2, 'bob', 'bobby') on duplicate key update nickname = 'bobby' /* vtgate:: keyspace_id:06e7ea22ce92708f */
   111  4 ks_sharded/c0-: begin
   112  4 ks_sharded/c0-: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859433', 1, 1515392387454561857)
   113  4 ks_sharded/c0-: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:c0-:1515392387053859433', 1, 'ks_sharded', '-40')
   114  4 ks_sharded/c0-: commit
   115  5 ks_sharded/-40: begin
   116  5 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859433', 1, 1515392387467658995)
   117  5 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:c0-:1515392387053859433', 1, 'insert into user(id, name, nickname) values (2, \'bob\', \'bobby\') on duplicate key update nickname = \'bobby\' /* vtgate:: keyspace_id:06e7ea22ce92708f */')
   118  5 ks_sharded/-40: commit
   119  6 ks_sharded/c0-: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:c0-:1515392387053859433' and state = 1
   120  6 ks_sharded/c0-: commit
   121  7 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:c0-:1515392387053859433'
   122  7 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:c0-:1515392387053859433'
   123  7 ks_sharded/-40: commit
   124  8 ks_sharded/c0-: begin
   125  8 ks_sharded/c0-: delete from `_vt`.dt_state where dtid = 'ks_sharded:c0-:1515392387053859433'
   126  8 ks_sharded/c0-: delete from `_vt`.dt_participant where dtid = 'ks_sharded:c0-:1515392387053859433'
   127  8 ks_sharded/c0-: commit
   128  
   129  ----------------------------------------------------------------------
   130  insert into user (id, name, nickname, address) values(2, 'bob', 'bobby', '123 main st') on duplicate key update nickname=values(nickname), address=values(address)
   131  
   132  1 ks_sharded/c0-: begin
   133  1 ks_sharded/c0-: insert ignore into name_user_map(name, user_id) values ('bob', 2) /* vtgate:: keyspace_id:da8a82595aa28154c17717955ffeed8b */
   134  2 ks_sharded/c0-: select name from name_user_map where name = 'bob' and user_id = 2 limit 10001
   135  3 ks_sharded/-40: begin
   136  3 ks_sharded/-40: insert into user(id, name, nickname, address) values (2, 'bob', 'bobby', '123 main st') on duplicate key update nickname = values(nickname), address = values(address) /* vtgate:: keyspace_id:06e7ea22ce92708f */
   137  3 ks_sharded/-40: select count(*) from `_vt`.redo_state where time_created < 1515392382546684649
   138  3 ks_sharded/-40: select dtid, time_created from `_vt`.dt_state where time_created < 1515392386546990720
   139  4 ks_sharded/c0-: begin
   140  4 ks_sharded/c0-: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859436', 1, 1515392387549507151)
   141  4 ks_sharded/c0-: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:c0-:1515392387053859436', 1, 'ks_sharded', '-40')
   142  4 ks_sharded/c0-: commit
   143  4 ks_sharded/c0-: select count(*) from `_vt`.redo_state where time_created < 1515392382555938983
   144  4 ks_sharded/c0-: select dtid, time_created from `_vt`.dt_state where time_created < 1515392386556481105
   145  5 ks_sharded/-40: begin
   146  5 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859436', 1, 1515392387561241013)
   147  5 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:c0-:1515392387053859436', 1, 'insert into user(id, name, nickname, address) values (2, \'bob\', \'bobby\', \'123 main st\') on duplicate key update nickname = values(nickname), address = values(address) /* vtgate:: keyspace_id:06e7ea22ce92708f */')
   148  5 ks_sharded/-40: commit
   149  6 ks_sharded/c0-: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:c0-:1515392387053859436' and state = 1
   150  6 ks_sharded/c0-: commit
   151  7 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:c0-:1515392387053859436'
   152  7 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:c0-:1515392387053859436'
   153  7 ks_sharded/-40: commit
   154  8 ks_sharded/c0-: begin
   155  8 ks_sharded/c0-: delete from `_vt`.dt_state where dtid = 'ks_sharded:c0-:1515392387053859436'
   156  8 ks_sharded/c0-: delete from `_vt`.dt_participant where dtid = 'ks_sharded:c0-:1515392387053859436'
   157  8 ks_sharded/c0-: commit
   158  
   159  ----------------------------------------------------------------------