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

[Guillaume Perréal]

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 ?

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/