su: ignoring --preserve-environment, it's mutually exclusive with --login Linking to GEOS 3.12.1, GDAL 3.8.4, PROJ 9.4.0; sf_use_s2() is TRUE ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ── ✔ dplyr 1.1.4 ✔ readr 2.1.5 ✔ forcats 1.0.0 ✔ stringr 1.5.1 ✔ ggplot2 3.5.1 ✔ tibble 3.2.1 ✔ lubridate 1.9.3 ✔ tidyr 1.3.1 ✔ purrr 1.0.2 ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ── ✖ dplyr::filter() masks stats::filter() ✖ dplyr::lag() masks stats::lag() ℹ Use the conflicted package () to force all conflicts to become errors Attaching package: ‘shinydashboard’ The following object is masked from ‘package:graphics’: box Attaching package: ‘magrittr’ The following object is masked from ‘package:purrr’: set_names The following object is masked from ‘package:tidyr’: extract Attaching package: ‘plotly’ The following object is masked from ‘package:ggplot2’: last_plot The following object is masked from ‘package:stats’: filter The following object is masked from ‘package:graphics’: layout Loading required package: sp Please note that rgdal will be retired during October 2023, plan transition to sf/stars/terra functions using GDAL and PROJ at your earliest convenience. See https://r-spatial.org/r/2023/05/15/evolution4.html and https://github.com/r-spatial/evolution rgdal: version: 1.6-7, (SVN revision 1203) Geospatial Data Abstraction Library extensions to R successfully loaded Loaded GDAL runtime: GDAL 3.8.4, released 2024/02/08 Path to GDAL shared files: /usr/share/gdal GDAL does not use iconv for recoding strings. GDAL binary built with GEOS: TRUE Loaded PROJ runtime: Rel. 9.4.0, March 1st, 2024, [PJ_VERSION: 940] Path to PROJ shared files: /home/shiny/.local/share/proj:/usr/share/proj PROJ CDN enabled: FALSE Linking to sp version:2.1-4 To mute warnings of possible GDAL/OSR exportToProj4() degradation, use options("rgdal_show_exportToProj4_warnings"="none") before loading sp or rgdal. Listening on http://127.0.0.1:35031 Warning: The select input "sele1" contains a large number of options; consider using server-side selectize for massively improved performance. See the Details section of the ?selectizeInput help topic. Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '11' AND substr(id_setor_mundest, 1, 2) = '11' AND durations < 180 Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 2: WHERE substring(destin_mun,1,2) = '11' AND substr(id_setor_mundest, 1, 2) = '11' AND durations < 180... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#58] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf1 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '11' AND substr(id_setor_mundest, 1, 2) = '11' AND durations < 180 AND destin_mun IN (110012,110020) Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#80] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '11' AND substr(id_setor_mundest, 1, 2) = '11' AND durations < 180 Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 2: WHERE substring(destin_mun,1,2) = '11' AND substr(id_setor_mundest, 1, 2) = '11' AND durations < 180... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#63] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf1 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '11' AND substr(id_setor_mundest, 1, 2) = '11' AND durations < 180 AND destin_mun IN (110012,110020) Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#84] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '13' AND substr(id_setor_mundest, 1, 2) = '13' AND durations < 180 Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 2: WHERE substring(destin_mun,1,2) = '13' AND substr(id_setor_mundest, 1, 2) = '13' AND durations < 180... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#63] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf1 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '13' AND substr(id_setor_mundest, 1, 2) = '13' AND durations < 180 AND destin_mun IN (130260,130340,130406) Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#84] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '13' AND substr(id_setor_mundest, 1, 2) = '13' AND durations < 180 Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 2: WHERE substring(destin_mun,1,2) = '13' AND substr(id_setor_mundest, 1, 2) = '13' AND durations < 180... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#63] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf1 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '13' AND substr(id_setor_mundest, 1, 2) = '13' AND durations < 180 AND destin_mun IN (130260,130340,130406) Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#84] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '33' AND substr(id_setor_mundest, 1, 2) = '33' AND durations < 180 Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 2: WHERE substring(destin_mun,1,2) = '33' AND substr(id_setor_mundest, 1, 2) = '33' AND durations < 180... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#63] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf1 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '33' AND substr(id_setor_mundest, 1, 2) = '33' AND durations < 180 AND destin_mun IN (330100,330455,330630) Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#84] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new WHERE substr(destin_mun,1,2) = '11' AND substr(id_setor_mundest, 1, 2) = '11' AND durations < 180 Error: Binder Error: No function matches the given name and argument types 'substr(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substr(VARCHAR, BIGINT, BIGINT) -> VARCHAR substr(VARCHAR, BIGINT) -> VARCHAR LINE 2: WHERE substr(destin_mun,1,2) = '11' AND substr(id_setor_mundest, 1, 2) = '11' AND durations < 180... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#63] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf1 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '11' AND substr(id_setor_mundest, 1, 2) = '11' AND durations < 180 AND destin_mun IN (110012,110020) Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#84] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new WHERE substr(destin_mun,1,2) = '53' AND substr(id_setor_mundest, 1, 2) = '53' AND durations < 180 Error: Binder Error: No function matches the given name and argument types 'substr(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substr(VARCHAR, BIGINT, BIGINT) -> VARCHAR substr(VARCHAR, BIGINT) -> VARCHAR LINE 2: WHERE substr(destin_mun,1,2) = '53' AND substr(id_setor_mundest, 1, 2) = '53' AND durations < 180... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#63] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf1 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '53' AND substr(id_setor_mundest, 1, 2) = '53' AND durations < 180 AND destin_mun IN (530010) Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#84] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new WHERE substr(destin_mun,1,2) = '53' AND substr(id_setor_mundest, 1, 2) = '53' AND durations < 180; Error: Binder Error: No function matches the given name and argument types 'substr(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substr(VARCHAR, BIGINT, BIGINT) -> VARCHAR substr(VARCHAR, BIGINT) -> VARCHAR LINE 1: ... durations FROM tb_resul_all_new WHERE substr(destin_mun,1,2) = '53' AND subst... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#63] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf1 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '53' AND substr(id_setor_mundest, 1, 2) = '53' AND durations < 180 AND destin_mun IN (530010) Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 1: ...durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '53' AND su... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#86] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new WHERE substr(destin_mun,1,2) = '41' AND substr(id_setor_mundest, 1, 2) = '41' AND durations < 180; Error: Binder Error: No function matches the given name and argument types 'substr(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substr(VARCHAR, BIGINT, BIGINT) -> VARCHAR substr(VARCHAR, BIGINT) -> VARCHAR LINE 1: ... durations FROM tb_resul_all_new WHERE substr(destin_mun,1,2) = '41' AND subst... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#63] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf1 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '41' AND substr(id_setor_mundest, 1, 2) = '41' AND durations < 180 AND destin_mun IN (410480,410690,411370,411520) Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR substring(VARCHAR, BIGINT) -> VARCHAR LINE 1: ...durations FROM tb_resul_all_new WHERE substring(destin_mun,1,2) = '41' AND su... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#86] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new WHERE substr(destin_mun,1,2) = '11' AND substr(id_setor_mundest, 1, 2) = '11' AND durations < 180; Error: Binder Error: No function matches the given name and argument types 'substr(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substr(VARCHAR, BIGINT, BIGINT) -> VARCHAR substr(VARCHAR, BIGINT) -> VARCHAR LINE 1: ... durations FROM tb_resul_all_new WHERE substr(destin_mun,1,2) = '11' AND subst... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#63] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf1 1: runApp Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new WHERE substr(destin_mun,1,2) = '15' AND substr(id_setor_mundest, 1, 2) = '15' AND durations < 180; Error: Binder Error: No function matches the given name and argument types 'substr(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts. Candidate functions: substr(VARCHAR, BIGINT, BIGINT) -> VARCHAR substr(VARCHAR, BIGINT) -> VARCHAR LINE 1: ... durations FROM tb_resul_all_new WHERE substr(destin_mun,1,2) = '15' AND subst... ^ 176: rapi_prepare 175: .local 174: dbSendQuery 172: .local 171: dbGetQuery 169: conn_banco_duck 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#63] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf1 1: runApp Warning: Connection is garbage-collected, use dbDisconnect() to avoid this. Warning: There were 5 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = T)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 4 remaining warnings. Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: There were 5 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = TRUE)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 4 remaining warnings. Warning: There were 5 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = T)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 4 remaining warnings. Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: There were 5 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = TRUE)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 4 remaining warnings. Warning: There were 5 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = T)`. ℹ In group 2: `class = "120 - 149 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 4 remaining warnings. Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: There were 6 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = TRUE)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 5 remaining warnings. Warning: There were 5 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = T)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 4 remaining warnings. Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: There were 6 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = TRUE)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 5 remaining warnings. Warning: There were 5 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = T)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 4 remaining warnings. Warning: Error in cat: argument 1 (type 'list') cannot be handled by 'cat' 169: cat 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#108] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: There were 3 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = TRUE)`. ℹ In group 2: `class = "120 - 149 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 2 remaining warnings. Warning: There were 5 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = T)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 4 remaining warnings. Warning: Error in cat: argument 1 (type 'list') cannot be handled by 'cat' 169: cat 168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#108] 166: func 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: There were 2 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = TRUE)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 1 remaining warning. Warning: There was 1 warning in `summarise()`. ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = T)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: There were 6 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = TRUE)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 5 remaining warnings. Warning: There were 6 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = T)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 5 remaining warnings. Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: There were 5 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = TRUE)`. ℹ In group 2: `class = "120 - 149 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 4 remaining warnings. Warning: There were 5 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = T)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 4 remaining warnings. Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Warning: There was 1 warning in `summarise()`. ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = TRUE)`. ℹ In group 3: `class = "150 - 179 min"`. Caused by warning: ! NAs introduced by coercion Warning: There were 2 warnings in `summarise()`. The first warning was: ℹ In argument: `pop = sum(as.numeric(pop2022), na.rm = T)`. ℹ In group 1: `class = "0 - 29 min"`. Caused by warning: ! NAs introduced by coercion ℹ Run `dplyr::last_dplyr_warnings()` to see the 1 remaining warning. Warning: Error in geom_col: Problem while computing aesthetics. ℹ Error occurred in the 1st layer. Caused by error in `check_aesthetics()`: ! Aesthetics must be either length 1 or the same as the data (5). ✖ Fix the following mappings: `y`. 196: 195: signalCondition 194: signal_abort 193: rlang::abort 192: cli::cli_abort 191: handlers[[1L]] 190: 189: signalCondition 188: signal_abort 187: rlang::abort 186: cli::cli_abort 185: check_aesthetics 184: compute_aesthetics 183: l$compute_aesthetics 182: f 175: by_layer 174: ggplot_build.ggplot 172: print.ggplot 167: func 165: f 164: Reduce 155: do 154: hybrid_chain 126: drawPlot 112: 96: drawReactive 83: renderFunc 82: output$graf2 1: runApp Execution halted