Looking back through old logs, this has happened before but not with the frequency that has occurred in the last 3 days.
On Thu, 2007-07-26 at 14:50 -0500, Scott T. Hildreth wrote: > I've had rt-3.6.3 running for awhile, while I was on vacation > users were complaining that the changes to tickets were not saved. > My manager was poking around and found seg fault messages in the > Apache logs. I ran mysqlcheck on the databases (we have replication > running) and the tables seem fine. I checked /var/log/messages and > I see this error message when the seq fault occurs, > > Jul 26 13:36:51 dots1a RT: DBD::mysql::st execute failed: Unknown column > > 'main.0xa00c930' in 'order clause' > > > at /usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm > line 505. > > (/usr/local/perl-5.8.8/lib/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505) > Jul 26 13:36:51 dots1a RT: RT::Handle=HASH(0x9af88ac) couldn't execute the > query > 'SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND ( ( > main.Owner = '10' ) > AND ( main.Status = 'new' OR main.Status = 'open' ) ) AND ( > > > 'main.0xa00c930' <= this doesn't look good > > any ideas? > > Thanks. -- Scott T. Hildreth <[EMAIL PROTECTED]> _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
