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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.3.0, 1.4.0
    • 1.4.1
    • mariadbclient
    • 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

              markus makela markus makela
              tanj Guillaume Lefranc
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.