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

[readwritesplit] Failed to execute session command

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.20, 2.4.17, 2.5.11
    • Fix Version/s: 2.5.13, 2.3.21, 2.4.18
    • Component/s: readwritesplit
    • Labels:
      None
    • Environment:
      Debian buster, backend 10.4.19, 10.5.10

      Description

      Got this in logs:

      2021-06-01 07:20:25   info   : (2714773) Found matching user 'meshok7'@'%' for client 'meshok7'@'::ffff:10.0.0.1' with sufficient privileges.
      2021-06-01 07:20:25   info   : (2714773) [readwritesplit] (Read-Write-Service) Target connection counts:
      2021-06-01 07:20:25   info   : (2714773) [readwritesplit] (Read-Write-Service) current operations : 2 in        flea Slave, Running
      2021-06-01 07:20:25   info   : (2714773) [readwritesplit] (Read-Write-Service) current operations : 1 in        ladybug Slave, Running
      2021-06-01 07:20:25   info   : (2714773) [readwritesplit] (Read-Write-Service) current operations : 5 in        odonata Master, Running
      2021-06-01 07:20:25   info   : (2714773) (odonata) Sent COM_CHANGE_USER
      2021-06-01 07:20:25   info   : (2714773) [readwritesplit] (Read-Write-Service) Connected to 'odonata'
      2021-06-01 07:20:25   info   : (2714773) [readwritesplit] (Read-Write-Service) Selected Master: odonata
      2021-06-01 07:20:25   info   : (2714773) [readwritesplit] (Read-Write-Service) Connected to 'ladybug'
      2021-06-01 07:20:25   info   : (2714773) [readwritesplit] (Read-Write-Service) Selected Slave: ladybug
      2021-06-01 07:20:25   info   : (2714773) (flea) Sent COM_CHANGE_USER
      2021-06-01 07:20:25   info   : (2714773) [readwritesplit] (Read-Write-Service) Connected to 'flea'
      2021-06-01 07:20:25   info   : (2714773) [readwritesplit] (Read-Write-Service) Selected Slave: flea
      2021-06-01 07:20:25   info   : (2714773) Started Read-Write-Service client session [2714773] for 'meshok7' from ::ffff:10.0.0.1
      2021-06-01 07:20:25   info   : (2714773) Connected to 'ladybug' with thread id 729886
      2021-06-01 07:20:25   info   : (2714773) (Read-Write-Service) > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt:
      2021-06-01 07:20:25   info   : (2714773) [readwritesplit] (Read-Write-Service) Session write, routing to all servers.
      2021-06-01 07:20:25   info   : (2714773) (Read-Write-Service) Execute sescmd #1 on 'flea': [COM_QUIT]
      2021-06-01 07:20:25   info   : (2714773) (flea) COM_QUIT received while COM_CHANGE_USER is in progress, closing pooled connection
      2021-06-01 07:20:25   error  : (2714773) [readwritesplit] (Read-Write-Service) Failed to execute session command in flea
      2021-06-01 07:20:25   info   : (2714773) (Read-Write-Service) Execute sescmd #1 on 'ladybug': [COM_QUIT]
      2021-06-01 07:20:25   info   : (2714773) [readwritesplit] (Read-Write-Service) Route query to slave: ladybug
      2021-06-01 07:20:25   info   : (2714773) (Read-Write-Service) Execute sescmd #1 on 'odonata': [COM_QUIT]
      2021-06-01 07:20:25   info   : (2714773) (odonata) COM_QUIT received while COM_CHANGE_USER is in progress, closing pooled connection
      2021-06-01 07:20:25   error  : (2714773) [readwritesplit] (Read-Write-Service) Failed to execute session command in odonata
      2021-06-01 07:20:25   info   : (2714773) Authentication to 'ladybug' succeeded.
      2021-06-01 07:20:25   info   : Stopped Read-Write-Service client session [2714773]
      
      

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            alexcool Alex
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration