Bug #86243 SHOW PLUGIN command should take care of plugins in PLUGIN_IS_DYING state as well
Submitted: 9 May 2017 12:53 Modified: 19 Oct 2017 17:33
Reporter: Mayank Prasad Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:8.0.1 OS:Any
Assigned to: Marc ALFF CPU Architecture:Any

[9 May 2017 12:53] Mayank Prasad
Description:
During uninstalling a plugin, before the plugin gets uninstalled completely, if from another session "show plugins" is issued, then there would be an ASSERT failure.

"mysqld: /home/mayank/mysql-tree/mysql-trunk-wl8879/sql/sql_show.cc:255: bool show_plugins(THD*, plugin_ref, void*): Assertion `0' failed.
12:03:46 UTC - mysqld got signal 6 ;"

How to repeat:
Session 1:
install a plugin;
uninstall a plugin; (make sure to have a plugin which takes good amount of time here)

Session 2:
show plugins;

Suggested fix:
Add a case for PLUGIN_IS_DYING in switch in show_plugins():sql_show.cc
[19 Oct 2017 17:33] Paul DuBois
Posted by developer:
 
Fixed in 8.0.4, 9.0.0.

SHOW PLUGINS did not handle plugins that were terminating, resulting
in a server exit. The statement now displays the status for such
plugins as DELETING.