When I had this problem it was a bug in DBD:mysql 4.007. I'm not sure the exact details but it only happend on low traffic sites, my guess is the connection pool times out when it shouldn't causing the http server to fail on the first try and then working again once the proccesses reconnect. Seems to be related to this, the fix is to downgrade to 4.006 or even 3.x (your distribution's version should have the bugfix backported).
http://bugs.mysql.com/bug.php?id=36810 Curtis. James Chamberlain wrote: > On Mon, 15 Sep 2008, Jesse Vincent wrote: > >> On Sep 15, 2008, at 8:55 AM, James Chamberlain wrote: >> >> >>> It does, but the thing that gets me is that this has only happened since I >>> upgraded to 3.8.1. If I switch back to 3.8.0 - granted, not something I >>> should do since there have been database changes - I don't have the >>> overnight segfault problem anymore. >>> >> The database changes shouldn't be "dangerous", though that's quite >> interesting. By "switch back" do you mean restoring the server to an older >> version or just switching the RT directory? >> > > I'm doing things in a slightly different way than the installation or > upgrading instructions call for, I think. Rather than upgrade /opt/rt3, I > do a fresh install to /opt/rt3-<build#>. I then copy over local changes, > and copy and check RT_SiteConfig.pm for updates. From there, I follow the > "upgrade" instructions as they relate to the database, and update my Apache > configs and my /opt/rt3 symlink. Doing it in this way lets me keep the > previous version intact in case something goes wrong and I need to switch > back in a hurry. All I need to do is change the symlink and the Apache > configs. > > >> Can you catch a stacktrace from the segfault's core dump? Can you make it >> dump core without waiting for 10 hours of silence from you users? >> > > I'll see what I can do, but I've only reliably seen this in the morning and > don't know the exact trigger yet. > > Thanks, > > James > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > > > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
