Shiny App频繁与服务器断开连接，需多次重载才可使用

问题说明 #

Shiny应用频繁与服务器断开连接，需手动重载约10次才能正常使用，服务器日志未显示任何错误信息。

修复建议 #

• 延长会话超时时间：在应用开头添加options(shiny.timeout = 3600)，将超时时间设置为1小时，避免因会话超时触发断连。
• 优化数据加载逻辑：日志显示应用重复加载Qualtrics数据，建议将数据缓存到服务器本地（用saveRDS()存储，启动时通过readRDS()读取），减少重复请求的耗时与资源占用。
• 检查服务器资源配置：确认shinyapps.io实例的内存、CPU配额是否足够，若数据量较大，升级实例规格。
• 取消重连次数限制：在UI中添加tags$script("Shiny.setReconnectLimit(Infinity);")，让应用自动无限重试连接，无需手动刷新。
• 排查网络稳定性：若用户端网络波动较大，建议切换至稳定网络环境；服务器端可配置WebSocket长连接保持机制。

服务器日志片段 #

2024-05-31T10:03:32.459573+00:00 shinyapps[12060394]:   meta_Browser = col_character(),
2024-05-31T10:03:32.464524+00:00 shinyapps[12060394]:   meta_Version = col_character(),
2024-05-31T10:03:32.469311+00:00 shinyapps[12060394]:   `meta_Operating System` = col_character(),
2024-05-31T10:03:32.474291+00:00 shinyapps[12060394]:   meta_Resolution = col_character(),
2024-05-31T10:03:32.479509+00:00 shinyapps[12060394]:   height_male_cm = col_logical(),
2024-05-31T10:03:32.484553+00:00 shinyapps[12060394]:   weight_male_kg = col_logical(),
2024-05-31T10:03:32.489709+00:00 shinyapps[12060394]:   height_female_cm = col_logical(),
2024-05-31T10:03:32.495436+00:00 shinyapps[12060394]:   height_female_inches_3 = col_character(),
2024-05-31T10:03:32.500224+00:00 shinyapps[12060394]:   weight_female_kg = col_logical(),
2024-05-31T10:03:32.505657+00:00 shinyapps[12060394]:   sex_55_TEXT = col_logical(),
2024-05-31T10:03:32.510581+00:00 shinyapps[12060394]:   religion.identificat_9_TEXT = col_character(),
2024-05-31T10:03:32.515766+00:00 shinyapps[12060394]:   debrief.comment = col_character(),
2024-05-31T10:03:32.520976+00:00 shinyapps[12060394]:   Q_Language = col_character(),
2024-05-31T10:03:32.527512+00:00 shinyapps[12060394]:   testing = col_logical()
2024-05-31T10:03:32.532506+00:00 shinyapps[12060394]:   # ... with 5 more columns
2024-05-31T10:03:32.538553+00:00 shinyapps[12060394]: )
2024-05-31T10:03:32.543668+00:00 shinyapps[12060394]: ℹ Use `spec()` for the full column specifications.
2024-05-31T10:03:32.548719+00:00 shinyapps[12060394]: 
2024-05-31T10:03:32.553575+00:00 shinyapps[12060394]: Your original .Renviron will be backed up and stored in your R HOME directory if needed.
2024-05-31T10:03:32.560939+00:00 shinyapps[12060394]: Your Qualtrics key and base URL have been stored in your .Renviron.  
2024-05-31T10:03:32.565862+00:00 shinyapps[12060394]: To use now, restart R or run `readRenviron("~/.Renviron")`
2024-05-31T10:03:35.405457+00:00 shinyapps[12060394]:     |                                                                               |                                                                      |   0%   |                                                                               |========================                                              |  34%   |                                                                               |================================================                      |  69%   |                                                                               |======================================================================| 100%
2024-05-31T10:03:37.274785+00:00 shinyapps[12060394]: 
2024-05-31T10:03:37.280132+00:00 shinyapps[12060394]: ── Column specification ────────────────────────────────────────────────────────
2024-05-31T10:03:37.285433+00:00 shinyapps[12060394]: cols(
2024-05-31T10:03:37.290817+00:00 shinyapps[12060394]:   .default = col_double(),
2024-05-31T10:03:37.296958+00:00 shinyapps[12060394]:   StartDate = col_datetime(format = ""),
2024-05-31T10:03:37.302653+00:00 shinyapps[12060394]:   EndDate = col_datetime(format = ""),
2024-05-31T10:03:37.308441+00:00 shinyapps[12060394]:   RecordedDate = col_datetime(format = ""),
2024-05-31T10:03:37.313395+00:00 shinyapps[12060394]:   ResponseId = col_character(),
2024-05-31T10:03:37.318623+00:00 shinyapps[12060394]:   DistributionChannel = col_character(),
2024-05-31T10:03:37.323711+00:00 shinyapps[12060394]:   UserLanguage = col_character(),
2024-05-31T10:03:37.328743+00:00 shinyapps[12060394]:   meta_Browser = col_character(),
2024-05-31T10:03:37.333643+00:00 shinyapps[12060394]:   meta_Version = col_character(),
2024-05-31T10:03:37.338800+00:00 shinyapps[12060394]:   `meta_Operating System` = col_character(),
2024-05-31T10:03:37.344076+00:00 shinyapps[12060394]:   meta_Resolution = col_character(),
2024-05-31T10:03:37.349141+00:00 shinyapps[12060394]:   height_male_cm = col_logical(),
2024-05-31T10:03:37.354627+00:00 shinyapps[12060394]:   weight_male_kg = col_logical(),
2024-05-31T10:03:37.360695+00:00 shinyapps[12060394]:   height_female_cm = col_logical(),
2024-05-31T10:03:37.365949+00:00 shinyapps[12060394]:   height_female_inches_3 = col_character(),
2024-05-31T10:03:37.370929+00:00 shinyapps[12060394]:   weight_female_kg = col_logical(),
2024-05-31T10:03:37.376164+00:00 shinyapps[12060394]:   sex_55_TEXT = col_logical(),
2024-05-31T10:03:37.381410+00:00 shinyapps[12060394]:   religion.identificat_9_TEXT = col_character(),
2024-05-31T10:03:37.386601+00:00 shinyapps[12060394]:   debrief.comment = col_character(),
2024-05-31T10:03:37.391587+00:00 shinyapps[12060394]:   Q_Language = col_character(),
2024-05-31T10:03:37.396624+00:00 shinyapps[12060394]:   testing = col_logical()
2024-05-31T10:03:37.401349+00:00 shinyapps[12060394]:   # ... with 5 more columns
2024-05-31T10:03:37.406578+00:00 shinyapps[12060394]: )
2024-05-31T10:03:37.413837+00:00 shinyapps[12060394]: ℹ Use `spec()` for the full column specifications.
2024-05-31T10:03:37.418699+00:00 shinyapps[12060394]:

内容的提问来源于stack exchange，提问作者Olivia