[Rt-devel] RT eating memory

Tue Aug 17 07:25:32 EDT 2004

This is from top:
 1790 nobody    15   0  317M  25M  1780 S     0.0  2.2   7:27   1
mason_handler.f
 1805 nobody    17   0  317M 116M  1724 S     0.0 10.2  10:26   1
mason_handler.f
 1855 nobody    15   0  316M  23M  1872 S     0.0  2.0   6:42   0
mason_handler.f
 1910 nobody    17   0  332M 299M  1812 S     0.0 26.4   6:20   1
mason_handler.f

free:
             total       used       free     shared    buffers    
cached
Mem:       1159576     841000     318576          0      60380    
127844
-/+ buffers/cache:     652776     506800
Swap:      2562232    1226940    1335292

It had been rebooted on Sunday, no changes made to RT.
Then yesterday about noon it starts to eat memory and swap
like there is no tomorrow, until it's full.
Oh, and RT is also very slow now with this problem.

In the RT log, these are appearing since Monday around 9AM
[Mon Aug 16 12:37:46 2004] [crit]: RT::Ticket=HASH(0x9671c24) tried to
load a bogus ticket: 1173
 (/usr/rt3/lib/RT/Ticket_Overlay.pm:227)
[Mon Aug 16 12:37:46 2004] [err]: RT::Scrips=HASH(0x9722510) couldn't
load ticket 1173
 (/usr/rt3/lib/RT/Scrips_Overlay.pm:260)
[Mon Aug 16 12:37:47 2004] [crit]: Trying to check RT::Queue rights for
an unspecified RT::Queue (/usr/rt3/lib/RT/Principal_Overlay.pm:355)

They appear about 1-2 hour apart from then until now.
Memory leak somewhere maybe?
Attached is a .PNG graph showing memory usage. Green=mem, Blue=swap.

After some investigation I can see that what makes these occur are a
mail from a customer. It contains 5 attachments, 3 doc files and two
powerpoint files. the .doc files are: 25,5KB, 25.5KB, 188KB.
The .ppt files are around 2MB.

The ticket is created, and all the .doc files are visiable, but the
.ppt files are nowhere to be seen. Now, I think RT returns an error
to the MTA, since this mail has been coming again ever since Mondat 9AM,
each time creating a new ticket, each time failing on the .ppt (?).

The maillog (postfix) says:
Aug 17 11:38:13 master postfix/local[15017]: 5FEDCFD84B:
to=<no-support at support.isphuset.net>, relay=local, delay=88084,
status=deferred (temporary failure. Command output: RT server error. 
The RT server which handled your email did not behave as expected. It
said: <html><body> System error <table border="0"
cellspacing="0" cellpadding="1"> <tr> <td nowrap="nowrap"
align="left" valign="top">error:&nbsp;</td> <td align="left"
valign="top">DBD driver has not implemented the AutoCommit attribute at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line
612. </td> </tr> <tr> <td nowrap="nowrap" align="left"
valign="top">context:&nbsp;</td> <td align="left"
valign="top" nowrap="nowrap">

But please note that everything else seems to work just fine.

-HK