[rt-users] Sudden segfaults Rt-3.6.3

[Scott T. Hildreth]

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 <shildreth at allantgroup.com>