From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | pgstat wait timeout |
Date: | 2011-12-28 01:51:06 |
Message-ID: | 4EFA760A.6040204@pinpointresearch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
Dec 27 17:43:59 foo postgres[23697]: [6-1] : WARNING: pgstat wait timeout
Dec 27 17:44:04 foo postgres[27324]: [71402-1] : WARNING: pgstat wait
timeout
Dec 27 17:44:09 foo postgres[23715]: [6-1] : WARNING: pgstat wait timeout
Dec 27 17:44:17 foo postgres[27324]: [71403-1] : WARNING: pgstat wait
timeout
Dec 27 17:44:22 foo postgres[23716]: [6-1] : WARNING: pgstat wait timeout
Dec 27 17:44:27 foo postgres[27324]: [71404-1] : WARNING: pgstat wait
timeout
Dec 27 17:44:33 foo postgres[23718]: [6-1] : WARNING: pgstat wait timeout
Dec 27 17:44:54 foo postgres[27324]: [71405-1] : WARNING: pgstat wait
timeout
Dec 27 17:44:59 foo postgres[23824]: [6-1] : WARNING: pgstat wait timeout
Dec 27 17:45:04 foo postgres[27324]: [71406-1] : WARNING: pgstat wait
timeout
I can't correlate events exactly, but the messages seem to have started
shortly after I dropped a pgbench user and database. My Googling turned
up various requests for debugging info on "hackers". Since the system
isn't live, I haven't touched it in case anyone wants me to collect
debugging info.
Otherwise, I plan on just blowing the install away and replacing it with 9.1
Cheers,
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2011-12-28 02:00:38 | Re: Misleading CREATE TABLE error |
Previous Message | Jeff Davis | 2011-12-28 00:06:19 | Re: Page Checksums + Double Writes |