[rt-users] Sudden segfaults Rt-3.6.3

[Scott T. Hildreth]

On Fri, 2007-07-27 at 00:48 +0400, Ruslan Zakirov wrote:
> 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.

  I will try the updates, I figured I might have to just wanted to see
if anybody else had experienced this problem.  I did run the 
'make fixdeps' when I installed it so modules should be fine, but I will
try an update.

Thanks Ruslan.

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