[rt-users] Problem with RT3 and FastCGI

[Rich West]

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:

>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
>