connection to db close_wait

asked 2020-04-04 13:16:18 -0500

tien86 gravatar image

I install 3 controller and 1 lb,

While check the controller. I see a lot of process of nova-api and keystone is in state close_wait for long. nova-api ---> LB --> database This is I know is big problem. But I haven't find an idea how to fix this problem. Please take a look and give me some comment. Hope be helped.

Other I found a lot of nova-api create connection to dataabase ( ESTABLISHED ), however almost are in sleep state. I don't know why they sleep there alot and quite long?

neutron-s 3203 neutron 18u IPv4 11259895 0t0 TCP 10.1.17.101:57006->10.1.17.106:mysql (CLOSE_WAIT) nova-api 18132 nova 10u IPv4 11219792 0t0 TCP 10.1.17.101:56432->10.1.17.106:mysql (CLOSE_WAIT) nova-api 18132 nova 11u IPv4 11219793 0t0 TCP 10.1.17.101:56434->10.1.17.106:mysql (CLOSE_WAIT) nova-api 18132 nova 12u IPv4 11219794 0t0 TCP 10.1.17.101:56436->10.1.17.106:mysql (CLOSE_WAIT) nova-api 18133 nova 11u IPv4 11237649 0t0 TCP 10.1.17.101:56664->10.1.17.106:mysql (CLOSE_WAIT) nova-api 18133 nova 12u IPv4 11237650 0t0 TCP 10.1.17.101:56666->10.1.17.106:mysql (CLOSE_WAIT) nova-api 18133 nova 13u IPv4 11237651 0t0 TCP 10.1.17.101:56668->10.1.17.106:mysql (CLOSE_WAIT) nova-api 18134 nova 10u IPv4 11207060 0t0 TCP 10.1.17.101:56218->10.1.17.106:mysql (CLOSE_WAIT) nova-api 18134 nova 11u IPv4 11207061 0t0 TCP 10.1.17.101:56220->10.1.17.106:mysql (CLOSE_WAIT) nova-api 18134 nova 12u IPv4 11207062 0t0 TCP 10.1.17.101:56222->10.1.17.106:mysql (CLOSE_WAIT) httpd 18623 keystone 15u IPv4 11221562 0t0 TCP 10.1.17.101:56428->10.1.17.106:mysql (CLOSE_WAIT) httpd 18641 keystone 15u IPv4 11235026 0t0 TCP 10.1.17.101:56662->10.1.17.106:mysql (CLOSE_WAIT) httpd 18653 keystone 15u IPv4 11220658 0t0 TCP 10.1.17.101:56430->10.1.17.106:mysql (CLOSE_WAIT)

Every 1.0s: mysqladmin --user=root --password=Admin@123 processlist |grep nova Sun Apr 5 01:15:36 2020

| 144505 | nova | 10.1.17.104:38158 | nova | Sleep | 1 | | | 0.000 | | 144518 | nova | 10.1.17.104:40706 | nova | Sleep | 5 | | | 0.000 | | 144530 | nova | 10.1.17.104:43298 | nova | Sleep | 2 | | | 0.000 | | 144538 | nova | 10.1.17.104:46576 | nova | Sleep | 15 | | | 0.000 | | 144765 | nova | 10.1.17.104:53240 | nova | Sleep | 2 | | | 0.000 | | 144851 | nova | 10.1.17.104:49728 | nova | Sleep | 2 | | | 0.000 | | 144873 | nova | 10.1.17.104:55802 | nova_placement | Sleep | 53 | | | 0.000 | | 144895 | nova | 10.1.17.104:32890 | nova | Sleep | 11 | | | 0.000 | | 144958 | nova | 10.1.17.104:44232 | nova | Sleep | 2 | | | 0.000 | | 144967 | nova | 10.1.17.104:44744 | nova | Sleep | 2 | | | 0.000 | | 144969 | nova | 10.1.17.104:44790 | nova | Sleep | 1 | | | 0.000 | | 144970 | nova | 10.1.17.104:44804 | nova | Sleep | 1 | | | 0 ... (more)

edit retag flag offensive close merge delete