Обсуждение: incomplete startup packet
Hi -am monitoring the postgresql9.2.4 using monit in my virtual private server. Am always getting following log 2013-08-21 06:02:33 UTC LOG: incomplete startup packet 2013-08-21 06:04:33 UTC LOG: incomplete startup packet 2013-08-21 06:06:33 UTC LOG: incomplete startup packet -why these happening how to solve this.I googled it but cant find proper solution. pls guide me Thanks
On Wed, Aug 21, 2013 at 3:11 AM, alfred <alfred@arrivusystems.com> wrote:
-- Hi
-am monitoring the postgresql9.2.4 using monit in my virtual private server. Am always getting following log
2013-08-21 06:02:33 UTC LOG: incomplete startup packet
2013-08-21 06:04:33 UTC LOG: incomplete startup packet
2013-08-21 06:06:33 UTC LOG: incomplete startup packet
Looks like this is happening at each 2 minutes, so it is probably some monitoring tool (like Nagios, Cacti, Zabbix, etc.) is opening a socket to PostgreSQL's port only to check if it is responding, and them disconnecting. Check if you have this kind of service on your environment.
You would have the same effect with nc:
$ nc -zv <host> 5432
$ nc -zv <host> 5432
As what you can do, if that is the case, just ignore this message, it should cause no harm.
Regards,
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres
Hi,
I am seeing lot of these "incomplete startup packet" messages in postgresql.log in 9.6 version, what does it mean? some thing wrong with server?
Thanks,
Ram
Hi,I am seeing lot of these "incomplete startup packet" messages in postgresql.log in 9.6 version, what does it mean? some thing wrong with server?
It means that some piece of software is trying, incorrectly, to connect to PostgreSQL. The server is probably just fine but you should probably hunt down the other side of the connections and see what is wrong there - or block them if the other end isn't something you want trying to connect to your database.
David J.
Thank you David!
On Thu, Feb 8, 2018 at 11:02 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
Hi,I am seeing lot of these "incomplete startup packet" messages in postgresql.log in 9.6 version, what does it mean? some thing wrong with server?It means that some piece of software is trying, incorrectly, to connect to PostgreSQL. The server is probably just fine but you should probably hunt down the other side of the connections and see what is wrong there - or block them if the other end isn't something you want trying to connect to your database.David J.
Greetings, * David G. Johnston (david.g.johnston@gmail.com) wrote: > On Thu, Feb 8, 2018 at 10:16 AM, rammohan ganapavarapu < > rammohanganap@gmail.com> wrote: > > I am seeing lot of these* "incomplete startup packet" *messages in > > postgresql.log in 9.6 version, what does it mean? some thing wrong with > > server? > > It means that some piece of software is trying, incorrectly, to connect to > PostgreSQL. The server is probably just fine but you should probably hunt > down the other side of the connections and see what is wrong there - or > block them if the other end isn't something you want trying to connect to > your database. These might be entirely reasonable checks to see if the service is up and running from monitoring systems. That's certainly not unheard of and it'd actually be nice if we had a way to avoid having these errors get thrown in that case. Even better would be making the monitoring systems smarter, but that's not always easily done. Thanks! Stephen