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 readcon
is 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.
- Is this a Bug in the connections pane?
- Can I see open connections without reference?
This looks like a bug to me