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\rNO-PASSWORDVDo 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@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 …foundMaybe 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