 | |
drop database not working
comp.databases.postgresql comp.databases.postgresql
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
drop database not working -
06-18-2008
, 10:10 AM
#2
| |||
| |||
|
|
Tomcat 5.5, Java 1.5, Postgres 8.2. I use jndi to access resources. When I try to delete a database, listed in the context.xml, I get the message: ERROR: database is being accessed by other user. It seems that pooling service has not released the resource. I waited some time just to let dbcp release abandoned connections, I wrote a function etc. but nothing seems to work. Of course nobody is connected to the database. |
SELECT datname, procpid, usename, backend_start FROM pg_stat_activity;
Which database do you want to drop?
Yours,
Laurenz Albe
#3
| |||
| |||
|
|
Tomcat 5.5, Java 1.5, Postgres 8.2. I use jndi to access resources. When I try to delete a database, listed in the context.xml, I get the message: ERROR: database is being accessed by other user. It seems that pooling service has not released the resource. I waited some time just to let dbcp release abandoned connections, I wrote a function etc. but nothing seems to work. Of course nobody is connected to the database. |
SELECT datname, procpid, usename, backend_start FROM pg_stat_activity;
Which database do you want to drop?
Yours,
Laurenz Albe
#4
| |||
| |||
|
|
Tomcat 5.5, Java 1.5, Postgres 8.2. I use jndi to access resources. When I try to delete a database, listed in the context.xml, I get the message: ERROR: database is being accessed by other user. It seems that pooling service has not released the resource. I waited some time just to let dbcp release abandoned connections, I wrote a function etc. but nothing seems to work. Of course nobody is connected to the database. |
SELECT datname, procpid, usename, backend_start FROM pg_stat_activity;
Which database do you want to drop?
Yours,
Laurenz Albe
#5
| |||
| |||
|
|
Tomcat 5.5, Java 1.5, Postgres 8.2. I use jndi to access resources. When I try to delete a database, listed in the context.xml, I get the message: ERROR: database is being accessed by other user. It seems that pooling service has not released the resource. I waited some time just to let dbcp release abandoned connections, I wrote a function etc. but nothing seems to work. Of course nobody is connected to the database. |
SELECT datname, procpid, usename, backend_start FROM pg_stat_activity;
Which database do you want to drop?
Yours,
Laurenz Albe
#6
| |||
| |||
|
|
Tomcat 5.5, Java 1.5, Postgres 8.2. I use jndi to access resources. When I try to delete a database, listed in the context.xml, I get the message: ERROR: database is being accessed by other user. It seems that pooling service has not released the resource. I waited some time just to let dbcp release abandoned connections, I wrote a function etc. but nothing seems to work. Of course nobody is connected to the database. |
SELECT datname, procpid, usename, backend_start FROM pg_stat_activity;
Which database do you want to drop?
Yours,
Laurenz Albe
#7
| |||
| |||
|
|
Tomcat 5.5, Java 1.5, Postgres 8.2. I use jndi to access resources. When I try to delete a database, listed in the context.xml, I get the message: ERROR: database is being accessed by other user. It seems that pooling service has not released the resource. I waited some time just to let dbcp release abandoned connections, I wrote a function etc. but nothing seems to work. Of course nobody is connected to the database. |
SELECT datname, procpid, usename, backend_start FROM pg_stat_activity;
Which database do you want to drop?
Yours,
Laurenz Albe
#8
| |||
| |||
|
|
Tomcat 5.5, Java 1.5, Postgres 8.2. I use jndi to access resources. When I try to delete a database, listed in the context.xml, I get the message: ERROR: database is being accessed by other user. It seems that pooling service has not released the resource. I waited some time just to let dbcp release abandoned connections, I wrote a function etc. but nothing seems to work. Of course nobody is connected to the database. |
SELECT datname, procpid, usename, backend_start FROM pg_stat_activity;
Which database do you want to drop?
Yours,
Laurenz Albe
#9
| |||
| |||
|
|
Tomcat 5.5, Java 1.5, Postgres 8.2. I use jndi to access resources. When I try to delete a database, listed in the context.xml, I get the message: ERROR: database is being accessed by other user. It seems that pooling service has not released the resource. I waited some time just to let dbcp release abandoned connections, I wrote a function etc. but nothing seems to work. Of course nobody is connected to the database. |
SELECT datname, procpid, usename, backend_start FROM pg_stat_activity;
Which database do you want to drop?
Yours,
Laurenz Albe
#10
| |||
| |||
|
|
SELECT datname, procpid, usename, backend_start FROM pg_stat_activity; |
"common";624;"postgres"
"common";3284;"postgres"
Quote:
|
Which database do you want to drop? There is a db named "common" which stores general informations, for |
"courseN" where N=1,2,3,...
I create "course2", using my template, then I want to drop it. I
connect to "common" and I create a statement "DROP DATABASE course2".
Executing the statement fires the error. Even if I don't open the db
"course2" it seems to be locked by the Java application (or Tomcat).
Executing the drop command from PGAdmin or command line (dropdb) gives
the same error.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.