author | wenzelm |
Tue, 24 Oct 2017 21:20:55 +0200 | |
changeset 66913 | 7cdd4d59e95c |
parent 66880 | 486f4af28db9 |
child 66944 | 05df740cb54b |
permissions | -rw-r--r-- |
64160 | 1 |
/* Title: Pure/Admin/build_log.scala |
64045 | 2 |
Author: Makarius |
3 |
||
65608 | 4 |
Management of build log files and database storage. |
64045 | 5 |
*/ |
6 |
||
7 |
package isabelle |
|
8 |
||
9 |
||
64100 | 10 |
import java.io.{File => JFile} |
11 |
import java.time.ZoneId |
|
64110 | 12 |
import java.time.format.{DateTimeFormatter, DateTimeParseException} |
64096 | 13 |
import java.util.Locale |
64061
1bbea2b55d22
some support for header and data fields, notably from afp-test;
wenzelm
parents:
64054
diff
changeset
|
14 |
|
65600 | 15 |
import scala.collection.immutable.SortedMap |
64054 | 16 |
import scala.collection.mutable |
17 |
import scala.util.matching.Regex |
|
18 |
||
19 |
||
64045 | 20 |
object Build_Log |
21 |
{ |
|
64298 | 22 |
/** content **/ |
64101 | 23 |
|
64298 | 24 |
/* properties */ |
64150 | 25 |
|
64298 | 26 |
object Prop |
27 |
{ |
|
65624 | 28 |
val build_tags = SQL.Column.string("build_tags") // lines |
29 |
val build_args = SQL.Column.string("build_args") // lines |
|
65591 | 30 |
val build_group_id = SQL.Column.string("build_group_id") |
31 |
val build_id = SQL.Column.string("build_id") |
|
32 |
val build_engine = SQL.Column.string("build_engine") |
|
33 |
val build_host = SQL.Column.string("build_host") |
|
34 |
val build_start = SQL.Column.date("build_start") |
|
35 |
val build_end = SQL.Column.date("build_end") |
|
36 |
val isabelle_version = SQL.Column.string("isabelle_version") |
|
37 |
val afp_version = SQL.Column.string("afp_version") |
|
38 |
||
65611 | 39 |
val all_props: List[SQL.Column] = |
65591 | 40 |
List(build_tags, build_args, build_group_id, build_id, build_engine, |
41 |
build_host, build_start, build_end, isabelle_version, afp_version) |
|
64298 | 42 |
} |
64150 | 43 |
|
44 |
||
64298 | 45 |
/* settings */ |
64080 | 46 |
|
64081 | 47 |
object Settings |
48 |
{ |
|
65611 | 49 |
val ISABELLE_BUILD_OPTIONS = SQL.Column.string("ISABELLE_BUILD_OPTIONS") |
50 |
val ML_PLATFORM = SQL.Column.string("ML_PLATFORM") |
|
51 |
val ML_HOME = SQL.Column.string("ML_HOME") |
|
52 |
val ML_SYSTEM = SQL.Column.string("ML_SYSTEM") |
|
53 |
val ML_OPTIONS = SQL.Column.string("ML_OPTIONS") |
|
54 |
||
55 |
val ml_settings = List(ML_PLATFORM, ML_HOME, ML_SYSTEM, ML_OPTIONS) |
|
56 |
val all_settings = ISABELLE_BUILD_OPTIONS :: ml_settings |
|
64081 | 57 |
|
58 |
type Entry = (String, String) |
|
59 |
type T = List[Entry] |
|
64080 | 60 |
|
64081 | 61 |
object Entry |
62 |
{ |
|
63 |
def unapply(s: String): Option[Entry] = |
|
64 |
s.indexOf('=') match { |
|
65 |
case -1 => None |
|
66 |
case i => |
|
67 |
val a = s.substring(0, i) |
|
68 |
val b = Library.perhaps_unquote(s.substring(i + 1)) |
|
69 |
Some((a, b)) |
|
70 |
} |
|
71 |
def apply(a: String, b: String): String = a + "=" + quote(b) |
|
72 |
def getenv(a: String): String = apply(a, Isabelle_System.getenv(a)) |
|
73 |
} |
|
64080 | 74 |
|
64081 | 75 |
def show(): String = |
76 |
cat_lines( |
|
65611 | 77 |
List(Entry.getenv(ISABELLE_BUILD_OPTIONS.name), "") ::: |
78 |
ml_settings.map(c => Entry.getenv(c.name))) |
|
64080 | 79 |
} |
80 |
||
81 |
||
64298 | 82 |
/* file names */ |
83 |
||
84 |
def log_date(date: Date): String = |
|
85 |
String.format(Locale.ROOT, "%s.%05d", |
|
86 |
DateTimeFormatter.ofPattern("yyyy-MM-dd").format(date.rep), |
|
87 |
new java.lang.Long((date.time - date.midnight.time).ms / 1000)) |
|
88 |
||
89 |
def log_subdir(date: Date): Path = |
|
90 |
Path.explode("log") + Path.explode(date.rep.getYear.toString) |
|
91 |
||
92 |
def log_filename(engine: String, date: Date, more: List[String] = Nil): Path = |
|
93 |
Path.explode((engine :: log_date(date) :: more).mkString("", "_", ".log")) |
|
94 |
||
95 |
||
64100 | 96 |
|
64062 | 97 |
/** log file **/ |
64045 | 98 |
|
64155 | 99 |
def print_date(date: Date): String = Log_File.Date_Format(date) |
100 |
||
64062 | 101 |
object Log_File |
102 |
{ |
|
65607 | 103 |
/* log file */ |
104 |
||
65609 | 105 |
def plain_name(name: String): String = |
106 |
{ |
|
107 |
List(".log", ".log.gz", ".log.xz", ".gz", ".xz").find(name.endsWith(_)) match { |
|
108 |
case Some(s) => Library.try_unsuffix(s, name).get |
|
109 |
case None => name |
|
110 |
} |
|
111 |
} |
|
112 |
||
64062 | 113 |
def apply(name: String, lines: List[String]): Log_File = |
65609 | 114 |
new Log_File(plain_name(name), lines) |
64062 | 115 |
|
116 |
def apply(name: String, text: String): Log_File = |
|
64063 | 117 |
Log_File(name, Library.trim_split_lines(text)) |
64090 | 118 |
|
119 |
def apply(file: JFile): Log_File = |
|
120 |
{ |
|
121 |
val name = file.getName |
|
65609 | 122 |
val text = |
123 |
if (name.endsWith(".gz")) File.read_gzip(file) |
|
124 |
else if (name.endsWith(".xz")) File.read_xz(file) |
|
125 |
else File.read(file) |
|
126 |
apply(name, text) |
|
64090 | 127 |
} |
128 |
||
129 |
def apply(path: Path): Log_File = apply(path.file) |
|
64101 | 130 |
|
64110 | 131 |
|
65607 | 132 |
/* log file collections */ |
133 |
||
134 |
def is_log(file: JFile, |
|
135 |
prefixes: List[String] = |
|
65664 | 136 |
List(Build_History.log_prefix, Identify.log_prefix, Isatest.log_prefix, |
137 |
AFP_Test.log_prefix, Jenkins.log_prefix), |
|
65609 | 138 |
suffixes: List[String] = List(".log", ".log.gz", ".log.xz")): Boolean = |
65607 | 139 |
{ |
140 |
val name = file.getName |
|
65639 | 141 |
|
65607 | 142 |
prefixes.exists(name.startsWith(_)) && |
65639 | 143 |
suffixes.exists(name.endsWith(_)) && |
144 |
name != "isatest.log" && |
|
145 |
name != "afp-test.log" && |
|
146 |
name != "main.log" |
|
65607 | 147 |
} |
148 |
||
149 |
def find_files(dirs: Iterable[Path]): List[JFile] = |
|
150 |
dirs.iterator.flatMap(dir => File.find_files(dir.file, is_log(_))).toList |
|
151 |
||
152 |
||
64110 | 153 |
/* date format */ |
154 |
||
64101 | 155 |
val Date_Format = |
156 |
{ |
|
157 |
val fmts = |
|
158 |
Date.Formatter.variants( |
|
64116 | 159 |
List("EEE MMM d HH:mm:ss O yyyy", "EEE MMM d HH:mm:ss VV yyyy"), |
64104
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
160 |
List(Locale.ENGLISH, Locale.GERMAN)) ::: |
64110 | 161 |
List( |
162 |
DateTimeFormatter.RFC_1123_DATE_TIME, |
|
163 |
Date.Formatter.pattern("EEE MMM d HH:mm:ss yyyy").withZone(ZoneId.of("Europe/Berlin"))) |
|
64101 | 164 |
|
64104
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
165 |
def tune_timezone(s: String): String = |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
166 |
s match { |
64101 | 167 |
case "CET" | "MET" => "GMT+1" |
168 |
case "CEST" | "MEST" => "GMT+2" |
|
64104
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
169 |
case "EST" => "Europe/Berlin" |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
170 |
case _ => s |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
171 |
} |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
172 |
def tune_weekday(s: String): String = |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
173 |
s match { |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
174 |
case "Die" => "Di" |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
175 |
case "Mit" => "Mi" |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
176 |
case "Don" => "Do" |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
177 |
case "Fre" => "Fr" |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
178 |
case "Sam" => "Sa" |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
179 |
case "Son" => "So" |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
180 |
case _ => s |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
181 |
} |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
182 |
|
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
183 |
def tune(s: String): String = |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
184 |
Word.implode( |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
185 |
Word.explode(s) match { |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
186 |
case a :: "M\uFFFDr" :: bs => tune_weekday(a) :: "Mär" :: bs.map(tune_timezone(_)) |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
187 |
case a :: bs => tune_weekday(a) :: bs.map(tune_timezone(_)) |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
188 |
case Nil => Nil |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
189 |
} |
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
190 |
) |
64101 | 191 |
|
192 |
Date.Format.make(fmts, tune) |
|
193 |
} |
|
64117 | 194 |
|
195 |
||
196 |
/* inlined content */ |
|
197 |
||
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
198 |
def print_props(marker: String, props: Properties.T): String = |
65624 | 199 |
marker + YXML.string_of_body(XML.Encode.properties(Properties.encode_lines(props))) |
64102 | 200 |
} |
201 |
||
202 |
class Log_File private(val name: String, val lines: List[String]) |
|
203 |
{ |
|
204 |
log_file => |
|
205 |
||
206 |
override def toString: String = name |
|
207 |
||
208 |
def text: String = cat_lines(lines) |
|
209 |
||
210 |
def err(msg: String): Nothing = |
|
211 |
error("Error in log file " + quote(name) + ": " + msg) |
|
212 |
||
213 |
||
214 |
/* date format */ |
|
64101 | 215 |
|
216 |
object Strict_Date |
|
217 |
{ |
|
218 |
def unapply(s: String): Some[Date] = |
|
64102 | 219 |
try { Some(Log_File.Date_Format.parse(s)) } |
64101 | 220 |
catch { case exn: DateTimeParseException => log_file.err(exn.getMessage) } |
221 |
} |
|
222 |
||
223 |
||
64062 | 224 |
/* inlined content */ |
225 |
||
226 |
def find[A](f: String => Option[A]): Option[A] = |
|
227 |
lines.iterator.map(f).find(_.isDefined).map(_.get) |
|
228 |
||
64196
6688b9cd443b
more robust wrt. old versions that use clear-text properties (e.g. Timing in build_history_base);
wenzelm
parents:
64193
diff
changeset
|
229 |
def find_line(marker: String): Option[String] = |
6688b9cd443b
more robust wrt. old versions that use clear-text properties (e.g. Timing in build_history_base);
wenzelm
parents:
64193
diff
changeset
|
230 |
find(Library.try_unprefix(marker, _)) |
6688b9cd443b
more robust wrt. old versions that use clear-text properties (e.g. Timing in build_history_base);
wenzelm
parents:
64193
diff
changeset
|
231 |
|
65684 | 232 |
def find_match(regexes: List[Regex]): Option[String] = |
233 |
regexes match { |
|
234 |
case Nil => None |
|
235 |
case regex :: rest => |
|
236 |
lines.iterator.map(regex.unapplySeq(_)).find(res => res.isDefined && res.get.length == 1). |
|
237 |
map(res => res.get.head) orElse find_match(rest) |
|
238 |
} |
|
64062 | 239 |
|
240 |
||
241 |
/* settings */ |
|
242 |
||
64091 | 243 |
def get_setting(a: String): Option[Settings.Entry] = |
244 |
lines.find(_.startsWith(a + "=")) match { |
|
245 |
case Some(line) => Settings.Entry.unapply(line) |
|
246 |
case None => None |
|
247 |
} |
|
64045 | 248 |
|
65611 | 249 |
def get_all_settings: Settings.T = |
250 |
for { c <- Settings.all_settings; entry <- get_setting(c.name) } |
|
251 |
yield entry |
|
64062 | 252 |
|
253 |
||
254 |
/* properties (YXML) */ |
|
255 |
||
256 |
val xml_cache = new XML.Cache() |
|
257 |
||
258 |
def parse_props(text: String): Properties.T = |
|
66046 | 259 |
try { |
260 |
xml_cache.props(Properties.decode_lines(XML.Decode.properties(YXML.parse_body(text)))) |
|
261 |
} |
|
262 |
catch { case _: XML.Error => log_file.err("malformed properties") } |
|
64062 | 263 |
|
65934 | 264 |
def filter_lines(marker: String): List[String] = |
265 |
for (line <- lines; s <- Library.try_unprefix(marker, line)) yield s |
|
266 |
||
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
267 |
def filter_props(marker: String): List[Properties.T] = |
65934 | 268 |
for (s <- filter_lines(marker) if YXML.detect(s)) yield parse_props(s) |
64062 | 269 |
|
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
270 |
def find_props(marker: String): Option[Properties.T] = |
64196
6688b9cd443b
more robust wrt. old versions that use clear-text properties (e.g. Timing in build_history_base);
wenzelm
parents:
64193
diff
changeset
|
271 |
find_line(marker) match { |
6688b9cd443b
more robust wrt. old versions that use clear-text properties (e.g. Timing in build_history_base);
wenzelm
parents:
64193
diff
changeset
|
272 |
case Some(text) if YXML.detect(text) => Some(parse_props(text)) |
6688b9cd443b
more robust wrt. old versions that use clear-text properties (e.g. Timing in build_history_base);
wenzelm
parents:
64193
diff
changeset
|
273 |
case _ => None |
6688b9cd443b
more robust wrt. old versions that use clear-text properties (e.g. Timing in build_history_base);
wenzelm
parents:
64193
diff
changeset
|
274 |
} |
64062 | 275 |
|
276 |
||
277 |
/* parse various formats */ |
|
278 |
||
64105 | 279 |
def parse_meta_info(): Meta_Info = Build_Log.parse_meta_info(log_file) |
280 |
||
65646 | 281 |
def parse_build_info(ml_statistics: Boolean = false): Build_Info = |
282 |
Build_Log.parse_build_info(log_file, ml_statistics) |
|
64105 | 283 |
|
64082 | 284 |
def parse_session_info( |
285 |
command_timings: Boolean = false, |
|
66873
9953ae603a23
provide theory timing information, similar to command timing but always considered relevant;
wenzelm
parents:
66863
diff
changeset
|
286 |
theory_timings: Boolean = false, |
64082 | 287 |
ml_statistics: Boolean = false, |
288 |
task_statistics: Boolean = false): Session_Info = |
|
66873
9953ae603a23
provide theory timing information, similar to command timing but always considered relevant;
wenzelm
parents:
66863
diff
changeset
|
289 |
Build_Log.parse_session_info( |
9953ae603a23
provide theory timing information, similar to command timing but always considered relevant;
wenzelm
parents:
66863
diff
changeset
|
290 |
log_file, command_timings, theory_timings, ml_statistics, task_statistics) |
64045 | 291 |
} |
292 |
||
293 |
||
64098 | 294 |
|
65276 | 295 |
/** digested meta info: produced by Admin/build_history in log.xz file **/ |
64045 | 296 |
|
64108 | 297 |
object Meta_Info |
64099 | 298 |
{ |
64108 | 299 |
val empty: Meta_Info = Meta_Info(Nil, Nil) |
64099 | 300 |
} |
64098 | 301 |
|
65611 | 302 |
sealed case class Meta_Info(props: Properties.T, settings: Settings.T) |
64103 | 303 |
{ |
304 |
def is_empty: Boolean = props.isEmpty && settings.isEmpty |
|
65599 | 305 |
|
65611 | 306 |
def get(c: SQL.Column): Option[String] = |
307 |
Properties.get(props, c.name) orElse |
|
308 |
Properties.get(settings, c.name) |
|
309 |
||
310 |
def get_date(c: SQL.Column): Option[Date] = |
|
311 |
get(c).map(Log_File.Date_Format.parse(_)) |
|
64103 | 312 |
} |
64061
1bbea2b55d22
some support for header and data fields, notably from afp-test;
wenzelm
parents:
64054
diff
changeset
|
313 |
|
65625 | 314 |
object Identify |
315 |
{ |
|
316 |
val log_prefix = "isabelle_identify_" |
|
65674
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
317 |
|
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
318 |
def engine(log_file: Log_File): String = |
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
319 |
if (log_file.name.startsWith(Jenkins.log_prefix)) "jenkins_identify" |
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
320 |
else "identify" |
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
321 |
|
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
322 |
def content(date: Date, isabelle_version: Option[String], afp_version: Option[String]): String = |
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
323 |
terminate_lines( |
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
324 |
List("isabelle_identify: " + Build_Log.print_date(date), "") ::: |
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
325 |
isabelle_version.map("Isabelle version: " + _).toList ::: |
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
326 |
afp_version.map("AFP version: " + _).toList) |
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
327 |
|
65625 | 328 |
val Start = new Regex("""^isabelle_identify: (.+)$""") |
329 |
val No_End = new Regex("""$.""") |
|
65684 | 330 |
val Isabelle_Version = List(new Regex("""^Isabelle version: (\S+)$""")) |
331 |
val AFP_Version = List(new Regex("""^AFP version: (\S+)$""")) |
|
65625 | 332 |
} |
333 |
||
64095 | 334 |
object Isatest |
335 |
{ |
|
65588 | 336 |
val log_prefix = "isatest-makeall-" |
64108 | 337 |
val engine = "isatest" |
64109 | 338 |
val Start = new Regex("""^------------------- starting test --- (.+) --- (.+)$""") |
339 |
val End = new Regex("""^------------------- test (?:successful|FAILED) --- (.+) --- .*$""") |
|
65684 | 340 |
val Isabelle_Version = List(new Regex("""^Isabelle version: (\S+)$""")) |
64095 | 341 |
} |
342 |
||
64109 | 343 |
object AFP_Test |
64061
1bbea2b55d22
some support for header and data fields, notably from afp-test;
wenzelm
parents:
64054
diff
changeset
|
344 |
{ |
65588 | 345 |
val log_prefix = "afp-test-devel-" |
64108 | 346 |
val engine = "afp-test" |
64109 | 347 |
val Start = new Regex("""^Start test(?: for .+)? at ([^,]+), (.*)$""") |
348 |
val Start_Old = new Regex("""^Start test(?: for .+)? at ([^,]+)$""") |
|
349 |
val End = new Regex("""^End test on (.+), .+, elapsed time:.*$""") |
|
65684 | 350 |
val Isabelle_Version = List(new Regex("""^Isabelle version: .* -- hg id (\S+)$""")) |
351 |
val AFP_Version = List(new Regex("""^AFP version: .* -- hg id (\S+)$""")) |
|
64104
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
352 |
val Bad_Init = new Regex("""^cp:.*: Disc quota exceeded$""") |
64061
1bbea2b55d22
some support for header and data fields, notably from afp-test;
wenzelm
parents:
64054
diff
changeset
|
353 |
} |
1bbea2b55d22
some support for header and data fields, notably from afp-test;
wenzelm
parents:
64054
diff
changeset
|
354 |
|
64110 | 355 |
object Jenkins |
356 |
{ |
|
65664 | 357 |
val log_prefix = "jenkins_" |
64110 | 358 |
val engine = "jenkins" |
65663 | 359 |
val Host = new Regex("""^Building remotely on (\S+) \((\S+)\).*$""") |
65665 | 360 |
val Start = new Regex("""^(?:Started by an SCM change|Started from command line by admin|).*$""") |
64110 | 361 |
val Start_Date = new Regex("""^Build started at (.+)$""") |
362 |
val No_End = new Regex("""$.""") |
|
65674
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
363 |
val Isabelle_Version = |
65684 | 364 |
List(new Regex("""^(?:Build for Isabelle id|Isabelle id) (\w+).*$"""), |
65685 | 365 |
new Regex("""^ISABELLE_CI_REPO_ID="(\w+)".*$"""), |
366 |
new Regex("""^(\w{12}) tip.*$""")) |
|
65674
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
367 |
val AFP_Version = |
65684 | 368 |
List(new Regex("""^(?:Build for AFP id|AFP id) (\w+).*$"""), |
369 |
new Regex("""^ISABELLE_CI_AFP_ID="(\w+)".*$""")) |
|
64110 | 370 |
val CONFIGURATION = "=== CONFIGURATION ===" |
371 |
val BUILD = "=== BUILD ===" |
|
372 |
} |
|
373 |
||
64105 | 374 |
private def parse_meta_info(log_file: Log_File): Meta_Info = |
64061
1bbea2b55d22
some support for header and data fields, notably from afp-test;
wenzelm
parents:
64054
diff
changeset
|
375 |
{ |
64108 | 376 |
def parse(engine: String, host: String, start: Date, |
65684 | 377 |
End: Regex, Isabelle_Version: List[Regex], AFP_Version: List[Regex]): Meta_Info = |
64091 | 378 |
{ |
64296
544481988e65
explicit identification of builds and correlated build groups;
wenzelm
parents:
64196
diff
changeset
|
379 |
val build_id = |
544481988e65
explicit identification of builds and correlated build groups;
wenzelm
parents:
64196
diff
changeset
|
380 |
{ |
65714 | 381 |
val prefix = proper_string(host) orElse proper_string(engine) getOrElse "build" |
382 |
prefix + ":" + start.time.ms |
|
64296
544481988e65
explicit identification of builds and correlated build groups;
wenzelm
parents:
64196
diff
changeset
|
383 |
} |
65591 | 384 |
val build_engine = if (engine == "") Nil else List(Prop.build_engine.name -> engine) |
385 |
val build_host = if (host == "") Nil else List(Prop.build_host.name -> host) |
|
64108 | 386 |
|
65599 | 387 |
val start_date = List(Prop.build_start.name -> print_date(start)) |
64091 | 388 |
val end_date = |
389 |
log_file.lines.last match { |
|
64109 | 390 |
case End(log_file.Strict_Date(end_date)) => |
65599 | 391 |
List(Prop.build_end.name -> print_date(end_date)) |
64091 | 392 |
case _ => Nil |
393 |
} |
|
394 |
||
395 |
val isabelle_version = |
|
65591 | 396 |
log_file.find_match(Isabelle_Version).map(Prop.isabelle_version.name -> _) |
64091 | 397 |
val afp_version = |
65591 | 398 |
log_file.find_match(AFP_Version).map(Prop.afp_version.name -> _) |
64062 | 399 |
|
65591 | 400 |
Meta_Info((Prop.build_id.name -> build_id) :: build_engine ::: build_host ::: |
64108 | 401 |
start_date ::: end_date ::: isabelle_version.toList ::: afp_version.toList, |
65611 | 402 |
log_file.get_all_settings) |
64091 | 403 |
} |
404 |
||
405 |
log_file.lines match { |
|
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
406 |
case line :: _ if line.startsWith(Build_History.META_INFO_MARKER) => |
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
407 |
Meta_Info(log_file.find_props(Build_History.META_INFO_MARKER).get, |
65611 | 408 |
log_file.get_all_settings) |
64117 | 409 |
|
65625 | 410 |
case Identify.Start(log_file.Strict_Date(start)) :: _ => |
65674
23897f5d885d
approximate repository identify job based on isabelle-nightly-slow;
wenzelm
parents:
65670
diff
changeset
|
411 |
parse(Identify.engine(log_file), "", start, Identify.No_End, |
65625 | 412 |
Identify.Isabelle_Version, Identify.AFP_Version) |
413 |
||
64109 | 414 |
case Isatest.Start(log_file.Strict_Date(start), host) :: _ => |
415 |
parse(Isatest.engine, host, start, Isatest.End, |
|
65684 | 416 |
Isatest.Isabelle_Version, Nil) |
64099 | 417 |
|
64109 | 418 |
case AFP_Test.Start(log_file.Strict_Date(start), host) :: _ => |
419 |
parse(AFP_Test.engine, host, start, AFP_Test.End, |
|
420 |
AFP_Test.Isabelle_Version, AFP_Test.AFP_Version) |
|
64099 | 421 |
|
64109 | 422 |
case AFP_Test.Start_Old(log_file.Strict_Date(start)) :: _ => |
423 |
parse(AFP_Test.engine, "", start, AFP_Test.End, |
|
424 |
AFP_Test.Isabelle_Version, AFP_Test.AFP_Version) |
|
64099 | 425 |
|
65665 | 426 |
case Jenkins.Start() :: _ => |
64110 | 427 |
log_file.lines.dropWhile(_ != Jenkins.BUILD) match { |
428 |
case Jenkins.BUILD :: _ :: Jenkins.Start_Date(log_file.Strict_Date(start)) :: _ => |
|
65663 | 429 |
val host = |
430 |
log_file.lines.takeWhile(_ != Jenkins.CONFIGURATION).collectFirst({ |
|
431 |
case Jenkins.Host(a, b) => a + "." + b |
|
432 |
}).getOrElse("") |
|
433 |
parse(Jenkins.engine, host, start.to(ZoneId.of("Europe/Berlin")), Jenkins.No_End, |
|
64110 | 434 |
Jenkins.Isabelle_Version, Jenkins.AFP_Version) |
435 |
case _ => Meta_Info.empty |
|
436 |
} |
|
437 |
||
64341 | 438 |
case line :: _ if line.startsWith("\u0000") => Meta_Info.empty |
64109 | 439 |
case List(Isatest.End(_)) => Meta_Info.empty |
440 |
case _ :: AFP_Test.Bad_Init() :: _ => Meta_Info.empty |
|
64105 | 441 |
case Nil => Meta_Info.empty |
64104
b70fa05d6746
more permissive: accept all historic isatest and afp-test logs;
wenzelm
parents:
64103
diff
changeset
|
442 |
|
64110 | 443 |
case _ => log_file.err("cannot detect log file format") |
64061
1bbea2b55d22
some support for header and data fields, notably from afp-test;
wenzelm
parents:
64054
diff
changeset
|
444 |
} |
1bbea2b55d22
some support for header and data fields, notably from afp-test;
wenzelm
parents:
64054
diff
changeset
|
445 |
} |
1bbea2b55d22
some support for header and data fields, notably from afp-test;
wenzelm
parents:
64054
diff
changeset
|
446 |
|
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
447 |
|
64098 | 448 |
|
65276 | 449 |
/** build info: toplevel output of isabelle build or Admin/build_history **/ |
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
450 |
|
66873
9953ae603a23
provide theory timing information, similar to command timing but always considered relevant;
wenzelm
parents:
66863
diff
changeset
|
451 |
val THEORY_TIMING_MARKER = "\ftheory_timing = " |
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
452 |
val ML_STATISTICS_MARKER = "\fML_statistics = " |
65937 | 453 |
val ERROR_MESSAGE_MARKER = "\ferror_message = " |
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
454 |
val SESSION_NAME = "session_name" |
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
455 |
|
64061
1bbea2b55d22
some support for header and data fields, notably from afp-test;
wenzelm
parents:
64054
diff
changeset
|
456 |
object Session_Status extends Enumeration |
1bbea2b55d22
some support for header and data fields, notably from afp-test;
wenzelm
parents:
64054
diff
changeset
|
457 |
{ |
65633 | 458 |
val existing, finished, failed, cancelled = Value |
64061
1bbea2b55d22
some support for header and data fields, notably from afp-test;
wenzelm
parents:
64054
diff
changeset
|
459 |
} |
1bbea2b55d22
some support for header and data fields, notably from afp-test;
wenzelm
parents:
64054
diff
changeset
|
460 |
|
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
461 |
sealed case class Session_Entry( |
65643 | 462 |
chapter: String = "", |
463 |
groups: List[String] = Nil, |
|
464 |
threads: Option[Int] = None, |
|
465 |
timing: Timing = Timing.zero, |
|
466 |
ml_timing: Timing = Timing.zero, |
|
66913 | 467 |
sources: Option[String] = None, |
65643 | 468 |
heap_size: Option[Long] = None, |
469 |
status: Option[Session_Status.Value] = None, |
|
65937 | 470 |
errors: List[String] = Nil, |
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
471 |
theory_timings: Map[String, Timing] = Map.empty, |
65643 | 472 |
ml_statistics: List[Properties.T] = Nil) |
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
473 |
{ |
65631 | 474 |
def proper_groups: Option[String] = if (groups.isEmpty) None else Some(cat_lines(groups)) |
65643 | 475 |
def finished: Boolean = status == Some(Session_Status.finished) |
65937 | 476 |
def failed: Boolean = status == Some(Session_Status.failed) |
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
477 |
} |
64054 | 478 |
|
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
479 |
object Build_Info |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
480 |
{ |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
481 |
val sessions_dummy: Map[String, Session_Entry] = |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
482 |
Map("" -> Session_Entry(theory_timings = Map("" -> Timing.zero))) |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
483 |
} |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
484 |
|
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
485 |
sealed case class Build_Info(sessions: Map[String, Session_Entry]) |
64054 | 486 |
{ |
65937 | 487 |
def finished_sessions: List[String] = for ((a, b) <- sessions.toList if b.finished) yield a |
488 |
def failed_sessions: List[String] = for ((a, b) <- sessions.toList if b.failed) yield a |
|
64054 | 489 |
} |
490 |
||
65646 | 491 |
private def parse_build_info(log_file: Log_File, parse_ml_statistics: Boolean): Build_Info = |
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
492 |
{ |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
493 |
object Chapter_Name |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
494 |
{ |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
495 |
def unapply(s: String): Some[(String, String)] = |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
496 |
space_explode('/', s) match { |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
497 |
case List(chapter, name) => Some((chapter, name)) |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
498 |
case _ => Some(("", s)) |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
499 |
} |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
500 |
} |
64054 | 501 |
|
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
502 |
val Session_No_Groups = new Regex("""^Session (\S+)$""") |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
503 |
val Session_Groups = new Regex("""^Session (\S+) \((.*)\)$""") |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
504 |
val Session_Finished1 = |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
505 |
new Regex("""^Finished (\S+) \((\d+):(\d+):(\d+) elapsed time, (\d+):(\d+):(\d+) cpu time.*$""") |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
506 |
val Session_Finished2 = |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
507 |
new Regex("""^Finished (\S+) \((\d+):(\d+):(\d+) elapsed time.*$""") |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
508 |
val Session_Timing = |
65679 | 509 |
new Regex("""^Timing (\S+) \((\d+) threads, (\d+\.\d+)s elapsed time, (\d+\.\d+)s cpu time, (\d+\.\d+)s GC time.*$""") |
64086
ac7ae5067783
clarified status: started sessions may bomb without explicit FAILED or CANCELLED (cf. in afp-test-devel-2016-01-03.log);
wenzelm
parents:
64085
diff
changeset
|
510 |
val Session_Started = new Regex("""^(?:Running|Building) (\S+) \.\.\.$""") |
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
511 |
val Session_Failed = new Regex("""^(\S+) FAILED""") |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
512 |
val Session_Cancelled = new Regex("""^(\S+) CANCELLED""") |
66913 | 513 |
val Sources = new Regex("""^Sources (\S+) (\S{""" + SHA1.digest_length + """})$""") |
64120 | 514 |
val Heap = new Regex("""^Heap (\S+) \((\d+) bytes\)$""") |
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
515 |
|
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
516 |
object Theory_Timing |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
517 |
{ |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
518 |
def unapply(line: String): Option[(String, (String, Timing))] = |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
519 |
Library.try_unprefix(THEORY_TIMING_MARKER, line).map(log_file.parse_props(_)) match { |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
520 |
case Some((SESSION_NAME, name) :: props) => |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
521 |
(props, props) match { |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
522 |
case (Markup.Name(thy), Markup.Timing_Properties(t)) => Some((name, thy -> t)) |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
523 |
case _ => None |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
524 |
} |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
525 |
case _ => None |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
526 |
} |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
527 |
} |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
528 |
|
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
529 |
var chapter = Map.empty[String, String] |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
530 |
var groups = Map.empty[String, List[String]] |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
531 |
var threads = Map.empty[String, Int] |
64054 | 532 |
var timing = Map.empty[String, Timing] |
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
533 |
var ml_timing = Map.empty[String, Timing] |
64086
ac7ae5067783
clarified status: started sessions may bomb without explicit FAILED or CANCELLED (cf. in afp-test-devel-2016-01-03.log);
wenzelm
parents:
64085
diff
changeset
|
534 |
var started = Set.empty[String] |
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
535 |
var failed = Set.empty[String] |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
536 |
var cancelled = Set.empty[String] |
66913 | 537 |
var sources = Map.empty[String, String] |
65627 | 538 |
var heap_sizes = Map.empty[String, Long] |
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
539 |
var theory_timings = Map.empty[String, Map[String, Timing]] |
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
540 |
var ml_statistics = Map.empty[String, List[Properties.T]] |
65937 | 541 |
var errors = Map.empty[String, List[String]] |
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
542 |
|
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
543 |
def all_sessions: Set[String] = |
64120 | 544 |
chapter.keySet ++ groups.keySet ++ threads.keySet ++ timing.keySet ++ ml_timing.keySet ++ |
66913 | 545 |
failed ++ cancelled ++ started ++ sources.keySet ++ heap_sizes.keySet ++ |
546 |
theory_timings.keySet ++ ml_statistics.keySet |
|
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
547 |
|
64054 | 548 |
|
64062 | 549 |
for (line <- log_file.lines) { |
64054 | 550 |
line match { |
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
551 |
case Session_No_Groups(Chapter_Name(chapt, name)) => |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
552 |
chapter += (name -> chapt) |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
553 |
groups += (name -> Nil) |
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
554 |
|
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
555 |
case Session_Groups(Chapter_Name(chapt, name), grps) => |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
556 |
chapter += (name -> chapt) |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
557 |
groups += (name -> Word.explode(grps)) |
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
558 |
|
64086
ac7ae5067783
clarified status: started sessions may bomb without explicit FAILED or CANCELLED (cf. in afp-test-devel-2016-01-03.log);
wenzelm
parents:
64085
diff
changeset
|
559 |
case Session_Started(name) => |
ac7ae5067783
clarified status: started sessions may bomb without explicit FAILED or CANCELLED (cf. in afp-test-devel-2016-01-03.log);
wenzelm
parents:
64085
diff
changeset
|
560 |
started += name |
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
561 |
|
64054 | 562 |
case Session_Finished1(name, |
563 |
Value.Int(e1), Value.Int(e2), Value.Int(e3), |
|
564 |
Value.Int(c1), Value.Int(c2), Value.Int(c3)) => |
|
565 |
val elapsed = Time.hms(e1, e2, e3) |
|
566 |
val cpu = Time.hms(c1, c2, c3) |
|
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
567 |
timing += (name -> Timing(elapsed, cpu, Time.zero)) |
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
568 |
|
64054 | 569 |
case Session_Finished2(name, |
570 |
Value.Int(e1), Value.Int(e2), Value.Int(e3)) => |
|
571 |
val elapsed = Time.hms(e1, e2, e3) |
|
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
572 |
timing += (name -> Timing(elapsed, Time.zero, Time.zero)) |
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
573 |
|
64054 | 574 |
case Session_Timing(name, |
575 |
Value.Int(t), Value.Double(e), Value.Double(c), Value.Double(g)) => |
|
576 |
val elapsed = Time.seconds(e) |
|
577 |
val cpu = Time.seconds(c) |
|
578 |
val gc = Time.seconds(g) |
|
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
579 |
ml_timing += (name -> Timing(elapsed, cpu, gc)) |
64054 | 580 |
threads += (name -> t) |
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
581 |
|
66913 | 582 |
case Sources(name, s) => |
583 |
sources += (name -> s) |
|
584 |
||
64120 | 585 |
case Heap(name, Value.Long(size)) => |
586 |
heap_sizes += (name -> size) |
|
587 |
||
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
588 |
case _ if line.startsWith(THEORY_TIMING_MARKER) && YXML.detect(line) => |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
589 |
line match { |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
590 |
case Theory_Timing(name, theory_timing) => |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
591 |
theory_timings += (name -> (theory_timings.getOrElse(name, Map.empty) + theory_timing)) |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
592 |
case _ => log_file.err("malformed theory_timing " + quote(line)) |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
593 |
} |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
594 |
|
65937 | 595 |
case _ if parse_ml_statistics && line.startsWith(ML_STATISTICS_MARKER) && YXML.detect(line) => |
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
596 |
Library.try_unprefix(ML_STATISTICS_MARKER, line).map(log_file.parse_props(_)) match { |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
597 |
case Some((SESSION_NAME, name) :: props) => |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
598 |
ml_statistics += (name -> (props :: ml_statistics.getOrElse(name, Nil))) |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
599 |
case _ => log_file.err("malformed ML_statistics " + quote(line)) |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
600 |
} |
64119
8094eaa38d4b
inline session ML statistics into main build log;
wenzelm
parents:
64117
diff
changeset
|
601 |
|
65937 | 602 |
case _ if line.startsWith(ERROR_MESSAGE_MARKER) && YXML.detect(line) => |
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
603 |
Library.try_unprefix(ERROR_MESSAGE_MARKER, line).map(log_file.parse_props(_)) match { |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
604 |
case Some(List((SESSION_NAME, name), (Markup.CONTENT, msg))) => |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
605 |
errors += (name -> (Library.decode_lines(msg) :: errors.getOrElse(name, Nil))) |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
606 |
case _ => log_file.err("malformed error message " + quote(line)) |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
607 |
} |
65937 | 608 |
|
64054 | 609 |
case _ => |
610 |
} |
|
611 |
} |
|
612 |
||
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
613 |
val sessions = |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
614 |
Map( |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
615 |
(for (name <- all_sessions.toList) yield { |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
616 |
val status = |
65633 | 617 |
if (failed(name)) Session_Status.failed |
618 |
else if (cancelled(name)) Session_Status.cancelled |
|
64086
ac7ae5067783
clarified status: started sessions may bomb without explicit FAILED or CANCELLED (cf. in afp-test-devel-2016-01-03.log);
wenzelm
parents:
64085
diff
changeset
|
619 |
else if (timing.isDefinedAt(name) || ml_timing.isDefinedAt(name)) |
65633 | 620 |
Session_Status.finished |
621 |
else if (started(name)) Session_Status.failed |
|
622 |
else Session_Status.existing |
|
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
623 |
val entry = |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
624 |
Session_Entry( |
65643 | 625 |
chapter = chapter.getOrElse(name, ""), |
626 |
groups = groups.getOrElse(name, Nil), |
|
627 |
threads = threads.get(name), |
|
628 |
timing = timing.getOrElse(name, Timing.zero), |
|
629 |
ml_timing = ml_timing.getOrElse(name, Timing.zero), |
|
66913 | 630 |
sources = sources.get(name), |
65643 | 631 |
heap_size = heap_sizes.get(name), |
632 |
status = Some(status), |
|
65937 | 633 |
errors = errors.getOrElse(name, Nil).reverse, |
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
634 |
theory_timings = theory_timings.getOrElse(name, Map.empty), |
65643 | 635 |
ml_statistics = ml_statistics.getOrElse(name, Nil).reverse) |
64085
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
636 |
(name -> entry) |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
637 |
}):_*) |
1c451e5c145f
clarified parse_build_info: isabelle build output;
wenzelm
parents:
64083
diff
changeset
|
638 |
Build_Info(sessions) |
64054 | 639 |
} |
64099 | 640 |
|
641 |
||
642 |
||
65276 | 643 |
/** session info: produced by isabelle build as session log.gz file **/ |
64099 | 644 |
|
645 |
sealed case class Session_Info( |
|
646 |
session_timing: Properties.T, |
|
647 |
command_timings: List[Properties.T], |
|
66873
9953ae603a23
provide theory timing information, similar to command timing but always considered relevant;
wenzelm
parents:
66863
diff
changeset
|
648 |
theory_timings: List[Properties.T], |
64099 | 649 |
ml_statistics: List[Properties.T], |
65934 | 650 |
task_statistics: List[Properties.T], |
651 |
errors: List[String]) |
|
64099 | 652 |
|
653 |
private def parse_session_info( |
|
654 |
log_file: Log_File, |
|
655 |
command_timings: Boolean, |
|
66873
9953ae603a23
provide theory timing information, similar to command timing but always considered relevant;
wenzelm
parents:
66863
diff
changeset
|
656 |
theory_timings: Boolean, |
64099 | 657 |
ml_statistics: Boolean, |
658 |
task_statistics: Boolean): Session_Info = |
|
659 |
{ |
|
65290 | 660 |
Session_Info( |
661 |
session_timing = log_file.find_props("\fTiming = ") getOrElse Nil, |
|
662 |
command_timings = if (command_timings) log_file.filter_props("\fcommand_timing = ") else Nil, |
|
66873
9953ae603a23
provide theory timing information, similar to command timing but always considered relevant;
wenzelm
parents:
66863
diff
changeset
|
663 |
theory_timings = if (theory_timings) log_file.filter_props(THEORY_TIMING_MARKER) else Nil, |
65290 | 664 |
ml_statistics = if (ml_statistics) log_file.filter_props(ML_STATISTICS_MARKER) else Nil, |
65934 | 665 |
task_statistics = if (task_statistics) log_file.filter_props("\ftask_statistics = ") else Nil, |
65937 | 666 |
errors = log_file.filter_lines(ERROR_MESSAGE_MARKER).map(Library.decode_lines(_))) |
64099 | 667 |
} |
65595 | 668 |
|
65937 | 669 |
def compress_errors(errors: List[String]): Option[Bytes] = |
670 |
if (errors.isEmpty) None |
|
671 |
else Some(Bytes(YXML.string_of_body(XML.Encode.list(XML.Encode.string)(errors))).compress()) |
|
672 |
||
673 |
def uncompress_errors(bytes: Bytes): List[String] = |
|
674 |
if (bytes.isEmpty) Nil |
|
675 |
else XML.Decode.list(YXML.string_of_body(_))(YXML.parse_body(bytes.uncompress().text)) |
|
676 |
||
65595 | 677 |
|
678 |
||
679 |
/** persistent store **/ |
|
680 |
||
65694 | 681 |
/* SQL data model */ |
682 |
||
683 |
object Data |
|
684 |
{ |
|
65702 | 685 |
def build_log_table(name: String, columns: List[SQL.Column], body: String = ""): SQL.Table = |
65700 | 686 |
SQL.Table("isabelle_build_log_" + name, columns, body) |
687 |
||
688 |
||
65694 | 689 |
/* main content */ |
690 |
||
66857 | 691 |
val log_name = SQL.Column.string("log_name").make_primary_key |
692 |
val session_name = SQL.Column.string("session_name").make_primary_key |
|
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
693 |
val theory_name = SQL.Column.string("theory_name").make_primary_key |
65694 | 694 |
val chapter = SQL.Column.string("chapter") |
695 |
val groups = SQL.Column.string("groups") |
|
696 |
val threads = SQL.Column.int("threads") |
|
697 |
val timing_elapsed = SQL.Column.long("timing_elapsed") |
|
698 |
val timing_cpu = SQL.Column.long("timing_cpu") |
|
699 |
val timing_gc = SQL.Column.long("timing_gc") |
|
700 |
val timing_factor = SQL.Column.double("timing_factor") |
|
701 |
val ml_timing_elapsed = SQL.Column.long("ml_timing_elapsed") |
|
702 |
val ml_timing_cpu = SQL.Column.long("ml_timing_cpu") |
|
703 |
val ml_timing_gc = SQL.Column.long("ml_timing_gc") |
|
704 |
val ml_timing_factor = SQL.Column.double("ml_timing_factor") |
|
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
705 |
val theory_timing_elapsed = SQL.Column.long("theory_timing_elapsed") |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
706 |
val theory_timing_cpu = SQL.Column.long("theory_timing_cpu") |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
707 |
val theory_timing_gc = SQL.Column.long("theory_timing_gc") |
65694 | 708 |
val heap_size = SQL.Column.long("heap_size") |
709 |
val status = SQL.Column.string("status") |
|
65937 | 710 |
val errors = SQL.Column.bytes("errors") |
66913 | 711 |
val sources = SQL.Column.string("sources") |
65694 | 712 |
val ml_statistics = SQL.Column.bytes("ml_statistics") |
65783
d3d5cb2d6866
pick isabelle_version based on build_log database;
wenzelm
parents:
65781
diff
changeset
|
713 |
val known = SQL.Column.bool("known") |
65694 | 714 |
|
715 |
val meta_info_table = |
|
65702 | 716 |
build_log_table("meta_info", log_name :: Prop.all_props ::: Settings.all_settings) |
65694 | 717 |
|
718 |
val sessions_table = |
|
65702 | 719 |
build_log_table("sessions", |
65694 | 720 |
List(log_name, session_name, chapter, groups, threads, timing_elapsed, timing_cpu, |
721 |
timing_gc, timing_factor, ml_timing_elapsed, ml_timing_cpu, ml_timing_gc, ml_timing_factor, |
|
66913 | 722 |
heap_size, status, errors, sources)) |
65694 | 723 |
|
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
724 |
val theories_table = |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
725 |
build_log_table("theories", |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
726 |
List(log_name, session_name, theory_name, theory_timing_elapsed, theory_timing_cpu, |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
727 |
theory_timing_gc)) |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
728 |
|
65694 | 729 |
val ml_statistics_table = |
65702 | 730 |
build_log_table("ml_statistics", List(log_name, session_name, ml_statistics)) |
65694 | 731 |
|
732 |
||
66855 | 733 |
/* AFP versions */ |
734 |
||
735 |
val isabelle_afp_versions_table: SQL.Table = |
|
736 |
{ |
|
737 |
val version1 = Prop.isabelle_version |
|
738 |
val version2 = Prop.afp_version |
|
66857 | 739 |
build_log_table("isabelle_afp_versions", List(version1.make_primary_key, version2), |
66855 | 740 |
SQL.select(List(version1, version2), distinct = true) + meta_info_table + |
66856 | 741 |
" WHERE " + version1.defined + " AND " + version2.defined) |
66855 | 742 |
} |
743 |
||
744 |
||
65705 | 745 |
/* earliest pull date for repository version (PostgreSQL queries) */ |
65694 | 746 |
|
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
747 |
def pull_date(afp: Boolean = false) = |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
748 |
if (afp) SQL.Column.date("afp_pull_date") |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
749 |
else SQL.Column.date("pull_date") |
65694 | 750 |
|
66863
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
751 |
def pull_date_table(afp: Boolean = false): SQL.Table = |
65709 | 752 |
{ |
66863
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
753 |
val (name, versions) = |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
754 |
if (afp) ("afp_pull_date", List(Prop.isabelle_version, Prop.afp_version)) |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
755 |
else ("pull_date", List(Prop.isabelle_version)) |
65694 | 756 |
|
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
757 |
build_log_table(name, versions.map(_.make_primary_key) ::: List(pull_date(afp)), |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
758 |
"SELECT " + versions.mkString(", ") + |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
759 |
", min(" + Prop.build_start + ") AS " + pull_date(afp) + |
66863
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
760 |
" FROM " + meta_info_table + |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
761 |
" WHERE " + (versions ::: List(Prop.build_start)).map(_.defined).mkString(" AND ") + |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
762 |
" GROUP BY " + versions.mkString(", ")) |
66855 | 763 |
} |
764 |
||
765 |
||
766 |
/* recent entries */ |
|
767 |
||
65736 | 768 |
def recent_time(days: Int): SQL.Source = |
769 |
"now() - INTERVAL '" + days.max(0) + " days'" |
|
770 |
||
66863
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
771 |
def recent_pull_date_table( |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
772 |
days: Int, rev: String = "", afp_rev: Option[String] = None): SQL.Table = |
65702 | 773 |
{ |
66863
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
774 |
val afp = afp_rev.isDefined |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
775 |
val rev2 = afp_rev.getOrElse("") |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
776 |
val table = pull_date_table(afp) |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
777 |
|
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
778 |
val version1 = Prop.isabelle_version |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
779 |
val version2 = Prop.afp_version |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
780 |
val eq1 = version1(table) + " = " + SQL.string(rev) |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
781 |
val eq2 = version2(table) + " = " + SQL.string(rev2) |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
782 |
|
65777 | 783 |
SQL.Table("recent_pull_date", table.columns, |
65783
d3d5cb2d6866
pick isabelle_version based on build_log database;
wenzelm
parents:
65781
diff
changeset
|
784 |
table.select(table.columns, |
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
785 |
"WHERE " + pull_date(afp)(table) + " > " + recent_time(days) + |
66863
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
786 |
(if (rev != "" && rev2 == "") " OR " + eq1 |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
787 |
else if (rev == "" && rev2 != "") " OR " + eq2 |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
788 |
else if (rev != "" && rev2 != "") " OR (" + eq1 + " AND " + eq2 + ")" |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
789 |
else ""))) |
65702 | 790 |
} |
65694 | 791 |
|
65781 | 792 |
def select_recent_log_names(days: Int): SQL.Source = |
793 |
{ |
|
794 |
val table1 = meta_info_table |
|
795 |
val table2 = recent_pull_date_table(days) |
|
796 |
table1.select(List(log_name), distinct = true) + SQL.join_inner + table2.query_named + |
|
797 |
" ON " + Prop.isabelle_version(table1) + " = " + Prop.isabelle_version(table2) |
|
798 |
} |
|
799 |
||
66863
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
800 |
def select_recent_versions(days: Int, |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
801 |
rev: String = "", afp_rev: Option[String] = None, sql: SQL.Source = ""): SQL.Source = |
65783
d3d5cb2d6866
pick isabelle_version based on build_log database;
wenzelm
parents:
65781
diff
changeset
|
802 |
{ |
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
803 |
val afp = afp_rev.isDefined |
66858 | 804 |
val version = Prop.isabelle_version |
66863
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
805 |
val table1 = recent_pull_date_table(days, rev = rev, afp_rev = afp_rev) |
65783
d3d5cb2d6866
pick isabelle_version based on build_log database;
wenzelm
parents:
65781
diff
changeset
|
806 |
val table2 = meta_info_table |
d3d5cb2d6866
pick isabelle_version based on build_log database;
wenzelm
parents:
65781
diff
changeset
|
807 |
val aux_table = SQL.Table("aux", table2.columns, table2.select(sql = sql)) |
d3d5cb2d6866
pick isabelle_version based on build_log database;
wenzelm
parents:
65781
diff
changeset
|
808 |
|
d3d5cb2d6866
pick isabelle_version based on build_log database;
wenzelm
parents:
65781
diff
changeset
|
809 |
val columns = |
66858 | 810 |
table1.columns.map(c => c(table1)) ::: |
811 |
List(known.copy(expr = log_name(aux_table).defined)) |
|
65783
d3d5cb2d6866
pick isabelle_version based on build_log database;
wenzelm
parents:
65781
diff
changeset
|
812 |
SQL.select(columns, distinct = true) + |
d3d5cb2d6866
pick isabelle_version based on build_log database;
wenzelm
parents:
65781
diff
changeset
|
813 |
table1.query_named + SQL.join_outer + aux_table.query_named + |
66858 | 814 |
" ON " + version(table1) + " = " + version(aux_table) + |
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
815 |
" ORDER BY " + pull_date(afp)(table1) + " DESC" |
65783
d3d5cb2d6866
pick isabelle_version based on build_log database;
wenzelm
parents:
65781
diff
changeset
|
816 |
} |
d3d5cb2d6866
pick isabelle_version based on build_log database;
wenzelm
parents:
65781
diff
changeset
|
817 |
|
65724 | 818 |
|
819 |
/* universal view on main data */ |
|
820 |
||
821 |
val universal_table: SQL.Table = |
|
822 |
{ |
|
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
823 |
val afp_pull_date = pull_date(afp = true) |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
824 |
val version1 = Prop.isabelle_version |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
825 |
val version2 = Prop.afp_version |
65724 | 826 |
val table1 = meta_info_table |
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
827 |
val table2 = pull_date_table(afp = true) |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
828 |
val table3 = pull_date_table() |
65724 | 829 |
|
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
830 |
val a_columns = log_name :: afp_pull_date :: table1.columns.tail |
65850
5414c14c3984
clarified universal table: include ml_statistics;
wenzelm
parents:
65804
diff
changeset
|
831 |
val a_table = |
5414c14c3984
clarified universal table: include ml_statistics;
wenzelm
parents:
65804
diff
changeset
|
832 |
SQL.Table("a", a_columns, |
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
833 |
SQL.select(List(log_name, afp_pull_date) ::: table1.columns.tail.map(_.apply(table1))) + |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
834 |
table1 + SQL.join_outer + table2 + |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
835 |
" ON " + version1(table1) + " = " + version1(table2) + |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
836 |
" AND " + version2(table1) + " = " + version2(table2)) |
65724 | 837 |
|
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
838 |
val b_columns = log_name :: pull_date() :: a_columns.tail |
65850
5414c14c3984
clarified universal table: include ml_statistics;
wenzelm
parents:
65804
diff
changeset
|
839 |
val b_table = |
5414c14c3984
clarified universal table: include ml_statistics;
wenzelm
parents:
65804
diff
changeset
|
840 |
SQL.Table("b", b_columns, |
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
841 |
SQL.select( |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
842 |
List(log_name(a_table), pull_date()(table3)) ::: a_columns.tail.map(_.apply(a_table))) + |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
843 |
a_table.query_named + SQL.join_outer + table3 + |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
844 |
" ON " + version1(a_table) + " = " + version1(table3)) |
65850
5414c14c3984
clarified universal table: include ml_statistics;
wenzelm
parents:
65804
diff
changeset
|
845 |
|
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
846 |
val c_columns = b_columns ::: sessions_table.columns.tail |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
847 |
val c_table = |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
848 |
SQL.Table("c", c_columns, |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
849 |
SQL.select(log_name(b_table) :: c_columns.tail) + |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
850 |
b_table.query_named + SQL.join_inner + sessions_table + |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
851 |
" ON " + log_name(b_table) + " = " + log_name(sessions_table)) |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
852 |
|
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
853 |
SQL.Table("isabelle_build_log", c_columns ::: List(ml_statistics), |
65724 | 854 |
{ |
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
855 |
SQL.select(c_columns.map(_.apply(c_table)) ::: List(ml_statistics)) + |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
856 |
c_table.query_named + SQL.join_outer + ml_statistics_table + |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
857 |
" ON " + log_name(c_table) + " = " + log_name(ml_statistics_table) + |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
858 |
" AND " + session_name(c_table) + " = " + session_name(ml_statistics_table) |
65724 | 859 |
}) |
860 |
} |
|
65694 | 861 |
} |
862 |
||
863 |
||
864 |
/* database access */ |
|
865 |
||
65595 | 866 |
def store(options: Options): Store = new Store(options) |
867 |
||
65857 | 868 |
class Store private[Build_Log](options: Options) |
65595 | 869 |
{ |
65857 | 870 |
val xml_cache: XML.Cache = new XML.Cache() |
871 |
||
65595 | 872 |
def open_database( |
873 |
user: String = options.string("build_log_database_user"), |
|
874 |
password: String = options.string("build_log_database_password"), |
|
875 |
database: String = options.string("build_log_database_name"), |
|
876 |
host: String = options.string("build_log_database_host"), |
|
877 |
port: Int = options.int("build_log_database_port"), |
|
878 |
ssh_host: String = options.string("build_log_ssh_host"), |
|
879 |
ssh_user: String = options.string("build_log_ssh_user"), |
|
880 |
ssh_port: Int = options.int("build_log_ssh_port")): PostgreSQL.Database = |
|
881 |
{ |
|
882 |
PostgreSQL.open_database( |
|
883 |
user = user, password = password, database = database, host = host, port = port, |
|
884 |
ssh = |
|
885 |
if (ssh_host == "") None |
|
65636
df804cdba5f9
ssh_close for proper termination after use of database;
wenzelm
parents:
65633
diff
changeset
|
886 |
else Some(SSH.init_context(options).open_session(ssh_host, ssh_user, port)), |
df804cdba5f9
ssh_close for proper termination after use of database;
wenzelm
parents:
65633
diff
changeset
|
887 |
ssh_close = true) |
65595 | 888 |
} |
65599 | 889 |
|
65723
3ee466e89047
clarified signature: PostgreSQL manages high-volume data, SQLite only sees small snapshots;
wenzelm
parents:
65722
diff
changeset
|
890 |
def update_database(db: PostgreSQL.Database, dirs: List[Path], ml_statistics: Boolean = false) |
65694 | 891 |
{ |
892 |
write_info(db, Log_File.find_files(dirs), ml_statistics = ml_statistics) |
|
893 |
||
66863
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
894 |
db.create_view(Data.pull_date_table()) |
6acd1a2bd146
clarified afp_pull_date: both repository versions are relevant;
wenzelm
parents:
66858
diff
changeset
|
895 |
db.create_view(Data.pull_date_table(afp = true)) |
65724 | 896 |
db.create_view(Data.universal_table) |
65694 | 897 |
} |
898 |
||
65723
3ee466e89047
clarified signature: PostgreSQL manages high-volume data, SQLite only sees small snapshots;
wenzelm
parents:
65722
diff
changeset
|
899 |
def snapshot_database(db: PostgreSQL.Database, sqlite_database: Path, |
65705 | 900 |
days: Int = 100, ml_statistics: Boolean = false) |
65694 | 901 |
{ |
902 |
Isabelle_System.mkdirs(sqlite_database.dir) |
|
903 |
sqlite_database.file.delete |
|
904 |
||
905 |
using(SQLite.open_database(sqlite_database))(db2 => |
|
906 |
{ |
|
907 |
db.transaction { |
|
908 |
db2.transaction { |
|
65705 | 909 |
// main content |
910 |
db2.create_table(Data.meta_info_table) |
|
911 |
db2.create_table(Data.sessions_table) |
|
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
912 |
db2.create_table(Data.theories_table) |
65705 | 913 |
db2.create_table(Data.ml_statistics_table) |
914 |
||
915 |
val recent_log_names = |
|
65781 | 916 |
db.using_statement(Data.select_recent_log_names(days))(stmt => |
65779 | 917 |
stmt.execute_query().iterator(_.string(Data.log_name)).toList) |
65705 | 918 |
|
919 |
for (log_name <- recent_log_names) { |
|
920 |
read_meta_info(db, log_name).foreach(meta_info => |
|
921 |
update_meta_info(db2, log_name, meta_info)) |
|
922 |
||
923 |
update_sessions(db2, log_name, read_build_info(db, log_name)) |
|
924 |
||
65856 | 925 |
if (ml_statistics) { |
926 |
update_ml_statistics(db2, log_name, |
|
927 |
read_build_info(db, log_name, ml_statistics = true)) |
|
928 |
} |
|
65705 | 929 |
} |
930 |
||
931 |
// pull_date |
|
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
932 |
for (afp <- List(false, true)) |
65694 | 933 |
{ |
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
934 |
val afp_rev = if (afp) Some("") else None |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
935 |
val table = Data.pull_date_table(afp) |
65694 | 936 |
db2.create_table(table) |
65698 | 937 |
db2.using_statement(table.insert())(stmt2 => |
65694 | 938 |
{ |
66880
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
939 |
db.using_statement( |
486f4af28db9
more thorough treatment of afp_version and afp_pull_date;
wenzelm
parents:
66874
diff
changeset
|
940 |
Data.recent_pull_date_table(days, afp_rev = afp_rev).query)(stmt => |
65694 | 941 |
{ |
65740 | 942 |
val res = stmt.execute_query() |
943 |
while (res.next()) { |
|
65748 | 944 |
for ((c, i) <- table.columns.zipWithIndex) { |
945 |
stmt2.string(i + 1) = res.get_string(c) |
|
946 |
} |
|
65740 | 947 |
stmt2.execute() |
65694 | 948 |
} |
949 |
}) |
|
950 |
}) |
|
65709 | 951 |
} |
65705 | 952 |
|
953 |
// full view |
|
65724 | 954 |
db2.create_view(Data.universal_table) |
65694 | 955 |
} |
956 |
} |
|
65708 | 957 |
db2.rebuild |
65694 | 958 |
}) |
959 |
} |
|
960 |
||
65688 | 961 |
def domain(db: SQL.Database, table: SQL.Table, column: SQL.Column): Set[String] = |
65698 | 962 |
db.using_statement(table.select(List(column), distinct = true))(stmt => |
65740 | 963 |
stmt.execute_query().iterator(_.string(column)).toSet) |
65688 | 964 |
|
65705 | 965 |
def update_meta_info(db: SQL.Database, log_name: String, meta_info: Meta_Info) |
65632 | 966 |
{ |
65694 | 967 |
val table = Data.meta_info_table |
65703
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
968 |
db.using_statement(db.insert_permissive(table))(stmt => |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
969 |
{ |
65748 | 970 |
stmt.string(1) = log_name |
65703
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
971 |
for ((c, i) <- table.columns.tail.zipWithIndex) { |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
972 |
if (c.T == SQL.Type.Date) |
65748 | 973 |
stmt.date(i + 2) = meta_info.get_date(c) |
65703
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
974 |
else |
65748 | 975 |
stmt.string(i + 2) = meta_info.get(c) |
65703
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
976 |
} |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
977 |
stmt.execute() |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
978 |
}) |
65600 | 979 |
} |
980 |
||
65705 | 981 |
def update_sessions(db: SQL.Database, log_name: String, build_info: Build_Info) |
65599 | 982 |
{ |
65694 | 983 |
val table = Data.sessions_table |
65703
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
984 |
db.using_statement(db.insert_permissive(table))(stmt => |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
985 |
{ |
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
986 |
val sessions = |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
987 |
if (build_info.sessions.isEmpty) Build_Info.sessions_dummy |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
988 |
else build_info.sessions |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
989 |
for ((session_name, session) <- sessions) { |
65748 | 990 |
stmt.string(1) = log_name |
991 |
stmt.string(2) = session_name |
|
65853 | 992 |
stmt.string(3) = proper_string(session.chapter) |
65748 | 993 |
stmt.string(4) = session.proper_groups |
994 |
stmt.int(5) = session.threads |
|
995 |
stmt.long(6) = session.timing.elapsed.proper_ms |
|
996 |
stmt.long(7) = session.timing.cpu.proper_ms |
|
997 |
stmt.long(8) = session.timing.gc.proper_ms |
|
998 |
stmt.double(9) = session.timing.factor |
|
999 |
stmt.long(10) = session.ml_timing.elapsed.proper_ms |
|
1000 |
stmt.long(11) = session.ml_timing.cpu.proper_ms |
|
1001 |
stmt.long(12) = session.ml_timing.gc.proper_ms |
|
1002 |
stmt.double(13) = session.ml_timing.factor |
|
1003 |
stmt.long(14) = session.heap_size |
|
1004 |
stmt.string(15) = session.status.map(_.toString) |
|
65937 | 1005 |
stmt.bytes(16) = compress_errors(session.errors) |
66913 | 1006 |
stmt.string(17) = session.sources |
65703
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
1007 |
stmt.execute() |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
1008 |
} |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
1009 |
}) |
65642 | 1010 |
} |
1011 |
||
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1012 |
def update_theories(db: SQL.Database, log_name: String, build_info: Build_Info) |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1013 |
{ |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1014 |
val table = Data.theories_table |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1015 |
db.using_statement(db.insert_permissive(table))(stmt => |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1016 |
{ |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1017 |
val sessions = |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1018 |
if (build_info.sessions.forall({ case (_, session) => session.theory_timings.isEmpty })) |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1019 |
Build_Info.sessions_dummy |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1020 |
else build_info.sessions |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1021 |
for { |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1022 |
(session_name, session) <- sessions |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1023 |
(theory_name, timing) <- session.theory_timings |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1024 |
} { |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1025 |
stmt.string(1) = log_name |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1026 |
stmt.string(2) = session_name |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1027 |
stmt.string(3) = theory_name |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1028 |
stmt.long(4) = timing.elapsed.ms |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1029 |
stmt.long(5) = timing.cpu.ms |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1030 |
stmt.long(6) = timing.gc.ms |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1031 |
stmt.execute() |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1032 |
} |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1033 |
}) |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1034 |
} |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1035 |
|
65705 | 1036 |
def update_ml_statistics(db: SQL.Database, log_name: String, build_info: Build_Info) |
65645
2c704ae04db1
clarified database layout: bulky ml_statistics are stored/retrieved separately;
wenzelm
parents:
65643
diff
changeset
|
1037 |
{ |
65694 | 1038 |
val table = Data.ml_statistics_table |
65703
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
1039 |
db.using_statement(db.insert_permissive(table))(stmt => |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
1040 |
{ |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
1041 |
val ml_stats: List[(String, Option[Bytes])] = |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
1042 |
Par_List.map[(String, Session_Entry), (String, Option[Bytes])]( |
65857 | 1043 |
{ case (a, b) => (a, Properties.compress(b.ml_statistics).proper) }, |
65703
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
1044 |
build_info.sessions.iterator.filter(p => p._2.ml_statistics.nonEmpty).toList) |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
1045 |
val entries = if (ml_stats.nonEmpty) ml_stats else List("" -> None) |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
1046 |
for ((session_name, ml_statistics) <- entries) { |
65748 | 1047 |
stmt.string(1) = log_name |
1048 |
stmt.string(2) = session_name |
|
1049 |
stmt.bytes(3) = ml_statistics |
|
65703
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
1050 |
stmt.execute() |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
1051 |
} |
cead65c19f2e
more direct insert_permissive statement, which avoids somewhat fragile nested transactions;
wenzelm
parents:
65702
diff
changeset
|
1052 |
}) |
65645
2c704ae04db1
clarified database layout: bulky ml_statistics are stored/retrieved separately;
wenzelm
parents:
65643
diff
changeset
|
1053 |
} |
2c704ae04db1
clarified database layout: bulky ml_statistics are stored/retrieved separately;
wenzelm
parents:
65643
diff
changeset
|
1054 |
|
2c704ae04db1
clarified database layout: bulky ml_statistics are stored/retrieved separately;
wenzelm
parents:
65643
diff
changeset
|
1055 |
def write_info(db: SQL.Database, files: List[JFile], ml_statistics: Boolean = false) |
65642 | 1056 |
{ |
65705 | 1057 |
abstract class Table_Status(table: SQL.Table) |
65642 | 1058 |
{ |
65688 | 1059 |
db.create_table(table) |
65694 | 1060 |
private var known: Set[String] = domain(db, table, Data.log_name) |
65688 | 1061 |
|
65642 | 1062 |
def required(file: JFile): Boolean = !known(Log_File.plain_name(file.getName)) |
65705 | 1063 |
|
1064 |
def update_db(db: SQL.Database, log_file: Log_File): Unit |
|
65642 | 1065 |
def update(log_file: Log_File) |
1066 |
{ |
|
1067 |
if (!known(log_file.name)) { |
|
1068 |
update_db(db, log_file) |
|
1069 |
known += log_file.name |
|
65618 | 1070 |
} |
65614
325801edb37d
clarified transaction boundaries: more robust incremental write operations;
wenzelm
parents:
65613
diff
changeset
|
1071 |
} |
65605 | 1072 |
} |
65642 | 1073 |
val status = |
1074 |
List( |
|
65705 | 1075 |
new Table_Status(Data.meta_info_table) { |
1076 |
override def update_db(db: SQL.Database, log_file: Log_File): Unit = |
|
1077 |
update_meta_info(db, log_file.name, log_file.parse_meta_info()) |
|
1078 |
}, |
|
1079 |
new Table_Status(Data.sessions_table) { |
|
1080 |
override def update_db(db: SQL.Database, log_file: Log_File): Unit = |
|
1081 |
update_sessions(db, log_file.name, log_file.parse_build_info()) |
|
1082 |
}, |
|
66874
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1083 |
new Table_Status(Data.theories_table) { |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1084 |
override def update_db(db: SQL.Database, log_file: Log_File): Unit = |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1085 |
update_theories(db, log_file.name, log_file.parse_build_info()) |
0b8da0fc9563
store theory timings in session in build_log database;
wenzelm
parents:
66873
diff
changeset
|
1086 |
}, |
65705 | 1087 |
new Table_Status(Data.ml_statistics_table) { |
1088 |
override def update_db(db: SQL.Database, log_file: Log_File): Unit = |
|
1089 |
if (ml_statistics) { |
|
1090 |
update_ml_statistics(db, log_file.name, |
|
1091 |
log_file.parse_build_info(ml_statistics = true)) |
|
1092 |
} |
|
1093 |
}) |
|
65642 | 1094 |
|
65645
2c704ae04db1
clarified database layout: bulky ml_statistics are stored/retrieved separately;
wenzelm
parents:
65643
diff
changeset
|
1095 |
for (file_group <- files.filter(file => status.exists(_.required(file))).grouped(100)) { |
65642 | 1096 |
val log_files = Par_List.map[JFile, Log_File](Log_File.apply _, file_group) |
1097 |
db.transaction { log_files.foreach(log_file => status.foreach(_.update(log_file))) } |
|
1098 |
} |
|
65605 | 1099 |
} |
1100 |
||
65621 | 1101 |
def read_meta_info(db: SQL.Database, log_name: String): Option[Meta_Info] = |
1102 |
{ |
|
65694 | 1103 |
val table = Data.meta_info_table |
65642 | 1104 |
val columns = table.columns.tail |
65699 | 1105 |
db.using_statement(table.select(columns, Data.log_name.where_equal(log_name)))(stmt => |
65621 | 1106 |
{ |
65740 | 1107 |
val res = stmt.execute_query() |
1108 |
if (!res.next) None |
|
65621 | 1109 |
else { |
1110 |
val results = |
|
65642 | 1111 |
columns.map(c => c.name -> |
65621 | 1112 |
(if (c.T == SQL.Type.Date) |
65740 | 1113 |
res.get_date(c).map(Log_File.Date_Format(_)) |
65621 | 1114 |
else |
65740 | 1115 |
res.get_string(c))) |
65621 | 1116 |
val n = Prop.all_props.length |
1117 |
val props = for ((x, Some(y)) <- results.take(n)) yield (x, y) |
|
1118 |
val settings = for ((x, Some(y)) <- results.drop(n)) yield (x, y) |
|
1119 |
Some(Meta_Info(props, settings)) |
|
1120 |
} |
|
1121 |
}) |
|
1122 |
} |
|
1123 |
||
1124 |
def read_build_info( |
|
65629 | 1125 |
db: SQL.Database, |
1126 |
log_name: String, |
|
1127 |
session_names: List[String] = Nil, |
|
1128 |
ml_statistics: Boolean = false): Build_Info = |
|
65621 | 1129 |
{ |
65694 | 1130 |
val table1 = Data.sessions_table |
1131 |
val table2 = Data.ml_statistics_table |
|
65629 | 1132 |
|
65645
2c704ae04db1
clarified database layout: bulky ml_statistics are stored/retrieved separately;
wenzelm
parents:
65643
diff
changeset
|
1133 |
val where_log_name = |
65699 | 1134 |
Data.log_name(table1).where_equal(log_name) + " AND " + |
65701 | 1135 |
Data.session_name(table1) + " <> ''" |
65621 | 1136 |
val where = |
65645
2c704ae04db1
clarified database layout: bulky ml_statistics are stored/retrieved separately;
wenzelm
parents:
65643
diff
changeset
|
1137 |
if (session_names.isEmpty) where_log_name |
65804 | 1138 |
else where_log_name + " AND " + SQL.member(Data.session_name(table1).ident, session_names) |
65629 | 1139 |
|
65645
2c704ae04db1
clarified database layout: bulky ml_statistics are stored/retrieved separately;
wenzelm
parents:
65643
diff
changeset
|
1140 |
val columns1 = table1.columns.tail.map(_.apply(table1)) |
2c704ae04db1
clarified database layout: bulky ml_statistics are stored/retrieved separately;
wenzelm
parents:
65643
diff
changeset
|
1141 |
val (columns, from) = |
2c704ae04db1
clarified database layout: bulky ml_statistics are stored/retrieved separately;
wenzelm
parents:
65643
diff
changeset
|
1142 |
if (ml_statistics) { |
65694 | 1143 |
val columns = columns1 ::: List(Data.ml_statistics(table2)) |
65668 | 1144 |
val join = |
65775 | 1145 |
table1 + SQL.join_outer + table2 + " ON " + |
65738 | 1146 |
Data.log_name(table1) + " = " + Data.log_name(table2) + " AND " + |
1147 |
Data.session_name(table1) + " = " + Data.session_name(table2) |
|
65668 | 1148 |
(columns, SQL.enclose(join)) |
65645
2c704ae04db1
clarified database layout: bulky ml_statistics are stored/retrieved separately;
wenzelm
parents:
65643
diff
changeset
|
1149 |
} |
65695 | 1150 |
else (columns1, table1.ident) |
65645
2c704ae04db1
clarified database layout: bulky ml_statistics are stored/retrieved separately;
wenzelm
parents:
65643
diff
changeset
|
1151 |
|
65621 | 1152 |
val sessions = |
65698 | 1153 |
db.using_statement(SQL.select(columns) + from + " " + where)(stmt => |
65621 | 1154 |
{ |
65740 | 1155 |
stmt.execute_query().iterator(res => |
65621 | 1156 |
{ |
65740 | 1157 |
val session_name = res.string(Data.session_name) |
65626 | 1158 |
val session_entry = |
1159 |
Session_Entry( |
|
65740 | 1160 |
chapter = res.string(Data.chapter), |
1161 |
groups = split_lines(res.string(Data.groups)), |
|
1162 |
threads = res.get_int(Data.threads), |
|
65741 | 1163 |
timing = res.timing(Data.timing_elapsed, Data.timing_cpu, Data.timing_gc), |
65626 | 1164 |
ml_timing = |
65741 | 1165 |
res.timing(Data.ml_timing_elapsed, Data.ml_timing_cpu, Data.ml_timing_gc), |
66913 | 1166 |
sources = res.get_string(Data.sources), |
65740 | 1167 |
heap_size = res.get_long(Data.heap_size), |
1168 |
status = res.get_string(Data.status).map(Session_Status.withName(_)), |
|
65937 | 1169 |
errors = uncompress_errors(res.bytes(Data.errors)), |
65629 | 1170 |
ml_statistics = |
65857 | 1171 |
if (ml_statistics) |
1172 |
Properties.uncompress(res.bytes(Data.ml_statistics), Some(xml_cache)) |
|
65629 | 1173 |
else Nil) |
65626 | 1174 |
session_name -> session_entry |
65621 | 1175 |
}).toMap |
1176 |
}) |
|
1177 |
Build_Info(sessions) |
|
1178 |
} |
|
65595 | 1179 |
} |
64045 | 1180 |
} |