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

maxadmin "show service" counters overflow

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.0.4
    • 2.1.3
    • maxadmin
    • CentOS 7 x64 virtual machine @ XenServer, 4vCPU, 8GB RAM
    • 2017-31

    Description

      We have a fairly large-ish instance of MaxScale. At March 10, we had the following counts after running the instance for 16 hours forwarding all SQL traffic from a very large message board to three MariaDB MySQL nodes:

      MaxScale> show services
      [...]
       Number of queries forwarded:            152065870
              Number of queries forwarded to master:  7151735 (4.70%)
              Number of queries forwarded to slave:   144914137 (95.30%)
              Number of queries forwarded to all:     25297037 (16.64%)
       Started:                             Wed Mar  8 10:39:04 2017
      

      Looking at the counters today, the values are negative:

      MaxScale> show services
      Service 0x16d6780
              Service:                             split-rw-service
              Router:                              readwritesplit (0x7f34aa8232c0)
              State:                               Started
              Number of router sessions:              270472727
              Current no. of router sessions:         105
              Number of queries forwarded:            -1842543097
              Number of queries forwarded to master:  117348154 (0.00%)
              Number of queries forwarded to slave:   -1959884562 (0.00%)
              Number of queries forwarded to all:     422237746 (0.00%)
              Started:                             Wed Mar  8 10:39:04 2017
      

      The value of "queries forwarded to slave" is changing and goes towards zero. it seems some sort of an integer overflow happened. Is it possible to get it fixed?

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            jkuchta Jakub Kuchta
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.