-
Notifications
You must be signed in to change notification settings - Fork 4
/
ChangeLog
371 lines (234 loc) · 11 KB
/
ChangeLog
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
2011-07-11 Mark Grondona <mgrondona@llnl.gov>
* : tag v0.19.
* slurm-joblog.pl :
Use NODECNT environment variable if set instead of counting
node list. Resolves Issue 2.
* slurm-joblog.pl, sqlog-db-util :
Improve debug and verbose output for better debugging.
* sqlog-db-util :
Fix CHAOS bz#1204: error setting up DB.
2009-10-23 Mark Grondona <mgrondona@llnl.gov>
* : tag v0.18.
* sqlog :
Add missing table name for nodes table in &lookup_ids().
2009-10-23 Mark Grondona <mgrondona@llnl.gov>
* : tag v0.17.
* skewstats, skewstats.1, sqlog.spec :
Add skewstats utility to sqlog package.
2009-10-16 Mark Grondona <mgrondona@llnl.gov>
* sqlog.1 : Update documentation of --regex.
* sqlog : Replace global conf{regex} boolean with conf{regex}{key}
to allow per-key setting of regex matching vs exact matching.
The --regex flag now operates similar to --exclude.
2009-10-12 Mark Grondona <mgrondona@llnl.gov>
* : tag v0.16.
* sqlog : Fix --regex queries against v2 database format.
* sqlog : Don't treat filter arguments for running jobs
as regular expressions unles --regex was used.
2009-10-10 Mark Grondona <mgrondona@llnl.gov>
* sqlog : Refactor code for running job selection, and fix
-J, --job-names processing on running jobs.
* sqlog-db-util : Fix -L --localhost processing.
2009-05-07 Mark Grondona <mgrondona@llnl.gov>
* : tag v0.15.
* sqlog : Fix -j, --jobids option on systems with v2
database.
2009-04-09 Mark Grondona <mgrondona@llnl.gov>
* : tag v0.14.
* sqlog :
Remove ncores from default short output format.
* sqlog (query_running_jobs, reformat_squeue_datetime) :
Drop the T character from new-style squeue output. SLURM
seems to have introduced this in slurm-1.4, and Date::Manip
doesn't handle it.
* sqlog (get_seconds_date_manip_is_buggy) :
If date is literally NONE, then just return that value.
Otherwise, try to handle dates that cannot be parsed by
Date::Manip by logging an error and setting them to NONE.
2009-04-02 Mark Grondona <mgrondona@llnl.gov>
* slurm-joblog.pl :
Try to log to text file even if there is a failure reading
one of the config files.
2009-04-02 Mark Grondona <mgrondona@llnl.gov>
* : tag v0.13.
2009-04-01 Mark Grondona <mgrondona@llnl.gov>
* sqlog :
Change timelocal debug message from log_verbose to log_debug.
* sqlog-db-util, sqlog-db-util.8, README :
Rename --cores option to --cores-per-node.
* sqlog-db-util :
Reformat --help output and comments to fit in 80 characters.
2009-03-13 Adam Moody <moody20@llnl.gov>
* sqlog : Added logic to track nodes and query records by node name
via SQL commands.
* sqlog-db-util : Added --backup, --prune, --cores, --obfuscate,
--notrack, and --delay-index options. Changed --drop to --drop=V.
Created usernames, jobnames, jobstates, and partitions tables
to reduce record length in new jobs table. Added indicies on
jobnames, starttime, endtime, runtime, nodecount, corecount to
speed up such queries. Added nodes table to assign each node name
to an id, and created a jobs_nodes table that maps node ids to
job ids.
2008-03-03 Adam Moody <moody20@llnl.gov>
* sqlog : Added --ncores, --maxcores, and --mincores options to display
and sort jobs based on number of processors used (PROCS field from
SLURM job log).
* sqlog-db-util : Added -x, --convert options to convert existing
slurm_job_log tables to version 2 (adds procs column and extends
nodelist column to a blob). Avoids reconverting an up-to-date table.
* slurm-joblog.pl : Added code to insert procs field.
2008-12-03 Mark Grondona <mgrondona@llnl.gov>
* : tag v0.12.
* sqlog : Add --regex option to use REGEXP instead of IN
for queries of jobid, username, jobstate, partition, or
job name.
2008-12-02 Mark Grondona <mgrondona@llnl.gov>
* sqlog : It appears that Date::Manip is buggy and doesn't
support DST properly. sqlog used Date::Manip to convert
between stored database dates and Unix time (seconds since
epoch). Instead convert time using other methods in this
instance to avoid misconverting during DST conversions.
2008-10-03 Py Watson <py@llnl.gov>
* sqlog.spec :
Change the various perl Requires to be based on the module
name rather than the RPM name. Fix for RPM Requires on SLES 9.
2008-06-24 Mark Grondona <mgrondona@llnl.gov>
* : tag v0.11.
* sqlog-db-util :
Drop all slurm* users from mysql DB before adding new
user privileges to avoid leaving old settings around.
* sqlog-db-util :
New slurm-joblog.conf parameter SQLNETWORK to specify the network
on which read-only access to the DB is allowed. Default: 192.168.%.%.
* slurm-joblog.conf.example :
Describe SQLNETWORK parameter.
2008-04-18 Mark Grondona <mgrondona@llnl.gov>
* : tag v0.10.
* sqlog.1 : Add OUTPUT FORMAT section.
* sqlog : Separate regexes in duration_to_seconds for
better parsing of the two support forms.
2008-02-29 Mark Grondona <mgrondona@llnl.gov>
* : tag v0.9.
* sqlog.1 : Add JOB STATE CODES section to manpage explaining
the various job states and their abbreviations.
* sqlog : Fix -o, --format when just a new format specification
is provided (e.g. "long" or "freeform").
2007-09-27 Mark Grondona <mgrondona@llnl.gov>
* : tag v0.8.
2007-09-14 Pythagoras Watson <py@llnl.gov>
* sqlog.spec : Add more packages to Requires.
2007-09-12 Mark Grondona <mgorndona@llnl.gov>
* slurm-joblog.pl : Fix test for whether a job logfile is
configured.
2007-08-13 Mark Grondona <mgorndona@llnl.gov>
* : tag v0.7.
2007-08-13 Pythagoras Watson <py@llnl.gov>
* sqlog, sqlog-db-util, slurm-joblog.pl, sqlog.spec :
Fixes required for AIX and other installations without
prefix = /usr: Allow modification of perl include paths
and PATH at RPM build time, use __perl RPM macro instead
of hardcoding /usr/bin/perl in specfile, correct perms
of sql-db-util.8 man page, and improve subst() functon in
specfile.
2007-08-10 Mark Grondona <mgrondona@llnl.gov>
* sqlog : Add runtime_s output field (runtime in seconds).
* sqlog : Add unixstart and unixend format keys for start and
end times in seconds since the epoch. Also, add an alias
time_s for runtime_s.
* : tag v0.6.
2007-08-10 Adam Moody <moody20@llnl.gov>
* sqlog : Fixed bug in parse_end_time preventing --end-before
and --end-after from working. Fixed comment in parse_start_time
to print --start-before and --start-after in error message.
2007-08-10 Mark Grondona <mgrondona@llnl.gov>
* sqlog, sqlog-db-util, slurm-joblog.pl, sqlog.spec :
Allow configuration directory (/etc/slurm by default) and perl
path (/usr/bin/perl by default) to be overridden at RPM build time.
* : tag 0.5.
2007-08-07 Mark Grondona <mgrondona@llnl.gov>
* sqlog-db-util : Failsafe check for existence of slurm_job_log
table in create_db(). Create SLURM DB with "IF NOT EXISTS" to
avoid error.
* sqlog : Don't read ~/.sqlog. This file is reserved for future
user configuration.
* sqlog : Parse ~/.sqlog for specification of alternate format
lists via "format{name} = LIST..." and default limit with
"limit = N". Similarly, new format lists may be specific in
sqlog.conf by creating a %FORMATS hash. User and system
configs may override the default format key lists for
"short", "long", and "freeform".
* sqlog.1 : Document ~/.sqlog.
* : tag v0.4.
2007-08-06 Mark Grondona <mgrondona@llnl.gov>
* sqlog.spec : Add perl-DateManip and gendersllnl to Requires.
* sqlog.1 : Add a note about sqlog's "More results available..."
message. Add some more examples.
* sqlog : When sorting start and end times, assume "NONE" to
mean "possibly infinite in the future" by faking a date 10 years
from now. This allows sorting end time to work as expected since
all jobs that end in the future should have the greateast end
time.
* sqlog-db-util.8 : Added.
* sqlog-db-util : Reformat usage output.
* sqlog : Give each format type (short, long, freeform) its own
format list. Put "longstart" and "longend" into default format
lists for long and freeform output types.
2007-08-06 Adam Moody <moody20@llnl.gov>
* sqlog : Changed option order in help output to more closely match
the order in the manpage.
* sqlog.1 : Added -L and -a, which were missing. Changed option
listing order slightly to group options by function.
2007-08-06 Mark Grondona <mgrondona@llnl.gov>
* sqlog : Apply sort keys to "ORDER BY" in DB query. Also, reverse
the sense of '-' on sort keys to be more intuitive.
* sqlog : Print "More results available..." if not all results from
DB and/or queue were displayed due to --limit.
* sqlog : Add "longstart" and "longend" format keys which print start
and end datetime in format "%Y-%m-%dT%H:%M:%S".
* sqlog : Fix typo in initialization of config arrays that caused
selection of job states to break.
2007-08-04 Mark Grondona <mgrondona@llnl.gov>
* slurm-joblog.pl, slurm-joblog.conf.example, README :
Optionally create DB if it doesn't exist in slurm-joblog.
* sqlog-db-util : Intialize $conf{verbose}.
* sqlog-db-util : Add --info option.
* : tag v0.3.
2007-08-03 Mark Grondona <mgrondona@llnl.gov>
* sqlog-db-util : Add Adam Moody's utility for creation of SLURM
job log database.
* sqlog.spec : Add sqlog-db-util to specfile.
* sqlog.conf.example, slurm-joblog.conf.example :
Add example config files.
* : tag v0.1.
* README, NEWS : Added.
* : tag v0.2.
2007-07-27 Mark Grondona <mgrondona@llnl.gov>
* sqlog.1 : Update man page with new RANGE OPERATORS section.
* sqlog : Remove Examples from --help. They are now in the manpage.
Read alternate config from /etc/slurm/sqlog.conf or ~/.sqlog.
* slurm-joblog.pl : Add slurm job completion script to repo.
* META, sqlog.spec : Add specfile and META for building RPMs.
2007-07-25 Mark Grondona <mgrondona@llnl.gov>
* sqlog : Changed range operator to ".."
--time may specify a min, max, or window of time.
@ may be used to escape leading + or - in datetime values.
2007-07-20 Adam Moody <moody20@llnl.gov>
* sqlog : Added RANGE operator description to usage,
--time still needs support.
2007-07-19 Adam Moody <moody20@llnl.gov>
* sqlog : Added support for 'S' in time duration, only 's' was working.
* sqlog : Changed comparison for runtime, minruntime, and maxruntime
to string equality tests of "eq" and "ne" since numeric operators of ">"
would get confused for input such as -T +1h.
* sqlog : Changed 'N-M' to 'N--M' to be consistent with time window format.
This way there is one consistent set of operators +/-/--.
2007-07-19 Mark Grondona <mgrondona@llnl.gov>
* sqlog : New options --start, --start-before, --start-after,
--end, --end-before, --end-after. Removed --before and --after
which are replaced by --start-before, --start-after.
* sqlog : Query running jobs by default and add -X, --no-running.
* sqlog : Add functions for parsing time ranges and min/max specifications.
* sqlog : Fix time window parsing.
* sqlog.1 : Added man page.
2007-07-18 Mark Grondona <mgrondona@llnl.gov>
* sqlog : Initial commit.