933963 - Split up the signature summary reports

Status: VERIFIED FIXED

(Socorro :: Database, task)

Description

[Selena Deckelmann :selenamarie :selena]

Divide up update_signature_summary() to shorten the runtime of these reports.

Comment 1

[Selena Deckelmann :selenamarie :selena]

r? https://github.com/mozilla/socorro/pull/1646 :rhelmer, :brandonsavage?

Comment 2

[[github robot]]

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

https://github.com/mozilla/socorro/commit/45e88e861ab55334895f0e9be28d06a34a48d311
Fixes bug 933963 Split up Signature Summary jobs

https://github.com/mozilla/socorro/commit/596691fba1ff5b4771d357afbce28e3dc97338af
Migration for bug 933963

https://github.com/mozilla/socorro/commit/0b2a6810c6b4721ae0429ab1d4981138672a468d
Merge pull request #1646 from selenamarie/bug933963-split-up-signature-summary

Bug933963 split up signature summary

Comment 3

[Selena Deckelmann :selenamarie :selena]

Working!

2013-11-05 13:30:48,528 INFO - MainThread - Result from calling update_signature_summary_flash_version([datetime.date(2013, 11, 4)]): (True,)
2013-11-05 13:30:48,532 DEBUG - MainThread - successfully ran <class 'socorro.cron.jobs.matviews.SignatureSummaryFlashVersionCronApp'> on 2013-11-05 21:30:08.032943+00:00
2013-11-05 13:30:48,576 DEBUG - MainThread - skipping <class 'socorro.cron.jobs.matviews.SignaturesCronApp'> because it's not time to run
2013-11-05 13:30:48,615 DEBUG - MainThread - about to run <class 'socorro.cron.jobs.matviews.SignatureSummaryProcessTypeCronApp'>
2013-11-05 13:30:48,630 WARNING - MainThread - No previous last_success information available
2013-11-05 13:31:22,250 INFO - MainThread - Result from calling update_signature_summary_process_type([datetime.date(2013, 11, 4)]): (True,)
2013-11-05 13:31:22,261 DEBUG - MainThread - successfully ran <class 'socorro.cron.jobs.matviews.SignatureSummaryProcessTypeCronApp'> on 2013-11-05 21:30:48.630258+00:00
2013-11-05 13:31:22,327 DEBUG - MainThread - skipping <class 'socorro.cron.jobs.matviews.BuildADUCronApp'> because it's not time to run
2013-11-05 13:31:22,337 DEBUG - MainThread - skipping <class 'socorro.cron.jobs.matviews.CorrelationsCronApp'> because it's not time to run
2013-11-05 13:31:22,347 DEBUG - MainThread - skipping <class 'socorro.cron.jobs.matviews.CrashesByUserBuildCronApp'> because it's not time to run
2013-11-05 13:31:22,391 DEBUG - MainThread - about to run <class 'socorro.cron.jobs.matviews.SignatureSummaryProductsCronApp'>
2013-11-05 13:31:22,409 WARNING - MainThread - No previous last_success information available
2013-11-05 13:31:55,904 INFO - MainThread - Result from calling update_signature_summary_products([datetime.date(2013, 11, 4)]): (True,)
2013-11-05 13:31:55,908 DEBUG - MainThread - successfully ran <class 'socorro.cron.jobs.matviews.SignatureSummaryProductsCronApp'> on 2013-11-05 21:31:22.409419+00:00
2013-11-05 13:31:55,978 DEBUG - MainThread - skipping <class 'socorro.cron.jobs.matviews.TCBSBuildCronApp'> because it's not time to run
2013-11-05 13:31:56,011 DEBUG - MainThread - about to run <class 'socorro.cron.jobs.matviews.SignatureSummaryOsCronApp'>
2013-11-05 13:31:56,020 WARNING - MainThread - No previous last_success information available
2013-11-05 13:32:48,828 INFO - MainThread - Result from calling update_signature_summary_os([datetime.date(2013, 11, 4)]): (True,)
2013-11-05 13:32:48,832 DEBUG - MainThread - successfully ran <class 'socorro.cron.jobs.matviews.SignatureSummaryOsCronApp'> on 2013-11-05 21:31:56.020865+00:00
2013-11-05 13:32:48,874 DEBUG - MainThread - skipping <class 'socorro.cron.jobs.matviews.NightlyBuildsCronApp'> because it's not time to run
2013-11-05 13:32:48,903 DEBUG - MainThread - about to run <class 'socorro.cron.jobs.matviews.SignatureSummaryArchitectureCronApp'>
2013-11-05 13:32:48,912 WARNING - MainThread - No previous last_success information available
2013-11-05 13:33:28,192 INFO - MainThread - Result from calling update_signature_summary_architecture([datetime.date(2013, 11, 4)]): (True,)
2013-11-05 13:33:28,196 DEBUG - MainThread - successfully ran <class 'socorro.cron.jobs.matviews.SignatureSummaryArchitectureCronApp'> on 2013-11-05 21:32:48.912946+00:00
2013-11-05 13:33:28,236 DEBUG - MainThread - skipping <class 'socorro.cron.jobs.matviews.HomePageGraphCronApp'> because it's not time to run
2013-11-05 13:33:28,303 DEBUG - MainThread - about to run <class 'socorro.cron.jobs.matviews.SignatureSummaryUptimeCronApp'>
2013-11-05 13:33:28,313 WARNING - MainThread - No previous last_success information available
2013-11-05 13:34:32,249 INFO - MainThread - Result from calling update_signature_summary_uptime([datetime.date(2013, 11, 4)]): (True,)
2013-11-05 13:34:32,254 DEBUG - MainThread - successfully ran <class 'socorro.cron.jobs.matviews.SignatureSummaryUptimeCronApp'> on 2013-11-05 21:33:28.313450+00:00
2013-11-05 13:34:32,322 DEBUG - MainThread - about to run <class 'socorro.cron.jobs.matviews.SignatureSummaryGraphicsCronApp'>
2013-11-05 13:34:32,350 WARNING - MainThread - No previous last_success information available

Comment 4

[Matt Brandt [:mbrandt]]

Bumping to verified as [qa-].