[rt-users] RT Hangs when clicking on the Tickets Link

Fri Jun 2 08:20:18 EDT 2006

Everyone,

We hare having some problems moving RT from Windows to Linux. We are
currently running RT 3.0.12 on a windows machine and wish to move
everything to a Redhat AS4 Linux machine. To test the migration we are
using VMware. (I have also tried the same setup under Debian)

I have followed the install guide on the wiki and have RT working
without problems with a clean new empty database. I then dump the MySQL
database (using mysqldump) from the windows machine and reload it on the
Linux machine. I can login to RT and perform most functions. However
when I click the Tickets link on the upper left the session just hangs.
It appears that Apache gets stuck in some type of infinite loop and the
web server stops responding to all requests. There is an excerpt of the
apache error_log attached to this post. Those errors just keep on
logging over and over and over until I restart apache. I have tried
several different versions of RT with the same result. The output bellow
is from version 3.4.4 (I did run the schema, acl, etc DB upgrade
scripts). The same problem manifests itself on version 3.0.12 for Linux
too. Also note the messages logged to the RT debug log. Those appear
just after clicking the Tickets link so I assume they must be related.

One other interesting note: I had to rename almost all the tables after
reloading the database on Linux. The windows version of the database has
all the table names in lowercase. After loading the database on the
Linux server I did rename table commands to match the case of what the
Linux database table names.

Thanks 

Eric.

[root at evvmware01 ~]# uname -a

Linux evvmware01.magnetar.com 2.6.9-5.EL #1 Wed Jan 5 19:22:18 EST 2005

i686 i686 i386 GNU/Linux

[root at evvmware01 ~]# cat /opt/rt3/lib/RT.pm|grep VERSION

use vars qw($VERSION $System $SystemUser $Nobody $Handle $Logger

$VERSION = '3.4.4';

[root at evvmware01 ~]# perl -v

This is perl, v5.8.5 built for i386-linux-thread-multi

[root at evvmware01 ~]# perl -MDBIx::SearchBuilder -e 'print

$DBIx::SearchBuilder::VERSION;'

1.43

[root at evvmware01 ~]# httpd -v

Server version: Apache/2.0.52

Server built:   Nov 30 2004 11:22:20

[root at evvmware01 ~]# mysql -V

mysql  Ver 14.7 Distrib 4.1.12, for redhat-linux-gnu (i386) using

readline 4.3

[root at evvmware01 log]# tail -f /opt/rt3/var/log/rt.log

[Thu May 25 04:35:48 2006] [debug]: RT::CustomField -> QueueObj

deprecated (/opt/rt3/lib/RT/CustomField_Overlay.pm:753)

[Thu May 25 04:35:48 2006] [debug]: RT::CustomField -> QueueObj

deprecated (/opt/rt3/lib/RT/CustomField_Overlay.pm:753)

tail -500 /var/log/httpd/error_log

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr: \tDBIx::SearchBuilder::Next

('RT::Attributes=HASH(0xb22b5e8)') call ed

at /opt/rt3/lib/RT/Attributes_Overlay.pm line 80, referer:

http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr:

\tRT::Attributes::_BuildAccessTable('RT::Attributes=HASH(0xb22b5e8 )')

called at /opt/rt3/lib/RT/Attributes_Overlay.pm line 73, referer:

http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr: \tRT::Attributes::_DoSearch

('RT::Attributes=HASH(0xb22b5e8)') call ed

at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder.pm line 491,

referer: http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr: \tDBIx::SearchBuilder::Next

('RT::Attributes=HASH(0xb22b5e8)') call ed

at /opt/rt3/lib/RT/Attributes_Overlay.pm line 80, referer:

http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr:

\tRT::Attributes::_BuildAccessTable('RT::Attributes=HASH(0xb22b5e8 )')

called at /opt/rt3/lib/RT/Attributes_Overlay.pm line 73, referer:

http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr: \tRT::Attributes::_DoSearch

('RT::Attributes=HASH(0xb22b5e8)') call ed

at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder.pm line 491,

referer: http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr: \tDBIx::SearchBuilder::Next

('RT::Attributes=HASH(0xb22b5e8)') call ed

at /opt/rt3/lib/RT/Attributes_Overlay.pm line 80, referer:

http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr:

\tRT::Attributes::_BuildAccessTable('RT::Attributes=HASH(0xb22b5e8 )')

called at /opt/rt3/lib/RT/Attributes_Overlay.pm line 73, referer:

http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr: \tRT::Attributes::_DoSearch

('RT::Attributes=HASH(0xb22b5e8)') call ed

at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder.pm line 491,

referer: http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr: \tDBIx::SearchBuilder::Next

('RT::Attributes=HASH(0xb22b5e8)') call ed

at /opt/rt3/lib/RT/Attributes_Overlay.pm line 80, referer:

http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr:

\tRT::Attributes::_BuildAccessTable('RT::Attributes=HASH(0xb22b5e8 )')

called at /opt/rt3/lib/RT/Attributes_Overlay.pm line 73, referer:

http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr: \tRT::Attributes::_DoSearch

('RT::Attributes=HASH(0xb22b5e8)') call ed

at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder.pm line 491,

referer: http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr: \tDBIx::SearchBuilder::Next

('RT::Attributes=HASH(0xb22b5e8)') call ed

at /opt/rt3/lib/RT/Attributes_Overlay.pm line 80, referer:

http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr:

\tRT::Attributes::_BuildAccessTable('RT::Attributes=HASH(0xb22b5e8 )')

called at /opt/rt3/lib/RT/Attributes_Overlay.pm line 73, referer:

http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr: \tRT::Attributes::_DoSearch

('RT::Attributes=HASH(0xb22b5e8)') call ed

at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder.pm line 491,

referer: http://testrt.magnetar.com/Ticket/Display.html?id=1294

[Wed May 24 23:36:01 2006] [error] [client 10.1.24.141] FastCGI: server

"/opt/rt3/bin/mason_handler.fcgi" stderr: \tDBIx::SearchBuilder::Next

('RT::Attributes=HASH(0xb22b5e8)') call ed

at /opt/rt3/lib/RT/Attributes_Overlay.pm line 80, referer:

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060602/873b865b/attachment.htm>