On Fri, May 9, 2008 at 2:55 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> William Temperley wrote: > > On Thu, May 8, 2008 at 6:14 PM, Magnus Hagander <[EMAIL PROTECTED]> > > wrote: > > > William Temperley wrote: > > >> > > > > >> > > Any ideas why this might be happening, and how I can stop it? > > >> > > > >> > It'd be interesting to know what the stats collector is actually > > >> > doing. Could you, using Process Explorer or a debugger, get a > > >> > stack trace from that process while it's in the trashing state? > > >> > > > >> > //Magnus > > >> > > > >> > > >> Certainly, but I'll have to wait 'til it does it again, it doesn't > > >> happen all the time. > > >> What would you like to know from Process Explorer? > > > > > > Get the backtrace from hung process. Find the process in the list, > > > open it. Go to the tab "Threads", find the thread that's using a > > > lot of CPU (or at least has a lot of ocntext switchs), and click > > > the Stack button. That should give you a window with a backtrace. > > > > > > //Magnus > > > > > > > Ok, got the little blighter. Below are 4 stack traces taken at random > > times. Doesn't seem to be doing much I/O (16 reads and 167 other in 3 > > hours). The memory usage seems to be static (3.7MB) even with high > > database usage (vacuum, read, update). > > Hmm. They all show the same function, but it's not a function being > used in the stats collector. I think I missed a step in the > instructions - you need to download the symbols for the server (make > sure you get the same version!) and configure process explorer to use > those (IIRC, it can use detached symbols), then do the same things > again. Sorry for missing that in the first instructions! > > //Magus > Hi Magnus, Sorry I didn't reply earlier (away on holiday). I can't seem to get the symbols to work - I can't find any way to attach symbols in process explorer, however windows debugger can. I've done this: 1. Downloaded the symbols (8.3.1!) 2. Set the path for windows debugger to find them 3. Atttached to the process (offending PID found from process explorer) Then I get this message: Microsoft (R) Windows Debugger Version 6.9.0003.113 X86 Copyright (c) Microsoft Corporation. All rights reserved. *** wait with pending attach Symbol search path is: C:\Temp\pgsymbols Executable search path is: ModLoad: 00400000 007da000 C:\Program Files\PostgreSQL\8.3\bin\postgres.exe ...........Lots more modload lines ..... (eb4.3e4): Break instruction exception - code 80000003 (first chance) eax=7ffd4000 ebx=00000001 ecx=00000002 edx=00000003 esi=00000004 edi=00000005 eip=7c901230 esp=0235ffcc ebp=0235fff4 iopl=0 nv up ei pl zr na pe nc cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000246 *** ERROR: Symbol file could not be found. Defaulted to export symbols for C:\WINDOWS\system32\ntdll.dll - ntdll!DbgBreakPoint: 7c901230 cc int 3 Any ideas? Will
