mbligh | 4263b06 | 2008-02-21 19:14:43 +0000 | [diff] [blame] | 1 | #!/usr/bin/python -u |
mbligh | 05bb633 | 2008-03-13 15:34:04 +0000 | [diff] [blame^] | 2 | import os, re, parse, frontend, db, sys, socket, fcntl |
mbligh | b89c7b3 | 2008-01-25 17:37:23 +0000 | [diff] [blame] | 3 | from optparse import OptionParser |
mbligh | bc98570 | 2007-11-05 20:52:15 +0000 | [diff] [blame] | 4 | from traceback import format_exception |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 5 | |
mbligh | bc98570 | 2007-11-05 20:52:15 +0000 | [diff] [blame] | 6 | def format_error(): |
| 7 | t, o, tb = sys.exc_info() |
| 8 | trace = format_exception(t, o, tb) |
| 9 | # Clear the backtrace to prevent a circular reference |
| 10 | # in the heap -- as per tutorial |
| 11 | tb = '' |
| 12 | |
| 13 | return ''.join(trace) |
| 14 | |
mbligh | b89c7b3 | 2008-01-25 17:37:23 +0000 | [diff] [blame] | 15 | parser = OptionParser() |
| 16 | parser.add_option('-m', help='Send mail for FAILED tests', dest='mailit', |
| 17 | action='store_true') |
| 18 | parser.add_option('-r', help='Reparse the results of a job', dest='reparse', |
| 19 | action='store_true') |
| 20 | parser.add_option('-o', help='one: parse a single results directory', |
| 21 | dest='singledir', action='store_true') |
| 22 | parser.add_option('-l', help='levels of subdirectories to include in job name', |
| 23 | type='int', dest='level', default=1) |
mbligh | 5a0c970 | 2008-03-11 22:40:55 +0000 | [diff] [blame] | 24 | parser.add_option('-s', help='Database server hostname', |
| 25 | dest='db_host', action='store') |
| 26 | parser.add_option('-u', help='Database username', |
| 27 | dest='db_user', action='store') |
| 28 | parser.add_option('-p', help='Database password', |
| 29 | dest='db_pass', action='store') |
| 30 | parser.add_option('-d', help='Database name', |
| 31 | dest='db_name', action='store') |
mbligh | b89c7b3 | 2008-01-25 17:37:23 +0000 | [diff] [blame] | 32 | (options, args) = parser.parse_args() |
mbligh | bc98570 | 2007-11-05 20:52:15 +0000 | [diff] [blame] | 33 | |
mbligh | 5a0c970 | 2008-03-11 22:40:55 +0000 | [diff] [blame] | 34 | if len(args) == 0: |
| 35 | print "ERROR: You need to at least provide a directory to parse\n" |
| 36 | parser.print_help() |
| 37 | sys.exit(1) |
| 38 | |
mbligh | b89c7b3 | 2008-01-25 17:37:23 +0000 | [diff] [blame] | 39 | dir = os.path.abspath(args[0]) |
| 40 | assert os.path.exists(dir) |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 41 | |
mbligh | b89c7b3 | 2008-01-25 17:37:23 +0000 | [diff] [blame] | 42 | if options.singledir: |
mbligh | 2c05bce | 2007-11-26 20:15:58 +0000 | [diff] [blame] | 43 | jobs_list = [dir] |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 44 | else: |
mbligh | b89c7b3 | 2008-01-25 17:37:23 +0000 | [diff] [blame] | 45 | jobs_list = [os.path.join(dir, subdir) for subdir in os.listdir(dir)] |
mbligh | bb7b891 | 2006-10-08 03:59:02 +0000 | [diff] [blame] | 46 | |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 47 | debug = True |
| 48 | |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 49 | failcc = "" |
mbligh | 9e7c6d0 | 2007-11-26 20:59:45 +0000 | [diff] [blame] | 50 | # The user to notify on job failures - TOOD, pull into the config file |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 51 | notify_user = None |
mbligh | 5a0c970 | 2008-03-11 22:40:55 +0000 | [diff] [blame] | 52 | # do commits transactionally |
| 53 | db = db.db(autocommit=False, host=options.db_host, |
| 54 | user=options.db_user, password=options.db_pass, |
| 55 | database=options.db_name) |
mbligh | 056d0d3 | 2006-10-08 22:31:10 +0000 | [diff] [blame] | 56 | |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 57 | |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 58 | def mailfailure(jobname, job, mesgtxt): |
| 59 | # XXX: Need to insert URL here too (frontend.test.url?) |
| 60 | link = "http://" + socket.gethostname() + "/results/" + jobname |
| 61 | |
| 62 | # This looks pretty good on fixed-width-font email reader. |
mbligh | 032c2de | 2007-11-24 19:20:12 +0000 | [diff] [blame] | 63 | message_header = "\n%s\n%s\n\n%-12s %-20s %-12s %-10s %s\n" % \ |
| 64 | ("The following tests FAILED for this job:", |
| 65 | link, "Job name", "Kernel", "Test name", |
| 66 | "FAIL/WARN", "Failure Reason") |
| 67 | message_header += "%-12s %-20s %-12s %-10s %s\n" % \ |
| 68 | ("========", "======", "=========", |
| 69 | "=========", "==============") |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 70 | |
| 71 | subject = "AUTOTEST: FAILED tests from " + " job " + jobname |
mbligh | 9e7c6d0 | 2007-11-26 20:59:45 +0000 | [diff] [blame] | 72 | parse.mail(notify_user, job.user, failcc, subject, |
mbligh | 032c2de | 2007-11-24 19:20:12 +0000 | [diff] [blame] | 73 | message_header + mesgtxt) |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 74 | |
| 75 | |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 76 | def dprint(string): |
| 77 | if debug: |
| 78 | print string |
| 79 | |
| 80 | |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 81 | def do_parse(jobname, path): |
mbligh | 0a498cb | 2007-11-26 17:34:28 +0000 | [diff] [blame] | 82 | """ |
| 83 | Parse a single job. Optionally send email on failure, etc. |
| 84 | """ |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 85 | dprint('\nScanning %s (%s)' % (jobname, path)) |
mbligh | b89c7b3 | 2008-01-25 17:37:23 +0000 | [diff] [blame] | 86 | if options.reparse and db.find_job(jobname): |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 87 | dprint('! Deleting old copy of job results, to reparse it') |
| 88 | db.delete_job(jobname) |
| 89 | if db.find_job(jobname): # Job has already been parsed |
| 90 | dprint('! Already processed') |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 91 | return |
mbligh | 532cb27 | 2007-11-26 18:54:20 +0000 | [diff] [blame] | 92 | job = parse.job(path) |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 93 | if not job: |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 94 | dprint('! Failed to parse job (no status file?)') |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 95 | return |
mbligh | d5c33db | 2006-10-08 21:34:16 +0000 | [diff] [blame] | 96 | if not job.kernel: |
mbligh | e8b37a9 | 2007-12-19 15:54:11 +0000 | [diff] [blame] | 97 | dprint('! Failed to find kernel for job') |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 98 | return |
mbligh | f54ed2a | 2007-11-24 19:31:30 +0000 | [diff] [blame] | 99 | print '+ Parsing ' + path |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 100 | print '* jobname, kernel version: %s %s' % (jobname, job.kernel.base) |
| 101 | mesgtxt = "\n" |
mbligh | e9cf9d4 | 2007-08-31 08:56:00 +0000 | [diff] [blame] | 102 | for test in job.tests: |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 103 | if not test.subdir: |
| 104 | continue |
mbligh | 4a2c61e | 2007-11-12 22:13:11 +0000 | [diff] [blame] | 105 | print "* testname, status, reason: %s %s %s" % \ |
| 106 | (test.subdir, test.status, test.reason) |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 107 | if re.match(r'(FAIL|WARN)',test.status): |
mbligh | 4a2c61e | 2007-11-12 22:13:11 +0000 | [diff] [blame] | 108 | mesgtxt += "%-12s %-20s %-12s %-10s %s" % \ |
| 109 | (jobname, job.kernel.base, test.subdir, |
| 110 | test.status, test.reason) |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 111 | |
mbligh | b89c7b3 | 2008-01-25 17:37:23 +0000 | [diff] [blame] | 112 | if len(mesgtxt) > 2 and options.mailit: |
mbligh | 4a2c61e | 2007-11-12 22:13:11 +0000 | [diff] [blame] | 113 | print "Sending email report of FAILURES on %s to %s" % \ |
| 114 | (jobname, job.user) |
mbligh | 74fc046 | 2007-11-05 20:24:17 +0000 | [diff] [blame] | 115 | mailfailure(jobname, job, mesgtxt) |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 116 | db.insert_job(jobname, job) |
mbligh | bc98570 | 2007-11-05 20:52:15 +0000 | [diff] [blame] | 117 | print "COMMITING" |
mbligh | 432bad4 | 2007-10-09 19:56:07 +0000 | [diff] [blame] | 118 | db.commit() |
mbligh | fd668245 | 2007-09-30 22:02:02 +0000 | [diff] [blame] | 119 | |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 120 | |
mbligh | 05bb633 | 2008-03-13 15:34:04 +0000 | [diff] [blame^] | 121 | def parse_path(path): |
mbligh | b89c7b3 | 2008-01-25 17:37:23 +0000 | [diff] [blame] | 122 | job_elements = path.split('/')[-options.level:] |
| 123 | # last 'level' elements of path |
mbligh | 2c05bce | 2007-11-26 20:15:58 +0000 | [diff] [blame] | 124 | jobname = '/'.join(job_elements) |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 125 | machine_list = os.path.join(path, '.machines') |
| 126 | if os.path.exists(machine_list): |
mbligh | 0a498cb | 2007-11-26 17:34:28 +0000 | [diff] [blame] | 127 | # This is a multi-machine job |
mbligh | 05bb633 | 2008-03-13 15:34:04 +0000 | [diff] [blame^] | 128 | for m in open(machine_list): |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 129 | machine = m.rstrip() |
| 130 | if not machine: |
| 131 | continue |
| 132 | jobpath = os.path.join(path, machine) |
| 133 | jobname = os.path.join(os.path.basename(path), machine) |
mbligh | bc98570 | 2007-11-05 20:52:15 +0000 | [diff] [blame] | 134 | try: |
| 135 | do_parse(jobname, jobpath) |
| 136 | except: |
| 137 | print format_error() |
| 138 | continue |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 139 | else: |
mbligh | 0a498cb | 2007-11-26 17:34:28 +0000 | [diff] [blame] | 140 | # This is a single-machine job |
mbligh | bc98570 | 2007-11-05 20:52:15 +0000 | [diff] [blame] | 141 | try: |
| 142 | do_parse(jobname, path) |
| 143 | except: |
| 144 | print format_error() |
mbligh | 9ec9485 | 2007-10-25 15:24:16 +0000 | [diff] [blame] | 145 | |
| 146 | |
mbligh | 05bb633 | 2008-03-13 15:34:04 +0000 | [diff] [blame^] | 147 | for path in jobs_list: |
| 148 | lockfile = open(os.path.join(path, ".parse.lock"), "w") |
| 149 | fcntl.flock(lockfile, fcntl.LOCK_EX) |
| 150 | try: |
| 151 | parse_path(path) |
| 152 | finally: |
| 153 | fcntl.flock(lockfile, fcntl.LOCK_UN) |
| 154 | lockfile.close() |