wsrep_desync warnings
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL patches by Codership |
New
|
High
|
Unassigned | |||
5.5 |
New
|
High
|
Unassigned | |||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
5.5 |
Fix Released
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
With 5.6,
mysql> set global wsrep_desync=ON;
Query OK, 0 rows affected, 2 warnings (0.02 sec)
mysql> show warnings;
+------
| Level | Code | Message |
+------
| Warning | 1292 | Truncated incorrect DOUBLE value: 'ON' |
| Warning | 1231 | 'wsrep_desync' is already OFF. |
+------
2 rows in set (0.00 sec)
mysql> show global variables like '%desync%';
+------
| Variable_name | Value |
+------
| wsrep_desync | ON |
+------
1 row in set (0.01 sec)
............
...........
mysql> set global wsrep_desync=OFF;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> show warnings
-> ;
+------
| Level | Code | Message |
+------
| Warning | 1292 | Truncated incorrect DOUBLE value: 'OFF' |
+------
1 row in set (0.00 sec)
Related branches
description: | updated |
There is also IMHO wrong error when turning the desync to ON twice:
pxc2>show global variables like 'wsrep_desync'; ------- --+---- ---+ ------- --+---- ---+ ------- --+---- ---+
+------
| Variable_name | Value |
+------
| wsrep_desync | OFF |
+------
1 row in set (0.00 sec)
pxc2>set global wsrep_desync=1;
Query OK, 0 rows affected (0.01 sec)
pxc2>set global wsrep_desync=1;
ERROR 1396 (HY000): Operation 'desync' failed for set global wsrep_desync=1
pxc2>show warnings; ---+--- ---+--- ------- ------- ------- ------- ------- ------- ------- -----+ ---+--- ---+--- ------- ------- ------- ------- ------- ------- ------- -----+ ---+--- ---+--- ------- ------- ------- ------- ------- ------- ------- -----+
+------
| Level | Code | Message |
+------
| Warning | 1231 | 'wsrep_desync' is already ON. |
| Error | 1396 | Operation 'desync' failed for set global wsrep_desync=1 |
+------
2 rows in set (0.00 sec)
But:
pxc2>set global wsrep_desync=0;
Query OK, 0 rows affected (0.00 sec)
pxc2>set global wsrep_desync=0;
Query OK, 0 rows affected, 1 warning (0.00 sec)
pxc2>show warnings; ---+--- ---+--- ------- ------- ------- ------- -+ ---+--- ---+--- ------- ------- ------- ------- -+ ---+--- ---+--- ------- ------- ------- ------- -+
+------
| Level | Code | Message |
+------
| Warning | 1231 | 'wsrep_desync' is already OFF. |
+------
1 row in set (0.00 sec)
Tested on both PXC 5.5 and 5.6.