[rt-users] Huge Attachments table in 3.4.4

[Luke Vanderfluit]

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

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