Bug #84339 Error While configuring MySQL Cluster
Submitted: 26 Dec 2016 11:57 Modified: 26 Dec 2016 12:13
Reporter: Ganapathy Arvindan Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S1 (Critical)
Version:5.5 OS:Windows (Server 2012)
Assigned to: CPU Architecture:Any
Tags: Cluster Error

[26 Dec 2016 11:57] Ganapathy Arvindan 
Description:
Configured all the things correctly in MGMD Node i am getting this output

C:\mysql\Bin>ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @192.168.11.145  (mysql-5.7.16 ndb-7.5.4, Nodegroup: 0, *)
id=3    @192.168.11.146  (mysql-5.7.16 ndb-7.5.4, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.11.142  (mysql-5.7.16 ndb-7.5.4)

[mysqld(API)]   1 node(s)
id=4 (not connected, accepting connect from 192.168.11.140)

In 192.168.11.140 (SQL Node )
while executing this statement "C:\mysql\mysql-cluster-gpl-7.5.4-winx64\bin>mysqld --defaults-file="C:\Program F
iles (x86)\MySQL\MySQL Server 5.5\my.ini" --console"

I am getting this below error:

2016-12-26T11:52:18.994111Z 0 [ERROR] unknown variable 'innodb_additional_mem_po
ol_size=50M'
2016-12-26T11:52:18.994111Z 0 [ERROR] Aborting

How to repeat:
In 192.168.11.140 (SQL Node )
while executing this statement "C:\mysql\mysql-cluster-gpl-7.5.4-winx64\bin>mysqld --defaults-file="C:\Program F
iles (x86)\MySQL\MySQL Server 5.5\my.ini" --console"

I am getting this below error:

2016-12-26T11:52:18.994111Z 0 [ERROR] unknown variable 'innodb_additional_mem_po
ol_size=50M'
2016-12-26T11:52:18.994111Z 0 [ERROR] Aborting
[26 Dec 2016 12:02] MySQL Verification Team 
Hi Ganapathy Arvindan,

Thank you for the report.
Imho innodb_additional_mem_pool_size was deprecated in MySQL 5.6.3 and removed in MySQL 5.7.4.  Please comment out the variable and check.

Thanks,
Umesh
[26 Dec 2016 12:13] Ganapathy Arvindan 
after disabling it

2016-12-26T12:14:14.882760Z 0 [ERROR] Incorrect definition of table performance_
schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID'
 at position 0 to have type bigint(20), found type int(11).
2016-12-26T12:14:14.882760Z 0 [ERROR]
2016-12-26T12:14:14.882760Z 0 [ERROR]
2016-12-26T12:14:14.882760Z 0 [ERROR]
2016-12-26T12:14:14.882760Z 0 [ERROR]
2016-12-26T12:14:14.882760Z 0 [ERROR]
2016-12-26T12:14:14.882760Z 0 [ERROR] Incorrect definition of table performance_
schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to h
ave type bigint(20), found type int(11).
2016-12-26T12:14:14.882760Z 0 [ERROR]
2016-12-26T12:14:14.882760Z 0 [ERROR] Incorrect definition of table performance_
schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position
 2 to have type bigint(20), found type int(11).
2016-12-26T12:14:14.882760Z 0 [ERROR]
2016-12-26T12:14:14.898341Z 0 [ERROR]
2016-12-26T12:14:14.898341Z 0 [ERROR]
2016-12-26T12:14:14.898341Z 0 [ERROR]
2016-12-26T12:14:14.898341Z 0 [ERROR]
2016-12-26T12:14:14.898341Z 0 [ERROR]
2016-12-26T12:14:14.898341Z 0 [ERROR]
2016-12-26T12:14:14.898341Z 0 [ERROR]
2016-12-26T12:14:14.898341Z 0 [ERROR]
2016-12-26T12:14:14.898341Z 0 [ERROR]
2016-12-26T12:14:14.898341Z 0 [ERROR]
2016-12-26T12:14:14.898341Z 0 [ERROR]
2016-12-26T12:14:14.898341Z 0 [ERROR]
2016-12-26T12:14:14.898341Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.913942Z 0 [ERROR]
2016-12-26T12:14:14.929557Z 0 [ERROR]
2016-12-26T12:14:14.929557Z 0 [ERROR]
2016-12-26T12:14:14.929557Z 0 [ERROR]
2016-12-26T12:14:14.929557Z 0 [ERROR]
2016-12-26T12:14:14.929557Z 0 [ERROR]
2016-12-26T12:14:14.929557Z 0 [ERROR]
2016-12-26T12:14:14.929557Z 0 [ERROR]
2016-12-26T12:14:14.929557Z 0 [ERROR]
2016-12-26T12:14:14.929557Z 0 [ERROR]
2016-12-26T12:14:14.929557Z 0 [ERROR]
2016-12-26T12:14:14.929557Z 0 [ERROR]
2016-12-26T12:14:14.929557Z 0 [ERROR]
2016-12-26T12:14:14.929557Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.945154Z 0 [ERROR]
2016-12-26T12:14:14.960741Z 0 [ERROR]
2016-12-26T12:14:14.960741Z 0 [ERROR]
2016-12-26T12:14:14.960741Z 0 [ERROR]
2016-12-26T12:14:14.960741Z 0 [ERROR]
2016-12-26T12:14:14.960741Z 0 [ERROR]
2016-12-26T12:14:14.960741Z 0 [ERROR]
2016-12-26T12:14:14.960741Z 0 [ERROR]
2016-12-26T12:14:14.960741Z 0 [ERROR]
2016-12-26T12:14:14.960741Z 0 [ERROR]
2016-12-26T12:14:14.960741Z 0 [ERROR]
2016-12-26T12:14:14.960741Z 0 [ERROR]
2016-12-26T12:14:14.960741Z 0 [ERROR] Incorrect definition of table mysql.db: ex
pected column 'User' at position 2 to have type char(32), found type char(16).
2016-12-26T12:14:14.960741Z 0 [ERROR] mysql.user has no `Event_priv` column at p
osition 28
2016-12-26T12:14:14.960741Z 0 [ERROR] Event Scheduler: An error occurred when in
itializing system tables. Disabling the Event Scheduler.
2016-12-26T12:14:14.976352Z 0 [Note]

These are the msg i am getting
[26 Dec 2016 12:32] MySQL Verification Team 
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.