SiT! Bugs - SiT!
View Issue Details
0001045SiT!inbound emailpublic2010-01-19 14:012010-03-27 12:30
ivan 
ivan 
normalminorhave not tried
closedfixed 
3.50 
3.60 LTS3.60 LTS 
0001045: Tempincoming table grows and grows
The tempincoming table grows indefinitely. Records should be deleted from this table as soon as they've served their purpose.
No tags attached.
Issue History
2010-01-19 14:01ivanNew Issue
2010-01-19 19:39paulhNote Added: 0002292
2010-01-31 16:26paulhNote Added: 0002335
2010-01-31 16:26paulhStatusnew => confirmed
2010-03-24 10:56ivanTarget Version => 4.0
2010-03-24 11:01ivanTarget Version4.0 => 3.60 LTS
2010-03-24 11:01ivanStatusconfirmed => assigned
2010-03-24 11:01ivanAssigned To => ivan
2010-03-24 20:16ivanSummaryTempincoming needs purging periodically => Tempincoming table grows and grows
2010-03-24 20:16ivanDescription Updatedbug_revision_view_page.php?rev_id=120#r120
2010-03-24 20:31ivanNote Added: 0002855
2010-03-24 20:31ivanStatusassigned => resolved
2010-03-24 20:31ivanFixed in Version => Current SVN
2010-03-24 20:31ivanResolutionopen => fixed
2010-03-27 11:16ivanFixed in VersionCurrent SVN => 3.60 LTS
2010-03-27 12:30ivanStatusresolved => closed

Notes
(0002292)
paulh   
2010-01-19 19:39   
Surely the task which removes the email from the holding queue should do this? We have a function delete_holding_queue_update() which does delete from this table though is only called when reopening an incident so we should call this when either deleting from the list or when we open an incident?
(0002335)
paulh   
2010-01-31 16:26   
Confirming this as a issue, think we should remove the entry when the item is removed from the queue (either incident created or deleted)
(0002855)
ivan   
2010-03-24 20:31   
Entry was already removed from tempincoming when moved or deleted from the holding queue but not when an incident was added.

Fixed in 3.x branch svn r6335
and Git sit:master a2eed62