[rt-users] Apache2 session problems with rt 3.0.4...

Robert Nickel robertcn at water.fresno.gov
Wed Jul 30 13:46:24 EDT 2003 

On 2003.07.30 19:41:09 +0000, Guillaume Perréal wrote:
> I've got the same problem and I'm using the same workaround... As the 
> permissions of the directory are ok and in regard of the error message, 
> I guess it is related to a connection timeout of MySQL. Maybe the 
> Apache::Session module doesn't check if its connection is up (and thus 
> don't reconnect).
> 
> How do you run RT : mod_perl, fastcgi or speedycgi ?

Oops.  Sorry.  Fastcgi.

--Robert

> Robert Nickel a écrit :
> 
> >I posted earlier but didn't give the complete error.  
> >I've not been able to cure the problem, but the problem is alleviated
> >temporarily by restarting apache.
> >
> >Thanks,
> >--Robert
> >
> >
> >Here's the error:
> >
> >                                System error
> >
> >error:  RT Couldn't write to session directory 
> >'/opt/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]
> >       [/opt/rt3/share/html/autohandler:51]
> >       . Check that this dir ectory's permissions are correct. at 
> >       /opt/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:  /opt/rt3/share/html/Elements/SetupSessionCookie:60
> >            /opt/rt3/share/html/autohandler:51
> >
> >
> >
> >/* And here's the raw error */
> >
> >RT Couldn't write to session directory '/opt/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]
> > [/opt/rt3/share/html/autohandler:51]
> >. Check that this dir ectory's permissions are correct. at 
> >/opt/rt3/share/html/Elements/SetupSessionCookie
> >+line 60.
> >
> >
> >Trace begun at /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Exceptions.pm 
> >line 131
> >HTML::Mason::Exceptions::rethrow_exception('RT Couldn\'t write to session 
> >directory
> >+\'/opt/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.^J^JStack:^J
> >+[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Lock/MySQL.pm:54]^J
> >+[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Lock/MySQL.pm:60]^J
> >+[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:569]^J
> >+[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:497]^J
> >+[/usr/lib/perl5/site_perl/5.8.0/Apache/Session.pm:462]^J
> >+[/usr/lib/perl5/site_perl/5.8.0/Apache/Session/Lock/MySQL.pm:54]^J  
> >[/opt/rt3/share/html/autohandler:51]^J.
> >+Check that this dir ectory\'s permissions are correct. at 
> >/opt/rt3/share/html/Elements/SetupSessionCookie
> >+line 60.^J') called at /opt/rt3/share/html/Elements/SetupSessionCookie 
> >line 60
> >HTML::Mason::Commands::__ANON__ at 
> >/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Component.pm line 134
> >HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8af256c)') called at
> >+/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1062
> >eval {...}('HTML::Mason::Component::FileBased=HASH(0x8af256c)') called at
> >+/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1056
> >HTML::Mason::Request::comp(undef, undef) called at 
> >/opt/rt3/share/html/autohandler line 51
> >HTML::Mason::Commands::__ANON__ at 
> >/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Component.pm line 134
> >HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8af16f0)') called at
> >+/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1062
> >eval {...}('HTML::Mason::Component::FileBased=HASH(0x8af16f0)') called at
> >+/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1056
> >HTML::Mason::Request::comp(undef, undef, undef) called at
> >+/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 333
> >eval {...}(undef, undef, undef) called at 
> >/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 333
> >eval {...}(undef, undef, undef) called at 
> >/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 290
> >HTML::Mason::Request::exec('HTML::Mason::Request::CGI=HASH(0x96a1104)') 
> >called at
> >+/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Interp.pm line 207
> >HTML::Mason::Interp::exec(undef, undef) called at 
> >/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/CGIHandler.pm
> >+line 87
> >HTML::Mason::CGIHandler::_handler('HTML::Mason::CGIHandler=HASH(0x8f62698)', 'HASH(0x9641dcc)') called at
> >+/usr/lib/perl5/site_perl/5.8.0/HTML/Mason/CGIHandler.pm line 70
> >HTML::Mason::CGIHandler::handle_cgi_object('HTML::Mason::CGIHandler=HASH(0x8f62698)',
> >+'CGI::Fast=HASH(0x969bdd4)') called at /opt/rt3/bin/mason_handler.fcgi 
> >line 50
> >
> >_______________________________________________
> >rt-users mailing list
> >rt-users at lists.fsck.com
> >http://lists.fsck.com/mailman/listinfo/rt-users
> >
> >Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> > 
> >
> 
> -- 
> Guillaume Perréal.
> 
> Responsable informatique,
> Cemagref, groupement de Lyon,
> France.
> 
> Tél: (+33) 4.72.20.87.87.
> Fax: (+33) 4.78.47.78.75.
> Site: http://www.lyon.cemagref.fr/
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

More information about the rt-users mailing list