"Tuple not found error" during Index creation

From: RUSHI KAW <rushi_life(at)yahoo(dot)co(dot)in>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: "Tuple not found error" during Index creation
Date: 2013-12-09 18:07:47
Message-ID: 1386612467.13263.YahooMailNeo@web193206.mail.sg3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I have been running Postgresxc 1.1 on a 40 core, 1 TB RAM, Intel(R) Xeon(R) machine.
The data tables size with which the database is populated is approx 14GB.
The issue is that during the index creation time on the big table of approx 13GB size, the following error occurs:

ERROR: could not find tuple for relation 16413.
Statement: Create Index mdx on Network(head)

I read on the forum that this could be because the Autovacuum process may have locked the tuple that the indexing process was trying to access. So, I turned off the Autovacuum and the error didn't recur after that. 

So, I wanted to ask if this is the only workaround for this error, turning off the Autovacuum during index creation and then restarting the process once Indexes have been created or is there something else one can do?

Thank you.
Regards,
Rushi Kaw 

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2013-12-09 18:23:59 Re: "Tuple not found error" during Index creation
Previous Message Steve Atkins 2013-12-09 17:39:52 Re: network protocol and compatibility question