My RT installation is very unhappy as of this morning. Most data in
tickets shows, but correspondence and comments are not there. So I can
see all the tickets, but if I click on one, I see all the actions, but
none of the data.
The logs are filling up with errors like this:
Jun 27 10:42:58 rt RT: RT::Handle=HASH(0xa89f334) couldn’t execute the
query ‘SELECT main., MAX(ObjectCustomFields_1.ObjectId)
__special_sort_0, MIN(ObjectCustomFields_1.SortOrder) __special_sort_1
FROM CustomFields main JOIN ObjectCustomFields ObjectCustomFields_1
ON ( ObjectCustomFields_1.CustomField = main.id ) WHERE
(main.Disabled = ‘0’) AND (main.Name = NULL) AND
(ObjectCustomFields_1.ObjectId = ‘11’ OR ObjectCustomFields_1.ObjectId
= ‘0’) AND (main.LookupType = ‘RT::Queue-RT::Ticket-RT::Transaction’)
GROUP BY main.id ORDER BY __special_sort_0 DESC, __special_sort_1 ASC
’ at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
'SELECT main., MAX(ObjectCustomFields_1.ObjectId) __special_s…’)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line
called at /opt/rt3/bin/…/lib/RT/CustomFields_Overlay.pm line 168
Any idea what this might be? In the past when RT lost contact with the
MySQL database (which is on a different host), I’d have to restart
Apache to get the two talking again. Restarting Apache in this case
I’m trying to determine if this is a problem with database access, or
something wrong with my RT host.
Nobody has made any changes to anything that would have caused this.