Re: Missing messages

Hi Tom:

In message <CO3PR08MB7957D9E18791532E2AA010A8CA179@CO3PR08MB7957.namprd08.prod.
outlook.com>,
Tom Ekberg writes:

    [Ralf said:]
> > So my guess is that Tom's original problem stems from an
> > accidental press of the remove button.
>
>The problem was that I didn't see the '-' in the history
>for the unlinked message. I noted the messages in the
>history list and that one of the messages wasn't display. I
>then looked at the __retired__ column for the hidden
>message and it was 0, indicating it wasn't retired.
>The person who unlinked the message, followed up with another
>message covering whatever issue they were dealing with. By
>not retiring unlinked messages it is very difficult to see
>what those messages are to deal with them.

If you go to the msgNN page, the journal/history should tell
you where it was linked/unlinked etc. You can dump (and I
mean dump) that info in roundup-admin with history msgNN.

>They are just 'floating around' in the database not linked to
>anything.

I wonder if a "roundup-admin orphan <classname>" command is
worthwhile? I suspect some sql join on the issue_messages table
and id of the _msg table would show that. For the nosql
backend it would be more difficult.

Maybe looking over the history records for msgNN and
flagging any with an identical number of link and unlink
actions would work?

>While the database can support having the same
>message linked to multiple issues, the stock roundup user
>interface does not.

True. But we also don't want to limit the core for other use
cases. Setting retired as part of unlink would have to be
part of core Roundup. It seems to be mixing the streams as
those are two different operations with different use cases.

This is an interesting discussion. Thanks for starting it.

Have you found any indications of other orphaned/missing
messages?

Have a great weekend.

--
				-- rouilj
John Rouillard
===========================================================================
My employers don't acknowledge my existence much less my opinions.