Skip site navigation (1) Skip section navigation (2)

BUG #6484: pgstat wait timeout

From: cneo(at)accessdata(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6484: pgstat wait timeout
Date: 2012-02-22 23:04:12
Message-ID: E1S0LEK-0003KU-4H@wrigleys.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6484
Logged by:          Charlie Neo
Email address:      cneo(at)accessdata(dot)com
PostgreSQL version: 9.0.6
Operating system:   Windows Server 2008 R2 Enterprise
Description:        

During heavy database loading, "pgstat wait timeout" is showing up in the
logs. When this happens pgstat.stat file stop updating. Stats in
pg_stat_user_tables also stop updating. Resulting in autovacuum not
triggering and greatly degrades performs. Killing the stats collection
process causing it to re-spawn does not help, as it will quickly go back
into the same state without any new stats collected.

Stack trace of the process postgres.exe -forkcol

ntoskrnl.exe!memset+0x64a
ntoskrnl.exe!KeWaitForMultipleObjects+0xf5d
ntoskrnl.exe!KeWaitForMultipleObjects+0x26a
ntoskrnl.exe!NtWaitForSingleObject+0x40f
ntoskrnl.exe!NtWaitForSingleObject+0x77e
ntoskrnl.exe!KeSynchronizeExecution+0x3a43
ntdll.dll!ZwWaitForMultipleObjects+0xa
KERNELBASE.dll!GetCurrentProcess+0x40
kernel32.dll!WaitForMultipleObjectsEx+0xb3
postgres.exe!reltimesend+0x1f8d50
postgres.exe!reltimesend+0x1f9053
postgres.exe!reltimesend+0x2054af
postgres.exe!reltimesend+0x20aa85
postgres.exe!reltimesend+0x14af4e
postgres.exe!reltimesend+0x38a65d
kernel32.dll!BaseThreadInitThunk+0xd
ntdll.dll!RtlUserThreadStart+0x21


Responses

pgsql-bugs by date

Next:From: innomotiveDate: 2012-02-23 03:40:57
Subject: BUG #6485: Primary index key not updated uniformly
Previous:From: Marti RaudseppDate: 2012-02-22 22:05:22
Subject: Re: BUG #6483: Rows being evaluated, although being outside the LIMIT / OFFSET boundaries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group