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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-11-28 15:50 UTC by Oleksii Samorukov
Modified: 2010-12-07 21:30 UTC (History)
1 user (show)

See Also:

Attachments
ap20-mod_log_mysql-1.0_1.patch (2.08 KB, patch)
2010-11-28 15:50 UTC, Oleksii Samorukov 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Oleksii Samorukov freebsd_committer freebsd_triage 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 freebsd_triage 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 freebsd_triage 2010-12-07 04:15:59 UTC 
Responsible Changed
From-To: apache->pgollucci

I will take it.
Comment 3 dfilter service freebsd_committer freebsd_triage 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 
  Log:
  - 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
http://lists.freebsd.org/mailman/listinfo/cvs-all
To unsubscribe, send any mail to "cvs-all-unsubscribe@freebsd.org"
Comment 4 Philip M. Gollucci freebsd_committer freebsd_triage 2010-12-07 21:29:42 UTC 
State Changed
From-To: open->closed

Committed, Thanks!