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