|
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. [EMAIL PROTECTED] ~]# 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 [EMAIL PROTECTED] ~]# cat /opt/rt3/lib/RT.pm|grep
VERSION use vars qw($VERSION $System $SystemUser $Nobody
$Handle $Logger $VERSION = '3.4.4'; [EMAIL PROTECTED] ~]# perl -v This is perl, v5.8.5 built for
i386-linux-thread-multi [EMAIL PROTECTED] ~]# perl -MDBIx::SearchBuilder -e
'print $DBIx::SearchBuilder::VERSION;' 1.43 [EMAIL PROTECTED] ~]# httpd -v Server version: Apache/2.0.52 Server built: Nov 30 2004 11:22:20 [EMAIL PROTECTED] ~]# mysql -V mysql Ver 14.7 Distrib 4.1.12, for
redhat-linux-gnu (i386) using readline 4.3 [EMAIL PROTECTED] 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: |
_______________________________________________ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
