Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Cannot Reproduce
-
Affects Version/s: 2.4.9, 2.4.10
-
Fix Version/s: N/A
-
Component/s: readconnroute, readwritesplit, Router
-
Labels:
-
Environment: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,