Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-256

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: Not a Bug
    • Affects Version/s: None
    • Fix Version/s: 1.3.6
    • Component/s: Other
    • 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)
       

      I posted an issue in MaxScale since this regards both connector and MaxScale
      Bug is not reproducible with Connector/J 1.2 and does not happen when connecting directly to the server

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              diego dupin Diego Dupin
              Reporter:
              tanj Guillaume Lefranc
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.