Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3026

maxctrl show sessions - queries always empty

    XMLWordPrintable

    Details

      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,

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            anthosz Anthony
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: