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

Maxscale 2.5.9 no longer allows `readwritesplit` router for read-only services

    XMLWordPrintable

Details

    • MXS-SPRINT-130

    Description

      user reported that they cannot use `readwritesplit` router for read-only services after upgrading to 2.5.9. Before, maxscale was v2.5.6.

      Mar 16 18:39:36 maxscale-staging-1 maxscale[3565997]: (931) [mariadbclient] Routing the query failed. Session will be closed.
      Mar 16 18:39:54 maxscale-staging-1 maxscale[3565997]: (932) [readwritesplit] (mariadb-reporting-service) [mariadb-reporting-service] Write query received from tocktix7@::ffff:10.8.11.4. Could not find a valid master connection. Closing
      client connection.
      Mar 16 18:39:54 maxscale-staging-1 maxscale[3565997]: (932) [readwritesplit] (mariadb-reporting-service) Could not find valid server for target type TARGET_MASTER (COM_QUERY: /* Username: mieko@tockhq.com, Task ID: 581faba5-0c08-4661-9b
      55-48f2e4b91991, Scheduled: False, Query Hash: 0e1a2394e409cfa1542e82c8e57f4ce8, Queue: queries, Query ID: adhoc */ select business.name, business.id, business_details.address_lat, business_details.address_lng, business.is_deleted, busi
      ness.is_authorized_by_tock, business.created_at
      from business_details
      join business on business.business_details_id = business_details.id
      where business_details.address_lat is null
      ;), closing connection.
       
      name: [node_secondary-0] status: [Slave, Running] state: [IN_USE] last opened at: [Tue Mar 16 18:39:54 2021] last closed at: [not closed] last close reason: [] num sescmd: [0]
      name: [node_secondary-1] status: [Slave, Running] state: [IN_USE|WAITING_RESULT] last opened at: [Tue Mar 16 18:39:54 2021] last closed at: [not closed] last close reason: [] num ses
      cmd: [1]
      

      Attached config and log file.

      Attachments

        1. maxscale.log
          148 kB
          Allen Lee
        2. ms.cfg
          3 kB
          Allen Lee

        Activity

          People

            markus makela markus makela
            allen.lee@mariadb.com Allen Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.