Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Cannot Reproduce
-
2.4.9, 2.4.10
-
RHEL7
3 nodes Percona XtraDB Cluster & MaxScale
Description
Hi,
I have an issue with maxctrl show sessions.
Indeed, when I want to show the sessions, queries is 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.
Best regards,