r2d2 icon indicating copy to clipboard operation
r2d2 copied to clipboard

Is there a way to drop all connections?

Open zhangli-pear opened this issue 5 years ago • 5 comments

I'm using Sqlite, and it sometime has integrity problems. When this happen, I simply delete the file. However there are some connections still open the database, it can not be deleted.

Is this problem can be solved? in any way?

zhangli-pear avatar Apr 23 '20 10:04 zhangli-pear

I'd probably just replace the entire pool.

sfackler avatar Apr 23 '20 11:04 sfackler

I did try this way, but it seems doesn't work. Maybe connections didn't get dropped immediately?

zhangli-pear avatar Apr 23 '20 13:04 zhangli-pear

There can be some operations running in the background that would hold onto connections for a little bit after the pool drops.

sfackler avatar Apr 23 '20 23:04 sfackler

I would also need something like this. I would like to destroy pool manually and be sure, that CustomizeConnection.on_release is trigger on every connection. Is there any possibility right now? Thx

bkontur avatar Jul 22 '20 07:07 bkontur

I did try this way, but it seems doesn't work. Maybe connections didn't get dropped immediately?

There is an open bug about it: #99

link2xt avatar Apr 16 '22 22:04 link2xt