[PXC Strict Mode] The example on setting pxc_strict_mode as session variable doesn't work

Bug #1694095 reported by Jaime Sicam
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Confirmed
Undecided
Alexey Zhebel

Bug Description

[In:/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html]

"Note

It is better to start the server with the necessary mode (the default ENFORCING is highly recommended). However, you can dynamically change it during runtime. For example, to set PXC Strict Mode to PERMISSIVE, run the following command:

mysql> SET pxc_strict_mode=PERMISSIVE;"

But if you run this on Percona XtraDB Cluster 5.7.17-13-57-log, you get this error:
mysql> set pxc_strict_mode=permissive;
ERROR 1229 (HY000): Variable 'pxc_strict_mode' is a GLOBAL variable and should be set with SET GLOBAL

Tags: doc i197402
Jaime Sicam (jssicam)
Changed in percona-xtradb-cluster:
status: New → Confirmed
Revision history for this message
Jaime Sicam (jssicam) wrote :

Also, https://www.percona.com/doc/percona-xtradb-cluster/5.7/wsrep-system-index.html#pxc_strict_mode :

"
variable pxc_strict_mode
Version Info:
5.7 – Variable introduced
Command Line:
Yes
Config File:
Yes
Scope:
Global, Session
Dynamic:
Yes
Default Value:
ENFORCING or DISABLED
"

Revision history for this message
Krunal Bauskar (krunal-bauskar) wrote :

Variable has global scope. Doc needs update.

Changed in percona-xtradb-cluster:
assignee: nobody → Alexey Zhebel (alexey-zhebel)
tags: added: i197402
Revision history for this message
Alexey Zhebel (alexey-zhebel) wrote :

Will be tracked as part of https://jira.percona.com/browse/DOC-565

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-1985

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.