856047 - the same query on bmo returns different results

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Peter ONeill [:zero]]

Attachment: Screen Shoot Of Not working search

So about half of the time I run the same saved search at the bottom of my screen it works. The other half of the time it ignores limiting the results to only the components I have selected. 

I have attached a screen shots that shows I am search for only those 2 components but it is bringing up bugs from other components. 

But If I continue to click on the saved search it will eventually bring up the correct results.

Comment 1

[Frédéric Buclin]

Is it intentional to leak the bug summary of non-public bugs?

Also, the fact that it works only half of the time makes me think that it's not an upstream bug.

Comment 2

[David Lawrence [:dkl]]

Made attachment private as it contained secure bug summaries in the screenshot.

dkl

Comment 3

[Peter ONeill [:zero]]

Sorry about not making the attachment private. 

Also this happens on all of my computers, could it just be related to my account then?

Comment 4

[:glob ✱]

it isn't related to your account -- i just run your saved query, and i also got more results than expected.

here's the generated sql:

SELECT
  bugs.bug_id AS bug_id
FROM
  bugs
  LEFT JOIN bug_group_map AS security_map ON bugs.bug_id = security_map.bug_id
    AND NOT ( security_map.group_id IN (13,20,19,87,30,31,10,3,9,18,4,7,8,1,94,93,132,57,53,48,92,23,123,2,125,124,142,119,69,136,130,84,11,126,111,144,88,138,14,128,90,32,6,42,26,120,121,122,85,86,109,140,96,106,100,101,73,113,116,58,17,65,134,91,52,12,50,103) )
  LEFT JOIN cc AS security_cc ON bugs.bug_id = security_cc.bug_id
    AND security_cc.who = 13647
  INNER JOIN profiles AS name_assigned_to_3 ON bugs.assigned_to = name_assigned_to_3.userid
  INNER JOIN profiles AS name_assigned_to_4 ON bugs.assigned_to = name_assigned_to_4.userid
WHERE
  bugs.creation_ts IS NOT NULL
  AND (security_map.group_id IS NULL
    OR (bugs.reporter_accessible = 1 AND bugs.reporter = 13647)
    OR (bugs.cclist_accessible = 1 AND security_cc.who IS NOT NULL)
    OR bugs.assigned_to = 13647
    OR bugs.qa_contact = 13647)
  AND bugs.component_id IN (601,600)
  AND bugs.product_id IN (10)
  AND bugs.resolution IN ('')
  AND (((name_assigned_to_3.login_name = '[e-mail]'
    OR name_assigned_to_4.login_name = '[e-mail]')))
GROUP BY
  bugs.bug_id
ORDER BY
  bug_id
LIMIT 500

i ran this query directly 6 times.  5 out of the 6 runs returned 11 bugs.  1 run returned 38 bugs.

Comment 5

[:glob ✱]

would it be possible for the dbas to have a look at this?

to test it i used the page which lets us run queries directly on the database, so this doesn't look like a bugzilla code issue.

Comment 6

[Sheeri Cabral [:sheeri]]

Brandon is taking a look now.

Comment 7

[Brandon Johnson [:cyborgshadow]]

All tables indices are fixed, data's back in sync from the issue we had from the failover, failover docs have been updated to account so that issue won't happen again, and failing back over now. Marking this FIXED.