[Bug 64373] Bugzilla ticket with recent comments listed under "Longest time without comment" on bugzilla_response_time.html
https://bugzilla.wikimedia.org/show_bug.cgi?id=64373
--- Comment #12 from Andre Klapper ---
Disclaimer: I'm rather clueless & it's late, so this might be naive:
(In reply to Santiago Dueñas from comment #11)
> To be more specific, our tool retrieves issues using URLs like:
> https://bugzilla.wikimedia.org/buglist.
> cgi?product=MediaWiki%20extensions&component=OAuth
> So, for instance, if an issue from OAuth is moved to "Extensions requests",
> that issue will not be listed anymore using the URL from above.
As you regularly update/sync the data in your database, how do you identify new
(recently created) tickets created in a key project which is tracked?
I assume by explicitly querying for tickets created since
$time_of_last_db_sync, and then adding them to "your list"?
No idea on performance or other side effects, just wondering:
Compare the list of bug IDs for a tracked project {1, 4, 17} gathered yesterday
with today's bug IDs from Bugzilla for that project {1, 17, 21}, in order to
see that 1) bug #21 should also be tracked now for the project's stats, and
that 2) bug #4 is not listed anymore and should be dropped from stats for this
project?
In other words, something like
curl -X POST -H"Content-Type: text/xml" -d "Bug.searchcomponentBugzillaresolutionlimit0"
https://bugzilla.wikimedia.org/xmlrpc.cgi
to get all open tickets for the "Bugzilla" component (query not tested, plus
cool kids use JSON instead of XML), then extract all provided values for "id"
nodes with your favorite parser, and compare that list against the list of bug
IDs you have from the last time you ran that query?
If that's not feasible (tool's architecture, Bugzilla sucks, etc.), a two-word
"Sorry, nope!" reply here is very acceptable, to not waste your time. ;)
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 64373] Bugzilla ticket with recent comments listed under "Longest time without comment" on bugzilla_response_time.html
https://bugzilla.wikimedia.org/show_bug.cgi?id=64373 --- Comment #11 from Santiago Dueñas --- The problem here is we only track those issues from the list of products and components (key projects) you gave us. When an issue is shifted to another product we cannot trace it. To be more specific, our tool retrieves issues using ULRs like: https://bugzilla.wikimedia.org/buglist.cgi?product=MediaWiki%20extensions&component=OAuth So, for instance, if an issue from OAuth is moved to "Extensions requests", that issue will not be listed anymore using the URL from above. The issue will be listed when requesting the issues from "Extensions requests" component. As we do not track this component, we can't know what has happened to that issue. I only found a solution for this and it's to crawl the whole Bugzilla, retrieve all issues and then, filter by key projects. The (huge) problem is it's time consuming. We will need more time on retrieving everyhing, filtering and measuring. I will talk during this week with Alvaro and let's see if we can find a better solution. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 64373] Bugzilla ticket with recent comments listed under "Longest time without comment" on bugzilla_response_time.html
https://bugzilla.wikimedia.org/show_bug.cgi?id=64373 --- Comment #10 from Andre Klapper --- (In reply to Santiago Dueñas from comment #9) > we still have a problem when an issue is moved from a key project to a non > key project. We still have to think how to track these kind of changes. https://bugzilla.wikimedia.org/show_bug.cgi?id=13090#c2 is another example with a comment from 2014-06-22, still listed in the "Longest time without comment" column. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 64373] Bugzilla ticket with recent comments listed under "Longest time without comment" on bugzilla_response_time.html
https://bugzilla.wikimedia.org/show_bug.cgi?id=64373 --- Comment #9 from Santiago Dueñas --- (In reply to Andre Klapper from comment #8) > This is still (again?) a problem: > The middle column lists bug 12360 (Implement an extension similar to the > LifeMarks - on the Hebrew Wikipedia) which I commented on a few weeks ago. We fixed the problem with duplicated issues but we still have a problem when an issue is moved from a key project to a non key project, that is the case of bug 12360. We still have to think how to track these kind of changes. BTW, I removed that issue from the database. That means it will be removed from the database with the daily update. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 64373] Bugzilla ticket with recent comments listed under "Longest time without comment" on bugzilla_response_time.html
https://bugzilla.wikimedia.org/show_bug.cgi?id=64373 --- Comment #8 from Andre Klapper --- This is still (again?) a problem: The middle column lists bug 12360 (Implement an extension similar to the LifeMarks - on the Hebrew Wikipedia) which I commented on a few weeks ago. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 64373] Bugzilla ticket with recent comments listed under "Longest time without comment" on bugzilla_response_time.html
https://bugzilla.wikimedia.org/show_bug.cgi?id=64373 --- Comment #7 from Andre Klapper --- Looks like this is FIXED now; item not listed anymore. Santiago: Is only this item "fixed", or is the general problem also fixed? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 64373] Bugzilla ticket with recent comments listed under "Longest time without comment" on bugzilla_response_time.html
https://bugzilla.wikimedia.org/show_bug.cgi?id=64373 --- Comment #6 from Santiago Dueñas --- I forgot to mention that this number is so low because we regenerate the database from time to time. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 64373] Bugzilla ticket with recent comments listed under "Longest time without comment" on bugzilla_response_time.html
https://bugzilla.wikimedia.org/show_bug.cgi?id=64373 --- Comment #5 from Santiago Dueñas --- Yes, that's the point. I checked the database and currently, we only have 39 duplicated out of 46276 issues. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 64373] Bugzilla ticket with recent comments listed under "Longest time without comment" on bugzilla_response_time.html
https://bugzilla.wikimedia.org/show_bug.cgi?id=64373 Quim Gil changed: What|Removed |Added Priority|High|Normal --- Comment #4 from Quim Gil --- Thank you for the details. Moving bugs to another component is a relatively frequent action. Do you mean that every time this happens, we have a duplicated entry in Korma's database? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 64373] Bugzilla ticket with recent comments listed under "Longest time without comment" on bugzilla_response_time.html
https://bugzilla.wikimedia.org/show_bug.cgi?id=64373 --- Comment #3 from Santiago Dueñas --- This bug is related to issues that shift from a component to another. We analize the issues by component so, when their component changes, we don't track it on the former component. We do it on the new one. Now, we have the same issue duplicated in our database. One in Search component that don't has info about the comments and new changes that were made; and the other on in CirrusSearch, which has the recent activity. That's why 7886 is been shown in the table. Because we're showing the issue, stored in our database, that don't have the latest comments. I've just removed from the database and on the next update, it should have been removed from the top list, too. In any case, we have to find ways to detect these kind of problems. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 64373] Bugzilla ticket with recent comments listed under "Longest time without comment" on bugzilla_response_time.html
https://bugzilla.wikimedia.org/show_bug.cgi?id=64373 --- Comment #2 from Quim Gil --- Note that it has also Lowest priority, another factor to take it out from the list. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 64373] Bugzilla ticket with recent comments listed under "Longest time without comment" on bugzilla_response_time.html
https://bugzilla.wikimedia.org/show_bug.cgi?id=64373 Quim Gil changed: What|Removed |Added Priority|Unprioritized |High CC||sdue...@bitergia.com --- Comment #1 from Quim Gil --- Strange, I have gone through dozens of links in that list, and all of them seemed legit. I wonder whether the fact that the status of that report is REOPENED has anything to do with this. Marking as "High" not because of the minor problem, but for the possibility that REOPENED reports are treated differently. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
