pgstat wait timeout

From: Tory M Blue <tmblue(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pgstat wait timeout
Date: 2011-03-15 05:36:06
Message-ID: AANLkTimV-8cVsmv+1EHAUj0KK65TMqcdrAS-h1fzaHyD@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I know you can't do much with this information, but maybe you can help
me acquire the information that is needed.

This started in 8.4 and trying to figure it out

Fedora 12, Postgres 8.4.4 with slony.

Although I don't see any panics or errors other then these Warnings,
but I did see a dead lock the other day and so I need to start diving
into this and try to figure out what is going on.

Thanks for your pointers on how to troubleshoot this

2011-03-12 03:35:30 PST WARNING: pgstat wait timeout
2011-03-12 03:35:35 PST WARNING: pgstat wait timeout
2011-03-12 03:35:46 PST WARNING: pgstat wait timeout

-bash-4.0$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 258410
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 1024
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

This happens for a decent amount of time each time it happens. 3am,
9pm, 10pm etc.

Thanks
Tory

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2011-03-15 06:46:50 Re: base backup and tar problems with disappearing files.
Previous Message Noah Misch 2011-03-15 04:14:11 Re: Huge spikes in number of connections doing "PARSE"