MySQL Forums
Forum List  »  NDB clusters

[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Posted by: kashif sheik
Date: August 27, 2019 12:51AM

I have a MYSQL NDB Cluster with the below configuration:

ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.252.4.92 (mysql-5.6.28 ndb-7.4.10, Nodegroup: 0)
id=3 @10.252.4.93 (mysql-5.6.28 ndb-7.4.10, Nodegroup: 0, *)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.252.4.89 (mysql-5.6.28 ndb-7.4.10)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 10.252.4.92)
id=5 @10.252.4.93 (mysql-5.6.28 ndb-7.4.10)

But i am unable to start the id:4 (SQL Node) as it is failing with the below error :

2019-08-27 05:49:04 0 [Note] /usr/sbin/mysqld (mysqld 5.6.28-ndb-7.4.10-cluster-gpl) starting as process 7764 ...
2019-08-27 05:49:04 7764 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
2019-08-27 05:49:04 7764 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

[root@sjgrcabt104 mysql]# cat /etc/my.cnf
[mysqld]
#innodb=OFF
#ignore-builtin-innodb
#skip-innodb
ndbcluster
ndb-connectstring=10.252.4.89 # IP address for server management node
default_storage_engine=ndbcluster # Define default Storage Engine used by MySQL
default-tmp-storage-engine=ndbcluster
#user=root
#password=MyNewPass123
#skip-grant-tables
#datadir=/usr/lib64/mysql
[mysql_cluster]
ndb-connectstring=10.252.4.89 # IP address for server management node

Options: ReplyQuote


Subject
Views
Written By
Posted
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
985
August 27, 2019 12:51AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.