[#MXS-3026] maxctrl show sessions - queries always empty

[maxscale]

threads=auto

retain_last_statements=50

dump_last_statements=on_close

session_trace=50

[.....]

So, indeed, I can see the queries in Log row (probably due to session_trace) and in the logs but nothing in queries row. What is the goal of this row? This is a bug or normal behavior?

│ Queries        │                                                                                                                                                                          │

├────────────────┼──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┤

│ Log            │ 2020-06-05 20:56:14   info   : (4) [readconnroute] Routed [COM_QUERY] to 'dbserv2': UPDATE sbtest16 SET k=k+1 WHERE id=4049785                                      │

│                │                                                                                                                                                                          │

│                │ 2020-06-05 20:56:14   info   : (4) [readconnroute] Routed [COM_QUERY] to 'dbserv2': UPDATE sbtest16 SET k=k+1 WHERE id=5004436                                      │

│                │                                                                                                                                                                          │

│                │ 2020-06-05 20:56:14   info   : (4) [readconnroute] Routed [COM_QUERY] to 'dbserv2': SELECT DISTINCT c FROM sbtest7 WHERE id BETWEEN 5038798 AND 5038897 ORDER BY c

If I remove session_trace & keep the statements conf: nothing in log/log row/queries row.

[MXS-3026] maxctrl show sessions - queries always empty Created: 2020-06-05 Updated: 2020-09-11 Resolved: 2020-09-11
Status:	Closed
Project:	MariaDB MaxScale
Component/s:	readconnroute, readwritesplit, Router
Affects Version/s:	2.4.9, 2.4.10
Fix Version/s:	N/A

[MXS-3026] maxctrl show sessions - queries always empty Created: 2020-06-05 Updated: 2020-09-11 Resolved: 2020-09-11