Обсуждение: Message: incomplete startup packet

Hi Guys,

                 We are having a problem with our pgsql 9.1 on
Linux(Debian).
                 Suddently, the database stop working and the logs shows
the statements below just before the problem. Any thoughts?

2012-11-08 02:46:44.216 CST 00000 509b70fb.4570LOG:  execute S_2: COMMIT
2012-11-08 02:47:12.529 CST 08P01 509b7190.4583LOG:  incomplete startup
packet
2012-11-08 02:48:12.534 CST 08P01 509b71cc.458bLOG:  incomplete startup
packet
2012-11-08 02:49:12.541 CST 08P01 509b7208.4593LOG:  incomplete startup
packet
2012-11-08 02:50:12.546 CST 08P01 509b7244.459aLOG:  incomplete startup
packet
2012-11-08 02:51:12.557 CST 08P01 509b7280.45a0LOG:  incomplete startup
packet
2012-11-08 02:52:12.562 CST 08P01 509b72bc.45a8LOG:  incomplete startup
packet
2012-11-08 02:53:12.569 CST 08P01 509b72f8.45b0LOG:  incomplete startup
packet
2012-11-08 02:54:12.575 CST 08P01 509b7334.45b6LOG:  incomplete startup
packet
2012-11-08 02:55:12.582 CST 08P01 509b7370.45c0LOG:  incomplete startup
packet
2012-11-08 02:56:12.592 CST 08P01 509b73ac.45c7LOG:  incomplete startup
packet
2012-11-08 02:57:12.599 CST 08P01 509b73e8.45d5LOG:  incomplete startup
packet
2012-11-08 02:58:12.604 CST 08P01 509b7424.45dcLOG:  incomplete startup
packet
2012-11-08 02:59:12.612 CST 08P01 509b7460.45eaLOG:  incomplete startup
packet
2012-11-08 03:00:12.617 CST 08P01 509b749c.45f2LOG:  incomplete startup
packet


Thank you,

Rodrigo Pereira da Silva.

On 11/8/2012 2:05 PM, Rodrigo Pereira da Silva wrote:
> Hi Guys,
>
>                 We are having a problem with our pgsql 9.1 on
> Linux(Debian).
>                 Suddently, the database stop working and the logs
> shows the statements below just before the problem. Any thoughts?
Just a word of caution that there may be no cause/effect relationship
between the log messages and the non-working-ness.
PG will print this message in the log if any TCP client simply connects
to it, then closes the connection.
For example if you have some kind of service liveness checker (nagios,
etc) that checks that something is accepting connections, you'll see
these messages.
Note that they have time stamps exactly one minute apart.
>
> 2012-11-08 02:47:12.529 CST 08P01 509b7190.4583LOG:  incomplete
> startup packet
> 2012-11-08 02:48:12.534 CST 08P01 509b71cc.458bLOG:  incomplete
> startup packet
> 2012-11-08 02:49:12.541 CST 08P01 509b7208.4593LOG:  incomplete
> startup packet