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@allantgroup.com
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@allantgroup.com
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.On 7/27/07, Scott T. Hildreth shildreth@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@allantgroup.com
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@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.
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.
Looking back through old logs, this has happened before but not
with the frequency that has occurred in the last 3 days.
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@allantgroup.com
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@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@allantgroup.com
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.
Looking back through old logs, this has happened before but not
with the frequency that has occurred in the last 3 days.
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@allantgroup.com
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@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@allantgroup.com
The rt-users Archives
Community help: http://wiki.bestpractical.com
Commercial support: sales@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@allantgroup.com