[Rt-devel] rt2-to-rt3-1.23 out of memory

[Robert Westendorp]

Can you give an example of the query to removing orphan'd users? I think I
might be having this issue .. we have 265,000+ users in the table and way
less tickets :)

----- Original Message ----- 
From: "Vivek Khera" <vivek at khera.org>
To: <rt-devel at lists.bestpractical.com>
Sent: Friday, May 28, 2004 7:36 AM
Subject: Re: [Rt-devel] rt2-to-rt3-1.23 out of memory


>
> On May 28, 2004, at 3:16 AM, Robert Loomans wrote:
>
> > When I tried to run rt-2.0-to-dumpfile it ran out of memory. The Linux
> > machine in question has 4GB and 4GB of swap.
> >
>
> A common failing is understanding that unix like systems are not
> originally single-user boxes.  That means that just because your box
> has X amount of resource it does not  mean that any single process can
> use that much resource.  In particular, check the memory resource
> limits of your process that is running the export.
>
> Anyhow, did your export get any tickets out or did it die while
> exporting the other info like users list and configs?
>
> I've found that it helps to purge the user list of owners who do not
> own any tickets (be sure not to delete the root user, or any privileged
> user).  You can do this with a left join on the tickets table on the
> owner id.  I do this after purging dead tickets (we get a boatload of
> spam to our abuse@ queue).
>
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.bestpractical.com
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel