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