1164531 - [processor] Invalid build_ids when querying version data for Beta Rule

Status: RESOLVED FIXED

(Socorro :: Backend, task, P1)

Description

[[DEACTIVATED] Adrian Gaudebert]

2015-05-13 14:55:30.233 GMT,"processor","breakpad",5775,"[local]",55536467.168f,1,"SELECT",2015-05-13 14:49:11 GMT,16/29579529,0,ERROR,22P02,"invalid input syntax for type numeric: """"",,,,,,"
            SELECT
                pv.version_string
            FROM product_versions pv
                LEFT JOIN product_version_builds pvb ON
                    (pv.product_version_id = pvb.product_version_id)
            WHERE pv.product_name = 'Firefox'
            AND pv.release_version = '38.0'
            AND pv.build_type ILIKE 'beta'
            AND pvb.build_id = ''
        ",381,,""


I guess that means there are some invalid build_ids in our database and we should sanitize that data in the rule before using it.

Comment 1

[[DEACTIVATED] Adrian Gaudebert]

PR: https://github.com/mozilla/socorro/pull/2810

Comment 2

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/3383152b4dbe3fa542ebfc7bc8e56f792a01cb1f
Fixes bug 1164531 - Sanitized build id before using it in BetaVersionRule.

https://github.com/mozilla/socorro/commit/7ef83c1531dcfe52e38a64b28945f349f3bb9e05
Merge pull request #2810 from AdrianGaudebert/1164531-processor-beta-rule-build-id

Fixes bug 1164531 - Sanitized build id before using it in BetaVersionRule.