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

(server part of) session state tracking

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2.2
    • OTHER
    • None
    • 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-2, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2

    Description

      see, e.g. https://dev.mysql.com/doc/refman/5.7/en/mysql-session-track-get-first.html

      this also deprecates the EOF packet. It will be only used for old clients that don't need session state tracking.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11761 CLIENT_DEPRECATE_EOF : Client must identify a "stored procedure output resultset"

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-32102 Permit to have intermediate EOF in resultset

          • Major - Major loss of function.
          • Open
          relates to

          Task - A task that needs to be done. CONC-148 Session state tracking (as in 5.7)

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-10734 Add/port connection tracker support in mysqltest. Add tests.

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. CONJ-319 handle Server session state flag in OKPacket

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-10734 Add/port connection tracker support in mysqltest. Add tests.

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29629 Session state tracking does not track variable changes via aliases

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Summary port session tracking from 5.7 port session state tracking from 5.7
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Summary port session state tracking from 5.7 (server part of) session state tracking
            serg Sergei Golubchik made changes -
            Description see, e.g. https://dev.mysql.com/doc/refman/5.7/en/mysql-session-track-get-first.html see, e.g. https://dev.mysql.com/doc/refman/5.7/en/mysql-session-track-get-first.html

            this also deprecates the EOF packet. It will be only used for old clients that don't need session state tracking.
            sanja Oleksandr Byelkin made changes -
            Sprint 10.2.0-6 [ 37 ]
            sanja Oleksandr Byelkin made changes -
            Sprint 10.2.0-6 [ 37 ]
            Assignee Oleksandr Byelkin [ sanja ]
            sanja Oleksandr Byelkin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Sprint 10.2.0-7 [ 39 ]
            sanja Oleksandr Byelkin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7 [ 39 ] 10.2.0-7, 10.2.0-8 [ 39, 41 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8 [ 39, 41 ] 10.2.0-7, 10.2.0-8, 10.2.0-9 [ 39, 41, 43 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            sanja Oleksandr Byelkin made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9 [ 39, 41, 43 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10 [ 39, 41, 43, 46 ]
            sanja Oleksandr Byelkin added a comment -

            Changes are in the branch 10.2-MDEV-8931 or:

            revision-id: 4c51152d9f43e271e17a2bc266f5887ce092c00f (mariadb-10.1.8-187-g4c51152)
            parent(s): 69b5c4a4220c8fa98bbca8b3f935b2a3735e19ac
            committer: Oleksandr Byelkin
            timestamp: 2016-03-28 19:19:54 +0200
            message:

            MDEV-8931: (server part of) session state tracking

            initial commit to test

            —

            revision-id: d4f228771adde02262061702950babd2539a99f5 (mariadb-10.1.8-188-gd4f2287)
            parent(s): 4c51152d9f43e271e17a2bc266f5887ce092c00f
            committer: Oleksandr Byelkin
            timestamp: 2016-04-03 19:58:38 +0200
            message:

            MDEV-8931: (server part of) session state tracking

            System variables tracking

            —

            sanja Oleksandr Byelkin added a comment - Changes are in the branch 10.2- MDEV-8931 or: revision-id: 4c51152d9f43e271e17a2bc266f5887ce092c00f (mariadb-10.1.8-187-g4c51152) parent(s): 69b5c4a4220c8fa98bbca8b3f935b2a3735e19ac committer: Oleksandr Byelkin timestamp: 2016-03-28 19:19:54 +0200 message: MDEV-8931 : (server part of) session state tracking initial commit to test — revision-id: d4f228771adde02262061702950babd2539a99f5 (mariadb-10.1.8-188-gd4f2287) parent(s): 4c51152d9f43e271e17a2bc266f5887ce092c00f committer: Oleksandr Byelkin timestamp: 2016-04-03 19:58:38 +0200 message: MDEV-8931 : (server part of) session state tracking System variables tracking —
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Sergei Golubchik [ serg ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10 [ 39, 41, 43, 46 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11 [ 39, 41, 43, 46, 47 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Oleksandr Byelkin [ sanja ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11 [ 39, 41, 43, 46, 47 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1 [ 39, 41, 43, 46, 47, 56 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1 [ 39, 41, 43, 46, 47, 56 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-2 [ 39, 41, 43, 46, 47, 56, 63 ]
            sanja Oleksandr Byelkin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin added a comment -

            Left tasks:
            1) make variable testable on unload with plugin
            2) SET STATEMENT workaround
            3) transactions info

            sanja Oleksandr Byelkin added a comment - Left tasks: 1) make variable testable on unload with plugin 2) SET STATEMENT workaround 3) transactions info
            sanja Oleksandr Byelkin added a comment -

            1) use variable bookmarks, add something like bookmarks to global plugin variables...

            sanja Oleksandr Byelkin added a comment - 1) use variable bookmarks, add something like bookmarks to global plugin variables...
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-2 [ 39, 41, 43, 46, 47, 56, 63 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3 [ 39, 41, 43, 46, 47, 56, 65 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3 [ 39, 41, 43, 46, 47, 56, 65 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4 [ 39, 41, 43, 46, 47, 56, 65, 66 ]
            sanja Oleksandr Byelkin added a comment -

            revision-id: d2b496f035f0789ec3c2aa6d49d3c9ae41693e47 (mariadb-10.2.0-44-gd2b496f)
            parent(s): 4cf74d8976c18e3a871ce3696f20ab6a08a77ba2
            committer: Oleksandr Byelkin
            timestamp: 2016-05-26 19:15:53 +0200
            message:

            MDEV-8931: (server part of) session state tracking

            System variables tracking

            —

            sanja Oleksandr Byelkin added a comment - revision-id: d2b496f035f0789ec3c2aa6d49d3c9ae41693e47 (mariadb-10.2.0-44-gd2b496f) parent(s): 4cf74d8976c18e3a871ce3696f20ab6a08a77ba2 committer: Oleksandr Byelkin timestamp: 2016-05-26 19:15:53 +0200 message: MDEV-8931 : (server part of) session state tracking System variables tracking —
            sanja Oleksandr Byelkin added a comment -

            2 commits are in 10.2-MDEV-8931

            sanja Oleksandr Byelkin added a comment - 2 commits are in 10.2- MDEV-8931
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            sanja Oleksandr Byelkin added a comment -

            Transaction tracking added and pushed (force)

            sanja Oleksandr Byelkin added a comment - Transaction tracking added and pushed (force)
            sanja Oleksandr Byelkin added a comment -

            session_tracker_trx_state from 5.7 passes as is but can not be added while we have no client support.

            sanja Oleksandr Byelkin added a comment - session_tracker_trx_state from 5.7 passes as is but can not be added while we have no client support.
            serg Sergei Golubchik added a comment -

            You can coordinate this with MDEV-9293 and wlad

            serg Sergei Golubchik added a comment - You can coordinate this with MDEV-9293 and wlad
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4 [ 39, 41, 43, 46, 47, 56, 65, 66 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5 [ 39, 41, 43, 46, 47, 56, 65, 66, 68 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5 [ 39, 41, 43, 46, 47, 56, 65, 66, 68 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4 [ 39, 41, 43, 46, 47, 56, 65, 66 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4 [ 39, 41, 43, 46, 47, 56, 65, 66 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5 [ 39, 41, 43, 46, 47, 56, 65, 66, 68 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Oleksandr Byelkin [ sanja ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5 [ 39, 41, 43, 46, 47, 56, 65, 66, 68 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-2 [ 39, 41, 43, 46, 47, 56, 65, 66, 68, 82 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            sanja Oleksandr Byelkin made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-2 [ 39, 41, 43, 46, 47, 56, 65, 66, 68, 82 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-2, 10.2.2-3 [ 39, 41, 43, 46, 47, 56, 65, 66, 68, 82, 83 ]
            sanja Oleksandr Byelkin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-2, 10.2.2-3 [ 39, 41, 43, 46, 47, 56, 65, 66, 68, 82, 83 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-2, 10.2.2-3, 5.51 & 10.2 [ 39, 41, 43, 46, 47, 56, 65, 66, 68, 82, 83, 85 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            sanja Oleksandr Byelkin made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin added a comment -

            The postreview work also pushed

            revision-id: db9822df31917c3d0162322a77bcd4433bfb705e (mariadb-10.2.1-15-gdb9822d)
            parent(s): b5e0f70e04cec625c99760e5bfb28bb31bc972ed
            committer: Oleksandr Byelkin
            timestamp: 2016-08-09 15:49:30 +0200
            message:

            MDEV-8931: (server part of) session state tracking

            Postreview fixes.
            New MySQL tests fixes.

            —

            sanja Oleksandr Byelkin added a comment - The postreview work also pushed revision-id: db9822df31917c3d0162322a77bcd4433bfb705e (mariadb-10.2.1-15-gdb9822d) parent(s): b5e0f70e04cec625c99760e5bfb28bb31bc972ed committer: Oleksandr Byelkin timestamp: 2016-08-09 15:49:30 +0200 message: MDEV-8931 : (server part of) session state tracking Postreview fixes. New MySQL tests fixes. —
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2 [ 39, 41, 43, 46, 47, 56, 65, 66, 68, 82, 83, 85 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1 [ 39, 41, 43, 46, 47, 56, 65, 66, 68, 82, 83, 85, 89 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1 [ 39, 41, 43, 46, 47, 56, 65, 66, 68, 82, 83, 85, 89 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2 [ 39, 41, 43, 46, 47, 56, 65, 66, 68, 82, 83, 85, 89, 92 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Oleksandr Byelkin [ sanja ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin added a comment - - edited

            I do not close it to do not forget add tests when Connector/C will be added to server tree. But the patch is pushed.

            I think it will be better to create separate issue for this task.

            sanja Oleksandr Byelkin added a comment - - edited I do not close it to do not forget add tests when Connector/C will be added to server tree. But the patch is pushed. I think it will be better to create separate issue for this task.
            sanja Oleksandr Byelkin made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            diego dupin Diego Dupin made changes -
            sanja Oleksandr Byelkin made changes -
            sanja Oleksandr Byelkin made changes -
            sanja Oleksandr Byelkin made changes -
            Component/s OTHER [ 10125 ]
            Fix Version/s 10.2.2 [ 22013 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            alvinr Alvin Richards (Inactive) made changes -
            Sprint 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2 [ 39, 41, 43, 46, 47, 56, 65, 66, 68, 82, 83, 85, 89, 92 ] 10.2.0-7, 10.2.0-8, 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-2, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2 [ 39, 41, 43, 46, 47, 56, 65, 66, 68, 82, 85, 89, 92 ]
            diego dupin Diego Dupin made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 72100 ] MariaDB v4 [ 132694 ]
            elenst Elena Stepanova made changes -
            diego dupin Diego Dupin made changes -

            People

              sanja Oleksandr Byelkin
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.