RT Hangs when clicking on the Tickets Link

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@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@evvmware01 ~]# cat /opt/rt3/lib/RT.pm|grep VERSION

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

$VERSION = ‘3.4.4’;

[root@evvmware01 ~]# perl -v

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

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

$DBIx::SearchBuilder::VERSION;’

1.43

[root@evvmware01 ~]# httpd -v

Server version: Apache/2.0.52

Server built: Nov 30 2004 11:22:20

[root@evvmware01 ~]# mysql -V

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

readline 4.3

[root@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: