Re: "Tuple not found error" during Index creation

Hello All,

We are trying to trace cause and potential solution of "tuple not found"
error with postgres-xc. The problem happens when indexing a large file. It
seems the autovaccum locks certain cache pages that the indexer tries to
read. The indexing fails with "tuple not found" error.

I am sure if it qualifies as postgres or postgres-xc error. However, I was
just wondering what is the recommended way to go about fixing this. Turning
off the autovaccumer is really not the best of solution because then the
system runs into memory usage error.

Would greatly appreciate any pointers on this.

-Sandeep

On Mon, Dec 9, 2013 at 1:43 PM, Sandeep Gupta <gupta(dot)sandeep(at)gmail(dot)com>wrote:

> Agreed. However, the "tuple not found" error problem seems to happen with
> postgres as well, if not in the particular case index creation over large
> datasets. It would helpful to know in that scenario what are the fixes and
> how to avoid it in the first place.
>
> The solution/fixes for postgres will carry over to pgxc because the low
> level stuff (blocks, files, indexes) etc. postgres-xc is really the same as
> in postgres.
>
> -Sandeep
>
>
>
> On Mon, Dec 9, 2013 at 1:23 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
>
>> On 12/9/2013 10:07 AM, RUSHI KAW wrote:
>>
>> I have been running Postgresxc 1.1
>>
>>
>> you'd probably be best off finding the postgresql-xc list, as that is
>> really a rather different system, even if it is forked from community
>> postgresql.
>>
>>
>>
>> --
>> john r pierce 37N 122W
>> somewhere on the middle of the left coast
>>
>>
>