[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] Postgres 7.2.3 hangs during vacuum.
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2002-12-23 18:11:13
[Download RAW message or body]

"Robert M. Meyer" <rmeyer@installs.com> writes:
> Having a bizarre one, today.  It seems that when doing a vacuum FULL on
> our system, the backend postgres process gets into a strange state.  It
> starts consuming 100% of a cpu (we have two) and is immune to any signal
> (except 9).

Could you attach to the stuck process with a debugger and get a stack
backtrace, so we can get some idea what it's doing?  With gdb, the
procedure is

		gdb /path/to/postgres-executable
		gdb> attach pid-of-process
		gdb> bt
		gdb> q

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]