[rt-users] Re: RT is hanging when trying to update tickets

[Paul Williams]

Here is the fix.

The first part is to turn on debugging to see what is
happening.  In /opt/rt3/etc/RT_SiteConfig.pm
change
     Set($LogToFile      , undef);
to
     Set($LogToFile      , 'debug');

Restart apache and the look in the log, in my case it was

      /opt/rt3/var/log/rt.log

The error message complained about a missing table
with the name Attributes.

At this point I needed assistance from our mysql expert
who set up the mysql database for rt.

He looked at some older versions of the software and discovered
that the Attributes table was added a few versions back.

The file /opt/rt3/etc/schema.mysql
provided the needed lines to modify the database.

paulw





>Date: Tue, 26 Oct 2004 13:01:04 -0500
>From: Paul Williams <paul.williams at uwex.edu>
>Subject: [rt-users] RT is hanging when trying to update tickets
>To: rt-users at lists.bestpractical.com
>Message-ID: <5.2.1.1.2.20041026130032.02010fb0 at imap.uwex.edu>
>Content-Type: text/plain; charset="us-ascii"; format=flowed
>
>I have installed rt-3.2.2 on a Redhat 2.1 AS linux system
>with the latest up2dates patches installed.  I have installed
>apache-1.3.31 and mod_perl-1.29 from source.
>
>After starting RT, when I click on the Ticket option
>an apache process begins to use approx. 100% of the cpu.
>
>I need to kill and restart apache before I can do anything else with
>RT.
>
>I have tracked down the problem to the
>module /Search/Elements/EditSearches, at least that
>appears to be where there is a problem.
>
>If I comment out the line EditSearches line in /Search/Build.html
>I don't have the problem of the cpu going to 100%.
>Of course the program probably doesn't work properly then.  (:-)
>
>It looks like the problem is centered in the code below.
>I have not been able to figure out what is happening to see
>if the problem is really there and whether there is a fix.
>
>paulw