MySQL Forums :: NDB clusters :: Cluster Error


Advanced Search

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 359 Ganapathy Arvindan 12/26/2016 07:37AM
Re: Cluster Error 147 Mikael Ronström 12/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.