Обсуждение: lookup fail at DROP USER

Hi,

i have installed the latest CVS, 8.1beta1.

and get an error executing at DROP USER. these are the commands i
execute and the error i get:

in:  psql -U postgres template1

CREATE USER deimos;
CREATE TABLESPACE sgis_dat OWNER deimos LOCATION '/data/postgres/sgis_dat';
CREATE TABLESPACE sgis_idx OWNER deimos LOCATION '/data/postgres/sgis_idx';
CREATE DATABASE sgis WITH OWNER deimos ENCODING 'latin1' TABLESPACE sgis_dat;

the i drop the objects:
DROP DATABASE sgis;
DROP TABLESPACE sgis_dat;
DROP TABLESPACE sgis_idx;
DROP USER deimos;
ERROR:  cache lookup failed for tablespace 16396

i get these lines from the log file:

LOG:  statement: drop database sgis;
LOG:  transaction ID wrap limit is 2147484144, limited by database "postgres"
LOG:  statement: drop tablespace sgis_idx;
LOG:  statement: drop tablespace sgis_dat;
LOG:  statement: drop user deimos;
ERROR:  cache lookup failed for tablespace 16396

i hope it helps...

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

On Mon, Aug 29, 2005 at 07:19:21PM -0500, Jaime Casanova wrote:

> the i drop the objects:
> DROP DATABASE sgis;
> DROP TABLESPACE sgis_dat;
> DROP TABLESPACE sgis_idx;
> DROP USER deimos;
> ERROR:  cache lookup failed for tablespace 16396

Confirmed.  Most likely this is a problem in shared dependency handling.
I'll submit a fix after dinner.

Thanks for the report.

-- 
Alvaro Herrera <alvherre[]alvh.no-ip.org>      Architect, www.EnterpriseDB.com
"La felicidad no es mañana. La felicidad es ahora"

Jaime Casanova <systemguards@gmail.com> writes:
> the i drop the objects:
> DROP DATABASE sgis;
> DROP TABLESPACE sgis_dat;
> DROP TABLESPACE sgis_idx;
> DROP USER deimos;
> ERROR:  cache lookup failed for tablespace 16396

Fixed ... it seems the shared-dependency patch missed DROP TABLESPACE.
If you need to clean up from this, you can just manually remove the
relevant rows in pg_shdepend (look for rows with classid = 1213 and
objid not equal to any OID in pg_tablespace).

Thanks for the report!
        regards, tom lane

Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> I'll submit a fix after dinner.

Done already ...
        regards, tom lane