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