Query Blocking Between Containers in ShinyProxy on AWS

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!