My Oracle Support Banner

MCMD Connections Stuck In CLOSE_WAIT State (Doc ID 1955704.1)

Last updated on FEBRUARY 11, 2019

Applies to:

MySQL Cluster - Version 7.1 to 7.3 [Release 7.1 to 7.3]
Information in this document applies to any platform.

Symptoms

Observed mcmd leaves a lot connections in CLOSE_WAIT state and is needed to restart mcmd from time to time to limit the number of open connections:

shell> netstat -ap 2>/dev/null | grep CLOSE_WAIT
tcp 1 0 host2:46923 host1:mysql-cluster CLOSE_WAIT 7298/mysqld
tcp 1 0 host2:mysql-cm-agent host1:39779 CLOSE_WAIT 1373/mcmd
tcp 1 0 host2:mysql-cm-agent host1:43945 CLOSE_WAIT 1373/mcmd
tcp 1 0 host2:mysql-cm-agent host1:41047 CLOSE_WAIT 1373/mcmd
tcp 1 0 host2:46922 host1:mysql-cluster CLOSE_WAIT 7298/mysqld
tcp 1 0 host2:46926 host1:mysql-cluster CLOSE_WAIT 7298/mysqld
tcp 1 0 host2:mysql-cm-agent host1:42675 CLOSE_WAIT 1373/mcmd
tcp 1 0 host2:mysql-cm-agent host1:39600 CLOSE_WAIT 1373/mcmd
tcp 1 0 host2:mysql-cm-agent host1:42496 CLOSE_WAIT 1373/mcmd
tcp 1 0 host2:mysql-cm-agent host1:44122 CLOSE_WAIT 1373/mcmd
tcp 1 0 host2:mysql-cm-agent host1:38154 CLOSE_WAIT 1373/mcmd
tcp 1 0 host2:46929 host1:mysql-cluster CLOSE_WAIT 7298/mysqld
tcp 1 0 host2:mysql-cm-agent host1:38332 CLOSE_WAIT 1373/mcmd
tcp 1 0 host2:mysql-cm-agent host1:41226 CLOSE_WAIT 1373/mcmd

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.