[rt-users] occasionally missing metadata

[Jesse Vincent]

On Mon, Oct 12, 2009 at 10:00:09AM +0200, Bernhard wrote:
> Hello again,
> 
> back to this issue - it happened again.
> Please give me directions on how to give you enough information to 
> analyse the problem...
> Cut short: mails do arrive in the tracker, but are not displayed - no 
> error message (at least not where i could find it),
> all I see in the tracker are ID, queue, sender address - other fields 
> are simply empty or not shown - no content, no header...
> 
> Here's my approach to analyse the problem:
> 1. Got the ticket number -> look it up in table Tickets, all data is there
> 
> 2. Take Creator ID from Tickets table and look it up in the Transactions 
> table -> found a couple of RT::Group entries, but look for RT::Ticket 
> entry with the same date to identify the Attachments -> found one 
> "Create" record where ObjectId equals the Ticket ID
> 
> 3. Take the Transaction ID and look it up in the Attachments table
> 
> 4. found 3 entries,
>    * one with the Ticket Subject and Parent 0 -> ContentType = 
> multipart/alternative, ContentEncoding NULL, Content NULL, Headers okay
>    * one with the previous one as ParentID -> "text/plain", 
> ContentEncoding "none", Content: BLOB -> the body of the message!, 
> Headers okay
>    * one another with the first one as Parent ID -> "text/html", 
> ContentEncoding "none", Content: BLOB -> again, the message, this time 
> in valid HTML, Headers seem okay as well
> 
> So - it seems the text/plain and text/html part are correctly in the DB.

Ok. so it's a display issue with multipart/alternative messages showing
neither part in the UI? Can you post a screenshot?

> 
> I have compared the results with a ticket that is shown without problem, 
> can't find any difference except that the Headers in the erroneous mail 
> start with "X-Originalarrivaltime" instead of the MIME-Version.

that shouldn't matter.