[I] Connection is garbage-collected, use dbDisconnect() to avoid this. [arrow]

["PMassicotte (via GitHub)" <gi...@apache.org>]

PMassicotte opened a new issue, #38382:
URL: https://github.com/apache/arrow/issues/38382

   ### Describe the bug, including details regarding any error messages, version, and platform.
   
   ``` r
   # " I have this folowing code:
   
   library(tidyverse)
   library(arrow)
   #> 
   #> Attaching package: 'arrow'
   #> The following object is masked from 'package:lubridate':
   #> 
   #>     duration
   #> The following object is masked from 'package:utils':
   #> 
   #>     timestamp
   
   bb <- s3_bucket(
     bucket = "cdoc",
     endpoint_override = "s3.valeria.science",
     anonymous = TRUE
   )
   
   open_dataset(bb) |>
     to_duckdb() |>
     summarise(mean_doc = mean(doc, na.rm = TRUE), .by = ecosystem) |>
     collect()
   #> # A tibble: 5 × 2
   #>   ecosystem mean_doc
   #>   <chr>        <dbl>
   #> 1 lake        1323. 
   #> 2 coastal      253. 
   #> 3 river        527. 
   #> 4 ocean         60.2
   #> 5 estuary      235.
   ```
   
   When I quit R I get this message:
   
   ``` r
   Warning messages:
   Connection is garbage-collected, use dbDisconnect() to avoid this.
   Database is garbage-collected, use dbDisconnect(con, shutdown=TRUE) or duckd
   duckdb_shutdown(drv) to avoid this.
   ```
   
   ``` r
   # " One way to avoid this is to explicitly use a connection (credit:
   # https://discord.com/channels/909674491309850675/921100826884341781/1165053445657608222):
   
   library(DBI)
   library(duckdb)
   
   drv <- duckdb()
   con <- dbConnect(drv)
   
   open_dataset(bb) |>
     to_duckdb(con = con) |>
     summarise(mean_doc = mean(doc, na.rm = TRUE), .by = ecosystem) |>
     collect()
   #> # A tibble: 5 × 2
   #>   ecosystem mean_doc
   #>   <chr>        <dbl>
   #> 1 lake        1323. 
   #> 2 river        527. 
   #> 3 coastal      253. 
   #> 4 ocean         60.2
   #> 5 estuary      235.
   
   dbDisconnect(con)
   duckdb_shutdown(drv)
   ```
   
   Is this expected or it should be done automatically?
   
   <sup>Created on 2023-10-21 with [reprex v2.0.2](https://reprex.tidyverse.org)</sup>
   
   ### Component(s)
   
   R


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [R] Connection is garbage-collected, use dbDisconnect() to avoid this (when using to_duckdb()) [arrow]

["thisisnic (via GitHub)" <gi...@apache.org>]

thisisnic closed issue #38382: [R] Connection is garbage-collected, use dbDisconnect() to avoid this (when using to_duckdb())
URL: https://github.com/apache/arrow/issues/38382


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org