<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi.<br>
<br>
I have added 2 indexes to the database.<br>
That seems to have solved the problem.<br>
I added:<br>
<br>
create index Principals4 on Principals(Disabled); <br>
create index Groups5 on Groups(Domain);<br>
<br>
After that, all was fine :-)<br>
<br>
Kind regards.<br>
Luke.<br>
<br>
Luke Vanderfluit wrote:
<blockquote cite="mid4366ABE6.9050805@internode.com.au" type="cite">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
Hi.<br>
<br>
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.<br>
However now I'm having trouble with another query. <br>
This query: <br>
<br>
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<br>
<br>
is generated when I want to view the 'member' of a group<br>
<br>
It seems that the connection to the server is lost.<br>
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.<br>
<br>
I hope this isn't too hard to fix. It seems to be a consequence of
applying the patches.<br>
<br>
When I killed the mysql process, I got the following error messages:<br>
<br>
<br>
<br>
<table border="0" cellpadding="1" cellspacing="0">
<tbody>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>error:</b> </font></td>
<td align="left" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2">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.<br>
</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>context:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>...</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><br>
</td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>63:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><br>
</td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>64:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2">$self->{update_sth}->bind_param(1,
$session->{serialized});</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>65:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2">$self->{update_sth}->bind_param(2,
$session->{data}->{_session_id});</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>66:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"> </font><br>
</td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>67:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><font
color="red"> $self->{update_sth}->execute;</font></font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>68:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><br>
</td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>69:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2">$self->{update_sth}->finish;</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>70:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2">}</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>71:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><br>
</td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>...</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><br>
</td>
</tr>
</tbody>
</table>
</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>code stack:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font
face="Verdana, Arial, Helvetica, sans-serif" size="-2">/webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/Apache/Session/Store/DBI.pm:67<br>
/webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/Apache/Session.pm:523<br>
/webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/Apache/Session.pm:477<br>
/webhosting/stow/perl-5.8.5/perl5/lib/site_perl/5.8.5/HTML/Mason/Request.pm:1068<br>
</font></td>
</tr>
</tbody>
</table>
<a
href="http://bld-sparc.internode.on.net/Admin/Groups/Members.html?id=2926#raw">raw
error</a><br>
<br>
<br>
<a name="raw"></a>
<pre>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
</pre>
Kind regards.<br>
Luke.<br>
<pre class="moz-signature" cols="72">--
Luke
</pre>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Be sure to check out the RT Wiki at <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a></pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Luke
</pre>
</body>
</html>