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

Reads are not retried if connection creation fails due to sub-service failure

    XMLWordPrintable

Details

    Description

      If readwritesplit is configured with lazy_connect=true and it uses another service as one of its targets, if the sub-service fails to create a new session when a read is being routed, the read will not be retried and instead an error about failing to find a valid target is logged:

      2025-01-31 12:51:04   error  : (1) [readwritesplit] (RW-Split-Router); Could not find valid server for target type TARGET_SLAVE (COM_QUERY: SELECT 1), closing connection. { Name: write-service Open: No Status: Master, Running },{ Name: bad-service Open: Broken Status: Slave, Running },{ Name: read-service Open: No Status: Slave, Running }
      

      This error is not correct as there is a valid server to which a connection could be created.

      Attachments

        Activity

          People

            markus makela markus makela
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.