[rt-users] Huge Attachments table in 3.4.4

[Luke Vanderfluit]

Hi.

I have added 2 indexes to the database.
That seems to have solved the problem.
I added:

create index Principals4 on Principals(Disabled);
create index Groups5 on Groups(Domain);

After that, all was fine :-)

Kind regards.
Luke.

Luke Vanderfluit wrote:

> Hi.
>
> The patches that you sent and I have applied to the installation of 
> rt3.4.4 are working well for the query we were having trouble with.
> However now I'm having trouble with another query.
> This query:
>
> SELECT DISTINCT main.* FROM Groups main , Principals Principals_1  
> WHERE ((Principals_1.Disabled = '0')) AND ((main.Domain = 
> 'UserDefined')) AND ((main.id = Principals_1.id)or(main.id != 
> '2926'))    ORDER BY main.Name ASC
>
> is generated when I want to view the 'member' of a group
>
> It seems that the connection to the server is lost.
> If I try a simple query in the mysql client after I have executed the 
> above query (requested the Members.html page) from a browser, the 
> connection to the server is lost.
>
> I hope this isn't too hard to fix. It seems to be a consequence of 
> applying the patches.
>
> When I killed the mysql process, I got the following error messages:
>
>
>
> *error:*  	DBD::mysql::st execute failed: Lost connection to MySQL 
> server during query at 
> /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/Apache/Session/Store/DBI.pm 
> line 67.
> *context:*  	
> *...*  	
> *63:*  	
> *64:*  	$self->{update_sth}->bind_param(1, $session->{serialized});
> *65:*  	$self->{update_sth}->bind_param(2, 
> $session->{data}->{_session_id});
> *66:*  	
> *67:*  	$self->{update_sth}->execute;
> *68:*  	
> *69:*  	$self->{update_sth}->finish;
> *70:*  	}
> *71:*  	
> *...*  	
>
> *code stack:*  
> /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/Apache/Session/Store/DBI.pm:67
> /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/Apache/Session.pm:523
> /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/Apache/Session.pm:477
> /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/HTML/Mason/Request.pm:1068
>
> raw error 
> <http://bld-sparc.internode.on.net/Admin/Groups/Members.html?id=2926#raw>
>
>
>DBD::mysql::st execute failed: Lost connection to MySQL server during query at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/Apache/Session/Store/DBI.pm line 67.
>
>
>Trace begun at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/HTML/Mason/Exceptions.pm line 131
>HTML::Mason::Exceptions::rethrow_exception('DBD::mysql::st execute failed: Lost connection to MySQL server during query at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/Apache/Session/Store/DBI.pm line 67.^J') called at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/Apache/Session/Store/DBI.pm line 67
>Apache::Session::Store::DBI::update('Apache::Session::Store::MySQL=HASH(0x1ed5cd4)', 'Apache::Session::MySQL=HASH(0x1ed5c80)') called at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/Apache/Session.pm line 523
>Apache::Session::save('Apache::Session::MySQL=HASH(0x1ed5c80)') called at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/Apache/Session.pm line 477
>Apache::Session::DESTROY('Apache::Session::MySQL=HASH(0x1ed5c80)') called at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1068
>eval {...} at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1068
>HTML::Mason::Request::comp(undef, undef, undef, 'id', 2926) called at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 338
>eval {...} at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 338
>eval {...} at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 297
>HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x1b28a94)') called at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm line 134
>eval {...} at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm line 134
>HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x1b28a94)') called at /webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm line 827
>HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x18e2554)', 'Apache=SCALAR(0x1a1cfdc)') called at /usr/local/rt3/bin/webmux.pl line 123
>eval {...} at /usr/local/rt3/bin/webmux.pl line 123
>RT::Mason::handler('Apache=SCALAR(0x1a1cfdc)') called at /dev/null line 0
>eval {...} at /dev/null line 0
>  
>
> Kind regards.
> Luke.
>
>-- 
>Luke
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
>Buy your copy of our new book, RT Essentials, today! 
>
>Download a free sample chapter from http://rtbook.bestpractical.com
>


-- 
Luke

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20051101/0ca0f003/attachment.htm>