[rt-users] RT1 to RT2 Import Very Slow (import-1.0-to-2.0)

[feidhlim o neill]

> 
> 
> The import-1.0-to-2.0 runs very slowly and eventually stops.
> I remember seeing something about this before on a post but cannot 
seem 
> to find an answer.
> Perhaps some incompatible perl module!
> The import-1.0-to-2.0 takes about 20 minutes to create 5 or so queues 
> and 20 or so users.
> It then take about 10minutes to import a single ticket.
> 
> Running strace on the process I see...
> 
> read(3, "\1\0\0$", 4)                   = 4
> read(3, "\376", 1)                      = 1
> brk(0x887d000)                          = 0x887d000
> read(3, "\313\0\0%", 4)                 = 4
> read(3, "\0011\tRT_System\r*NO-PASSWORD*VDo no"..., 203) = 203
> brk(0x887f000)                          = 0x887f000
> read(3, "\1\0\0&", 4)                   = 4
> read(3, "\376", 1)                      = 1
> time(NULL)                              = 1034952934
> time(NULL)                              = 1034952934
> fcntl64(3, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
> read(3, 0x8871b28, 8192)                = -1 EAGAIN (Resource 
> temporarily
> unavailable)
> fcntl64(3, F_SETFL, O_RDWR)             = 0
> write(3, "+\0\0\0\3SELECT  * FROM Users WHERE "..., 47) = 47
> read(3, "\1\0\0\1", 4)                  = 4
> read(3, "\"", 1)                        = 1
> read(3, "\23\0\0\2", 4)                 = 4
> read(3, "\5Users\2id\3\v\0\0\1\3\3\vB\0", 19) = 19
> read(3, "\25\0\0\3", 4)                 = 4
> read(3, "\5Users\4Name\3x\0\0\1\375\3\5@\0", 21) = 21
> read(3, "\31\0\0\4", 4)
> 
> And lots of time(NULL) messages.
> 
> The servers is mandrake 9.0 with mysql 3.23.38 , RT is 2-0-15
> 
> make testdeps returns ...
> 
> [root at test rt-2-0-15]# make testdeps
> /usr/bin/perl ./tools/testdeps -warn mysql
> Checking for Digest::MD5...found
> Checking for Storable...found
> Checking for DBI 1.18 ...found
> Checking for DBIx::DataSource 0.02 ...found
> Checking for DBIx::SearchBuilder 0.48 ...found
> Checking for HTML::Entities...found
> Checking for MLDBM...found
> Checking for Net::Domain...found
> Checking for Net::SMTP...found
> Checking for Params::Validate 0.02 ...found
> Checking for HTML::Mason 1.02 ...found
> Checking for CGI::Cookie 1.20 ...found
> Checking for Apache::Cookie...found
> Checking for Apache::Session 1.53 ...found
> Checking for Date::Parse...found
> Checking for Date::Format...found
> Checking for MIME::Entity 5.108 ...found
> Checking for Mail::Mailer 1.20 ...found
> Checking for Getopt::Long 2.24 ...found
> Checking for Tie::IxHash...found
> Checking for Text::Wrapper...found
> Checking for Text::Template...found
> Checking for File::Spec 0.8 ...found
> Checking for Errno...found
> Checking for FreezeThaw...found
> Checking for File::Temp...found
> Checking for Log::Dispatch 1.6 ...found
> Checking for DBD::mysql 2.0416 ...found
> 
> Maybe a better example is
> 
> fcntl64(3, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
> read(3, 0x8f03e50, 53248)               = -1 EAGAIN (Resource 
> temporarily
> unavailable)
> fcntl64(3, F_SETFL, O_RDWR)             = 0
> write(3, ")\0\0\0\3SELECT  * FROM Watchers WHE"..., 45) = 45
> read(3, "\1\0\0\1", 4)                  = 4
> read(3, "\v", 1)                        = 1
> read(3, "\26\0\0\2", 4)                 = 4
> read(3, "\10Watchers\2id\3\v\0\0\1\3\3\3B\0", 22) = 22
> read(3, "\30\0\0\3", 4)                 = 4
> read(3, "\10Watchers\4Type\3\20\0\0\1\375\3\0@\0", 24) = 24
> read(3, "\31\0\0\4", 4)                 = 4
> read(3, "\10Watchers\5Scope\3\20\0\0\1\375\3\10@\0", 25) = 25
> read(3, "\31\0\0\5", 4)                 = 4
> read(3, "\10Watchers\5Value\3\v\0\0\1\3\3\0@\0", 25) = 25
> read(3, "\31\0\0\6", 4)                 = 4
> read(3, "\10Watchers\5Email\3\377\0\0\1\375\3\0\0\0", 25) = 25
> read(3, "\31\0\0\7", 4)                 = 4
> read(3, "\10Watchers\5Quiet\3\v\0\0\1\3\3\0\0\0", 25) = 25
> read(3, "\31\0\0\10", 4)                = 4
> read(3, "\10Watchers\5Owner\3\v\0\0\1\3\3\0@\0", 25) = 25
> read(3, "\33\0\0\t", 4)                 = 4
> read(3, "\10Watchers\7Creator\3\v\0\0\1\3\3\0\0\0", 27) = 27
> read(3, "\33\0\0\n", 4)                 = 4
> read(3, "\10Watchers\7Created\3\23\0\0\1\f\3\0\0\0", 27) = 27
> read(3, "!\0\0\v", 4)                   = 4
> read(3, "\10Watchers\rLastUpdatedBy\3\v\0\0\1\3\3\0\0"..., 33) = 33
> read(3, "\37\0\0\f", 4)                 = 4
> read(3, "\10Watchers\vLastUpdated\3\23\0\0\1\f\3\0\0\0", 31) = 31
> read(3, "\1\0\0\r", 4)                  = 4
> read(3, "\376", 1)                      = 1
> read(3, "L\0\0\16", 4)                  = 4
> read(3, "\003778\tRequestor\6Ticket\003346\373\0010\003109"..., 76) = 
76
> read(3, "\1\0\0\17", 4)                 = 4
> read(3, "\376", 1)                      = 1
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> time(NULL)                              = 1034958707
> 
> 
> Any ideas?
> 
> Thanks