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
207
July 04, 2017 03:40AM
Re: global schema lock
92
July 04, 2017 03: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.