Hello, I ve the message "An error has occured" when I try to launch the leaflet page that I ve created.
The message is : Error 137, "The application failed to start"
The time seems too be long before to get the message. More than 15 secondes
(I ve too a warning about 'reticulate' which is "remplaced" by .GlobalEnv.)
I use a Slq request to get the data from my PostgreSql database.
df_postgresUsersLeafLet <- dbGetQuery(con, "SELECT distinct instance_id,first_name,last_name,gender,postcode,latitude,longitude,moving_date,city,'D' as Demenagement from core.users inner join core.address on core.users.destination_address_id=core.address.id
where core.address.latitude>41 and core.address.latitude<51 and core.address.longitude>-5.5667 and core.address.longitude<8.5316" )
Regroupement<-df_postgresUsersLeafLet%>% count(instance_id,latitude,longitude,city)
ui <- fluidPage(
p(),
leafletOutput("mymap")
)
server <- function(input, output, session) {
ERA <- Regroupement %>%filter(instance_id=="eraimmobilier")
SERGIC <- Regroupement %>%filter(instance_id=="sergic")
output$mymap <- renderLeaflet({
leaflet(Regroupement) %>%
addTiles() %>%
addCircles(data=ERA,
lat=~latitude,
lng=~longitude,
radius=~n,
group = "eraimmobilier",
color = "#a500a5", fillOpacity = 0.1)%>% addCircles(data=SERGIC,
lat=~latitude,
lng=~longitude,
radius=~n,
group = "sergic",
color = "#a500a5", fillOpacity = 0.1)%>%addLayersControl(
overlayGroups = c("eraimmobilier", "sergic"),
options = layersControlOptions(collapsed = FALSE))
})
}
shinyApp(ui, server)
Do you have an idea about what is bad with that. ?
Thanks.
Can you show the logs of your app? that could tell us where to start looking for problems.
Hello I ve put the application with a "shinyapps.io/" Application, I don't find on the dashboard if I can get a log.
Is there a way to get it.
Thank you.
Hello, this is the log, thanks you for your presentation of the correct way.
2020-01-27T16:52:43.506990+00:00 shinyapps[1639512]: shiny version: 1.4.0
2020-01-27T16:52:43.506990+00:00 shinyapps[1639512]: httpuv version: 1.5.2
2020-01-27T16:52:43.507007+00:00 shinyapps[1639512]: knitr version: 1.25
2020-01-27T16:52:43.507006+00:00 shinyapps[1639512]: rmarkdown version: 1.16
2020-01-27T16:52:43.507015+00:00 shinyapps[1639512]: jsonlite version: 1.6
2020-01-27T16:52:43.507030+00:00 shinyapps[1639512]: RJSONIO version: (none)
2020-01-27T16:52:43.507604+00:00 shinyapps[1639512]: Using pandoc at /opt/connect/ext/pandoc2
2020-01-27T16:52:43.507042+00:00 shinyapps[1639512]: htmltools version: 0.4.0
2020-01-27T16:52:47.988068+00:00 shinyapps[system]: Out of memory!
2020-01-27T16:55:12.982464+00:00 shinyapps[1639512]: Warning: l'espace de nom ‘reticulate’ n'est pas disponible et a été remplacé
2020-01-27T16:55:12.982466+00:00 shinyapps[1639512]: par .GlobalEnv lors du traitement de l'objet ‘test’
2020-01-27T16:55:39.402905+00:00 shinyapps[1639512]: Server version: 1.7.8-7
2020-01-27T16:55:39.402923+00:00 shinyapps[1639512]: LANG: fr_FR.UTF-8
2020-01-27T16:55:39.402924+00:00 shinyapps[1639512]: R version: 3.6.1
2020-01-27T16:55:39.402924+00:00 shinyapps[1639512]: shiny version: 1.4.0
2020-01-27T16:55:39.402925+00:00 shinyapps[1639512]: httpuv version: 1.5.2
2020-01-27T16:55:39.402950+00:00 shinyapps[1639512]: rmarkdown version: 1.16
2020-01-27T16:55:39.402961+00:00 shinyapps[1639512]: knitr version: 1.25
2020-01-27T16:55:39.402962+00:00 shinyapps[1639512]: jsonlite version: 1.6
2020-01-27T16:55:39.402970+00:00 shinyapps[1639512]: RJSONIO version: (none)
2020-01-27T16:55:39.402991+00:00 shinyapps[1639512]: htmltools version: 0.4.0
2020-01-27T16:55:39.403156+00:00 shinyapps[1639512]: Using pandoc at /opt/connect/ext/pandoc2
2020-01-27T16:55:39.803900+00:00 shinyapps[system]: Out of memory!
2020-01-27T16:58:41.514144+00:00 shinyapps[1639512]: Warning: l'espace de nom ‘reticulate’ n'est pas disponible et a été remplacé
2020-01-27T16:58:41.514146+00:00 shinyapps[1639512]: par .GlobalEnv lors du traitement de l'objet ‘test’
2020-01-27T16:59:08.106547+00:00 shinyapps[1639512]: Server version: 1.7.8-7
2020-01-27T16:59:08.106572+00:00 shinyapps[1639512]: LANG: fr_FR.UTF-8
2020-01-27T16:59:08.106616+00:00 shinyapps[1639512]: RJSONIO version: (none)
2020-01-27T16:59:08.106573+00:00 shinyapps[1639512]: R version: 3.6.1
2020-01-27T16:59:08.106654+00:00 shinyapps[1639512]: htmltools version: 0.4.0
2020-01-27T16:59:08.106574+00:00 shinyapps[1639512]: shiny version: 1.4.0
2020-01-27T16:59:08.106595+00:00 shinyapps[1639512]: httpuv version: 1.5.2
2020-01-27T16:59:08.106604+00:00 shinyapps[1639512]: rmarkdown version: 1.16
2020-01-27T16:59:08.106604+00:00 shinyapps[1639512]: knitr version: 1.25
2020-01-27T16:59:08.106612+00:00 shinyapps[1639512]: jsonlite version: 1.6
2020-01-27T16:59:08.106817+00:00 shinyapps[1639512]: Using pandoc at /opt/connect/ext/pandoc2
2020-01-27T16:59:08.391152+00:00 shinyapps[system]: Out of memory!
2020-01-27T17:00:16.746203+00:00 shinyapps[1639512]: Warning: l'espace de nom ‘reticulate’ n'est pas disponible et a été remplacé
2020-01-27T17:00:16.746205+00:00 shinyapps[1639512]: par .GlobalEnv lors du traitement de l'objet ‘test’
2020-01-27T17:00:43.015789+00:00 shinyapps[1639512]: LANG: fr_FR.UTF-8
2020-01-27T17:00:43.015790+00:00 shinyapps[1639512]: R version: 3.6.1
2020-01-27T17:00:43.015791+00:00 shinyapps[1639512]: shiny version: 1.4.0
2020-01-27T17:00:43.015791+00:00 shinyapps[1639512]: httpuv version: 1.5.2
2020-01-27T17:00:43.015800+00:00 shinyapps[1639512]: rmarkdown version: 1.16
2020-01-27T17:00:43.015801+00:00 shinyapps[1639512]: knitr version: 1.25
2020-01-27T17:00:43.015807+00:00 shinyapps[1639512]: jsonlite version: 1.6
2020-01-27T17:00:43.015838+00:00 shinyapps[1639512]: RJSONIO version: (none)
2020-01-27T17:00:43.015872+00:00 shinyapps[1639512]: htmltools version: 0.4.0
2020-01-27T17:00:43.015752+00:00 shinyapps[1639512]: Server version: 1.7.8-7
2020-01-27T17:00:43.016013+00:00 shinyapps[1639512]: Using pandoc at /opt/connect/ext/pandoc2
2020-01-27T17:00:46.798938+00:00 shinyapps[system]: Out of memory!
It seems you are running out of memory if you are on the free plan, you are under heavy memory and processing power limitations.
