Many database connections?

[Dave Briccetti]

I get these PostgreSQL messages when I stop Jetty. Shouldn’t there be only one connection, if there is only one user doing one thing at a time?

[2012-11-04 15:27:05.411 PST 5096f8da.a632 0] LOG:  unexpected EOF on client connection

[2012-11-04 15:27:05.411 PST 5096f8da.a631 0] LOG:  unexpected EOF on client connection

[2012-11-04 15:27:05.411 PST 5096f8da.a630 0] LOG:  unexpected EOF on client connection

[2012-11-04 15:27:05.411 PST 5096f8da.a62f 0] LOG:  unexpected EOF on client connection

[2012-11-04 15:27:05.412 PST 5096f8cc.a628 0] LOG:  unexpected EOF on client connection

[2012-11-04 15:27:05.412 PST 5096f8cc.a629 0] LOG:  unexpected EOF on client connection

[2012-11-04 15:27:05.412 PST 5096f8cc.a627 0] LOG:  unexpected EOF on client connection

[2012-11-04 15:27:05.412 PST 5096f8cc.a626 0] LOG:  unexpected EOF on client connection

[2012-11-04 15:27:05.413 PST 5096f8cc.a625 0] LOG:  unexpected EOF on client connection

[2012-11-04 15:27:05.413 PST 5096f8cc.a624 0] LOG:  unexpected EOF on client connection

[2012-11-04 15:27:05.413 PST 5096f8da.a62e 0] LOG:  unexpected EOF on client connection

[2012-11-04 15:27:05.414 PST 5096f8da.a62d 0] LOG:  unexpected EOF on client connection

[Diego Medina]

I don;t remember if the pull req was merged or not, but if we are
using connection pool, then we will have multiple connections, even if
only one user is connected.

I don;t know much about PostgreSQL, but is there anything similar to
"show processlist;" (show processlist works on mysql and shows you all
the connections that are live at that moment.

Regards,

Diego

> --
>
>



--
Diego Medina
Lift/Scala Developer
di...@fmpwizard.com
http://www.fmpwizard.com

[carlos.montemuino]

We're using BoneCP mostly with default values. The acquireIncrement is 10, so it makes sense what Dave is getting in logs.

I just defined a new task to update DbSettings, so we can override default values as per our needs.

Source: http://jolbox.com/configuration.html