Bug #81564 ps_setup_show_enabled and ps_setup_show_disabled and company issues
Submitted: 24 May 2016 8:23 Modified: 30 Jun 2016 16:27
Reporter: Jesper wisborg Krogh Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: SYS Schema Severity:S3 (Non-critical)
Version:5.7.12 OS:Any
Assigned to: CPU Architecture:Any

[24 May 2016 8:23] Jesper wisborg Krogh
There are a few issues issues with the various procedures to show enabled and disabled parts of the Performance Schema:

* Enabled and disabled accounts are shown as host@user
* Disabled accounts in ps_setup_show_disabled are called enabled_users
* There is no explicit ordering; this can cause random changes in the output which also affects testing, e.g. the sysschem.pr_ps_setup_show_enabled test is randomly failing

How to repeat:
See the source code.
[24 May 2016 9:35] Jesper wisborg Krogh
Posted by developer:
setup_actors are not filtered either (all rows returned whether the actor is enabled or disabled)
[30 Jun 2016 16:27] Paul DuBois
Posted by developer:
Noted in 5.7.14 changelog.

Several issues were addressed in the sys schema stored procedures
that show enabled or disabled Performance Schema setup:

* Enabled and disabled accounts were shown as host@user, not user@host.

* Disabled users in ps_setup_show_disabled were called enabled_users.

* setup_actors content was not filtered (all rows were returned whether
  the actor was enabled or disabled).

* Output is now ordered to be more deterministic.