MCMD Connections Stuck In CLOSE_WAIT State (Doc ID 1955704.1)

Last updated on DECEMBER 05, 2016

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 EDESPR02:46923 EDESPR01:mysql-cluster CLOSE_WAIT 7298/mysqld
tcp 1 0 EDESPR02:mysql-cm-agent EDESPR01:39779 CLOSE_WAIT 1373/mcmd
tcp 1 0 EDESPR02:mysql-cm-agent EDESPR01:43945 CLOSE_WAIT 1373/mcmd
tcp 1 0 EDESPR02:mysql-cm-agent EDESPR01:41047 CLOSE_WAIT 1373/mcmd
tcp 1 0 EDESPR02:46922 EDESPR01:mysql-cluster CLOSE_WAIT 7298/mysqld
tcp 1 0 EDESPR02:46926 EDESPR01:mysql-cluster CLOSE_WAIT 7298/mysqld
tcp 1 0 EDESPR02:mysql-cm-agent EDESPR01:42675 CLOSE_WAIT 1373/mcmd
tcp 1 0 EDESPR02:mysql-cm-agent EDESPR01:39600 CLOSE_WAIT 1373/mcmd
tcp 1 0 EDESPR02:mysql-cm-agent EDESPR01:42496 CLOSE_WAIT 1373/mcmd
tcp 1 0 EDESPR02:mysql-cm-agent EDESPR01:44122 CLOSE_WAIT 1373/mcmd
tcp 1 0 EDESPR02:mysql-cm-agent EDESPR01:38154 CLOSE_WAIT 1373/mcmd
tcp 1 0 EDESPR02:46929 EDESPR01:mysql-cluster CLOSE_WAIT 7298/mysqld
tcp 1 0 EDESPR02:mysql-cm-agent EDESPR01:38332 CLOSE_WAIT 1373/mcmd
tcp 1 0 EDESPR02:mysql-cm-agent EDESPR01:41226 CLOSE_WAIT 1373/mcmd

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms