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

Intermittent connection failure with MaxScale 1.2/1.3 using MariaDB/J 1.3

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.3.0, 1.4.0
    • Fix Version/s: 1.4.1
    • Component/s: mariadbclient
    • Labels:
      None

      Description

      Environment:
      3 nodes of MariaDB Galera Cluster
      1.2.1 or 1.3 MaxScale default configuration with galera monitor, RW split and readconnroute

      Test case with Simple python2 script (install jaydebeapi lib with pip first)

      import jaydebeapi
       
      for i in range(1,10000):
          conn = jaydebeapi.connect('org.mariadb.jdbc.Driver', ['jdbc:mariadb://192.168.99.100:4008/option_service', 'root', 'admin'],'../mariadb-java-client-1.3.4.jar',)
          curs = conn.cursor()
          curs.execute('select ' + str(i) + ';')
          data = curs.fetchall()
          for val in data:
              print val[0].value
          conn.close()

      After some iterations:

      1
      ...
      430
      Traceback (most recent call last):
        File "jdbc.py", line 4, in <module>
          conn = jaydebeapi.connect('org.mariadb.jdbc.Driver', ['jdbc:mariadb://192.168.50.104:4008/test', 'maxuser', 'maxpwd'],'mariadb-java-client-1.3.4.jar',)
        File "/usr/lib/python2.7/site-packages/jaydebeapi/__init__.py", line 359, in connect
          jconn = _jdbc_connect(jclassname, jars, libs, *driver_args)
        File "/usr/lib/python2.7/site-packages/jaydebeapi/__init__.py", line 183, in _jdbc_connect_jpype
          return jpype.java.sql.DriverManager.getConnection(*driver_args)
      jpype._jexception.SQLInvalidAuthorizationSpecExceptionPyRaisable: java.sql.SQLInvalidAuthorizationSpecException: Could not connect: Access denied for user ''@'192.168.50.1' (using password: NO)
       

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              markus makela markus makela
              Reporter:
              tanj Guillaume Lefranc
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: