Web app crashing with simple query

[cristinamullin]

Describe the bug

TADAShiny on cloud.gov crashes with simple query. The same query works fine if you run TADAShiny locally.

To Reproduce

Steps to reproduce the behavior:

1. Open application: https://owshiny-dev.app.cloud.gov/tada-dev/

2. Use Option B on the data import tab.

State = OK
Characteristic Group = Nutrient
Date = 2022-03-21 to 2024-03-21

3. Run query

4. The application turns grey (crashes)

see error in log stream from cloud.gov

10:28:48.470: [APP/PROC/WEB.0] [1] "Downloading WQP query results. This may take some time depending upon the query size."
10:28:49.120: [APP/PROC/WEB.0] NEWS: USGS data availability and format are changing.
10:28:49.120: [APP/PROC/WEB.0] Beginning in mid-March 2024 the data obtained from legacy profiles
10:28:49.120: [APP/PROC/WEB.0] will not include new USGS data or recent updates to existing data.
10:28:49.120: [APP/PROC/WEB.0] To view the status of changes in data availability and code functionality, visit:
10:28:49.120: [APP/PROC/WEB.0] https://doi-usgs.github.io/dataRetrieval/articles/Status.html
10:28:49.120: [APP/PROC/WEB.0] If you have additional questions about these changes,
10:28:49.120: [APP/PROC/WEB.0] email [email protected].
10:28:49.487: [APP/PROC/WEB.0] sh: 1: wc: not found
10:28:49.831: [APP/PROC/WEB.0] NEWS: USGS data availability and format are changing.
10:28:49.831: [APP/PROC/WEB.0] Beginning in mid-March 2024 the data obtained from legacy profiles
10:28:49.831: [APP/PROC/WEB.0] will not include new USGS data or recent updates to existing data.
10:28:49.831: [APP/PROC/WEB.0] To view the status of changes in data availability and code functionality, visit:
10:28:49.831: [APP/PROC/WEB.0] https://doi-usgs.github.io/dataRetrieval/articles/Status.html
10:28:49.831: [APP/PROC/WEB.0] If you have additional questions about these changes,
10:28:49.831: [APP/PROC/WEB.0] email [email protected].
10:28:50.239: [APP/PROC/WEB.0] [1] "Data successfully downloaded. Running TADA_AutoClean function."
10:28:50.239: [APP/PROC/WEB.0] [1] "TADA_Autoclean: creating TADA-specific columns."
10:28:50.254: [APP/PROC/WEB.0] [1] "TADA_Autoclean: checking for special characters."
10:28:50.427: [APP/PROC/WEB.0] [1] "TADA_Autoclean: updating deprecated (i.e. retired) characteristic names."
10:28:50.711: [APP/PROC/WEB.0] [1] "503 results in your dataset have one of the following deprecated characteristic names: Inorganic nitrogen (nitrate and nitrite); Inorganic nitrogen (nitrate and nitrite) ***retired***use Nitrate + Nitrite. These names have been substituted with the updated preferred names in the TADA.CharacteristicName field."
10:28:50.795: [APP/PROC/WEB.0] [1] "TADA_Autoclean: harmonizing result and depth units."
10:28:52.242: [APP/PROC/WEB.0] [1] "NOTE: This version of the TADA package is designed to work with quantitative (numeric) data with media name: 'WATER'. TADA_AutoClean does not currently remove (filter) data with non-water media types. If desired, the user must make this specification on their own outside of package functions. Example: dplyr::filter(.data, TADA.ActivityMediaName == 'WATER')"
10:28:58.067: [RTR.5] tada-dev.app.cloud.gov - [2024-03-21T14:27:20.913319779Z] "GET /websocket/ HTTP/1.1" 101 0 0 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36 Edg/122.0.0.0" "127.0.0.1:53444" "10.10.2.23:61132" x_forwarded_for:"208.238.204.194, 127.0.0.1, 52.222.123.172, 127.0.0.1" x_forwarded_proto:"https" vcap_request_id:"affa6eb9-4772-48c7-6d35-8a68a57a5639" response_time:97.153757 gorouter_time:0.000144 app_id:"8ff82b48-51a8-4e94-b701-b11f3f1e15c0" app_index:"0" instance_id:"73006c0f-03f3-457e-6cb2-52a5" x_cf_routererror:"-" x_b3_traceid:"affa6eb9477248c76d358a68a57a5639" x_b3_spanid:"6d358a68a57a5639" x_b3_parentspanid:"-" b3:"affa6eb9477248c76d358a68a57a5639-6d358a68a57a5639"
10:28:58.086: [RTR.8] tada-dev.app.cloud.gov - [2024-03-21T14:26:18.777133923Z] "GET /websocket/ HTTP/1.1" 101 0 0 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36" "127.0.0.1:4454" "10.10.2.23:61132" x_forwarded_for:"161.80.29.65, 127.0.0.1, 52.222.123.172, 127.0.0.1" x_forwarded_proto:"https" vcap_request_id:"d256b2fd-ce0b-4775-5dc3-30f4c8108e43" response_time:159.309002 gorouter_time:0.000084 app_id:"8ff82b48-51a8-4e94-b701-b11f3f1e15c0" app_index:"0" instance_id:"73006c0f-03f3-457e-6cb2-52a5" x_cf_routererror:"-" x_b3_traceid:"d256b2fdce0b47755dc330f4c8108e43" x_b3_spanid:"5dc330f4c8108e43" x_b3_parentspanid:"-" b3:"d256b2fdce0b47755dc330f4c8108e43-5dc330f4c8108e43"
10:28:58.203: [APP/PROC/WEB.0] Error: (converted from warning) Error in : (converted from warning) Error in grDevices::png: X11 is not available
10:28:58.204: [APP/PROC/WEB.0] Execution halted
10:28:58.206: [APP/PROC/WEB.0] sh: 1: rm: not found
10:28:58.274: [APP/PROC/WEB.0] Exit status 1

specifically

10:28:58.203: [APP/PROC/WEB.0] Error: (converted from warning) Error in : (converted from warning) Error in grDevices::png: X11 is not available

Expected behavior

The query should not crash the application.

Screenshots

[cristinamullin]

I ran through this again but got a different error code

11:26:35.785: [APP/PROC/WEB.0] Error: (converted from warning) Error in : (converted from warning) Error in grDevices::png: X11 is not available
11:26:35.785: [APP/PROC/WEB.0] Execution halted
11:26:35.788: [APP/PROC/WEB.0] sh: 1: rm: not found
11:26:35.878: [APP/PROC/WEB.0] Exit status 1