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 (<http://conflicted.r-lib.org/>) 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:41461
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 < 120 AND
destin_mun IN (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 4: substring(destin_mun,1,2) = '11' AND
^
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
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#184]
166: func
126: drawPlot
112: <reactive:plotObj>
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 < 120 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 4: substring(destin_mun,1,2) = '11' AND
^
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#286]
166: func
126: drawPlot
112: <reactive:plotObj>
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) = '16' AND
substr(id_setor_mundest, 1, 2) = '16' AND
durations < 120 AND
destin_mun IN (160030)
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 4: substring(destin_mun,1,2) = '16' AND
^
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#184]
166: func
126: drawPlot
112: <reactive:plotObj>
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) = '16' AND
substr(id_setor_mundest, 1, 2) = '16' AND
durations < 120 AND
destin_mun IN (160030)
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 4: substring(destin_mun,1,2) = '16' AND
^
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#286]
166: func
126: drawPlot
112: <reactive:plotObj>
96: drawReactive
83: renderFunc
82: output$graf2
1: runApp
Warning: Error in : rapi_execute: Failed to run query
Error: Conversion Error: Could not convert string '' to INT32
LINE 2: WHERE destin_mun = '' AND durations < 120
^
178: rapi_execute
177: duckdb_execute
176: duckdb_result
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#402]
166: func
126: drawPlot
112: <reactive:plotObj>
96: drawReactive
83: renderFunc
82: output$graf3
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.
Execution halted