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

[Robert Nickel]

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