Mailing List Archive: ModPerl: ModPerl

[PATCH] Apache::DBI - Disconnect on child exit

Index | Next | Previous | View Threaded

wellnhofer at aevum

Jul 20, 2009, 8:15 AM

Post #1 of 3 (820 views)
Permalink

[PATCH] Apache::DBI - Disconnect on child exit

Currently, Apache::DBI never disconnects from the database. This leads
to the following warnings in my Postgres logs every time an Apache child
exits:

LOG: unexpected EOF on client connection

Depending on MaxRequestsPerChild this can really spam your Postgres logs.

Attached is a patch against Apache::DBI that adds a PerlChildExitHandler
in order to disconnect all existing database connections.

Comments are welcome.

Nick

--
aevum gmbh
rumfordstr. 4
80469 münchen
germany

tel: +49 89 3838 0653
http://aevum.de/

Attachments:

dbi.diff (1.82 KB)

adam.prime at utoronto

Jul 20, 2009, 4:18 PM

Post #2 of 3 (746 views)
Permalink

Re: [PATCH] Apache::DBI - Disconnect on child exit [In reply to]

Seems like a reasonable addition to me. Apache::DBI 1.07 is kind of
broken right now (see bugs in RT), it'd be nice to get a new release
with this fixed and some of those bugs closed.

Adam

Nick Wellnhofer wrote:
> Currently, Apache::DBI never disconnects from the database. This leads
> to the following warnings in my Postgres logs every time an Apache child
> exits:
>
> LOG: unexpected EOF on client connection
>
> Depending on MaxRequestsPerChild this can really spam your Postgres logs.
>
> Attached is a patch against Apache::DBI that adds a PerlChildExitHandler
> in order to disconnect all existing database connections.
>
> Comments are welcome.
>
> Nick
>
>
>

jira at getnet

Jul 21, 2009, 12:39 PM

Post #3 of 3 (753 views)
Permalink

Re: [PATCH] Apache::DBI - Disconnect on child exit [In reply to]

Nick Wellnhofer napsal(a):
> Currently, Apache::DBI never disconnects from the database. This leads
> to the following warnings in my Postgres logs every time an Apache child
> exits:
>
> LOG: unexpected EOF on client connection
>
> Depending on MaxRequestsPerChild this can really spam your Postgres logs.
>
> Attached is a patch against Apache::DBI that adds a PerlChildExitHandler
> in order to disconnect all existing database connections.
>
> Comments are welcome.
>

Thanks, it made my Postgres log useful again.

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads