[rt-users] Sudden segfaults Rt-3.6.3

[Ruslan Zakirov]

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.

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


-- 
Best regards, Ruslan.