On Fri, 2007-07-27 at 01:12 +0400, Ruslan Zakirov wrote: > On 7/27/07, Scott T. Hildreth <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > > > > _______________________________________________ > > > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > > > > > > > Community help: http://wiki.bestpractical.com > > > > Commercial support: [EMAIL PROTECTED] > > > > > > > > > > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > > > > Buy a copy at http://rtbook.bestpractical.com > > > > > > > > > > > > -- > > Scott T. Hildreth <[EMAIL PROTECTED]> > > _______________________________________________ > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > > > Community help: http://wiki.bestpractical.com > > Commercial support: [EMAIL PROTECTED] > > > > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > > Buy a copy at http://rtbook.bestpractical.com > > > > -- Scott T. Hildreth <[EMAIL PROTECTED]> _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
