ERROR: all connections are in use?

[tcash21]

Haven't been able to find any documentation on this error message, but I'm assuming I've hit my limit on max concurrent client connections?

http://ec2-54-224-148-85.compute-1.amazonaws.com:3838/fantasy/

[Joe Cheng]

Hmm, working fine now--I don't suppose you took a screenshot of what you were seeing?

On Sun, Aug 25, 2013 at 8:10 PM, tcash21 <tany...@gmail.com> wrote:

Haven't been able to find any documentation on this error message, but I'm assuming I've hit my limit on max concurrent client connections?

http://ec2-54-224-148-85.compute-1.amazonaws.com:3838/fantasy/

--
You received this message because you are subscribed to the Google Groups "Shiny - Web Framework for R" group.
To unsubscribe from this group and stop receiving emails from it, send an email to shiny-discus...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Tanya Cashorali]

No but I'm loading S3 objects on startup. Here's what I found in the logs:

Error in url("http://s3.amazonaws.com/rshiny/players.Rdat") :
all connections are in use
Error in gzfile(file, "rb") : all connections are in use
Error in textConnection("rval", "w", local = TRUE) :
all connections are in use
Error in gzfile(file, "rb") : all connections are in use
ERROR: [on_request_read] parse error
Error in gzfile(file, "rb") : all connections are in use
ERROR: [on_request_read] parse error
Error in gzfile(file, "rb") : all connections are in use
ERROR: [on_request_read] parse error
Error in gzfile(file, "rb") : all connections are in use
ERROR: [on_request_read] parse error
Error in gzfile(file, "rb") : all connections are in use
ERROR: [on_request_read] parse error
Error in gzfile(file, "rb") : all connections are in use
ERROR: [on_request_read] parse error
Error in gzfile(file, "rb") : all connections are in use
ERROR: [on_request_read] parse error
Error in gzfile(file, "rb") : all connections are in use
ERROR: [on_request_read] parse error
Error in gzfile(file, "rb") : all connections are in use
ERROR: [on_request_read] parse error
Error in gzfile(file, "rb") : all connections are in use
ERROR: [on_request_read] parse error
Error in textConnection(NULL, "w") : all connections are in use
Error in textConnection(NULL, "w") : all connections are in use
Error in textConnection(NULL, "w") : all connections are in use
Error in textConnection(NULL, "w") : all connections are in use
Error in textConnection(NULL, "w") : all connections are in use
Error in textConnection(NULL, "w") : all connections are in use
Error in textConnection(NULL, "w") : all connections are in use
Error in textConnection(NULL, "w") : all connections are in use
Error in textConnection(NULL, "w") : all connections are in use
Error in textConnection(NULL, "w") : all connections are in use
Error in textConnection(NULL, "w") : all connections are in use
Error in textConnection("rval", "w", local = TRUE) :

> You received this message because you are subscribed to a topic in the

> Google Groups "Shiny - Web Framework for R" group.

> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/shiny-discuss/mohgNp2BAks/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to

[tcash21]

Just happened again after tweeting a link to the site.

Attached a screenshot.

>> email to shiny-discuss+unsubscribe@googlegroups.com.

>>
>> For more options, visit https://groups.google.com/groups/opt_out.
>
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Shiny - Web Framework for R" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/shiny-discuss/mohgNp2BAks/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to

> shiny-discuss+unsubscribe@googlegroups.com.

[Tanya Cashorali]

I had up to 15 concurrent users at one time according to Google
Real-Time Analytics and it dropped down to 0 pretty quickly after when
that error started.

>> >> email to shiny-discus...@googlegroups.com.

>> >>
>> >> For more options, visit https://groups.google.com/groups/opt_out.
>> >
>> >
>> > --
>> > You received this message because you are subscribed to a topic in the
>> > Google Groups "Shiny - Web Framework for R" group.
>> > To unsubscribe from this topic, visit
>> > https://groups.google.com/d/topic/shiny-discuss/mohgNp2BAks/unsubscribe.
>> > To unsubscribe from this group and all its topics, send an email to

>> > shiny-discus...@googlegroups.com.

>> > For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Shiny - Web Framework for R" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/shiny-discuss/mohgNp2BAks/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to

> shiny-discus...@googlegroups.com.

[tcash21]

Is there a way to kill or close a postgres connection from within R/Shiny once that user goes idle or closes the browser? 
I'm now experiencing this error: 

Error in postgresqlNewConnection(drv, ...) : RS-DBI driver: (cannot allocate a new connection -- maximum of 16 connections already opened)