On 12/28/2011 05:05 AM, Alvaro Herrera wrote:
Excerpts from Steve Crawford's message of mar dic 27 22:51:06 -0300 2011:
I have a system (9.0.4 on Ubuntu Server 10.04 LTS x86_64) that is
currently in test/dev mode. I'm currently seeing the following messages
occurring every few seconds:
...
Dec 27 17:43:22 foo postgres[23693]: [6-1] : WARNING: pgstat wait timeout
Dec 27 17:43:27 foo postgres[27324]: [71400-1] : WARNING: pgstat wait
timeout
Dec 27 17:43:33 foo postgres[23695]: [6-1] : WARNING: pgstat wait timeout
Dec 27 17:43:54 foo postgres[27324]: [71401-1] : WARNING: pgstat wait
timeout
Hm, so can you strace the stats collector to see what it's doing? Maybe
grab a backtrace with GDB from it before anything else.
My guess is 27324 is the autovac launcher and the others are autovac
workers just as they die.
You are correct. 27324 is the launcher and the others are autovac
workers. Here's the strace of the stats collector process:
getppid() = 27320
poll([{fd=8, events=POLLIN|POLLERR}], 1, 2000) = 0 (Timeout)
getppid() = 27320
poll([{fd=8, events=POLLIN|POLLERR}], 1, 2000) = 0 (Timeout)
getppid() = 27320
poll([{fd=8, events=POLLIN|POLLERR}], 1, 2000) = 0 (Timeout)
....rinse...lather...repeat...ad nauseum...
And the backtrace:
#0 0x00007ff4d2e80f58 in poll () from /lib/libc.so.6
#1 0x00007ff4d4e6f465 in ?? ()
#2 0x00007ff4d4e6fd83 in pgstat_start ()
#3 0x00007ff4d4e73475 in ?? ()
#4 <signal handler called>
#5 0x00007ff4d2e85fd3 in select () from /lib/libc.so.6
#6 0x00007ff4d4e71b93 in ?? ()
#7 0x00007ff4d4e74b01 in PostmasterMain ()
#8 0x00007ff4d4e193b3 in main ()
Cheers,
Steve
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
