[MXS-4091] Maxscale Redis | Spyder Deployments are failing (OperationalError: (2013, 'Lost connection to MySQL server during query')) Created: 2022-04-12  Updated: 2022-06-01  Resolved: 2022-04-25

Status: Closed
Project: MariaDB MaxScale
Component/s: maxbase
Affects Version/s: 6.2.3, 6.2.4
Fix Version/s: 6.3.1

Type: Bug Priority: Major
Reporter: Pon Suresh Pandian (Inactive) Assignee: Johan Wikman
Resolution: Fixed Votes: 1
Labels: None
Environment:

centos7

Attachments: Zip Archive maxscale (3).log-backup_test-29032022.zip     Text File maxscale_config (3).txt     File redis (1).log-1.gz     File test.csv    

 Description   

Hi Team,

We have galera cluster with three nodes and we have maxscale on top of Galera cluster, so we are trying to deploy the few data sheets using spyder tool.

CASE1: When we enabled the maxscale with redis cache then we are getting the below error.

exec(compile(f.read(), filename, 'exec'), namespace)
 
 
 
File "C:/Bave/C stack/baveautomation_v2.py", line 405, in <module>
 
(proj_nm, req_by, req_date, access_type_cd, access_type_desc, status, @dummy, @dummy, @dummy, @dummy, @dummy);""")
 
 
 
File "C:\ProgramData\Anaconda3\lib\site-packages\MySQLdb\cursors.py", line 206, in execute
 
res = self._query(query)
 
 
 
 
 
File "C:\ProgramData\Anaconda3\lib\site-packages\MySQLdb\cursors.py", line 319, in _query
 
db.query(q)
 
 
 
 
 
File "C:\ProgramData\Anaconda3\lib\site-packages\MySQLdb\connections.py", line 259, in query
 
_mysql.connection.query(self, query)
 
 
 
OperationalError: (2013, 'Lost connection to MySQL server during query')

CASE2:

When we disabled the maxscale with redis cache then we are not getting any errors and deployment went fine.

Attaching the maxscale config file and error log.

Below is the command: We are trying to load the data from Maxscale(Cache enabled).

Sample Table :

CREATE TABLE `t1` (
 
`id` int(11) NOT NULL,
 
`empid` int(11) NOT NULL
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8

SQL Command:

LOAD DATA LOCAL INFILE 'C:/Users/xxxx/Desktop/test.csv'
 
INTO TABLE test1.t1
 
FIELDS TERMINATED BY ','
 
OPTIONALLY ENCLOSED BY '"'
 
LINES TERMINATED BY '\r\n'
 
IGNORE 1 LINES
 
(id,empid);


Generated at Thu Feb 08 04:26:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.