[rt-users] 0 results after corrupt sessions table, myisamchk

[Peter Nikolaidis]

Additional info:

After a short while, I observed the rt.log file was growing at an
astounding rate, and quickly grew to fill up the entire available space.
Every second or faster, it was filling up with the lines below. Inspired
by the first line, I ran another myisamchck against the Attributes.MYI file.

Now the RT homepage is loading, and I can again see all of my queues,
but it's still showing as having no tickets in any of them. There are
1.2GB of files in /var/lib/mysql/rt3, so the data's got to be there, but
I still need suggestions on how to get RT to realize this.

I've also observed that if I try to select all tickets that are open and
in the 'support' queue, I get no results. But if I list only tickets
whose status is 'open', I see the expected results. However, if I click
on any of them, I cannot open it.

Any advice greatly appreciated.

Thanks,

Peter

[Mon Aug 25 02:14:04 2008] [warning]: DBD::mysql::st execute failed:
Incorrect key file for table './rt3/Attributes.MYI'; try to repair it at
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505
, <GEN27> line 4.
(/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Mon Aug 25 02:14:05 2008] [warning]: RT::Handle=HASH(0x9fd6e84)
couldn't execute the query 'SELECT main.* FROM Attributes main  WHERE
(main.ObjectType = 'RT::User') AND (main.ObjectId = 35) ' at /usr/local/
share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518
       
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x9fd6e84)',
'SELECT main.* FROM Attributes main  WHERE (main.ObjectType = ...')
called at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm
line 238
        DBIx::SearchBuilder::_DoSearch('RT::Attributes=HASH(0xa67447c)')
called at /usr/local/rt3.8/bin/../lib/RT/Attributes_Overlay.pm line 74
        RT::Attributes::_DoSearch('RT::Attributes=HASH(0xa67447c)')
called at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 498
        DBIx::SearchBuilder::Next('RT::Attributes=HASH(0xa67447c)')
called at /usr/local/rt3.8/bin/../lib/RT/Attributes_Overlay.pm line 82
       
RT::Attributes::_BuildAccessTable('RT::Attributes=HASH(0xa67447c)')
called at /usr/local/rt3.8/bin/../lib/RT/Attributes_Overlay.pm line 75
        RT::Attributes::_DoSearch('RT::Attributes=HASH(0xa67447c)')
called at /usr/local/rt3.8/bin/../lib/RT/Attributes_Overlay.pm line 90
        RT::Attributes::_AttrHash('RT::Attributes=HASH(0xa67447c)')
called at /usr/local/rt3.8/bin/../lib/RT/Attributes_Overlay.pm line 121
        RT::Attributes::Named('RT::Attributes=HASH(0xa67447c)',
'AuthToken') called at /usr/local/rt3.8/bin/../lib/RT/Record.pm line 239
        RT::Record::FirstAttribute('RT::User=HASH(0xa50fe00)',
'AuthToken') called at /usr/local/rt3.8/bin/../lib/RT/User_Overlay.pm
line 1011
        RT::User::AuthToken('RT::User=HASH(0xa50fe00)') called at
/usr/local/rt3.8/bin/../lib/RT/User_Overlay.pm line 1049
        RT::User::GenerateAuthString('RT::User=HASH(0xa50fe00)', 'Queue
= \'support\' AND (Status = \'open\' OR Status = \'new\')') called at
/usr/local/rt3.8/share/html/Search/Elements/ResultViews line 74
        HTML::Mason::Commands::__ANON__('QueryString',
'?Format=%0A%20%20%20\'%3CB%3E%3CA%20HREF%3D%22__WebPath__%2FT...',
'Query', 'Queue = \'support\' AND (Status = \'open\' OR Status =
\'new\')', 'Format'
, '\x{a}   \'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">...', 'Rows', 50,
'OrderBy', ...) called at
/usr/local/share/perl/5.8.8/HTML/Mason/Component.pm line 135
       
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa6743ec)',
'QueryString',
'?Format=%0A%20%20%20\'%3CB%3E%3CA%20HREF%3D%22__WebPath__%2FT...',
'Query', 'Queue = \'support\' AND (
Status = \'open\' OR Status = \'new\')', 'Format', '\x{a}   \'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">...', 'Rows', 50, ...)
called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 12
84
        eval {...} called at
/usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 1274
        HTML::Mason::Request::comp('undef', 'undef', 'QueryString',
'?Format=%0A%20%20%20\'%3CB%3E%3CA%20HREF%3D%22__WebPath__%2FT...',
'Query', 'Queue = \'support\' AND (Status = \'open\' OR Status = \'new\
')', 'Format', '\x{a}   \'<B><A
HREF="__WebPath__/Ticket/Display.html?id=__id__">...', 'Rows', ...)
called at /usr/local/rt3.8/share/html/Search/Results.html line 83
        HTML::Mason::Commands::__ANON__('pass', 'passwordwouldgohere',
'Rows', 50, 'Format', '', 'Page', 1, 'Order', ...) called at
/usr/local/share/perl/5.8.8/HTML/Mason/Component.pm line 135
       
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa518be8)',
'pass', 'mypasswordwouldbehere', 'Rows', 50, 'Format', '', 'Page', 1,
...) called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.
pm line 1284
        eval {...} called at
/usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 1274
        HTML::Mason::Request::comp('undef', 'undef', 'undef', 'pass',
'mypasswordwouldbehere', 'Rows', 50, 'Format', '', ...) called at
/usr/local/rt3.8/share/html/autohandler line 308
        HTML::Mason::Commands::__ANON__('pass', 'passwordwouldgohere',
'Rows', 50, 'Format', '', 'Page', 1, 'Order', ...) called at
/usr/local/share/perl/5.8.8/HTML/Mason/Component.pm line 135
       
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa3d9058)',
'pass', 'mypasswordwouldbehere', 'Rows', 50, 'Format', '', 'Page', 1,
...) called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.
pm line 1279
        eval {...} called at
/usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 1274
        HTML::Mason::Request::comp('undef', 'undef', 'undef', 'pass',
'mypasswordwouldbehere', 'Rows', 50, 'Format', '', ...) called at
/usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 473
        eval {...} called at
/usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 473
        eval {...} called at
/usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 425
       
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0xa46e218)')
called at /usr/local/share/perl/5.8.8/HTML/Mason/ApacheHandler.pm line 168
       
HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0xa46e218)')
called at /usr/local/share/perl/5.8.8/HTML/Mason/ApacheHandler.pm line 825
       
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x9979c58)',
'Apache=SCALAR(0xa024c60)') called at /usr/local/rt3.8/bin/webmux.pl
line 148
        eval {...} called at /usr/local/rt3.8/bin/webmux.pl line 148
        RT::Mason::handler('Apache=SCALAR(0xa024c60)') called at
/dev/null line 0
        eval {...} called at /dev/null line 0
(/usr/share/perl/5.8/Carp.pm:105)