Problem with RT3 and FastCGI

Hi everybody,

I got a problem with RT 3.0.4 and Apache using FastCGI. Approx. once a day RT isn’t working anymore and I get the error message below if I try to access RT.

Although the message states some MySQL or Permission Problems, the problem is Apache. After a restart of the Web Server everything is working again.

Any hints?

Torsten

Error message:

error: RT Couldn’t write to session directory ‘/usr/local/rt3/var/session_data’: DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/site_perl/5.8.0/Apache/Session/Lock/MySQL.pm line 54.

Stack:
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Lock/MySQL.pm:54]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Lock/MySQL.pm:60]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:569]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:497]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462]
[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Lock/MySQL.pm:54]
[/usr/local/rt3/share/html/autohandler:51]
. Check that this dir ectory’s permissions are correct. at /usr/local/rt3/share/html/Elements/SetupSessionCookie line 60.
context:

56: };
57: undef $cookies{‘RT_SID’};
58: }
59: else {
60: die “RT Couldn’t write to session directory ‘$RT::MasonSessionDir’: $@. Check that this dir ectory’s permissions are correct.”;
61: }
62: }
63:
64: if ( !$cookies{‘RT_SID’} ) {

code stack: /usr/local/rt3/share/html/Elements/SetupSessionCookie:60
/usr/local/rt3/share/html/autohandler:51

Fellhauer, Torsten wrote:

I got a problem with RT 3.0.4 and Apache using FastCGI. Approx. once
a day RT isn’t working anymore and I get the error message below if I
try to access RT.

MySQL “morning bug”. The latest 3.0.5 prerelease contains code to
mitigate this.
Phil Homewood, Systems Janitor, http://www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances

I’m seeing the same thing since updating to 3.0.4, the latest
DBIx::SearchBuilder, and the latest HTML::Mason. It seems rather
sporadic (not daily, but every few days). And the web-generated error
is identical.

The MySQL server is definitely there (other apps utilize it), and
restarting Apache (in my case, I am also utilizing FastCGI) clears up
the problem.

I found another reference on the list to “server has gone away”, but it
was in regards to a “max_packet” option and file attachments.

This only started up since upgrading to 3.0.4 (from 3.0.2 w/ the
respective HTML::Mason and DBIx::SearchBuilder).

Any ideas?

Weird thing is that, via the web page error, it references
/opt/rt3/…, but I don’t have my RT3 install in /opt and there are no
references to it in the config files. shrug But, like I said, it all
comes back once the web server is restarted.

-Rich

Fellhauer, Torsten wrote:

I’m seeing the same thing since updating to 3.0.4, the latest
DBIx::SearchBuilder, and the latest HTML::Mason. It seems rather
sporadic (not daily, but every few days). And the web-generated error
is identical.

That should be fixed in 3.0.5rc1.

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.