postgresql - PostgreSQL 空连接

Question

我将 Azure Database for Postgres 与 Kubernetes 应用程序一起使用。在过去的两天里，我对这个数据库有一些问题。看起来网络到数据库的工作有些错误（网络延迟大约是 600 毫秒，而它应该是 2-3 毫秒！）。

在日志上，我有很多很多这种“空”连接。

2021-10-28 16:29:12 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:12 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:12 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:12 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:12 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:12 UTC-617acfd8.58210-LOG:  duration: 0.000 ms
2021-10-28 16:29:12 UTC-617acfd8.58210-LOG:  duration: 0.000 ms
2021-10-28 16:29:12 UTC-617acfd8.58210-LOG:  duration: 0.000 ms
2021-10-28 16:29:12 UTC-617acfd8.58210-LOG:  duration: 0.000 ms
2021-10-28 16:29:12 UTC-617acfd8.58210-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acfd8.58210-LOG:  duration: 8500.520 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acea5.58098-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acfd8.58210-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acfd8.58210-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acfd8.58210-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acfd8.58210-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acfd8.58210-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acfd8.58210-LOG:  duration: 0.000 ms
2021-10-28 16:29:20 UTC-617acfd8.58210-LOG:  disconnection: session time: 0:00:08.734 user=azure_superuser database=azure_sys host=127.0.0.1 port=33915
2021-10-28 16:29:29 UTC-617ace8f.58074-LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

    
2021-10-28 16:29:29 UTC-617ace8f.58074-LOG:  disconnection: session time: 0:05:45.818 user= database= host=10.240.0.6 port=10881

我不确定这意味着什么？应用程序是否会以某种方式死锁连接？所有其他指标看起来都很好。有没有办法在 postgres 服务上修复它？

标签： postgresqlazurekubernetesnetworking