| From: | Steve Horn <steve(at)stevehorn(dot)cc> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Cannot DROP while process running |
| Date: | 2012-04-09 19:38:27 |
| Message-ID: | CAFLkBaXN3-v-hXitsg8wX-HcYaZJq=Aec5pWF52mzoGaDsT9ag@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I am on Postgres 9.1 and running into a problem when trying to drop a table
in my public schema.
When I issue the drop command for a table, the server doesn't respond - not
even with increased disk activity or CPU usage. I am wondering if a lock is
blocking it? When I select from pg_stat_activity the table I am intending
on dropping is not listed as having anything actively using it.
The only table with a lock or any activity is 'public.raw_tomtom'.
mapping=# select datname, procpid, current_query from pg_stat_activity;
datname | procpid | current_query
----------+---------+----------------------------------------------------------------------------------
postgres | 3944 | <IDLE>
mapping | 3945 | <IDLE>
mapping | 16193 | SELECT * FROM public.assign_vertex_id('raw_tomtom',
0.00001, 'the_geom', 'gid');
mapping | 25456 | <IDLE>
mapping | 20897 | autovacuum: VACUUM ANALYZE public.raw_tomtom
mapping | 20405 | LOCK TABLE public.vertices_tmp IN ACCESS SHARE MODE
mapping | 19461 | LOCK TABLE public.vertices_tmp IN ACCESS SHARE MODE
mapping | 17570 | <IDLE>
mapping | 20466 | LOCK TABLE public.vertices_tmp IN ACCESS SHARE MODE
postgres | 20874 | <IDLE>
mapping | 20976 | select datname, procpid, current_query from
pg_stat_activity;
mapping | 20609 | <IDLE>
mapping | 20876 | <IDLE>
*procpid 16193 "SELECT * FROM ..." is a long running process that would not
be touching the table I am trying to drop.
Thanks for any help!
--
Steve Horn
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Horn | 2012-04-09 19:46:24 | Re: Cannot DROP while process running |
| Previous Message | Jean MAURICE | 2012-04-08 14:04:15 | Re: Hello, I am a newbie on Postgres ! |