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

Connection attributes are not passed on

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.4.2, 2.3.12
    • Fix Version/s: 2.5.0
    • Component/s: mariadbbackend
    • Labels:
      None
    • Sprint:
      MXS-SPRINT-96

      Description

      When connecting through maxscale custom connection attributes are not passed through.

      When e.g. connecting directly with the command line client, we can see the following connection attributes being set by the client:

      SELECT * 
        FROM performance_schema.session_connect_attrs 
       WHERE processlist_id = connection_id();
       
      +----------------+-----------------+------------+------------------+
      | PROCESSLIST_ID | ATTR_NAME       | ATTR_VALUE | ORDINAL_POSITION |
      +----------------+-----------------+------------+------------------+
      |             13 | _os             | Linux      |                0 |
      |             13 | _client_name    | libmariadb |                1 |
      |             13 | _pid            | 1889       |                2 |
      |             13 | _client_version | 3.0.10     |                3 |
      |             13 | _platform       | x86_64     |                4 |
      |             13 | program_name    | mysql      |                5 |
      |             13 | _server_host    | node-1     |                6 |
      +----------------+-----------------+------------+------------------+
      

      When connecting through maxscale, none of the connections attributes are visible in the PERFORMANCE_SCHEMA.SESSION_CONNECT_ATTRS table ...

      See also:

      https://mariadb.com/kb/en/library/mysql_optionsv/#connection-attribute-options

      https://mariadb.com/kb/en/library/performance-schema-session_connect_attrs-table/

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            hholzgra Hartmut Holzgraefe
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: