MySQL Bugs: #86243: SHOW PLUGIN command should take care of plugins in PLUGIN_IS

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

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

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.