Re: process exited with status 11 after XLogFlush: request is not satisfied

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bjoern Metzdorf" <bm(at)turtle-entertainment(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: process exited with status 11 after XLogFlush: request is not satisfied
Date: 2002-01-30 16:50:09
Message-ID: 24081.1012409409@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Bjoern Metzdorf" <bm(at)turtle-entertainment(dot)de> writes:
> (gdb) bt
> #0 0x08066109 in nocachegetattr ()
> #1 0x080c0bfc in ExecEvalVar ()
> #2 0x080c16bb in ExecEvalExpr ()
> #3 0x080c179d in ExecEvalExpr ()
> #4 0x080c10c8 in ExecEvalFuncArgs ()

Yeah, that does look like a corrupted-data problem. If you wanted to
rebuild with debugging symbols turned on, it might be possible to
extract the location of the bad tuple directly from the corefile.
Short of that, what I'd do is find out what query the backend is
crashing on (turn on debug query logging), and then investigate the
tables involved using queries like "select ctid,* from foo limit N".
By varying the limit you can home in on just where the bad tuple is.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-01-30 17:06:58 Re: unique & update
Previous Message Bjoern Metzdorf 2002-01-30 16:42:25 Re: process exited with status 11 after XLogFlush: request is not satisfied