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:33289
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
                                           ^
  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) = '14' AND
                                   substr(id_setor_mundest, 1, 2) = '14' AND
                                   durations < 120 AND
                                   destin_mun IN (140010)
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) = '14' 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) = '14' AND
                                   substr(id_setor_mundest, 1, 2) = '14' AND
                                   durations < 120 AND
                                   destin_mun IN (140010)
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) = '14' 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) = '17' AND
                                   substr(id_setor_mundest, 1, 2) = '17' AND
                                   durations < 120 AND
                                   destin_mun IN (172100)
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) = '17' 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) = '17' AND
                                   substr(id_setor_mundest, 1, 2) = '17' AND
                                   durations < 120 AND
                                   destin_mun IN (170210,172100)
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) = '17' AND
                                           ^
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: Connection is garbage-collected, use dbDisconnect() to avoid this.
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#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) = '21' AND
                                   substr(id_setor_mundest, 1, 2) = '21' AND
                                   durations < 120 AND
                                   destin_mun IN (211130)
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) = '21' 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) = '21' AND
                                   substr(id_setor_mundest, 1, 2) = '21' AND
                                   durations < 120 AND
                                   destin_mun IN (210530,211130,211220)
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) = '21' 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.


Execution halted