Hello,
I have a shiny app on a aws-EC2 instance (r4.xlarge) loading four tables from a database also on aws (postgres).
The app works very well and loads pretty quickly when I run it on the R studio server installed on the same aws-EC2 instance.
But then when I try to visualise the app with
http://XX.XXX.X.XXX:3838/my_app/ it does not work and I only get the "An error has occurred The application failed to start. The application exited during initialization."
When I look at the inspect element, I see "Failed to load resource: the server responded with a status of 500 (Internal Server Error)"
I can make the app work if I reduce the number of rows I pull with `collect(mydata, n = Inf)`. For example, 900000 instead of Inf will work.
I know I can boost the memory of the instance, but I would like to understand why it is working on the r studio server (same memory) but not with
http://XX.XXX.X.XXX:3838/my_app/?
I also added this to my shiny-server.conf file with no success.
app_init_timeout 300;
app_idle_timeout 300;
Any suggestions? Did I miss something?
thank you!
Martin