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

MaxScale select queries incorrectly returning strings instead of integers

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 2.4.4
    • Fix Version/s: N/A
    • Component/s: N/A
    • Labels:
    • Environment:
      CentOS 7, MaxScale 2.4.4, MariaDB 10.4.10

      Description

      When a SELECT query is run via MaxScale a result that should contain integers is being converted to strings.

      The query is being run from PHP.

      Amending the database connection to point directly to the master or slaves behind MaxScale resolves the problem and integers are correctly returned.

      This is the MacScale config we have in place:

      [maxscale]
      threads=auto
       
      # Server definitions
      #
       
      [service-sql1]
      type=server
      address=172.16.203.4
      port=3306
      protocol=MariaDBBackend
       
      [service-sql2]
      type=server
      address=172.16.203.5
      port=3306
      protocol=MariaDBBackend
       
      [service-sql3]
      type=server
      address=172.16.203.6
      port=3306
      protocol=MariaDBBackend
       
      [MariaDB-Monitor]
      type=monitor
      module=mariadbmon
      servers=service-sql1,service-sql2,service-sql3
      auto_failover=false
      auto_rejoin=false
      user=maxscale
      password=********************
      monitor_interval=2000
       
      [OLTP-Service]
      type=service
      disable_sescmd_history=true
      router=readwritesplit
      version_string=Maxscale2
      servers=service-sql1,service-sql2,service-sql3
      user=maxscale
      password=********************
       
      [OLTP-Listener]
      type=listener
      service=OLTP-Service
      protocol=MariaDBClient
      port=3306

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration