mbligh | c6b01ed | 2006-10-13 17:03:26 +0000 | [diff] [blame] | 1 | #!/usr/bin/python |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 2 | import os, re, parse, frontend, db, sys, socket, getopt |
mbligh | bc98570 | 2007-11-05 20:52:15 +0000 | [diff] [blame] | 3 | from traceback import format_exception |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 4 | |
| 5 | usage = """\ |
| 6 | usage: parse |
| 7 | [-m] # Send mail for FAILED tests |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 8 | [-r] # Reparse the results of a job |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 9 | [-o directory] # Specify results directory directly |
| 10 | <top level results directory> # Specify top level results directory |
| 11 | """ |
| 12 | |
mbligh | bc98570 | 2007-11-05 20:52:15 +0000 | [diff] [blame] | 13 | def format_error(): |
| 14 | t, o, tb = sys.exc_info() |
| 15 | trace = format_exception(t, o, tb) |
| 16 | # Clear the backtrace to prevent a circular reference |
| 17 | # in the heap -- as per tutorial |
| 18 | tb = '' |
| 19 | |
| 20 | return ''.join(trace) |
| 21 | |
| 22 | |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 23 | try: |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 24 | opts, args = getopt.getopt(sys.argv[1:], "hrmo:l:", ["help"]) |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 25 | except getopt.GetoptError: |
| 26 | # print help information and exit: |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 27 | print usage, |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 28 | sys.exit(2) |
| 29 | |
| 30 | if len(sys.argv) < 2: |
| 31 | print usage |
| 32 | sys.exit(2) |
| 33 | |
| 34 | singledir = None |
| 35 | mailit = False |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 36 | reparse = False |
mbligh | ebdbfe6 | 2007-11-29 16:38:27 +0000 | [diff] [blame] | 37 | level = 1 |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 38 | for name, value in opts: |
| 39 | if name in ("-h", "--help"): |
| 40 | usage() |
| 41 | sys.exit() |
| 42 | if name == "-m": |
| 43 | mailit = True |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 44 | if name == "-r": |
| 45 | reparse = True |
mbligh | 2c05bce | 2007-11-26 20:15:58 +0000 | [diff] [blame] | 46 | if name in ("-o"): |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 47 | singledir = value |
mbligh | 2c05bce | 2007-11-26 20:15:58 +0000 | [diff] [blame] | 48 | if name in ("-l"): |
| 49 | level = int(value) |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 50 | |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 51 | if singledir: |
| 52 | dir = os.path.abspath(singledir) |
mbligh | 8586dc2 | 2007-11-29 18:41:06 +0000 | [diff] [blame] | 53 | assert os.path.exists(dir) |
mbligh | 2c05bce | 2007-11-26 20:15:58 +0000 | [diff] [blame] | 54 | jobs_list = [dir] |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 55 | else: |
| 56 | topdir = os.path.abspath(args[0]) |
mbligh | 8586dc2 | 2007-11-29 18:41:06 +0000 | [diff] [blame] | 57 | assert os.path.exists(topdir) |
mbligh | 2c05bce | 2007-11-26 20:15:58 +0000 | [diff] [blame] | 58 | jobs_list = [os.path.join(topdir, dir) for dir in os.listdir(topdir)] |
mbligh | bb7b891 | 2006-10-08 03:59:02 +0000 | [diff] [blame] | 59 | |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 60 | debug = True |
| 61 | |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 62 | failcc = "" |
mbligh | 9e7c6d0 | 2007-11-26 20:59:45 +0000 | [diff] [blame] | 63 | # The user to notify on job failures - TOOD, pull into the config file |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 64 | notify_user = None |
mbligh | bb7b891 | 2006-10-08 03:59:02 +0000 | [diff] [blame] | 65 | |
mbligh | 432bad4 | 2007-10-09 19:56:07 +0000 | [diff] [blame] | 66 | db = db.db(autocommit=False) # do commits transactionally |
mbligh | 056d0d3 | 2006-10-08 22:31:10 +0000 | [diff] [blame] | 67 | |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 68 | |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 69 | def mailfailure(jobname, job, mesgtxt): |
| 70 | # XXX: Need to insert URL here too (frontend.test.url?) |
| 71 | link = "http://" + socket.gethostname() + "/results/" + jobname |
| 72 | |
| 73 | # This looks pretty good on fixed-width-font email reader. |
mbligh | 032c2de | 2007-11-24 19:20:12 +0000 | [diff] [blame] | 74 | message_header = "\n%s\n%s\n\n%-12s %-20s %-12s %-10s %s\n" % \ |
| 75 | ("The following tests FAILED for this job:", |
| 76 | link, "Job name", "Kernel", "Test name", |
| 77 | "FAIL/WARN", "Failure Reason") |
| 78 | message_header += "%-12s %-20s %-12s %-10s %s\n" % \ |
| 79 | ("========", "======", "=========", |
| 80 | "=========", "==============") |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 81 | |
| 82 | subject = "AUTOTEST: FAILED tests from " + " job " + jobname |
mbligh | 9e7c6d0 | 2007-11-26 20:59:45 +0000 | [diff] [blame] | 83 | parse.mail(notify_user, job.user, failcc, subject, |
mbligh | 032c2de | 2007-11-24 19:20:12 +0000 | [diff] [blame] | 84 | message_header + mesgtxt) |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 85 | |
| 86 | |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 87 | def dprint(string): |
| 88 | if debug: |
| 89 | print string |
| 90 | |
| 91 | |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 92 | def do_parse(jobname, path): |
mbligh | 0a498cb | 2007-11-26 17:34:28 +0000 | [diff] [blame] | 93 | """ |
| 94 | Parse a single job. Optionally send email on failure, etc. |
| 95 | """ |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 96 | dprint('\nScanning %s (%s)' % (jobname, path)) |
| 97 | if reparse and db.find_job(jobname): |
| 98 | dprint('! Deleting old copy of job results, to reparse it') |
| 99 | db.delete_job(jobname) |
| 100 | if db.find_job(jobname): # Job has already been parsed |
| 101 | dprint('! Already processed') |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 102 | return |
mbligh | 532cb27 | 2007-11-26 18:54:20 +0000 | [diff] [blame] | 103 | job = parse.job(path) |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 104 | if not job: |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 105 | dprint('! Failed to parse job (no status file?)') |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 106 | return |
mbligh | d5c33db | 2006-10-08 21:34:16 +0000 | [diff] [blame] | 107 | if not job.kernel: |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 108 | dprint('! Failed to find kernel for job') |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 109 | return |
mbligh | f54ed2a | 2007-11-24 19:31:30 +0000 | [diff] [blame] | 110 | print '+ Parsing ' + path |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 111 | print '* jobname, kernel version: %s %s' % (jobname, job.kernel.base) |
| 112 | mesgtxt = "\n" |
mbligh | e9cf9d4 | 2007-08-31 08:56:00 +0000 | [diff] [blame] | 113 | for test in job.tests: |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 114 | if not test.subdir: |
| 115 | continue |
mbligh | 4a2c61e | 2007-11-12 22:13:11 +0000 | [diff] [blame] | 116 | print "* testname, status, reason: %s %s %s" % \ |
| 117 | (test.subdir, test.status, test.reason) |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 118 | if re.match(r'(FAIL|WARN)',test.status): |
mbligh | 4a2c61e | 2007-11-12 22:13:11 +0000 | [diff] [blame] | 119 | mesgtxt += "%-12s %-20s %-12s %-10s %s" % \ |
| 120 | (jobname, job.kernel.base, test.subdir, |
| 121 | test.status, test.reason) |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 122 | |
| 123 | if len(mesgtxt) > 2 and mailit: |
mbligh | 4a2c61e | 2007-11-12 22:13:11 +0000 | [diff] [blame] | 124 | print "Sending email report of FAILURES on %s to %s" % \ |
| 125 | (jobname, job.user) |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 126 | mailfailure(jobname, job, mesgtxt) |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 127 | db.insert_job(jobname, job) |
mbligh | bc98570 | 2007-11-05 20:52:15 +0000 | [diff] [blame] | 128 | print "COMMITING" |
mbligh | 432bad4 | 2007-10-09 19:56:07 +0000 | [diff] [blame] | 129 | db.commit() |
mbligh | fd668245 | 2007-09-30 22:02:02 +0000 | [diff] [blame] | 130 | |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 131 | |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 132 | |
mbligh | 2c05bce | 2007-11-26 20:15:58 +0000 | [diff] [blame] | 133 | for path in jobs_list: |
| 134 | job_elements = path.split('/')[-level:] # last 'level' elements of path |
| 135 | jobname = '/'.join(job_elements) |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 136 | machine_list = os.path.join(path, '.machines') |
| 137 | if os.path.exists(machine_list): |
mbligh | 0a498cb | 2007-11-26 17:34:28 +0000 | [diff] [blame] | 138 | # This is a multi-machine job |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 139 | for m in open(machine_list, 'r').readlines(): |
| 140 | machine = m.rstrip() |
| 141 | if not machine: |
| 142 | continue |
| 143 | jobpath = os.path.join(path, machine) |
| 144 | jobname = os.path.join(os.path.basename(path), machine) |
mbligh | bc98570 | 2007-11-05 20:52:15 +0000 | [diff] [blame] | 145 | try: |
| 146 | do_parse(jobname, jobpath) |
| 147 | except: |
| 148 | print format_error() |
| 149 | continue |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 150 | else: |
mbligh | 0a498cb | 2007-11-26 17:34:28 +0000 | [diff] [blame] | 151 | # This is a single-machine job |
mbligh | bc98570 | 2007-11-05 20:52:15 +0000 | [diff] [blame] | 152 | try: |
| 153 | do_parse(jobname, path) |
| 154 | except: |
| 155 | print format_error() |
| 156 | continue |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 157 | |
| 158 | |
mbligh | 0a498cb | 2007-11-26 17:34:28 +0000 | [diff] [blame] | 159 | # Generate vertical text pngs for pretty display in tables. |
| 160 | # |
mbligh | bc98570 | 2007-11-05 20:52:15 +0000 | [diff] [blame] | 161 | # rows = db.select('distinct hostname', 'machines', {}) |
| 162 | # machines = [row[0] for row in rows] |
| 163 | # |
| 164 | # for machine in machines: |
| 165 | # dir = os.path.dirname(os.path.abspath(sys.argv[0])) |
| 166 | # vertical_text = os.path.join(dir, 'vertical_text.py') |
| 167 | # os.system(vertical_text + ' ' + machine) |