Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
6.2.3, 6.2.4
-
None
-
centos7
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);
|