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

[Drew Barnes]

.MYI.... That is the index file for the sessions table?  Might it be too
big?
http://wiki.bestpractical.com/view/CleanupSessions

John Schubert wrote:
> 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
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>   

-- 
Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati