Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-4091

Maxscale Redis | Spyder Deployments are failing (OperationalError: (2013, 'Lost connection to MySQL server during query'))

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.2.3, 6.2.4
    • 6.3.1
    • maxbase
    • 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);
      

      Attachments

        1. redis (1).log-1.gz
          8.41 MB
        2. maxscale (3).log-backup_test-29032022.zip
          2.23 MB
        3. test.csv
          0.0 kB
        4. maxscale_config (3).txt
          6 kB

        Activity

          People

            johan.wikman Johan Wikman
            ponsuresh.pandians Pon Suresh Pandian (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            1 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.