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

Prepared statements do not work

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.5
    • Fix Version/s: 2.2.6
    • Component/s: readconnroute
    • Labels:
      None
    • Environment:
      RHEL 7
      JBoss 6.1
      Java 6
      mariadb-java-client-1.7.3.jar
      MariaDB 10.2.13
    • Sprint:
      MXS-SPRINT-58

      Description

      Hi there,

      I'm in simple setup. Two hosts: one master, one slave. All requests (W/R) are forwarded to the master.

      Here is my config:

      [maxscale]
      threads=auto
      logdir=/var/log/maxscale/
      piddir=/var/run/maxscale/
       
      [xxx1]
      type=server
      address=192.168.82.1
      port=3306
      protocol=MariaDBBackend
      serv_weight=1
       
      [xxxx2]
      type=server
      address=192.168.3.1
      port=3306
      protocol=MariaDBBackend
      serv_weight=0
       
      [MariaDB-Monitor]
      type=monitor
      module=mariadbmon
      servers=xxxx1,xxxx2
      user=xxx
      passwd=xxx
      monitor_interval=2000
      auto_failover=true
      detect_standalone_master=true
      auto_rejoin=true
      replication_user=replicator
      replication_password=xxxx
       
      [Readconn-Router-Service]
      type=service
      router=readconnroute
      servers=xxxx1,xxxx2
      router_options=master
      user=maxboy
      passwd=xxxx
      weightby=serv_weight
       
      [MaxAdmin-Service]
      type=service
      router=cli
       
      [CLI]
      type=service
      router=cli
       
      [RRS-Listener]
      type=listener
      service=Readconn-Router-Service
      protocol=MariaDBClient
      port=3306
      address=127.0.0.1
       
      [MaxAdmin-Listener]
      type=listener
      service=MaxAdmin-Service
      protocol=maxscaled
      socket=default
       
      [CLI Listener]
      type=listener
      service=CLI
      protocol=maxscaled
      address=localhost
      port=6603
      

      When executing a batch of prepared statements from my application, I encounter a JAVA Exception.

      You will find the Exception as an attachment.

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            BobSauvage Bob Sauvage
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: