Normal select queries with group by generate writesets
Bug #1638138 reported by
Miguel Angel Nieto
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_
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: | 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 |
To post a comment you must log in.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PXC-720