tcp - Influxdb 不关闭 TCP 连接
问题描述
1.1.1.1:8086
我从我的电脑 ( )连接到我的 influxdb ( 2.2.2.2
) 以执行一些查询。我发现,我的服务器保持连接打开:
netstat -tpn | grep 8086
tcp6 0 0 1.1.1.1:8086 2.2.2.2:50839 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:51890 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:48478 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:56878 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:52680 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:52580 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:57184 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:61375 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:51220 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:34310 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:52282 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:49720 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:52946 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:52501 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:57278 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:36788 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:50687 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:64940 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:64949 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:48236 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:46754 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:50046 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:60312 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:55634 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:65141 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:51456 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:59572 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:49993 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:54233 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:50674 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:64182 ESTABLISHED 48554/influxd
tcp6 0 0 1.1.1.1:8086 2.2.2.2:58076 ESTABLISHED 48554/influxd
当我在本地主机上尝试它时,当我停止发送查询或数据以几乎立即保存时,连接减少了。influxdb 也没有执行查询:
InfluxDB shell version: 1.6.0
> SHOW QUERIES
qid query database duration status
--- ----- -------- -------- ------
670 SHOW QUERIES 537µs running
如何在 linux 中关闭此会话?我应该如何配置 influxdb 以自动关闭此会话(在本地主机上我有默认配置)。
版本:
Python lib influxdb (5.1.0)
OS Ubuntu 16.04.5 LTS
程序:
from influxdb import InfluxDBClient
import random
host = '1.1.1.1'
port = 8086
user = 'user'
password = 'password'
dbname = 'database'
client = InfluxDBClient(host, port, user, password, dbname)
json_body = [{"measurement": "TEST",
"tags": {"Location": "local0"},
"fields": {"Value": random.random()}}]
print(json_body)
client.write_points(json_body)
解决方案
推荐阅读
- firebase - Firebase 数据库中子项的自动递增子项
- c# - 如何从自定义用户控件 WPF,C# 中的枚举自定义属性中获取值?
- javascript - 导出 React.JS 变量并在其他文件中使用
- postgresql - 根据最近的时间戳加入同一个表
- maven - Bamboo 无法在命令行中运行/读取带引号或双引号的 Maven 参数
- sql-server - 在可用报表生成器数据集中添加新数据点(变量)时矩阵的行数
- php - 在php中从单行的2列中获取值
- django - 用于移动应用程序的 Angular Web 应用程序代码库?
- c++ - 访问派生结构向量中的元素?
- spring-boot - 如何在使用 SpringBoot 应用程序的 RabbitMQ 连接错误后建立连接