Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-36164

INSERT ... RETURNING doesn't return last_gtid in the system variable trackers

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.11.11, 11.4.4
    • N/A
    • Server
    • None

    Description

      This started off in MXS-5527 where I noticed that INSERT ... RETURNING does not return the value of last_gtid the same way it is for a plain INSERT statement.

      Here's a network dump where the behavior is seen. The GTID 0-3000-11 is returned but the GTID 

      T 127.0.0.1:39908 -> 127.0.0.1:3000 [AP] #24
      		 
        23 00 00 00 03 63 72 65    61 74 65 20 6f 72 20 72    #....create or r
      		 
        65 70 6c 61 63 65 20 74    61 62 6c 65 20 74 31 28    eplace table t1(
      		 
        69 64 20 69 6e 74 29                                  id int)         
      #
      		 
      T 127.0.0.1:3000 -> 127.0.0.1:39908 [AP] #25
      		 
        1f 00 00 01 00 00 00 02    40 00 00 00 16 00 14 09    ........@.......
      		 
        6c 61 73 74 5f 67 74 69    64 09 30 2d 33 30 30 30    last_gtid.0-3000
      		 
        2d 31 33                                              -13             
      ##
      		 
      T 127.0.0.1:39908 -> 127.0.0.1:3000 [AP] #27
      		 
        27 00 00 00 03 69 6e 73    65 72 74 20 69 6e 74 6f    '....insert into
      		 
        20 74 31 20 76 61 6c 75    65 73 20 28 31 29 20 72     t1 values (1) r
      		 
        65 74 75 72 6e 69 6e 67    20 69 64                   eturning id     
      #
      		 
      T 127.0.0.1:3000 -> 127.0.0.1:39908 [AP] #28
      		 
        02 00 00 01 01 01 23 00    00 02 03 64 65 66 04 74    ......#....def.t
      		 
        65 73 74 02 74 31 02 74    31 02 69 64 02 69 64 00    est.t1.t1.id.id.
      		 
        0c 3f 00 0b 00 00 00 03    00 00 00 00 00 05 00 00    .?..............
      		 
        03 fe 00 00 02 00 02 00    00 04 01 31 05 00 00 05    ...........1....
      		 
        fe 00 00 02 40                                        ....@           
      ##
      		 
      T 127.0.0.1:39908 -> 127.0.0.1:3000 [AP] #30
      		 
        13 00 00 00 03 73 65 6c    65 63 74 20 40 40 6c 61    .....select @@la
      		 
        73 74 5f 67 74 69 64                                  st_gtid         
      #
      		 
      T 127.0.0.1:3000 -> 127.0.0.1:39908 [AP] #31
      		 
        02 00 00 01 01 01 22 00    00 02 03 64 65 66 00 00    ......"....def..
      		 
        00 0b 40 40 6c 61 73 74    5f 67 74 69 64 00 00 0c    ..@@last_gtid...
      		 
        21 00 1b 00 00 00 fd 00    00 27 00 00 05 00 00 03    !........'......
      		 
        fe 00 00 02 00 0a 00 00    04 09 30 2d 33 30 30 30    ..........0-3000
      		 
        2d 31 34 05 00 00 05 fe    00 00 02 00                -14.........    
      ##
      		 
      T 127.0.0.1:39908 -> 127.0.0.1:3000 [AP] #33
      		 
        1a 00 00 00 03 69 6e 73    65 72 74 20 69 6e 74 6f    .....insert into
      		 
        20 74 31 20 76 61 6c 75    65 73 20 28 32 29           t1 values (2)  
      #
      		 
      T 127.0.0.1:3000 -> 127.0.0.1:39908 [AP] #34
      		 
        1f 00 00 01 00 01 00 02    40 00 00 00 16 00 14 09    ........@.......
      		 
        6c 61 73 74 5f 67 74 69    64 09 30 2d 33 30 30 30    last_gtid.0-3000
      		 
        2d 31 35                                              -15             
      ##
      		 
      T 127.0.0.1:39908 -> 127.0.0.1:3000 [AP] #36
      		 
        13 00 00 00 03 73 65 6c    65 63 74 20 40 40 6c 61    .....select @@la
      		 
        73 74 5f 67 74 69 64                                  st_gtid         
      #
      		 
      T 127.0.0.1:3000 -> 127.0.0.1:39908 [AP] #37
      		 
        02 00 00 01 01 01 22 00    00 02 03 64 65 66 00 00    ......"....def..
      		 
        00 0b 40 40 6c 61 73 74    5f 67 74 69 64 00 00 0c    ..@@last_gtid...
      		 
        21 00 1b 00 00 00 fd 00    00 27 00 00 05 00 00 03    !........'......
      		 
        fe 00 00 02 00 0a 00 00    04 09 30 2d 33 30 30 30    ..........0-3000
      		 
        2d 31 35 05 00 00 05 fe    00 00 02 00                -15.........

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MXS-5527 The "INSERT INTO...RETURNING" syntax breaks causal_reads

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            markus makela markus makela created issue -
            markus makela markus makela made changes -
            Field Original Value New Value
            Description This started off in MXS-5527 where I noticed that {{INSERT ... RETURNING}} does not return the value of {{last_gtid}} the same way it is for a plain {{INSERT}} statement. This started off in MXS-5527 where I noticed that {{INSERT ... RETURNING}} does not return the value of {{last_gtid}} the same way it is for a plain {{INSERT}} statement.

            Here's a network dump where the behavior is seen. The GTID 0-3000-11 is returned but the GTID
            {code}
            T 127.0.0.1:39908 -> 127.0.0.1:3000 [AP] #24
              23 00 00 00 03 63 72 65 61 74 65 20 6f 72 20 72 #....create or r
              65 70 6c 61 63 65 20 74 61 62 6c 65 20 74 31 28 eplace table t1(
              69 64 20 69 6e 74 29 id int)
            #
            T 127.0.0.1:3000 -> 127.0.0.1:39908 [AP] #25
              1f 00 00 01 00 00 00 02 40 00 00 00 16 00 14 09 ........@.......
              6c 61 73 74 5f 67 74 69 64 09 30 2d 33 30 30 30 last_gtid.0-3000
              2d 31 33 -13
            ##
            T 127.0.0.1:39908 -> 127.0.0.1:3000 [AP] #27
              27 00 00 00 03 69 6e 73 65 72 74 20 69 6e 74 6f '....insert into
              20 74 31 20 76 61 6c 75 65 73 20 28 31 29 20 72 t1 values (1) r
              65 74 75 72 6e 69 6e 67 20 69 64 eturning id
            #
            T 127.0.0.1:3000 -> 127.0.0.1:39908 [AP] #28
              02 00 00 01 01 01 23 00 00 02 03 64 65 66 04 74 ......#....def.t
              65 73 74 02 74 31 02 74 31 02 69 64 02 69 64 00 est.t1.t1.id.id.
              0c 3f 00 0b 00 00 00 03 00 00 00 00 00 05 00 00 .?..............
              03 fe 00 00 02 00 02 00 00 04 01 31 05 00 00 05 ...........1....
              fe 00 00 02 40 ....@
            ##
            T 127.0.0.1:39908 -> 127.0.0.1:3000 [AP] #30
              13 00 00 00 03 73 65 6c 65 63 74 20 40 40 6c 61 .....select @@la
              73 74 5f 67 74 69 64 st_gtid
            #
            T 127.0.0.1:3000 -> 127.0.0.1:39908 [AP] #31
              02 00 00 01 01 01 22 00 00 02 03 64 65 66 00 00 ......"....def..
              00 0b 40 40 6c 61 73 74 5f 67 74 69 64 00 00 0c ..@@last_gtid...
              21 00 1b 00 00 00 fd 00 00 27 00 00 05 00 00 03 !........'......
              fe 00 00 02 00 0a 00 00 04 09 30 2d 33 30 30 30 ..........0-3000
              2d 31 34 05 00 00 05 fe 00 00 02 00 -14.........
            ##
            T 127.0.0.1:39908 -> 127.0.0.1:3000 [AP] #33
              1a 00 00 00 03 69 6e 73 65 72 74 20 69 6e 74 6f .....insert into
              20 74 31 20 76 61 6c 75 65 73 20 28 32 29 t1 values (2)
            #
            T 127.0.0.1:3000 -> 127.0.0.1:39908 [AP] #34
              1f 00 00 01 00 01 00 02 40 00 00 00 16 00 14 09 ........@.......
              6c 61 73 74 5f 67 74 69 64 09 30 2d 33 30 30 30 last_gtid.0-3000
              2d 31 35 -15
            ##
            T 127.0.0.1:39908 -> 127.0.0.1:3000 [AP] #36
              13 00 00 00 03 73 65 6c 65 63 74 20 40 40 6c 61 .....select @@la
              73 74 5f 67 74 69 64 st_gtid
            #
            T 127.0.0.1:3000 -> 127.0.0.1:39908 [AP] #37
              02 00 00 01 01 01 22 00 00 02 03 64 65 66 00 00 ......"....def..
              00 0b 40 40 6c 61 73 74 5f 67 74 69 64 00 00 0c ..@@last_gtid...
              21 00 1b 00 00 00 fd 00 00 27 00 00 05 00 00 03 !........'......
              fe 00 00 02 00 0a 00 00 04 09 30 2d 33 30 30 30 ..........0-3000
              2d 31 35 05 00 00 05 fe 00 00 02 00 -15.........
            {code}
            markus makela markus makela made changes -
            Affects Version/s 11.4.4 [ 29907 ]
            markus makela markus makela made changes -
            elenst Elena Stepanova made changes -
            Component/s Server [ 13907 ]
            Fix Version/s 10.11 [ 27614 ]
            Fix Version/s 11.4 [ 29301 ]
            Assignee Oleksandr Byelkin [ sanja ]
            markus makela markus makela made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.11 [ 27614 ]
            Fix Version/s 11.4 [ 29301 ]
            Resolution Not a Bug [ 6 ]
            Status Open [ 1 ] Closed [ 6 ]

            People

              sanja Oleksandr Byelkin
              markus makela markus makela
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.