Hi Kenny,<br>we had exactly the same problem. i'm not sure if our solution is the best, but it helped us to get rid of this.<br><br>We changed the following: (and again, i'm not sure if it is a good idea, but it fixes the problem)<br>
<br>grab up from /usr/lib/perl5/site_perl/5.8.xxx/Apache/Session/Lock the file MySQL.pm and find the line with my GET_LOCK, its around line 53. It uses default 3600 sec for lock timeout. we changed this to 1sec.<br><br> 50 #MySQL requires a timeout on the lock operation. There is no option<br>
51 #to simply wait forever. So we'll wait for a hour.<br> 52<br> 53 my $sth = $self->{dbh}->prepare_cached(q{SELECT GET_LOCK(?, 1)}, {}, 1);<br><br>And again, and hopefully some of the DB/PERL Gurus have a better idea, this fixed our problem (for over one year) but i'm not sure which site effects it has (we discovered nothing so far....)<br>
<br>Torsten<br><br><div class="gmail_quote">2008/11/7 Kenny Seever <span dir="ltr"><<a href="mailto:kseever@innonetkc.com">kseever@innonetkc.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p>Hello everyone. I was looking through the archives and
came across the following. It looks like we are having the same problem and I
was wondering if a solution was ever found.</p>
<p> </p>
<p>Thanks in advance,</p>
<p> </p>
<p>Kenny Seever</p>
<p>Innovative Networks, Inc.</p>
<p> </p>
<p> </p>
<p> </p>
<p>Original Message…:</p>
<p> </p>
<p><span style="font-size: 10pt; color: black;">Hi all, <br>
<br>
<br>
<br>
I managed to track down a problem with merged tickets being <b><span style="background: rgb(255, 170, 170) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">slow</span></b> to <br>
display. I have enabled the <b><span style="background: rgb(255, 170, 170) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">slow</span></b>
queries log on Mysql (5.0.51a) and get <br>
the following in the log files. I searched over the RT list archives and <br>
I found note of setting low_priority_updates to <b><span style="background: rgb(170, 255, 170) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</span></b> on mysql for this. <br>
This however makes no difference. Does someone perhaps have an answer <br>
for this problem? <br>
<br>
<br>
<br>
The server is a test setup I made to test the migration of <b><span style="background: rgb(255, 255, 128) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">3</span></b>.6.6 RT <br>
installation to <b><span style="background: rgb(255, 255, 128) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">3</span></b>.<b><span style="background: rgb(170, 170, 255) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">8</span></b>.<b><span style="background: rgb(170, 255, 170) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</span></b>.
The problem was there in <b><span style="background: rgb(255, 255, 128) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">3</span></b>.6.6
when I imported <br>
the production database from a mysql dump the production server also <br>
running rt <b><span style="background: rgb(255, 255, 128) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">3</span></b>.6.6 is fine (not <b><span style="background: rgb(255, 170, 170) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">slow</span></b> on merged tickets). The difference <br>
between the systems is that the production server is a Redhat Enterprise <br>
4 server (MySQL-server-community-5.0.51a-0.rhel4) and the test system is <br>
a newer Fedora 9 (mysql-server-5.0.51a-<b><span style="background: rgb(170, 255, 170) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</span></b>.fc9).
The fedora 9 installation <br>
installed all required modules from CPAN during installation. After <br>
migrating it to <b><span style="background: rgb(255, 255, 128) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">3</span></b>.<b><span style="background: rgb(170, 170, 255) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">8</span></b>.<b><span style="background: rgb(170, 255, 170) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</span></b>
the problem remains. It looks like it slightly <br>
faster but not much. Database has been updated from mysql 4.0 to 4.<b><span style="background: rgb(170, 255, 170) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</span></b> <br>
followed by the database update script. All is working fine accept for <br>
the <b><span style="background: rgb(255, 170, 170) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">slow</span></b> queries on merged
tickets and the GET_LOCK reports in the <b><span style="background: rgb(255, 170, 170) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">slow</span></b>
<br>
query log. <br>
<br>
<br>
<br>
I've cleared the session table. This currently makes no difference. It <br>
had about 1100 records in it before I cleared it. <br>
<br>
<br>
<br>
Regards, <br>
<br>
<br>
<br>
Ton Hoogstraten <br>
<br>
<br>
<br>
SELECT GET_LOCK('Apache-Session-7dee36ca13e864c568b1659d2fa18751', <br>
3600); <br>
<br>
</span><span style="font-size: 10pt; color: rgb(102, 0, 102);"># Time: 080822 14:36:01 <br>
</span><span style="font-size: 10pt; color: black;"><br>
</span><span style="font-size: 10pt; color: rgb(102, 0, 102);"># User[at]Host: rt[rt] @ localhost [] <br>
</span><span style="font-size: 10pt; color: black;"><br>
</span><span style="font-size: 10pt; color: rgb(102, 0, 102);"># Query_time: 110 Lock_time: 0 Rows_sent: </span><b><span style="background: rgb(170, 255, 170) none repeat scroll 0% 0%; font-size: 10pt; color: black; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</span></b><span style="font-size: 10pt; color: rgb(102, 0, 102);"> Rows_examined: 0 <br>
</span><span style="font-size: 10pt; color: black;"><br>
SELECT GET_LOCK('Apache-Session-a196db0f41ab721840dba0b78f2dd36e', <br>
3600); <br>
<br>
</span><span style="font-size: 10pt; color: rgb(102, 0, 102);"># User[at]Host: rt[rt] @ localhost [] <br>
</span><span style="font-size: 10pt; color: black;"><br>
</span><span style="font-size: 10pt; color: rgb(102, 0, 102);"># Query_time: 80 Lock_time: 0 Rows_sent: </span><b><span style="background: rgb(170, 255, 170) none repeat scroll 0% 0%; font-size: 10pt; color: black; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">1</span></b><span style="font-size: 10pt; color: rgb(102, 0, 102);"> Rows_examined: 0 <br>
</span><span style="font-size: 10pt; color: black;"><br>
SELECT GET_LOCK('Apache-Session-a196db0f41ab721840dba0b78f2dd36e', <br>
3600);</span></p>
</div>
</div>
<br>_______________________________________________<br>
<a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
<br>
Community help: <a href="http://wiki.bestpractical.com" target="_blank">http://wiki.bestpractical.com</a><br>
Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>
<br>
<br>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><br></blockquote></div><br><br clear="all"><br>-- <br>MFG<br><br>Torsten Brumm<br><br><a href="http://www.torsten-brumm.de">http://www.torsten-brumm.de</a><br>