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

I am getting WARNING at log file:

Jan  6 11:19:54 dev04 postgres[14624]: [1622-1] DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
Jan  6 11:19:54 dev04 postgres[14624]: [1623-1] LOG:  could not send data to client: Broken pipe
Jan  6 11:19:54 dev04 postgres[14624]: [1624-1] DEBUG:  CommitTransaction
Jan  6 11:19:54 dev04 postgres[14624]: [1625-1] DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
Jan  6 11:19:54 dev04 postgres[14624]: [1626-1] DEBUG:  proc_exit(0)
Jan  6 11:19:54 dev04 postgres[14624]: [1627-1] DEBUG:  shmem_exit(0)
Jan  6 11:19:54 dev04 postgres[14624]: [1628-1] DEBUG:  exit(0)
Jan  6 11:19:54 dev04 postgres[11989]: [1613-1] DEBUG:  forked new backend, pid=14624 socket=8
Jan  6 11:19:54 dev04 postgres[11989]: [1614-1] DEBUG:  reaping dead processes
Jan  6 11:19:54 dev04 postgres[11989]: [1615-1] DEBUG:  server process (PID 14624) exited with exit code 0

This message has been got by setting debug5 at log_min_messages and client_min_messages.

 

Ahmad,

Do you have something monitoring PostgreSQL by connecting to port 5432
(or whatever you have it listening on) such as Nagios or Zenoss?

    - Chris

Ahmad Rumman wrote:
> I am getting WARNING at log file:
>
> Jan  6 11:19:54 dev04 postgres[14624]: [1622-1] DEBUG:  name: unnamed;
> blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0,
> nestlvl: 1, children:
> Jan  6 11:19:54 dev04 postgres[14624]: [1623-1] LOG:  could not send
> data to client: Broken pipe
> Jan  6 11:19:54 dev04 postgres[14624]: [1624-1] DEBUG:  CommitTransaction
> Jan  6 11:19:54 dev04 postgres[14624]: [1625-1] DEBUG:  name: unnamed;
> blockState:       STARTED; state: INPROGR, xid/subid/cid: 0/1/0,
> nestlvl: 1, children:
> Jan  6 11:19:54 dev04 postgres[14624]: [1626-1] DEBUG:  proc_exit(0)
> Jan  6 11:19:54 dev04 postgres[14624]: [1627-1] DEBUG:  shmem_exit(0)
> Jan  6 11:19:54 dev04 postgres[14624]: [1628-1] DEBUG:  exit(0)
> Jan  6 11:19:54 dev04 postgres[11989]: [1613-1] DEBUG:  forked new
> backend, pid=14624 socket=8
> Jan  6 11:19:54 dev04 postgres[11989]: [1614-1] DEBUG:  reaping dead
> processes
> Jan  6 11:19:54 dev04 postgres[11989]: [1615-1] DEBUG:  server process
> (PID 14624) exited with exit code 0
>
> This message has been got by setting debug5 at log_min_messages and
> client_min_messages.
>
>
>