[rt-users] 0 results after corrupt sessions table, myisamchk
Ruslan Zakirov
ruz at bestpractical.com
Mon Aug 25 02:36:52 EDT 2008
Most of RT's table MUST use InnoDB engine to work correctly. I'm not
sure what's going on but I have feeling that you've disabled innodb
and mysql went wild after that.
On Mon, Aug 25, 2008 at 6:40 AM, Peter Nikolaidis
<rt-list at paradigmcc.com> wrote:
> 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)
>
> _______________________________________________
> 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
>
--
Best regards, Ruslan.
More information about the rt-users
mailing list