[rt-users] Sudden segfaults Rt-3.6.3

[Ruslan Zakirov]

mysql update? perl modules updates? Try different versions of
DBIx::SearchBuilder, but if you see seg faults then it's most probably
some binary module, for example DBI or DBD::mysql.

On 7/27/07, Scott T. Hildreth <shildreth at allantgroup.com> wrote:
> 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>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>


-- 
Best regards, Ruslan.