[rt-users] Couldnt open File 'sessions.MYI' in /opt/rt3/var/session_data

[John Schubert]

First post didn't get a single reply, so please let me
know if I'm not posting correctly.  I've read the FAQs
and posted on this list before.

The system is a 3 year old RT (RT 3.0.4 I believe)
that has been running without problems.  The /var
partition filled up at some point in time and this
error occurred sometime around the same time.  I could
give all the sys info but it got no response last
time.

I did a find / -name "sessions.MYI" and don't see the
file it says it cant open.  I've CHMOD'ed all the
directories to 777 that are listed in the error,
restarted a couple times and /var is under 70%
utilization. The session_data directory is 777, and
there are no files inside of it.  I tried to "touch"
sessions.MYI (when the search showed it didn't exist
anywhere) within the session_data file (and even
restarted Apache in case it mattered) with no result.

Below is a System Error summary you get when you put
in the URL of the server running RT:

___________________________________________________

error:  RT Couldn't write to session directory
'/opt/rt3/var/session_data': DBD::mysql::st execute
failed: Can't open file: 'sessions.MYI'. (errno: 145)
at
/usr/lib/perl5/site_perl/5.6.1/Apache/Session/Store/DBI.pm
line 42.

Stack:
[/usr/lib/perl5/site_perl/5.6.1/Apache/Session/Store/DBI.pm:42]
[/usr/lib/perl5/site_perl/5.6.1/Apache/Session.pm:515]
[/usr/lib/perl5/site_perl/5.6.1/Apache/Session.pm:462]
[/opt/rt3/share/html/Elements/SetupSessionCookie:49]
[/opt/rt3/share/html/autohandler:51]
. Check that this dir ectory's permissions are
correct. at
/opt/rt3/share/html/Elements/SetupSessionCookie line
64.
 
context:  ...   
60:  }; 
61:  undef $cookies{'RT_SID'}; 
62:  } 
63:  else { 
64:  die "RT Couldn't write to session directory
'$RT::MasonSessionDir': $@. Check that this dir
ectory's permissions are correct."; 
65:  } 
66:  } 
67:   
68:  if ( !$cookies{'RT_SID'} ) { 
...   
 
code stack: 
/opt/rt3/share/html/Elements/SetupSessionCookie:64
g /opt/rt3/share/html/autohandler:51
g  



 
____________________________________________________________________________________
Don't get soaked.  Take a quick peak at the forecast
with the Yahoo! Search weather shortcut.
http://tools.search.yahoo.com/shortcuts/#loc_weather