Thread: 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