Rails - Close current DB connection

Question

I am trying to do some DB experiments in which I reset the DB a few times as part of Rails runner script. Here is a simple example:

`rake db:reset`
puts User.count
`rake db:reset`

This fails with:

PG::ObjectInUse: ERROR:  database "my_db" is being accessed by other users
DETAIL:  There is 1 other session using the database.

I understand why this happens. The User.count opens a connection so the reset cannot happen. I have tried a few things to close said connection, including calling close and reset_active_connections!, to no avail. Any idea how I can achieve this? Some other pursuits were not fruitful as well, such as trying to close the connection by passing the process ID to psql.

n_x_l · Accepted Answer · 2019-12-03 00:56:03Z

2

The right call is:

ApplicationRecord.connection_pool.connections.map &:disconnect!

I simply couldn't find the right method the first time, had to read the AR code in more detail to find it.

answered Dec 3, 2019 at 0:56

n_x_l

1,6143 gold badges19 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Rails - Close current DB connection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related