Thread: 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