Re: [HACKERS] Got it...and... - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Re: [HACKERS] Got it...and...
Date
Msg-id 3530EF81.7D22A19F@sable.krasnoyarsk.su
Whole thread Raw
In response to Got it...and...  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: [HACKERS] Got it...and...
List pgsql-hackers
The Hermit Hacker wrote:
>
> perfect, and error message that tells me what to fix:
>
> FATAL 1:  btree: BTP_CHAIN flag was expected in radhist_userid (access =
> bt_read)
>
> Whoop! :)  Rebuilding that index now...
>
> But, still have, and don't know where to begin diagnosing it...
>
> FATAL 1:  palloc failure: memory exhausted
>
> Except, the query appears to be:
>
> Apr 11 10:25:23 clio radiusd[13005]: query failed: select uniq_id
> from radlog     where uniq_id='237287829'         and stop_time=0
> and term_server='isdn-1.trends.ca';
>
> When it failed...radlog being 7k records large...

Did you restart postmaster after FATALs ?

Vadim

pgsql-hackers by date:

Previous
From: "Vadim B. Mikheev"
Date:
Subject: Re: [HACKERS] Did we ever...
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Safe/Fast I/O ...