gpt4 book ai didi

postgresql - 在 PostgreSQL 日志中获取 "incomplete startup packet"

转载 作者:行者123 更新时间:2023-12-03 03:37:02 30 4
gpt4 key购买 nike

我有一个在 PostgreSQL(版本 11.6)上运行的数据仓库(Unix Debian),它从 2 个远程服务器导入数据并处理它们并将其用于报告。一切似乎都工作正常,但在 PostgreSQL 日志中我得到了下面的消息非常频繁,每一秒我都会不断收到此消息。

当我在谷歌搜索时,各种帖子说这可以被忽略,并且一旦 postgres 服务重新启动就会发生这种情况,但我对此不确定。

为什么要记录这么多数据包/信息,从字面上看,当我实时看到这些条目时,这些条目会不断堆积。

谁能帮我识别一下,

  1. 这是什么原因?
  2. 这有害吗?或者有什么需要担心的吗?
  3. 日志是否会因此增长到无法控制的大小?
2019-12-05 13:17:29.930 UTC [24101] [unknown]@[unknown] LOG:  incomplete startup packet
2019-12-05 13:17:30.657 UTC [24102] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:30.723 UTC [24103] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:31.004 UTC [24104] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:31.118 UTC [24105] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:31.752 UTC [24106] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:32.285 UTC [24107] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:32.494 UTC [24108] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:32.511 UTC [24109] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:32.513 UTC [24110] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:33.216 UTC [24111] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:33.989 UTC [24112] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:34.950 UTC [24113] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:35.210 UTC [24114] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:35.511 UTC [24115] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:38.839 UTC [24116] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:39.938 UTC [24117] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:40.238 UTC [24118] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:40.686 UTC [24119] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:40.971 UTC [24120] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:41.348 UTC [24121] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:42.006 UTC [24122] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:42.068 UTC [24123] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:42.489 UTC [24124] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:42.622 UTC [24125] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:42.702 UTC [24126] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:42.719 UTC [24127] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:43.325 UTC [24128] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:44.225 UTC [24129] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:45.276 UTC [24130] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:45.444 UTC [24131] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:45.812 UTC [24132] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:49.016 UTC [24133] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:50.044 UTC [24135] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:50.558 UTC [24136] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:50.795 UTC [24137] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:51.135 UTC [24138] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:51.553 UTC [24139] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:52.377 UTC [24140] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:52.698 UTC [24141] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:52.730 UTC [24142] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:52.915 UTC [24143] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:52.944 UTC [24144] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:53.423 UTC [24145] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:54.440 UTC [24146] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:55.524 UTC [24147] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:55.666 UTC [24148] [unknown]@[unknown] LOG: incomplete startup packet
2019-12-05 13:17:56.097 UTC [24149] [unknown]@[unknown] LOG: incomplete startup packet

谢谢

最佳答案

这很可能是一个监控程序或类似的程序,定期测试是否可以打开到数据库服务器的 TCP 连接。

这些消息是无害的,可以忽略。 PostgreSQL v13 won't output these messages any more .

关于postgresql - 在 PostgreSQL 日志中获取 "incomplete startup packet",我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/59196280/

30 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com