Lists: | pgsql-bugs |
---|
From: | Brian Hirt <bhirt(at)mobygames(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | failed to re-find parent key in "..." for deletion target page |
Date: | 2007-08-04 21:09:16 |
Message-ID: | AE971354-1343-45FE-8B6E-BCD771BCED40@mobygames.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
I was doing some testing with tsearch2 on my dev box and I've run
across this problem.
I created the tsvector and added the trigger and then i was updating
the entire table to populate the ixdfti field. When i was done, I
was unable to vacuum the table, I get this error. Any ideas an
what's going on? I've shutdown the database and made a tar of it
incase there is additional info you need.
basement_dev=# update developer_name set developer_id = developer_id;
UPDATE 262083
basement_dev=# VACUUM FULL developer_name;
ERROR: failed to re-find parent key in
"developer_name_developer_name" for deletion target page 163
basement_dev=# \d developer_name;
Table
"public.developer_name"
Column | Type
| Modifiers
-------------------+------------------------
+-----------------------------------------------------------------------
-----
developer_name_id | integer | not null default nextval
('developer_name_developer_name_id_seq'::regclass)
developer_id | integer | not null
developer_name | character varying(255) | not null
idxfti | tsvector |
t | text |
idxfti2 | tsvector |
Indexes:
"developer_name_pkey" PRIMARY KEY, btree (developer_name_id)
"developer_name_developer_id" btree (developer_id)
"developer_name_developer_name" btree (developer_name)
Triggers:
tsvectorupdate BEFORE INSERT OR UPDATE ON developer_name FOR
EACH ROW EXECUTE PROCEDURE tsearch2('idxfti', 'developer_name')
basement_dev=# select version();
version
------------------------------------------------------------------------
----------------------------------------------------------------
PostgreSQL 8.2.4 on i386-apple-darwin8.9.1, compiled by GCC i686-
apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5341)
(1 row)
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Brian Hirt <bhirt(at)mobygames(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: failed to re-find parent key in "..." for deletion target page |
Date: | 2007-08-04 22:32:47 |
Message-ID: | 8655.1186266767@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Brian Hirt <bhirt(at)mobygames(dot)com> writes:
> basement_dev=# VACUUM FULL developer_name;
> ERROR: failed to re-find parent key in
> "developer_name_developer_name" for deletion target page 163
Oh dear, I thought we'd fixed that.
Can you send me copies of this index file ... and preferably the
underlying table too?
You should be able to get out of it by REINDEXing, but we need to find
the cause first.
regards, tom lane
From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Brian Hirt <bhirt(at)mobygames(dot)com>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: failed to re-find parent key in "..." for deletion target page |
Date: | 2007-08-10 14:11:15 |
Message-ID: | 46BC7203.3080806@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Any news on this?
Tom Lane wrote:
> Brian Hirt <bhirt(at)mobygames(dot)com> writes:
>> basement_dev=# VACUUM FULL developer_name;
>> ERROR: failed to re-find parent key in
>> "developer_name_developer_name" for deletion target page 163
>
> Oh dear, I thought we'd fixed that.
>
> Can you send me copies of this index file ... and preferably the
> underlying table too?
>
> You should be able to get out of it by REINDEXing, but we need to find
> the cause first.
>
> regards, tom lane
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
From: | Brian Hirt <bhirt(at)mobygames(dot)com> |
---|---|
To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: failed to re-find parent key in "..." for deletion target page |
Date: | 2007-08-13 13:43:26 |
Message-ID: | 9694D7CC-D906-4803-82AF-E407945E3DFD@mobygames.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Unfortunately, I wasn't able to get Tom the requested files.
On Aug 10, 2007, at 8:11 AM, Heikki Linnakangas wrote:
> Any news on this?
>
> Tom Lane wrote:
>> Brian Hirt <bhirt(at)mobygames(dot)com> writes:
>>> basement_dev=# VACUUM FULL developer_name;
>>> ERROR: failed to re-find parent key in
>>> "developer_name_developer_name" for deletion target page 163
>>
>> Oh dear, I thought we'd fixed that.
>>
>> Can you send me copies of this index file ... and preferably the
>> underlying table too?
>>
>> You should be able to get out of it by REINDEXing, but we need to
>> find
>> the cause first.
>>
>> regards, tom lane
>
> --
> Heikki Linnakangas
> EnterpriseDB http://www.enterprisedb.com