[rt-users] Sudden segfaults Rt-3.6.3

[Scott T. Hildreth]

On Fri, 2007-07-27 at 01:12 +0400, Ruslan Zakirov wrote:
> On 7/27/07, Scott T. Hildreth <shildreth at allantgroup.com> wrote:
> > 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.
> May be you didn't get my crappy response :) 

   :-)

> I meant that update of
> mysql may cause problems in DBI or DBD::mysql, in this case you should
> at least rebuild these modules, it often helps.

  Mysql hasn't been upgraded, so that shouldn't be the issue.  But I am
  going to upgrade DBD::mysql anyways and see if that fixes the issue.

 

> >
> > 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>
> > _______________________________________________
> > 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>