Bug 152644 - [PATCH] www/mod_log_mysql: [enable auto reconnect support]
Summary: [PATCH] www/mod_log_mysql: [enable auto reconnect support]
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: Normal Affects Only Me
Assignee: Philip M. Gollucci
Depends on:
Reported: 2010-11-28 15:50 UTC by samm
Modified: 2010-12-07 21:30 UTC (History)
1 user (show)

See Also:

ap20-mod_log_mysql-1.0_1.patch (2.08 KB, patch)
2010-11-28 15:50 UTC, samm
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description samm 2010-11-28 15:50:09 UTC
I am using mod_log_mysql on a busy web server and found that sometime i am gettng messages like 
"server gone away". In worst case i am also getting core dump in mysql_real_escape(), probably because 
db object is not valid anymore. After debugging I found that root reason is disconnect timeout - when
child is not active for a long time server closing connection. This small patch enable auto-reconnect 
support, so in this case conection is re-established automatically. I tested it ~4 days and found that 
messages are gone and no more core dumps in the logs. 

Changed files:
- Makefile
- distinfo

New file:
- files/patch-mod_log_mysql.c

Port maintainer (apache@FreeBSD.org) is cc'd.

Generated with FreeBSD Port Tools 0.99
Comment 1 Edwin Groothuis freebsd_committer 2010-11-28 15:50:16 UTC
Responsible Changed
From-To: freebsd-ports-bugs->apache

Over to maintainer (via the GNATS Auto Assign Tool)
Comment 2 Philip M. Gollucci freebsd_committer 2010-12-07 04:15:59 UTC
Responsible Changed
From-To: apache->pgollucci

I will take it.
Comment 3 dfilter service freebsd_committer 2010-12-07 21:29:38 UTC
pgollucci    2010-12-07 21:29:34 UTC

  FreeBSD ports repository

  Modified files:
    www/mod_log_mysql    Makefile distinfo 
  Added files:
    www/mod_log_mysql/files patch-mod_log_mysql.c 
  - enable auto-reconnect support
  PR:             ports/152644
  Submitted by:   Alex Samorukov <samm@os2.kiev.ua>
  Revision  Changes    Path
  1.15      +2 -1      ports/www/mod_log_mysql/Makefile
  1.8       +0 -1      ports/www/mod_log_mysql/distinfo
  1.5       +16 -0     ports/www/mod_log_mysql/files/patch-mod_log_mysql.c (new)
cvs-all@freebsd.org mailing list
To unsubscribe, send any mail to "cvs-all-unsubscribe@freebsd.org"
Comment 4 Philip M. Gollucci freebsd_committer 2010-12-07 21:29:42 UTC
State Changed
From-To: open->closed

Committed, Thanks!