时间戳

首页 > 解决方案 > 在 PostgreSQL 日志中获取“不完整的启动数据包”

postgresql - 在 PostgreSQL 日志中获取“不完整的启动数据包”

问题描述

我有一个在 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

谢谢

标签： postgresql

解决方案

这很可能是一个监视程序或类似的东西，它会定期测试它是否可以打开与数据库服务器的 TCP 连接。

这些消息是无害的，可以忽略。PostgreSQL v13将不再输出这些消息。

推荐阅读