Skip site navigation (1) Skip section navigation (2)

Re: "out of balance" result on select from suspected index corruption [RESOLVED]

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Henry - Zen Search SA" <henry(at)zen(dot)co(dot)za>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: "out of balance" result on select from suspected index corruption [RESOLVED]
Date: 2008-06-30 19:45:37
Message-ID: 3964.1214855137@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
"Henry - Zen Search SA" <henry(at)zen(dot)co(dot)za> writes:
> The problem was this:  a silly SQL error (misuse of OR and missing
> parentheses) resulted in a massive result set which resulted in OOM - if
> the select is run manually (no funny "out of balance" strings).

> If it's run in a function (which uses a FOR loop, which uses implicit
> cursors), then the "out of balance" string is returned for the TEXT column
> almost immediately.

Is it possible the "out of balance" is actually an expected result from
the query --- ie, it's in a table somewhere?  In the first case you'd
not see it because of the OOM failure, but with a cursor you'd be able
to process (at least some of) the query output ...

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: Greg SmithDate: 2008-06-30 19:58:19
Subject: Re: php + postgresql website ?
Previous:From: paragasuDate: 2008-06-30 19:38:15
Subject: Re: php + postgresql website ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group