All SQL is prefixed with this comment, time_zone set to +00:00 to help with time math

20:07:57 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SET TIME_ZONE='+00:00'

Get time from database perspective (in case the clocks are skewed)

20:07:57 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT

UNIX_TIMESTAMP(now()) `value`

Separate thread interested in the current time

20:08:05 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT

UNIX_TIMESTAMP(now()) `value`

Convert time to string, for use in all other queries (the start time)

20:08:05 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT

CAST(CONVERT_TZ(FROM_UNIXTIME(0/1000), 'UTC', 'US/Pacific') AS CHAR) `value`

20:08:05 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT max(bug_id)+1 bug_id FROM bugs

20:08:05 - Alias analysis skipped (--quick was used)

20:08:05 - Timer start: time to get bug list

An example of the datetime string

20:08:05 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT

b.bug_id

FROM

bugs b

LEFT JOIN

bug_group_map m ON m.bug_id=b.bug_id

WHERE

delta_ts >= '1970-01-01 00:00:00' AND

(0 <= b.bug_id AND b.bug_id < 1000) AND

m.bug_id IS NULL

20:08:06 - Timer end : time to get bug list (took 0.936 sec)

20:08:06 - Read comments from database

Thread responsible for comments etl: grab all comments on non-private bugs in the first block (1000 in a block)

20:08:06 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT

c.comment_id,

c.bug_id,

p.login_name modified_by,

UNIX_TIMESTAMP(CONVERT_TZ(bug_when, 'US/Pacific','UTC'))*1000 AS modified_ts,

c.thetext comment,

c.isprivate

FROM

longdescs c

LEFT JOIN

profiles p ON c.who = p.userid

WHERE

(`bug_id` in (35, 36, 37, 38, 39, 41, 42, 43, 51, 61, 62, 63, 71, 81, 82, 91, 92, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 163, 173, 174, 175, 176, 177, 178, 183, 184, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 369, 370, 371, 372, 373, 374, 375, 381, 382, 383, 384, 385, 386, 387, 388, 389, 399, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 487, 488, 489, 490, 491, 492, 497) OR (((`bug_id` BETWEEN 213 AND 361)) OR ((`bug_id` BETWEEN 507 AND 999)))) AND

bug_when >= '1970-01-01 00:00:00' AND

isprivate=0

Main ETL looks to see what columns are in the bugs table

20:08:06 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT

column_name,

column_type

FROM

information_schema.columns

WHERE

table_schema='bugzilla4' AND

table_name='bugs' AND

column_name NOT IN (

'bug_id', #EXPLICIT

'delta_ts', #NOT NEEDED

'lastdiffed', #NOT NEEDED

'creation_ts', #EXPLICIT

'reporter', #EXPLICIT

'assigned_to', #EXPLICIT

'qa_contact', #EXPLICIT

'product_id', #EXPLICIT

'component_id', #EXPLICIT

'cclist_accessible', #NOT NEEDED

'reporter_accessible', #NOT NEEDED

'short_desc', #NOT ALLOWED

'bug_file_loc', #NOT ALLOWED

'deadline', #NOT NEEDED

'estimated_time' #NOT NEEDED

)

Separate threads (and connections) are used to extract from bugzilla tables. These 10 SQL are listed in some random order:

20:08:06 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT bug_id

, UNIX_TIMESTAMP(CONVERT_TZ(f.creation_date, 'US/Pacific','UTC'))*1000 AS modified_ts

, ps.login_name AS modified_by

, 'flagtypes_name' AS field_name

, CONCAT(ft.`name`,status,IF(requestee_id IS NULL,'',CONCAT('(',pr.login_name,')'))) AS new_value

, CAST(null AS char(255)) AS old_value

, attach_id

, 8 AS _merge_order

FROM

flags f

JOIN `flagtypes` ft ON f.type_id = ft.id

JOIN profiles ps ON f.setter_id = ps.userid

LEFT JOIN profiles pr ON f.requestee_id = pr.userid

WHERE

ORDER BY

bug_id

20:08:06 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT blocked AS bug_id

, CAST(null AS signed) AS modified_ts

, CAST(null AS char(255)) AS modified_by

, 'dependson' AS field_name

, CAST(dependson AS SIGNED) AS new_value

, CAST(null AS SIGNED) AS old_value

, CAST(null AS signed) AS attach_id

, 2 AS _merge_order

FROM dependencies d

WHERE

(`blocked` in (35, 36, 37, 38, 39, 41, 42, 43, 51, 61, 62, 63, 71, 81, 82, 91, 92, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 163, 173, 174, 175, 176, 177, 178, 183, 184, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 369, 370, 371, 372, 373, 374, 375, 381, 382, 383, 384, 385, 386, 387, 388, 389, 399, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 487, 488, 489, 490, 491, 492, 497) OR (((`blocked` BETWEEN 213 AND 361)) OR ((`blocked` BETWEEN 507 AND 999))))

UNION

SELECT dependson dependson

, null

, 'blocked'

, CAST(blocked AS SIGNED)

, null

, 2

FROM dependencies d

WHERE

(`dependson` in (35, 36, 37, 38, 39, 41, 42, 43, 51, 61, 62, 63, 71, 81, 82, 91, 92, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 163, 173, 174, 175, 176, 177, 178, 183, 184, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 369, 370, 371, 372, 373, 374, 375, 381, 382, 383, 384, 385, 386, 387, 388, 389, 399, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 487, 488, 489, 490, 491, 492, 497) OR (((`dependson` BETWEEN 213 AND 361)) OR ((`dependson` BETWEEN 507 AND 999))))

ORDER BY bug_id

20:08:06 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT bug_id

, CAST(null AS signed) AS modified_ts

, CAST(null AS char(255)) AS modified_by

, 'see_also' AS field_name

, CAST(`value` AS char(255)) AS new_value

, CAST(null AS char(255)) AS old_value

, CAST(null AS signed) AS attach_id

, 2 AS _merge_order

FROM bug_see_also

WHERE

ORDER BY bug_id

20:08:06 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT

a.bug_id,

UNIX_TIMESTAMP(CONVERT_TZ(bug_when, 'US/Pacific','UTC'))*1000 AS modified_ts,

lower(login_name) AS modified_by,

replace(field.`name`, '.', '_') AS field_name,

lower(CAST(

CASE

WHEN a.fieldid IN (-1) THEN '<screened>'

WHEN trim(added)='' THEN NULL

ELSE trim(added)

END AS CHAR CHARACTER SET utf8

)) AS new_value,

lower(CAST(

CASE

WHEN a.fieldid IN (-1) THEN '<screened>'

WHEN trim(removed)='' THEN NULL

ELSE trim(removed)

END AS CHAR CHARACTER SET utf8

)) AS old_value,

attach_id,

9 AS _merge_order

FROM

bugs_activity a

JOIN

profiles p ON a.who = p.userid

JOIN

fielddefs field ON a.fieldid = field.`id`

WHERE

(`a`.`bug_id` in (35, 36, 37, 38, 39, 41, 42, 43, 51, 61, 62, 63, 71, 81, 82, 91, 92, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 163, 173, 174, 175, 176, 177, 178, 183, 184, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 369, 370, 371, 372, 373, 374, 375, 381, 382, 383, 384, 385, 386, 387, 388, 389, 399, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 487, 488, 489, 490, 491, 492, 497) OR (((`a`.`bug_id` BETWEEN 213 AND 361)) OR ((`a`.`bug_id` BETWEEN 507 AND 999)))) AND

bug_when >= '1970-01-01 00:00:00'

ORDER BY

bug_id,

bug_when DESC,

attach_id

20:08:06 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT bug_id

, UNIX_TIMESTAMP(CONVERT_TZ(a.creation_ts, 'US/Pacific','UTC'))*1000 AS modified_ts

, lower(login_name) AS modified_by

, UNIX_TIMESTAMP(CONVERT_TZ(a.creation_ts, 'US/Pacific','UTC'))*1000 AS created_ts

, login_name AS created_by

, ispatch AS 'attachments_ispatch'

, isobsolete AS 'attachments_isobsolete'

, isprivate AS 'attachments_isprivate'

, attach_id

FROM

attachments a

JOIN profiles p ON a.submitter_id = p.userid

WHERE

isprivate=0

ORDER BY

bug_id,

attach_id,

a.creation_ts

20:08:06 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT bug_id

, NULL AS modified_ts

, NULL AS modified_by

, 'keywords' AS field_name

, lower(kd.name) AS new_value

, NULL AS old_value

, NULL AS attach_id

, 2 AS _merge_order

FROM keywords k

JOIN keyworddefs kd ON k.keywordid = kd.id

WHERE

ORDER BY bug_id

20:08:06 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT bug_id

, CAST(null AS signed) AS modified_ts

, CAST(null AS char(255)) AS modified_by

, 'cc' AS field_name

, lower(CAST(p.login_name AS char(255))) AS new_value

, CAST(null AS char(255)) AS old_value

, CAST(null AS signed) AS attach_id

, 2 AS _merge_order

FROM

JOIN

profiles p ON cc.who = p.userid

WHERE

20:08:06 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT bug_id

, CAST(null AS signed) AS modified_ts

, CAST(null AS char(255)) AS modified_by

, 'bug_group' AS field_name

, lower(CAST(g.`name` AS char(255))) AS new_value

, CAST(null AS char(255)) AS old_value

, CAST(null AS signed) AS attach_id

, 2 AS _merge_order

FROM bug_group_map bg

JOIN groups g ON bg.group_id = g.id

WHERE

20:08:06 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT

bug_id,

UNIX_TIMESTAMP(CONVERT_TZ(b.creation_ts, 'US/Pacific','UTC'))*1000 AS modified_ts,

lower(pr.login_name) AS modified_by,

UNIX_TIMESTAMP(CONVERT_TZ(b.creation_ts, 'US/Pacific','UTC'))*1000 AS created_ts,

lower(pr.login_name) AS created_by,

lower(pa.login_name) AS assigned_to,

lower(pq.login_name) AS qa_contact,

lower(prod.`name`) AS product,

lower(comp.`name`) AS component,

short_desc,

bug_file_loc

lower(`bug_severity`) `bug_severity`,

lower(`bug_status`) `bug_status`,

lower(`op_sys`) `op_sys`,

lower(`priority`) `priority`,

lower(`rep_platform`) `rep_platform`,

lower(`version`) `version`,

lower(`resolution`) `resolution`,

lower(`target_milestone`) `target_milestone`,

`status_whiteboard`,

`votes`,

`everconfirmed`,

lower(`alias`) `alias`,

`remaining_time`,

lower(`cf_colo_site`) `cf_colo_site`,

`cf_crash_signature`,

lower(`cf_office`) `cf_office`,

`cf_due_date`,

`cf_last_resolved`,

`cf_shadow_bug`,

`restrict_comments`

FROM bugs b

LEFT JOIN profiles pr ON b.reporter = pr.userid

LEFT JOIN profiles pa ON b.assigned_to = pa.userid

LEFT JOIN profiles pq ON b.qa_contact = pq.userid

LEFT JOIN products prod ON prod.id = product_id

LEFT JOIN components comp ON comp.id = component_id

WHERE

20:08:06 - Execute SQL:

# from https://github.com/klahnakoski/Bugzilla-ETL

SELECT dupe AS bug_id

, CAST(null AS signed) AS modified_ts

, CAST(null AS char(255)) AS modified_by

, 'dupe_of' AS field_name

, CAST(dupe_of AS SIGNED) AS new_value

, CAST(null AS SIGNED) AS old_value

, CAST(null AS signed) AS attach_id

, 2 AS _merge_order

FROM duplicates d

WHERE

(`dupe` in (35, 36, 37, 38, 39, 41, 42, 43, 51, 61, 62, 63, 71, 81, 82, 91, 92, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 163, 173, 174, 175, 176, 177, 178, 183, 184, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 369, 370, 371, 372, 373, 374, 375, 381, 382, 383, 384, 385, 386, 387, 388, 389, 399, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 487, 488, 489, 490, 491, 492, 497) OR (((`dupe` BETWEEN 213 AND 361)) OR ((`dupe` BETWEEN 507 AND 999))))

UNION

SELECT dupe_of

, null

, 'dupe_by'

, CAST(dupe AS SIGNED)

, null

, 2

FROM duplicates d

WHERE

(`dupe_of` in (35, 36, 37, 38, 39, 41, 42, 43, 51, 61, 62, 63, 71, 81, 82, 91, 92, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 163, 173, 174, 175, 176, 177, 178, 183, 184, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 369, 370, 371, 372, 373, 374, 375, 381, 382, 383, 384, 385, 386, 387, 388, 389, 399, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 487, 488, 489, 490, 491, 492, 497) OR (((`dupe_of` BETWEEN 213 AND 361)) OR ((`dupe_of` BETWEEN 507 AND 999))))

ORDER BY bug_id

The main thread now waits for all the workers to be done reading resultsets

20:08:11 - Waiting on thread etl comments

20:08:12 - Waiting on thread process

20:08:16 - Waiting on thread etl comments

20:08:17 - Waiting on thread process

20:08:21 - Waiting on thread etl comments

20:08:22 - Waiting on thread process

20:08:26 - Waiting on thread etl comments

20:08:27 - Waiting on thread process

20:08:31 - Waiting on thread etl comments

20:08:32 - Waiting on thread process

20:08:36 - Waiting on thread etl comments

ETL starts (comments etl is still running in background)

20:08:37 - 6235 aliases loaded

20:08:40 - Using bzAliases to match change 'review?(wtchang@redhat.com)' to 'review?(wtc@google.com)'

20:08:40 - Matched added flag {

"modified_by": "wtc@google.com",

"modified_ts": 1188844365000,

"request_status": "+",

"request_type": "review",

"value": "review+"

} to removed flag {

"duration_days": 645.0,

"modified_by": "samuel@sieb.net",

"modified_ts": 1188752233000,

"previous_modified_ts": 1132989724000,

"previous_status": "?",

"previous_value": "review?(wtc@google.com)",

"request_status": "d",

"request_type": "review",

"requestee": "wtc@google.com"

}

20:08:40 - Matched added flag {

"modified_by": "nelson@bolyard.me",

"modified_ts": 1188934643000,

"request_status": "+",

"request_type": "superreview",

"value": "superreview+"

} to removed flag {

"duration_days": 1.0,

"modified_by": "nelson@bolyard.me",

"modified_ts": 1188934643000,

"previous_modified_by": "wtc@google.com",

"previous_modified_ts": 1188846000000,

"previous_status": "?",

"previous_value": "superreview?(nelson@bolyard.com)",

"request_status": "d",

"request_type": "superreview",

"requestee": "nelson@bolyard.com"

}

20:08:40 - Matched added flag {

"modified_by": "nelson@bolyard.me",

"modified_ts": 1234134874000,

"request_status": "-",

"request_type": "superreview",

"value": "superreview-"

} to removed flag {

"duration_days": 1.0,

"modified_by": "nelson@bolyard.me",

"modified_ts": 1234134874000,

"previous_modified_by": "ryanvm@gmail.com",

"previous_modified_ts": 1234043373000,

"previous_status": "+",

"previous_value": "superreview+",

"request_status": "d",

"request_type": "superreview"

}

20:08:40 - Matched added flag {

"modified_by": "nelson@bolyard.me",

"modified_ts": 1234135388000,

"request_status": "-",

"request_type": "superreview",

"value": "superreview-"

} to removed flag {

"duration_days": 0.0,

"modified_by": "nelson@bolyard.me",

"modified_ts": 1234135388000,

"previous_modified_by": "ryanvm@gmail.com",

"previous_modified_ts": 1234049995000,

"previous_status": "+",

"previous_value": "superreview+",

"request_status": "d",

"request_type": "superreview"

}

20:08:41 - PROBLEM: Unable to find CC:

[

"uconrad@gmx.net"

]

not in:

[

"aha@pinknet.cz",

"basic@mozdev.org",

"bugzilla@gemal.dk",

"erwan.hamon@free.fr",

"josh@harding.net",

"miguel.covas@bancoval.es",

"moksa@freetekno.fr",

"mozilla@wagland.net",

"mozilla_bugs@rambler.ru",

"op@opweb.de",

"relf@os2.ru",

"robo@ynet.sk",

"ulli.conrad@bio.uni-goettingen.de",

"whistler@hideout.ch",

"zuperdee@yahoo.com"

]

alias info:

{

"uconrad@gmx.net": null

}

20:08:41 - Waiting on thread etl comments

20:08:42 - PROBLEM: Unable to find CC:

[

"ysugiura-ml@cl20.net"

]

not in:

[

"afranke@mathweb.org",

"altlist@gmail.com",

"ametedinov@gmail.com",

"ancestor.ak@gmail.com",

"andreas.christl@de.bosch.com",

"anthony@derobert.net",

"barnboy@trilobyte.net",

"basic@mozdev.org",

"bob.crystaltech@gmail.com",

"brad0112358@yahoo.com",

"brant@gurganus.name",

"bugzilla.1.wurblzap@spamgourmet.com",

"bugzilla@chimpychompy.org",

"bugzilla@tuxmachine.com",

"bvrkchowdary@yahoo.co.in",

"cb13@gmx.net",

"chris.yeh@nokia.com",

"dan.lambert@noa.nintendo.com",

"danielwang@mozillanews.org",

"delzoun@gmail.com",

"dveditz@mozilla.com",

"ehsan@mozilla.com",

"eyalroz@technion.ac.il",

"fe@alterplast.ru",

"gsaranyamca@gmail.com",

"gunnar@wagenknecht.org",

"hhielscher@gmail.com",

"hullabalooza09@googlemail.com",

"jasonb@dante.com",

"jean_seb@videotron.ca",

"jehan@zemarmot.net",

"joules@gorfajn.com",

"justdave@bugzilla.org",

"kbenton@yitr.com",

"kniht@us.ibm.com",

"marcoos+bmo@marcoos.org",

"matthias.thullner@de.bosch.com",

"mikekonikoff@gmail.com",

"mkanat@bugzilla.org",

"mockodin@gmail.com",

"mozilla-bugs@nogin.org",

"mozilla-linux@srasku.net",

"mozilla.bugs@alyoung.com",

"mozilla@jackieliu.org",

"mrbball@comcast.net",

"nghoduong@gmail.com",

"oliver@samera.com.py",

"pacho@condmat1.ciencias.uniovi.es",

"paulspencer@mindspring.com",

"peter.jackson@rocksoft.com",

"prodigion@hotmail.com",

"prognathous@bluebottle.com",

"raj@lordofthemoon.com",

"ray@raybooysen.com",

"reed@reedloden.com",

"remember.pol@gmail.com",

"roni_abusch@msafe.com",

"shimono@bug-ja.org",

"sreindl@sreindl.de",

"t8m@centrum.cz",

"tenorman777@yahoo.com",

"tjholly@gmail.com",

"veshi@veshi.com",

"webmaster@eclipse.org",

"wicked@sci.fi",

"wulf.bugmail@yahoo.com",

"yuta.sugiura@miraclelinux.com",

"zain@voltage.com"

]

alias info:

{

"ysugiura-ml@cl20.net": null

}

20:08:42 - PROBLEM: Unable to find CC:

[

"alt@sonic.net"

]

not in:

[

"afranke@mathweb.org",

"altlist@gmail.com",

"anthony@derobert.net",

"barnboy@trilobyte.net",

"basic@mozdev.org",

"brad0112358@yahoo.com",

"brant@gurganus.name",

"chris.yeh@nokia.com",

"dan.lambert@noa.nintendo.com",

"danielwang@mozillanews.org",

"jasonb@dante.com",

"jean_seb@videotron.ca",

"justdave@bugzilla.org",

"kniht@us.ibm.com",

"mozilla-bugs@nogin.org",

"mozilla-linux@srasku.net",

"oliver@samera.com.py",

"prodigion@hotmail.com",

"roni_abusch@msafe.com",

"yuta.sugiura@miraclelinux.com",

"zuperdee@yahoo.com"

]

alias info:

{

"alt@sonic.net": null

}

20:08:42 - Matched added flag {

"modified_by": "mkanat@bugzilla.org",

"modified_ts": 1124760363000,

"request_status": "-",

"request_type": "blocking2.20",

"value": "blocking2.20-"

} to removed flag {

"duration_days": 0.0,

"modified_by": "mkanat@bugzilla.org",

"modified_ts": 1124760363000,

"previous_modified_by": "ehilditch@aol.com",

"previous_modified_ts": 1124712740000,

"previous_status": "?",

"previous_value": "blocking2.20?",

"request_status": "d",

"request_type": "blocking2.20"

}

20:08:42 - Matched added flag {

"modified_by": "mkanat@bugzilla.org",

"modified_ts": 1124760363000,

"request_status": "-",

"request_type": "blocking2.18.4",

"value": "blocking2.18.4-"

} to removed flag {

"duration_days": 0.0,

"modified_by": "mkanat@bugzilla.org",

"modified_ts": 1124760363000,

"previous_modified_by": "ehilditch@aol.com",

"previous_modified_ts": 1124712740000,

"previous_status": "?",

"previous_value": "blocking2.18.4?",

"request_status": "d",

"request_type": "blocking2.18.4"

}

20:08:42 - Matched added flag {

"modified_by": "mkanat@bugzilla.org",

"modified_ts": 1124760363000,

"request_status": "-",

"request_type": "blocking2.16.11",

"value": "blocking2.16.11-"

} to removed flag {

"duration_days": 0.0,

"modified_by": "mkanat@bugzilla.org",

"modified_ts": 1124760363000,

"previous_modified_by": "ehilditch@aol.com",

"previous_modified_ts": 1124712740000,

"previous_status": "?",

"previous_value": "blocking2.16.11?",

"request_status": "d",

"request_type": "blocking2.16.11"

}

20:08:42 - Matched added flag {

"modified_by": "lpsolit@gmail.com",

"modified_ts": 1329618359000,

"request_status": "-",

"request_type": "review",

"value": "review-"

} to removed flag {

"duration_days": 115.0,

"modified_by": "lpsolit@gmail.com",

"modified_ts": 1329618359000,

"previous_modified_by": "yuta.sugiura@miraclelinux.com",

"previous_modified_ts": 1319619513000,

"previous_status": "?",

"previous_value": "review?(mkanat@bugzilla.org)",

"request_status": "d",

"request_type": "review",

"requestee": "mkanat@bugzilla.org"

}

20:08:42 - Matched added flag {

"modified_by": "lpsolit@gmail.com",

"modified_ts": 1361069117000,

"request_status": "-",

"request_type": "review",

"value": "review-"

} to removed flag {

"duration_days": 134.0,

"modified_by": "lpsolit@gmail.com",

"modified_ts": 1361069117000,

"previous_modified_by": "dkl@mozilla.com",

"previous_modified_ts": 1349456022000,

"previous_status": "?",

"previous_value": "review?(glob@mozilla.com)",

"request_status": "d",

"request_type": "review",

"requestee": "glob@mozilla.com"

}

20:08:42 - Matched added flag {

"modified_by": "jouni@heikniemi.net",

"modified_ts": 1059236629000,

"request_status": "-",

"request_type": "review",

"value": "review-"

} to removed flag {

"duration_days": 167.0,

"modified_by": "jouni@heikniemi.net",

"modified_ts": 1059236629000,

"previous_modified_by": "brant@gurganus.name",

"previous_modified_ts": 1044738348000,

"previous_status": "?",

"previous_value": "review?",

"request_status": "d",

"request_type": "review"

}

20:08:43 - PROBLEM Encountered uncertain added value. Skipping.

20:08:43 - PROBLEM Encountered uncertain removed value. Skipping.

20:08:43 - PROBLEM Setting this bug to be uncertain.

20:08:43 - Nothing added or removed. Skipping update.

20:08:43 - UNCERTAIN ALIAS FOUND: dbaron@fas.harvard == dbaron@dbaron.org