prod Socorro run startDailyCrashes.py

RESOLVED FIXED

Status

Infrastructure & Operations
WebOps: Other
--
critical
RESOLVED FIXED
8 years ago
5 years ago

People

(Reporter: ozten, Assigned: aravind)

Tracking

Details

(URL)

(Reporter)

Description

8 years ago
Please run startDailyCrashes.py again.

Reason: It hasn't been started today 6/10 so there are no 6/10 data points.

We could wait until the cron kicks in for the 1st time at 00:15am... but this data is useful for current 3.6.4 research.

Thanks.
(Assignee)

Comment 1

8 years ago
on it.
Assignee: server-ops → aravind
(Assignee)

Comment 2

8 years ago
and done.

2010-06-11 13:45:58,201 INFO - current configuration
        crashStorageClass=CrashStorageSystemForHBase
        databaseHost=tm-breakpad01-master01
        databaseName=breakpad
        databasePassword=**********
        databasePort=5432
        databaseUserName=breakpad_rw
        debug=False
        defaultDeltaWindow=0:12:00
        deltaDate
        deltaWindow
        dumpFileSuffix=.dump
        endDate
        endWindow
        hbaseHost=10.2.72.247
        hbasePort=9090
        hbaseTimeout=5000
        initialDeltaDate=4 days, 0:00:00
        jsonFileSuffix=.json
        logFileErrorLoggingLevel=10
        logFileLineFormatString=%(asctime)s %(levelname)s - %(message)s
        logFileMaximumBackupHistory=50
        logFileMaximumSize=1000000
        logFilePathname=./daily_crash.log
        minutesPerSlot=1
        processorCheckInTime=0:06:00
        socorroTimeToUTCInterval=8 hours
        startDate
        startWindow
        stderrErrorLoggingLevel=10
        stderrLineFormatString=%(asctime)s %(levelname)s - %(message)s

2010-06-11 13:45:58,223 INFO - Beginning search from this date (YYYY-MM-DD): 2010-06-10 00:00:00
2010-06-11 13:45:58,223 DEBUG - Processing 2010-06-10 00:00:00 crashes for use with ADU data
2010-06-11 13:45:58,223 DEBUG -
  INSERT INTO daily_crashes (count, report_type, productdims_id, os_short_name, adu_day)
    SELECT COUNT(r.uuid) as count, 'C', p.id, substring(r.os_name, 1, 3) AS os_short_name,
           timestamp without time zone '2010-06-10'
    FROM product_visibility cfg
    JOIN productdims p on cfg.productdims_id = p.id
    JOIN reports r on p.product = r.product AND p.version = r.version
    WHERE NOT cfg.ignore AND
          timestamp without time zone '2010-06-10T00:00:00' - interval E'8 hours' <= r.date_processed AND
          r.date_processed < timestamp without time zone '2010-06-10T00:00:00' + (interval '24 hours' - interval E'8 hours') AND
          cfg.start_date <= r.date_processed AND r.date_processed <= cfg.end_date AND
          hangid IS NULL
    GROUP BY p.id, os_short_name
    UNION
      SELECT COUNT(r.uuid) as count, 'H', p.id, substring(r.os_name, 1, 3) AS os_short_name,
             timestamp without time zone '2010-06-10'
      FROM product_visibility cfg
      JOIN productdims p on cfg.productdims_id = p.id
      JOIN reports r on p.product = r.product AND p.version = r.version
      WHERE NOT cfg.ignore AND
            timestamp without time zone '2010-06-10T00:00:00' - interval E'8 hours' <= r.date_processed AND
            r.date_processed < timestamp without time zone '2010-06-10T00:00:00' + (interval '24 hours' - interval E'8 hours') AND
            cfg.start_date <= r.date_processed AND r.date_processed <= cfg.end_date AND
            hangid IS NOT NULL
      GROUP BY p.id, os_short_name
2010-06-11 13:46:13,566 INFO - Inserted 109 rows
2010-06-11 13:46:13,575 DEBUG - Finished 2010-06-10 00:00:00
2010-06-11 13:46:13,575 INFO - done.
Status: NEW → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
You need to log in before you can comment on or make changes to this bug.