Critical 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.
