Hi all,
I am trying to host my ShinyProxy application on an AWS EC2 instance running Amazon Linux 2023. Say, I have two different Docker images, each containing an R Shiny app that connects to the same SQL Server database. Both images have the R Shiny app copied to the root of the image.
When I run both containers in interactive mode (docker exec -it) and manually execute the same SQL script inside each, the SELECT queries run simultaneously and I can see outputs from both containers at the same time.
However, when I launch the applications via ShinyProxy and access them through the browser, if I run a query in one application, it blocks the data retrieval in the other. All queries are read-only — there are no INSERT, UPDATE, or DELETE operations involved.
Why is this happening? How can I prevent one ShinyProxy application from blocking the other?
Thanks in advance!