Normal select queries with group by generate writesets

Bug #1638138 reported by Miguel Angel Nieto
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Fix Released
Undecided
Unassigned

Bug Description

A SELECT query that runs inside a transaction seems to generate a writeset. So, it gets limited by wsrep_max_ws_rows variable. Use the latest 5.6 pxc where the variable has been enabled again:

mysql> set global wsrep_max_ws_rows=2;
mysql> start transaction;
mysql> select * from t group by i;
+------+
| i |
+------+
| 1 |
+------+

mysql> select * from t group by i;
+------+
| i |
+------+
| 1 |
+------+

mysql> select * from t group by i;
ERROR 1180 (HY000): wsrep_max_ws_rows exceeded

Tags: i148022
tags: added: i148022
Changed in percona-xtradb-cluster:
status: New → Confirmed
Changed in percona-xtradb-cluster:
status: Confirmed → Fix Committed
Changed in percona-xtradb-cluster:
milestone: none → 5.6.34-26.19
Changed in percona-xtradb-cluster:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-720

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.