[MDEV-8931] (server part of) session state tracking Created: 2015-10-12  Updated: 2023-09-05  Resolved: 2016-09-04

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Fix Version/s: 10.2.2

Type: Task Priority: Major
Reporter: Sergei Golubchik Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
causes MDEV-11761 CLIENT_DEPRECATE_EOF : Client must i... Closed
causes MDEV-32102 Permit to have intermediate EOF in re... Open
Relates
relates to CONC-148 Session state tracking (as in 5.7) Open
relates to MDEV-10734 Add/port connection tracker support i... Open
relates to CONJ-319 handle Server session state flag in O... Closed
relates to MDEV-10734 Add/port connection tracker support i... Open
relates to MDEV-29629 Session state tracking does not track... Closed
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, 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.

 Comments   
Comment by Oleksandr Byelkin [ 2016-04-03 ]

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

—

Comment by Oleksandr Byelkin [ 2016-05-17 ]

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

Comment by Oleksandr Byelkin [ 2016-05-17 ]

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

Comment by Oleksandr Byelkin [ 2016-05-26 ]

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

—

Comment by Oleksandr Byelkin [ 2016-05-28 ]

2 commits are in 10.2-MDEV-8931

Comment by Oleksandr Byelkin [ 2016-05-30 ]

Transaction tracking added and pushed (force)

Comment by Oleksandr Byelkin [ 2016-05-30 ]

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

Comment by Sergei Golubchik [ 2016-05-31 ]

You can coordinate this with MDEV-9293 and wlad

Comment by Oleksandr Byelkin [ 2016-08-09 ]

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.

—

Comment by Oleksandr Byelkin [ 2016-08-31 ]

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.

Generated at Thu Feb 08 07:30:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.