Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-2091

LOAD DATA INFILE fails with ERROR 1180 (HY000): wsrep_max_ws_rows exceeded even when wsrep_on is OFF

    Details

    • Type: Bug
    • Status: Done
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.7.21-29.26
    • Fix Version/s: 5.6.40, 5.7.22
    • Component/s: None
    • Security Level: Public Bug
    • Labels:
    • Environment:

      MySQL         PXC 5.7.21

      OS               Ubuntu 16.04

      Description

      Hello,

      LOAD DATA IN FILE operations is failing with ERROR 1180 (HY000): wsrep_max_ws_rows exceeded even when wsrep_on is disabled for that session.

      Though log_bin is enabled and binary logs has to be generated, evaluating wsrep_ws_max_rows when wsrep_on disabled is not expected while executing a DML statement like LOAD DATA INFILE query.

       

      Steps to reproduce:

      • Connect to PXC 5.7 instance.
      • Disable wsrep_on for the session.

                 SET wsrep_on = 0 ;

      • Ensure Binary logging is ON;

                 SELECT @@log_bin ;

      • Set wsrep_max_ws_rows to non zero value.

                SET GLOBAL wsrep_max_ws_rows = 10000 ;  --> 10K

      • Generate a CSV file for LOAD DATA command with 100K rows.

                 Run LOAD DATA

       Run time report:

      mysql> select @@Version ; select @@Version_comment ; select @@log_bin ; set global wsrep_max_ws_rows = 100000; select @@wsrep_max_ws_rows ; set wsrep_on = 0 ; select @@wsrep_on ;
      +------------------+
      | @@Version        |
      +------------------+
      | 5.7.21-20-57-log |
      +------------------+
      1 row in set (0.01 sec)
      
      +-------------------------------------------------------------------------------------------------+
      | @@Version_comment                                                                               |
      +-------------------------------------------------------------------------------------------------+
      | Percona XtraDB Cluster (GPL), Release rel20, Revision 1702aea, WSREP version 29.26, wsrep_29.26 |
      +-------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)
      
      +-----------+
      | @@log_bin |
      +-----------+
      |         1 |
      +-----------+
      1 row in set (0.00 sec)
      
      Query OK, 0 rows affected (0.00 sec)
      
      +---------------------+
      | @@wsrep_max_ws_rows |
      +---------------------+
      |              10000 |
      +---------------------+
      1 row in set (0.00 sec)
      
      Query OK, 0 rows affected (0.00 sec)
      
      +------------+
      | @@wsrep_on |
      +------------+
      |          0 |
      +------------+
      1 row in set (0.00 sec)
      
      mysql> use PXC_LOAD ; truncate table loadtable ; LOAD DATA INFILE "/var/lib/mysql-files/load_table.csv" INTO TABLE loadtable ;
      Database changed
      Query OK, 0 rows affected (0.37 sec)
      ERROR 1180 (HY000): wsrep_max_ws_rows exceeded
      
      mysql> 
      mysql> system wc -l /var/lib/mysql-files/load_table.csv
      100000 /var/lib/mysql-files/load_table.csv
      mysql

      NOTE: We have observed this in PXC 5.6.39 as well.

        Attachments

          Expenses

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                uday.varagani Uday Varagani
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 4 hours, 30 minutes
                  4h 30m