[rt-users] rt2-to-rt3 fails

Craig Schenk murple at murple.net
Fri Jan 16 11:56:44 EST 2004


Well, the problem was not ulimit. Running as root with no limit set, it still
crashed. The problem doesn't appear to be Perl 5.6.x either since the script
works fine with Perl if I narrow the dump (see below). The host I was running
on has 2 gigs physical ram and a pretty good ammount of swap. If 2Gb+ memory
isnt sufficient to run a dump on a 16000 record 300Mb database, there's
something wrong with that picture... I mention this only because some of the
responses in the mailing list archives suggested that this script requires 5Gb
and several days to run, which seems to be just slightly absurd.

I tried running the script with the since option, and found that this would
let me dump a few months worth of records before it started crashing. Since
date limits arent really useful because some old tickets are still open, I
modified the script to limit the database search on the Queue field in Tickets
rather than LastUpdated. This way, I can dump out whole queues at a time, and
not lose tickets older than a certain date. It's also a little more useful in
that it allows for migration only of queues that are of interest. The
maintainer of this script may want to consider incorporating this kind of
functionality in future revisions.

I did save the corefile generated when the script crashed before, if anybody
cares to debug the problem.





More information about the rt-users mailing list