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
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" |