| Lists: | pgsql-hackers |
|---|
| From: | Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl> |
|---|---|
| To: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | relation 71478240 deleted while still in use on 8.1 |
| Date: | 2007-03-21 19:59:47 |
| Message-ID: | 8E9772F5-E623-4501-B38E-AA74B5D80026@pointblue.com.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
I got :
2007-03-21 20:56:17 CET ERROR: relation 71478240 deleted while still
in use
2007-03-21 20:56:17 CET ERROR: relation 71478240 deleted while still
in use
2007-03-21 20:56:17 CET ERROR: relation 71478240 deleted while still
in use
on 8.1.8 my production server here.
some inserts/updates, selects, and pg_dump was running.
there's a chance cluster was running in http://dupa.privatepaste.com/
d317KYXt5n
It is repeatable, if I run pg_dump. Guess that has something to do,
with slowing down db server - and some race cond occurs.
Any ideas ?
should I add it as a bug ? or perhaps someone already knows about
that kinda issue
--
Grzegorz Jaskiewicz
C/C++ freelance for hire
| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl> |
| Cc: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: relation 71478240 deleted while still in use on 8.1 |
| Date: | 2007-03-21 20:40:05 |
| Message-ID: | 46019825.2020805@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Grzegorz Jaskiewicz wrote:
> I got :
>
> 2007-03-21 20:56:17 CET ERROR: relation 71478240 deleted while still in
> use
> 2007-03-21 20:56:17 CET ERROR: relation 71478240 deleted while still in
> use
> 2007-03-21 20:56:17 CET ERROR: relation 71478240 deleted while still in
> use
>
> on 8.1.8 my production server here.
> some inserts/updates, selects, and pg_dump was running.
> there's a chance cluster was running in
> http://dupa.privatepaste.com/d317KYXt5n
>
> It is repeatable, if I run pg_dump. Guess that has something to do, with
> slowing down db server - and some race cond occurs.
> Any ideas ?
> should I add it as a bug ? or perhaps someone already knows about that
> kinda issue
Which transaction gets the error, pg_dump or the one you copied to that
web page? Is there anything else running? How often does it happen,
always? Can you reduce it to a self-contained test case that doesn't
require dblink?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl> |
| Cc: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: relation 71478240 deleted while still in use on 8.1 |
| Date: | 2007-03-21 22:25:04 |
| Message-ID: | 22261.1174515904@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl> writes:
> should I add it as a bug ?
Only if you can reproduce it in 8.2 --- what it looks like to me is a
relcache-opening race condition, which is (believed) fixed in 8.2 and
is not feasible to fix in older branches.
regards, tom lane
| From: | Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: relation 71478240 deleted while still in use on 8.1 |
| Date: | 2007-03-21 23:28:01 |
| Message-ID: | 3D283D1C-5B42-4743-8090-46F6F1E571A3@pointblue.com.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Mar 21, 2007, at 11:25 PM, Tom Lane wrote:
> Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl> writes:
>> should I add it as a bug ?
>
> Only if you can reproduce it in 8.2
okie dokie, I am moving the DB onto 8.2 next week (120M of rows, and
8.2 does sorting much faster).
--
Grzegorz Jaskiewicz
C/C++ freelance for hire
| From: | Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl> |
|---|---|
| To: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: relation 71478240 deleted while still in use on 8.1 |
| Date: | 2007-03-22 07:11:11 |
| Message-ID: | 23480AA9-0912-4E5F-A2CA-B7F9600BDB53@pointblue.com.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
okay, I got it. The main reason behind it - is that I do drop table
in transaction. Every 10 minutes. So during that period, when
'replication' is running - the thing becomes unstable, and this error
can appear.
--
Grzegorz Jaskiewicz
C/C++ freelance for hire