Re: FATAL: the database system is in recovery mode

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lhornbeck(at)oppunl(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: FATAL: the database system is in recovery mode
Date: 2006-10-12 18:09:48
Message-ID: 14641.1160676588@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Laura Hornbeck" <lhornbeck(at)oppunl(dot)com> writes:
> Hmmm ... unless you had extremely high settings for both checkpoint_segments
> and checkpoint_timeout, it shouldn't take an hour to recover from a crash.

> checkpoint_segments is 8.

That's certainly not out of line --- I'd expect a max recovery time on
the order of a minute or so for that much WAL.

> strace -p26891
> Process 26891 attached - interrupt to quit
> futex(0xb7db2880, FUTEX_WAIT, 2, NULL

Interesting. We don't use futexes directly, so this smells like a
problem in glibc or some such. Can you get a stack trace?

$ gdb /path/to/postgres-executable 26891
gdb> bt
gdb> quit

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Laura Hornbeck 2006-10-12 18:22:31 Re: FATAL: the database system is in recovery mode
Previous Message Laura Hornbeck 2006-10-12 17:55:43 Re: FATAL: the database system is in recovery mode