Tom Lane wrote:
>
>>main_v0_8=# REINDEX INDEX admin_users_pkey;
>>REINDEX
>>main_v0_8=# VACUUM ANALYZE ;
>>ERROR: No one parent tuple was found
>>
>
> This still looks like corrupted data, but one can't tell from this which
> table it's in. Try VACUUM VERBOSE.
>
This database is huge, so I won't fill the archives with the entire
output of VACUUM VERBOSE, but below are a few snippets.
This is an example of what most of the "non admin_users" indexes look
like, notice the "Deleted 0":
NOTICE: Index plate_map_pkey: Pages 2; Tuples 18: Deleted 0. CPU
0.00s/0.00u sec.
These are the two "admin_users" indexes, notice the "Deleted 141":
NOTICE: Index admin_users_pkey: Pages 2; Tuples 29: Deleted 141. CPU
0.00s/0.00u sec.
NOTICE: Index admin_users_name_key: Pages 2; Tuples 29: Deleted 141.
CPU 0.00s/0.00u sec.
ERROR: No one parent tuple was found
These are the last 3 messages that appear when running the VACUUM
VERBOSE, the 2 NOTICE's and the final ERROR.
--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham
Extracta Moléculas Naturais, Rio de Janeiro, Brasil
email: lapham@extracta.com.br web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------