You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
22 lines
762 B
22 lines
762 B
5 months ago
|
#
|
||
|
|
# Bug #24453571 SERVER CRASHES WHEN INSTALL COMPONENT IS ISSUED,
|
||
|
|
# AFTER MYSQL_UPGRADE
|
||
|
|
#
|
||
|
|
# Checking MYSQL_UPGRADE creates the missing mysql.component table
|
||
|
|
# when upgrading from 5.7. Simulating the senario by deleting the
|
||
|
|
# component table.
|
||
|
|
CALL mtr.add_suppression("Table 'mysql.component' doesn't exis");
|
||
|
|
CALL mtr.add_suppression("The mysql.component table is missing or has an incorrect definition.");
|
||
|
|
# Dropping component table.
|
||
|
|
DROP TABLE mysql.component;
|
||
|
|
# shutdown the server from mtr.
|
||
|
|
# restart the server.
|
||
|
|
# running mysql_upgrade
|
||
|
|
# restart:--upgrade=FORCE
|
||
|
|
INSTALL COMPONENT "file://component_example_component1";
|
||
|
|
# a component should present
|
||
|
|
SELECT COUNT(*) FROM mysql.component;
|
||
|
|
COUNT(*)
|
||
|
|
1
|
||
|
|
UNINSTALL COMPONENT "file://component_example_component1";
|