MySQL Forums
Forum List  »  NDB clusters

Re: global schema lock
Posted by: Mouhsen Ibrahim
Date: July 04, 2017 03:54AM

Hi, right now I am trying to execute this query "TRUNCATE TABLE performance_schema.events_statements_summary_by_digest" it just hangs with this state in the output of "SHOW PROCESSLIST"

"Waiting for ndbcluster global schema lock"

This is also the output of "ndb_mgm -e show"

Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=12 @192.168.2.21 (mysql-5.7.17 ndb-7.5.5, Nodegroup: 0, *)
id=13 @192.168.2.22 (mysql-5.7.17 ndb-7.5.5, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s)
id=1 @192.168.2.29 (mysql-5.7.17 ndb-7.5.5)
id=11 @192.168.2.20 (mysql-5.7.17 ndb-7.5.5)

[mysqld(API)] 2 node(s)
id=14 @192.168.2.22 (mysql-5.7.17 ndb-7.5.5)
id=15 @192.168.2.21 (mysql-5.7.17 ndb-7.5.5)



Edited 1 time(s). Last edit at 07/04/2017 03:55AM by Mouhsen Ibrahim.

Options: ReplyQuote


Subject
Views
Written By
Posted
56
July 04, 2017 03:40AM
Re: global schema lock
25
July 04, 2017 03:54AM


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.