Problem when we going to delete the DB

[Mantavya Gajjar (Open ERP)]

hello,

i am getting this error when i am going to delete the database using tiny client
in fact it allows, but i need to restart the server

Exception in thread Thread-131:
Traceback (most recent call last):
  File "/usr/lib/python2.5/threading.py", line 486, in __bootstrap_inner
    self.run()
  File "/home/mga/workspace/openerp/openobject-server/bin/netsvc.py", line 408, in run
    ts.mysend(e, exception=True, traceback=tb_s)
  File "/home/mga/workspace/openerp/openobject-server/bin/tiny_socket.py", line 50, in mysend
    msg = cPickle.dumps([msg,traceback])
  File "/usr/lib/python2.5/copy_reg.py", line 69, in _reduce_ex
    raise TypeError, "can't pickle %s objects" % base.__name__
TypeError: can't pickle cursor objects

[Jay Vora (Serpent Consulting Services) (jayvora)]

Can you provide More information?

I tried to generate the bug, but I couldn't.

[Husen Daudi (husendaudi)]

Check that your pg-adminIII or pswl prompt is not open.
if any of that is open then it will not allow you to drop database.

[Stephane Wirtel (OpenERP) (stephane-openerp)]

I confirm this bug too,

[Christophe CHAUVET (christophe-chauvet)]

I confirm, I can drop the last database used, but other unused database i can.

launch ps -awxf show
-------8<-------------8<---------------
 7265 ? S 0:24 /usr/lib/postgresql/8.3/bin/postgres -D /var/lib/postgresql/8.3/main -c config_file=/etc/postgresql/8.3/main/postgresql.conf
 7268 ? Ss 0:55 \_ postgres: writer process
 7269 ? Ss 0:45 \_ postgres: wal writer process
 7270 ? Ss 1:05 \_ postgres: autovacuum launcher process
 7271 ? Ss 2:31 \_ postgres: stats collector process
 8062 ? Ss 0:00 \_ postgres: terp50 testpsyco 127.0.0.1(37326) idle in transaction
 8066 ? Ss 0:00 \_ postgres: terp50 testpsyco 127.0.0.1(37329) idle
-------8<-------------8<---------------
There is a transaction in IDLE, which lock the database and we can't drop it.

[Christophe Simonis (OpenERP) (kangol)]

fixed on trunk