vadud3 at gmail
Apr 12, 2009, 1:35 AM
Post #3 of 3
(1040 views)
Permalink
|
|
Re: sessions table is lost after a system crash
[In reply to]
|
|
On Sun, Apr 12, 2009 at 2:31 PM, Asif Iqbal <vadud3 [at] gmail> wrote:
> On Sun, Apr 12, 2009 at 2:24 PM, Asif Iqbal <vadud3 [at] gmail> wrote:
>
>> (user)@webrt:~$ mysql -u root -p
>> Enter password:
>> Welcome to the MySQL monitor. Commands end with ; or \g.
>> Your MySQL connection id is 11 to server version: 4.0.24-log
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>
>> mysql> use rt3;
>> Reading table information for completion of table and column names
>> You can turn off this feature to get a quicker startup with -A
>>
>> Didn't find any fields in table 'sessions'
>> Database changed
>> mysql>
>
>
> mysql> desc sessions;
> ERROR 1016: Can't open file: 'sessions.MYI'. (errno: 145)
>
> Looks like sessions table is gone? Do I need to recreate it ?
>
ls -al /usr/local/mysql/data/rt3
[..]
-rw-rw---- 1 mysql mysql 149122960 Apr 12 07:42 sessions.MYD
-rw-rw---- 1 mysql mysql 12666880 Apr 12 08:29 sessions.MYI
Is it possible that the sessions table is corrupted?
>
>
>>
>> When I try to connect to RT (from cli) I get similar error
>>
>> RT couldn't store your session.<br>This may mean that that the directory
>> '/opt/rt3/var/session_data'
>> isn't writable or a database table is missing or corrupt.
>>
>> How do I fix it?
>>
>> I am using RT 3.4.5 with Perl 5.8.6 and mysql 4.0.24
>>
>
--
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
|
