[rt-users] rt2-to-rt3-v1.13 (.12?) Out of memory!

[Daniel Foster]

> ./rt-2.0-to-dumpfile /usr/local/share/dump/
> Script generate big CPU load 95-100%, This is normal, im read in README :-).
> Ending with system message "Out of memory!" ?
> My database is maybe big.
> 1.8G    /var/db/mysql/rt2/  > 102518 Tickets
> On a web machine I have 1Gb RAM.

I'm currently working on a similar setup, and ended up giving it 5GB of 
swap space to play with.  It doesn't fill it up and complains of lack of 
memory.

This happened on tickets that had got into autoresponder loops, and had 
thousands of transactions.

I ended up editing the RT2 database manually, removing all the 
transactions for these tickets and re-running rt-2.0-to-dumpfile.  I had 
to do this 4 times - took me about 5 days to get the dump in the end. 
The import process is now on ticket 20,000 and has so far been running 
for 26 hours...

-- 
Daniel Foster
Technical Director
34SP.com