MySQL Forums
Forum List  »  NDB clusters

Waiting for commit lock
Posted by: Mouhsen Ibrahim
Date: July 12, 2017 03:27AM

Hi everybody,

I need help with this problem please,
I have an NDB cluster with two management nodes, two api nodes and two data nodes
this is the output of "show" command in management console:

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)

One of my api servers (the one with id=14) is stuck with system user waiting for commit lock and all queries which insert data to my database are waiting for global read lock the other server is working just fine and I can execute insert queries on it, nothing special in the error log.

Also all data nodes are connected with this server as you can see here:

mysql> select * from ndbinfo.nodes;
+---------+--------+---------+-------------+-------------------+
| node_id | uptime | status | start_phase | config_generation |
+---------+--------+---------+-------------+-------------------+
| 12 | 693397 | STARTED | 0 | 1 |
| 13 | 691556 | STARTED | 0 | 1 |
+---------+--------+---------+-------------+-------------------+
2 rows in set (0.00 sec)

These are the contents of "/etc/my.cnf"
[mysqld]
ndbcluster
bind-address=192.168.2.22
sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
performance_schema

server-id=2

default-storage-engine=NDBCLUSTER
log_error=/var/log/mysql/error.log
long_query_time = 1
slow_query_log=ON
log-bin=/var/log/mysql/mysql-bin.log
binlog_do_db=fastestcow
expire_logs_days = 7
binlog_format=STATEMENT

skip-symbolic-links
local-infile=0

[mysql_cluster]
ndb-connectstring=192.168.2.29:1186


Please I need help with this, why this server is giving errors and the other one is just fine

thanks a lot.

Options: ReplyQuote


Subject
Views
Written By
Posted
Waiting for commit lock
69
July 12, 2017 03:27AM
23
July 14, 2017 12:03PM
18
July 16, 2017 03:19AM


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.