Mojo::Pg and db connection exhaustion

[Neil Watson]

Greetings,

After starting to use mojo::pg I'm getting these errors after some
running time:

failed: FATAL: remaining connection slots are reserved for
non-replication superuser connections at ../perl5/lib/perl5/Mojo/Pg.pm
line 83.

I assume the cached db connections are not being recycled. How do I fix
this?

--
Neil Watson
Linux/UNIX Consultant
http://watson-wilson.ca

[sri]

Only 5 connections are cached by default, which should rarely be a problem.

    http://mojolicio.us/perldoc/Mojo/Pg#max_connections

You're prolly just leaking connections in your code, which should be easy to figure out with Devel::Cycle and friends.

--

sebastian

[Neil Watson]

On Fri, Sep 11, 2015 at 08:38:04AM -0700, sri wrote:
>
>     http://mojolicio.us/perldoc/Mojo/Pg#max_connections
> You're prolly just leaking connections in your code, which should be
> easy to figure out with Devel::Cycle and friends.

When I was using straight DBI I never had an explicit disconnects. It
just worked. :(

[sri]

When I was using straight DBI I never had an explicit disconnects. It
just worked. :(

You might be misunderstanding something here. There's only more than one connection if you're performing queries non-blocking, and i very much doubt you've done that with raw DBI. If all you're doing is blocking queries, then there will never be more than one connection.

--

sebastian