Обсуждение: Postmaster errors
Good morning,
Has anyone encountered these errors? They repeat every five (5) minutes in my log file. Is there something I may have set incorrectly in my postgresql.conf file? Odd as I find them in my DEV & QA logs but not Production....
2006-02-02 10:52:33 EST USER=[unknown] DB=[unknown] [8931] LOG: 08P01: incomplete startup packet
2006-02-02 10:52:33 EST USER=[unknown] DB=[unknown] [8931] LOCATION: ProcessStartupPacket, postmaster.c:1311
Thank you,
Tim
On Thu, Feb 02, 2006 at 10:58:52AM -0500, mcelroy, tim wrote: > Has anyone encountered these errors? They repeat every five (5) minutes in > my log file. Is there something I may have set incorrectly in my > postgresql.conf file? Odd as I find them in my DEV & QA logs but not > Production.... > > 2006-02-02 10:52:33 EST USER=[unknown] DB=[unknown] [8931] LOG: 08P01: > incomplete startup packet > 2006-02-02 10:52:33 EST USER=[unknown] DB=[unknown] [8931] LOCATION: > ProcessStartupPacket, postmaster.c:1311 Something connected to your server without carrying out a proper PostgreSQL conversation. One of the usual suspects is a probe that connects to the port and then immediately disconnects, like a port scan or a network management system. Since it's happening every five minutes I'd guess the latter. -- Michael Fuhr
That was it, a fellow admin is watching the postmaster with OpenNMS....
Thanks for the tip!
Tim
-----Original Message-----
From: Michael Fuhr [mailto:mike@fuhr.org]
Sent: Thursday, February 02, 2006 11:10 AM
To: mcelroy, tim
Cc: 'pgsql-admin@postgresql.org'
Subject: Re: [ADMIN] Postmaster errors
On Thu, Feb 02, 2006 at 10:58:52AM -0500, mcelroy, tim wrote:
> Has anyone encountered these errors? They repeat every five (5) minutes in
> my log file. Is there something I may have set incorrectly in my
> postgresql.conf file? Odd as I find them in my DEV & QA logs but not
> Production....
>
> 2006-02-02 10:52:33 EST USER=[unknown] DB=[unknown] [8931] LOG: 08P01:
> incomplete startup packet
> 2006-02-02 10:52:33 EST USER=[unknown] DB=[unknown] [8931] LOCATION:
> ProcessStartupPacket, postmaster.c:1311
Something connected to your server without carrying out a proper
PostgreSQL conversation. One of the usual suspects is a probe that
connects to the port and then immediately disconnects, like a port
scan or a network management system. Since it's happening every
five minutes I'd guess the latter.
--
Michael Fuhr
On Thu, Feb 02, 2006 at 12:34:44PM -0500, mcelroy, tim wrote: > That was it, a fellow admin is watching the postmaster with OpenNMS.... I think OpenNMS has a way to set up a custom poller that can do anything you want (e.g., connect to the database, issue a query, check the results). I was playing with that a year or two ago; at that time the OpenNMS documentation was pretty scant but I remember coming across the feature in the release notes or some other document. Monitoring the database with such a poller would tell you more about whether the service is available than a simple TCP connect does. -- Michael Fuhr
Great, thank you for the additional info.
Tim
-----Original Message-----
From: Michael Fuhr [mailto:mike@fuhr.org]
Sent: Thursday, February 02, 2006 1:05 PM
To: mcelroy, tim
Cc: 'pgsql-admin@postgresql.org'
Subject: Re: [ADMIN] Postmaster errors
On Thu, Feb 02, 2006 at 12:34:44PM -0500, mcelroy, tim wrote:
> That was it, a fellow admin is watching the postmaster with OpenNMS....
I think OpenNMS has a way to set up a custom poller that can do
anything you want (e.g., connect to the database, issue a query,
check the results). I was playing with that a year or two ago; at
that time the OpenNMS documentation was pretty scant but I remember
coming across the feature in the release notes or some other document.
Monitoring the database with such a poller would tell you more about
whether the service is available than a simple TCP connect does.
--
Michael Fuhr