MySQL Forums
Forum List  »  NDB clusters

Cluster Error
Posted by: Ganapathy Arvindan
Date: December 26, 2016 07:37AM

MySQL Version : 5.5

Windows server 2012






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

after disabling this 'innodb_additional_mem_pool_size=50M'


i am getting this error

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]

Options: ReplyQuote


Subject
Views
Written By
Posted
Cluster Error
491
December 26, 2016 07:37AM
216
December 27, 2016 04:54AM


Sorry, you can't reply to this topic. It has been closed.

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.