912527 - Retest query once partition fixes are applied

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[Selena Deckelmann :selenamarie :selena]

Originally reported by :bsmedberg: 

This query isn't correctly respecting partitions becaues of bug 905346:

SELECT
   r.uuid,
   r.cpu_info
FROM
   reports r
   JOIN reports_clean rc ON rc.uuid = r.uuid
   JOIN signatures s ON s.signature_id = rc.signature_id
WHERE
   r.date_processed > '2013-04-25' AND r.date_processed < '2013-04-30'
   AND rc.date_processed > '2013-04-25' AND rc.date_processed < '2013-04-30'
   AND r.os_name ~ 'Windows NT'
   AND r.hangid IS NULL
   AND rc.product_version_id = 1552
   AND s.signature =
'mozilla::dom::DocumentBinding::CreateInterfaceObjects(JSContext*,
JSObject*, JSObject**)'
;

Comment 1

[Selena Deckelmann :selenamarie :selena]

It's not perfect, but we're at least only looking at partitions which are from April on now. 

I'm getting deadlocks starting with the June partitions. I'll try to run more migrations late this evening to avoid the deadlocks.

Comment 2

[Selena Deckelmann :selenamarie :selena]

All remaining misconfigured partitions have been removed!