wsrep_local_bf_aborts not updating
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Confirmed
|
Undecided
|
Unassigned | ||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
New
|
Undecided
|
Unassigned |
Bug Description
[root@node1 ~]# rpm -qa | grep -i percona
Percona-
Percona-
percona-
Percona-
Percona-
percona-
Percona-
| wsrep_provider_
3 node cluster. Triggering a brute-force abort does not increment wsrep_local_
Two nodes (in two transactions):
node1 mysql> set autocommit=off;
Query OK, 0 rows affected (0.00 sec)
node1 mysql> select * from test.autoinc;
+---+---------+
| i | j |
+---+---------+
| 2 | default |
| 5 | default |
| 8 | default |
+---+---------+
3 rows in set (0.00 sec)
node1 mysql> update test.autoinc set j="node1" where i = 2;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
NO COMMIT
On node3:
node3 mysql> select * from test.autoinc;
+---+---------+
| i | j |
+---+---------+
| 2 | default |
| 5 | default |
| 8 | default |
+---+---------+
3 rows in set (0.00 sec)
node3 mysql> update test.autoinc set j="node3" where i=2;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
node3 mysql> commit;
Query OK, 0 rows affected (0.01 sec)
Node 1's transaction aborted as expected:
node1 mysql> select * from test.autoinc;
ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
But no increment on wsrep_local_
node1 mysql> show global status like 'wsrep_
+------
| Variable_name | Value |
+------
| wsrep_local_
+------
1 row in set (0.00 sec)
Changed in codership-mysql: | |
status: | New → Confirmed |
Just a quick update. I do see bf_aborts incrementing when doing a load test with two sysbench runs on two nodes. It seems as if it something specific about the manual case above where the cluster is idle otherwise and things are moving slowly.