Re: DROP OWNED BY ... CACADE & "could not open relation with OID" error - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: DROP OWNED BY ... CACADE & "could not open relation with OID" error
Date
Msg-id 20160721045352.GA958496@alvherre.pgsql
Whole thread Raw
In response to DROP OWNED BY ... CACADE & "could not open relation with OID" error  (Satoshi Nagayasu <snaga@uptime.jp>)
Responses Re: DROP OWNED BY ... CACADE & "could not open relation with OID" error  (Satoshi Nagayasu <snaga@uptime.jp>)
List pgsql-hackers
Satoshi Nagayasu wrote:
> Hi,
> 
> I have been trying MADlib [1], a machine-learning library for PostgreSQL,
> and when I was tying it on 9.5 and 9.6beta2, I often got following
> error on my box.
> 
> ------------------------------------
> madpack.py : ERROR : SQL command failed:
> SQL: DROP OWNED BY madlib_19_installcheck CASCADE;
> ERROR:  could not open relation with OID 147056
> ------------------------------------
> 
> I wonder it could be a PostgreSQL bug or not.
> AFAIK, this kind of error should not occur during regular SQL command execution,
> so I guess this is a PostgreSQL bug.

Agreed.

> Should I dig it down deeper to reproduce in a simple procedure?

Yes, please.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Declarative partitioning
Next
From: David Fetter
Date:
Subject: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE