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

Output of 'status' wrong when connected to a backend server via schema router.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 2.4.8
    • Fix Version/s: N/A
    • Component/s: schemarouter
    • Labels:
    • Environment:
      Debian 10 (Buster)
      MariaDB 10.4.12

      Description

      When accessing a database which only resides on srv02 with

      mariadb -h srv02.addr.tld -u dbuser02 -p -D srv02_db02
      

      ... and executing the 'status' command. The Output of the command shows the status of srv01 instead of srv02.

      /var/log/maxscale/maxscale.log

      2020-04-12 20:55:38   notice : Server changed state: srv01[10.0.0.1:3306]: new_master. [Running] -> [Master, Running]
      

      -

      maxctrl list servers
       
      ┌─────────┬───────────────┬──────┬─────────────┬─────────────────┬─────────────────┐
      │ Server  │ Address       │ Port │ Connections │ State           │ GTID            │
      ├─────────┼───────────────┼──────┼─────────────┼─────────────────┼─────────────────┤
      │ srv01   │ 10.0.0.133060           │ Master, Running │ 0-1-200
      ├─────────┼───────────────┼──────┼─────────────┼─────────────────┼─────────────────┤
      │ srv02   │ 10.0.0.233060           │ Master, Running │ 0-2-450
      └─────────┴───────────────┴──────┴─────────────┴─────────────────┴─────────────────┘
      

      maxscale.cnf

      [maxscale]
      threads=auto
       
      [srv01]
      type=server
      address=10.0.0.1
      port=3306
      protocol=MariaDBBackend
       
      [srv02]
      type=server
      address=10.0.0.2
      port=3306
      protocol=MariaDBBackend
       
      [srv01-monitor]
      type=monitor
      module=mariadbmon
      servers=srv01
      user=maxscale_monitor
      password=password
      monitor_interval=2000ms
       
      [srv02-monitor]
      type=monitor
      module=mariadbmon
      servers=srv02
      user=maxscale_monitor
      password=password
      monitor_interval=2000ms
       
      [schema-service]
      type=service
      router=schemarouter
      servers=srv01,srv02
      user=maxscale
      password=password
      auth_all_servers=1
       
      [schema-listener]
      type=listener
      service=schema-service
      protocol=MariaDBClient
      port=3306
      

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            Oy5p aegh Oy5p aegh
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration