| Lists: | pgsql-novice |
|---|
| From: | Michael Guerin <guerin(at)rentec(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | error during vacuum |
| Date: | 2004-05-26 01:35:54 |
| Message-ID: | 40B3F47A.7020000@rentec.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
INFO: analyzing "pg_catalog.pg_type"
INFO: "pg_type": 5731 pages, 265 rows sampled, 265 estimated total rows
INFO: vacuuming "pg_catalog.pg_attribute"
ERROR: failed to re-find parent key in "pg_attribute_relid_attnam_index"
I get this error when I run Vacuum verbose analyze, any ideas? I
recently re-created a number of tables and indexes b/c we needed to
change to bigints.
Thanks
Michael
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Michael Guerin <guerin(at)rentec(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: error during vacuum |
| Date: | 2004-05-26 04:10:40 |
| Message-ID: | 1278.1085544640@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
Michael Guerin <guerin(at)rentec(dot)com> writes:
> ERROR: failed to re-find parent key in "pg_attribute_relid_attnam_index"
Oh? What PG version is this exactly?
Your best bet is probably to REINDEX pg_attribute, but it would be wise
to try to understand what happened before you wipe out the evidence...
regards, tom lane
| From: | Michael Guerin <guerin(at)rentec(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: error during vacuum |
| Date: | 2004-05-26 04:36:41 |
| Message-ID: | 40B41ED9.5030007@rentec.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
Tom Lane wrote:
>Michael Guerin <guerin(at)rentec(dot)com> writes:
>
>
>>ERROR: failed to re-find parent key in "pg_attribute_relid_attnam_index"
>>
>>
>
>Oh? What PG version is this exactly?
>
>Your best bet is probably to REINDEX pg_attribute, but it would be wise
>to try to understand what happened before you wipe out the evidence...
>
> regards, tom lane
>
>
7.4.1 , where should I look for some hints on what went wrong? I'll
search the logs for anything meaningful, should I look elsewhere?
thanks
michael