Cluster Error
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]
Subject
Views
Written By
Posted
Cluster Error
1381
December 26, 2016 07:37AM
593
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.