Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

explorePgtraj freezes with puechcirc #37

Open
basille opened this issue Jun 20, 2018 · 0 comments
Open

explorePgtraj freezes with puechcirc #37

basille opened this issue Jun 20, 2018 · 0 comments

Comments

@basille
Copy link
Member

basille commented Jun 20, 2018

It's all in the title:

library("adehabitatLT")
data(puechcirc)
attr(puechcirc, "proj4string") <- CRS("+init=epsg:27573")  # This is Lambert III projection

library("rpostgisLT")
drv <- dbDriver("PostgreSQL")
con <- dbConnect(drv, dbname = "<db>", host = "localhost", user = "<user>", password = "<pwd>")
ltraj2pgtraj(con, puechcirc)

So far so good, the trajectory is successfully created in the DB. Now with explorePgtraj, everything works fine and smooth, until I reach 1993-08-25 04:10, and it freezes (you can simply press until it happens):

explorePgtraj(conn = con, schema = "traj", pgtraj = "puechcirc")

which returns:

MATERIALIZED VIEW step_geometry_shiny_puechcirc created in schema 'traj'.
Query executed:
VACUUM ANALYZE "traj"."step_geometry_shiny_puechcirc";
MATERIALIZED VIEW all_burst_summary_shiny created in schema 'traj'.
Query executed:
VACUUM ANALYZE "traj"."all_burst_summary_shiny";
Loading required package: shiny

Listening on http://127.0.0.1:5590
ERROR: [_parse_http_data] invalid HTTP method
Warning in (function (w)  :
  Didn't find any steps at 1993-08-24 15:20:00 + 1H 40M 0S
Warning: 'sf::st_read_db' is deprecated.
Use 'st_read' instead.
See help("Deprecated")
Warning in (function (w)  :
  Didn't find any steps at 1993-08-24 15:30:00 + 1H 40M 0S
Warning: 'sf::st_read_db' is deprecated.
Use 'st_read' instead.
See help("Deprecated")

... [many similar warnings]

Warning in (function (w)  :
  Didn't find any steps at 1993-08-25 04:10:00 + 1H 40M 0S
Warning: 'sf::st_read_db' is deprecated.
Use 'st_read' instead.
See help("Deprecated")
Warning: Error in [.data.frame: undefined columns selected
  [No stack trace available]

I can kill the tab and the R call, and everything is back to normal.


R info:

> sessionInfo()
R version 3.3.3 (2017-03-06)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Debian GNU/Linux 9 (stretch)

locale:
[1] C

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
 [1] shiny_1.1.0         rpostgisLT_0.6.0    rpostgis_1.4.0-1   
 [4] RPostgreSQL_0.6-2   DBI_1.0.0           adehabitatLT_0.3.23
 [7] CircStats_0.2-4     boot_1.3-18         MASS_7.3-45        
[10] adehabitatMA_0.3.12 ade4_1.7-11         sp_1.3-1           
[13] cowsay_0.6.0        basr_0.11          

loaded via a namespace (and not attached):
 [1] sf_0.6-3           lattice_0.20-34    mapview_2.4.0      colorspace_1.3-2  
 [5] viridisLite_0.3.0  htmltools_0.3.6    stats4_3.3.3       yaml_2.1.19       
 [9] base64enc_0.1-3    rlang_0.2.1        R.oo_1.22.0        e1071_1.6-8       
[13] later_0.7.3        R.utils_2.6.0      fortunes_1.5-4     foreach_1.4.4     
[17] stringr_1.3.1      rgeos_0.3-28       munsell_0.5.0      raster_2.6-7      
[21] R.methodsS3_1.7.1  htmlwidgets_1.2    codetools_0.2-15   httpuv_1.4.4.1    
[25] crosstalk_1.0.0    class_7.3-14       shinyWidgets_0.4.3 gdalUtils_2.0.1.14
[29] Rcpp_0.12.17       xtable_1.8-2       promises_1.0.1     scales_0.5.0.9000 
[33] classInt_0.2-3     satellite_1.0.1    webshot_0.5.0      leaflet_2.0.1     
[37] jsonlite_1.5       mime_0.5           rmsfact_0.0.3      png_0.1-7         
[41] digest_0.6.15      stringi_1.2.3      grid_3.3.3         rgdal_1.3-2       
[45] tools_3.3.3        magrittr_1.5       spData_0.2.9.0     lubridate_1.7.4   
[49] iterators_1.0.9    R6_2.2.2           units_0.6-0        compiler_3.3.3    

PostgreSQL/PostGIS info:

> dbGetQuery(con, "SELECT version();")
                                                                                                           version
1 PostgreSQL 9.6.9 on x86_64-pc-linux-gnu (Debian 9.6.9-2.pgdg+1), compiled by gcc (Debian 7.3.0-18) 7.3.0, 64-bit

> dbGetQuery(con, "SELECT PostGIS_Version();")
                        postgis_version
1 2.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant