Loose connections and Connections pane

database
bug

#1

I have a problem with db-connections and my connections pane in R-studio.

If I create a databaseconnection like

 readcon <- DBI::dbConnect(odbc::obdbc(), ...)

The connection will appear in the connections pane.
I can then close the connection with

 DBI::dbDisconnect(readcon)

The connection will then be closed in the connections pane.

However. If I open two connections only one connection appears in the pane.
If I remove the second connection the connection pane will show that there are no open connections.

readcon <- DBI::dbConnect(odbc::obdbc(), ...)
readcon_2 <- DBI::dbConnect(odbc::obdbc(), ...)
DBI::dbDisconnect(readcon_2)

However, the first connection readconis still alive and I can call it:

dplyr::tbl(readcon, ')

I can still close the connection but if I remove the refererence the connection will be loose.

 rm(readcon)

Only restarting the session will remove the connection.

  1. Is this a Bug in the connections pane?
  2. Can I see open connections without reference?

This looks like a bug to me