4 [NB: I use this as a thought record/scribble, not everything on here
5 makes sense and/or is actually ever going to get done, so IIWY I
6 wouldn't use it as gospel for the future of katie or as a TODO
7 list for random hacking.]
9 ================================================================================
14 o cindy should remove the src-only override when a binary+source override
17 o reject on > or < in a version constraint
19 23:07 < aba> elmo: and, how about enhancing rene to spot half-dropped
20 binaries on one arch (i.e. package used to build A and B, but B is
21 no longer built on some archs)?
27 o check email only portions of addresses match too, iff the names
28 don't, helps with the "James Troup <james@nocrew.org>"
29 vs. "<james@nocrew.org>" case.
31 o ensure .dsc section/prio match .changes section/prio
33 o rhona's kind of crap when asked to remove a lot of files (e.g. 2k
36 o we don't handle the case where an identical orig.tar.gz is
37 mentioned in the .changes, but not in unchecked; but should we
40 o madison could do better sanity checking for -g/-G (e.g. not more
43 o use python2.2-tarfile (once it's in stable?) to check orig.tar.gz
46 o need to decide on whether we're tying for most errors at once.. if
47 so (probably) then make sure code doesn't assume variables exist and
48 either way do something about checking error code of check_dsc and
49 later functions so we skip later checks if they're bailing.
51 o the .katie stuff is fundamentally braindamaged, it's not versioned
52 so there's no way to change the format, yay me. need to fix.
53 probably by putting a version var as the first thing and checking
54 that.. auto-upgrade at least from original format would be good.
55 might also be a good idea to put everything in one big dict after
58 o [?, wishlist, distant future] RFC2047-ing should be extended to
59 all headers of mails sent out.
61 o reject sparc64 binaries in a non '*64*' package.
63 o katie.py(source_exists): a) we take arguments as parameters that
64 we could figure out for ourselves (we're part of the Katie class
65 after all), b) we have this 3rd argument which defaults to "any"
66 but could in fact be dropped since no one uses it like that.
68 o jennifer: doesn't handle bin-only NMUs of stuff still in NEW,
69 BYHAND or ACCEPTED (but not the pool) - not a big deal, upload can
70 be retried once the source is in the archive, but still.
72 o security global mail overrides should special case buildd stuff so
73 that buildds get ACCEPTED mails (or maybe amber (?)), that way
74 upload-security doesn't grow boundlessly.
76 o amber should upload sourceful packages first, otherwise with big
77 packages (e.g. X) and esp. when source is !i386, half the arches
78 can be uploaded without source, get copied into queue/unaccepted
79 and promptly rejected.
81 o rene's NVIU check doesn't catch cases where source package changed
82 name, should check binaries too. [debian-devel@l.d.o, 2004-02-03]
84 o cnf[melanie::logfile] is misnamed...
86 <aj> i'd be kinda inclined to go with insisting the .changes file take
87 the form ---- BEGIN PGP MESSAGE --- <non -- BEGIN/END lines> --
88 BEGIN PGP SIG -- END PGP MESSAGE -- with no lines before or after,
89 and rejecting .changes that didn't match that
91 o rene should check for source packages not building any binaries
93 o heidi should have a diff mode that accepts diff output!
95 o halle doesn't deal with melanie'd packages, partial replacements
98 o lauren, the tramp, blindly deletes with no check that the delete
99 failed which it might well given we only look for package/version,
100 not package/version _in p-u_. duh.
102 o melanie should remove obsolete changes when removing from p-u, or
103 at least warn. or halle should handle it.
105 o need a testsuite _badly_
107 o lisa should have an Bitch-Then-Accept option
109 o jennifer crashes if run as a user in -n mode when orig.tar.gz is
112 <elmo_home> [<random>maybe I should reject debian packages with a non-Debian origin or bugs field</>]
113 <Kamion> [<random>agreed; dunno what origin does but non-Debian bugs fields would be bad]
115 o rhona should make use of select..except select, temporary tables
116 etc. rather than looping and calling SQL every time so we can do
117 suite removal sanely (see potato-removal document)
119 o melanie will happily include packages in the Cc list that aren't
122 o melanie doesn't remove udebs when removing the source they build from
124 o check_dsc_against_db's "delete an entry from files while you're
125 not looking" habit is Evil and Bad.
127 o lisa allows you to edit the section and change the component, but
130 o melanie needs to, when not sending bug close mails, promote Cc: to
131 To: and send the mail anyways.
133 o the lockfile (Archive_Maintenance_In_Progress) should probably be in a conf file
135 o madison should cross-check the b.source field and if it's not null
136 and s.name linked from it != the source given in
137 -S/--source-and-binary ignore.
139 o lauren sucks; she should a) only spam d-i for sourceful
140 rejections, b) sort stuff so she rejects sourceful stuff first. the
141 non-sourceful should probably get a form mail, c) automate the
142 non-sourceful stuff (see b).
144 o jennifer should do q-d stuff for faster AA [ryan]
146 o split the morgue into source and binary so binaries can be purged first!
148 o per-architecture priorities for things like different arch'es
149 gcc's, silly BSD libftw, palo, etc.
151 o use postgres 7.2's built-in stat features to figure out how indices are used etc.
153 o neve shouldn't be using location, she should run down suites instead
155 o halle needs to know about udebs
157 o by default hamstring katie's mail sending so that she won't send
158 anything until someone edits a script; she's been used far too
159 much to send spam atm :(
161 o $ftpdir/indices isn't created by rose because it's not in katie.conf
163 o sanity check depends/recommends/suggests too? in fact for any
166 [minor] kelly's copychanges, copykatie handling sucks, the per-suite
167 thing is static for all packages, so work out in advance dummy.
169 [madison] # filenames ?
170 [madison] # maintainer, component, install date (source only?), fingerprint?
172 o UrgencyLog stuff should minimize it's bombing out(?)
173 o Log stuff should open the log file
175 o helena should footnote the actual notes, and also * the versions
176 with notes so we can see new versions since being noted...
178 o helena should have alternative sorting options, including reverse
179 and without or without differentiaion.
181 o julia should sync debadmin and ftpmaster (?)
183 o <drow> Can't read file.:
184 /org/security.debian.org/queue/accepted/accepted/apache-perl_1.3.9-14.1-1.21.20000309-1_sparc.katie.
185 You assume that the filenames are relative to accepted/, might want
188 o <neuro> the orig was in NEW, the changes that caused it to be NEW
189 were pulled out in -2, and we end up with no orig in the archive
192 o SecurityQueueBuild doesn't handle the case of foo_3.3woody1
193 with a new .orig.tar.gz followed by a foo_3.3potato1 with the same
194 .orig.tar.gz; jennifer sees it and copes, but the AA code doesn't
195 and can't really easily know so the potato AA dir is left with no
196 .orig.tar.gz copy. doh.
198 o orig.tar.gz in accepted not handled properly (?)
200 o amber doesn't include .orig.tar.gz but it should
202 o permissions (paranoia, group write, etc.) configurability and overhaul
204 o remember duplicate copyrights in lisaand skip them, per package
206 o <M>ove option for lisa byhand proecessing
208 o rene could do with overrides
210 o db_access.get_location_id should handle the lack of archive_id properly
212 o the whole versioncmp thing should be documented
214 o lisa doesn't do the right thing with -2 and -1 uploads, as you can
215 end up with the .orig.tar.gz not in the pool
217 o lisa exits if you check twice (aj)
219 o lisa doesn't trap signals from fernanda properly
221 o queued and/or perl on sparc stable sucks - reimplement it.
223 o aj's bin nmu changes
226 * priority >> optional
228 * build-depends wrong (via andrea)
231 * notification/stats to admin daily
232 o trap fernanda exiting
233 o distinguish binary only versus others (neuro)
235 o cache changes parsed from ordering (careful tho: would be caching
236 .changes from world writable incoming, not holding)
238 o katie doesn't recognise binonlyNMUs correctly in terms of telling
239 who their source is; source-must-exist does, but the info is not
242 o Fix BTS vs. katie sync issues by queueing(via BSMTP) BTS mail so
243 that it can be released on deman (e.g. ETRN to exim).
245 o maintainers file needs overrides
247 [ change override.maintainer to override.maintainer-from +
248 override.maintainer-to and have them reference the maintainers
249 table. Then fix charisma to use them and write some scripting
250 to handle the Santiago situation. ]
252 o Validate Depends (et al.) [it should match \(\s*(<<|<|<=|=|>=|>|>>)\s*<VERSIONREGEXP>\)]
254 o Clean up DONE; archive to tar file every 2 weeks, update tar tvzf INDEX file.
256 o testing-updates suite: if binary-only and version << version in
257 unstable and source-ver ~= source-ver in testing; then map
258 unstable -> testing-updates ?
260 o hooks or configurability for debian specific checks (e.g. check_urgency, auto-building support)
262 o morgue needs auto-cleaning (?)
264 o saffron: two modes, all included, seperate
265 o saffron: add non-US
266 o saffron: add ability to control components, architectures, archives, suites
267 o saffron: add key to expand header
269 ================================================================================
274 o What to do with multi-suite uploads? Presumably hold in unapproved
275 and warn? Or what? Can't accept just for unstable or reject just
278 o Whenever we check for anything in accepted we also need to check in
281 o non-sourceful uploads should go straight through if they have
282 source in accepted or the archive.
284 o security uploads on auric should be pre-approved.
286 ================================================================================
291 o change utils.copy to try rename() first
293 o [hard, long term] unchecked -> accepted should go into the db, not
294 a suite, but similar. this would allow katie to get even faster,
295 make madison more useful, decomplexify specialacceptedautobuild
296 and generally be more sane. may even be helpful to have e.g. new
297 in the DB, so that we avoid corner cases like the .orig.tar.gz
298 disappearing 'cos the package has been entirely removed but was
299 still on stayofexecution when it entered new.
301 o Logging [mostly done] (todo: rhona (hard), .. ?)
303 o jennifer: the tar extractor class doesn't need to be redone for each package
305 o reverse of source-must-exist; i.e. binary-for-source-must-not-exist
306 o REJECT reminders in shania.
307 o fernanda should check for conflicts and warn about them visavis priority [rmurray]
308 o store a list of removed/files versions; also compare against them.
309 [but be careful about scalability]
311 o fernanda: print_copyright should be a lot more intelligent
312 @ handle copyright.gz
313 @ handle copyright.ja and copyright
314 @ handle (detect at least) symlinks to another package's doc directory
315 @ handle and/or fall back on source files (?)
317 o To incorporate from utils:
320 o auto-purge out-of-date stuff from non-free/contrib so that testing and stuff works
321 o doogie's binary -> source index
322 o jt's web stuff, matt's changelog stuff (overlap)
324 o [Hard] Need to merge non-non-US and non-US DBs.
326 o experimental needs to auto clean (relative to unstable) [partial: rene warns about this]
328 o Do a checkpc(1)-a-like which sanitizes a config files.
329 o fix parse_changes()/build_file_list() to sanity check filenames
330 o saftey check and/or rename debs so they match what they should be
333 o Need to optimize all the queries by using EXAMINE and building some INDEXs.
334 [postgresql 7.2 will help here]
335 o Need to enclose all the setting SQL stuff in transactions (mostly done).
336 o Need to finish alyson (a way to sync katie.conf and the DB)
337 o Need the ability to rebuild all other tables from dists _or_ pools (in the event of disaster) (?)
338 o Make the --help and --version options do stuff for all scripts
340 o charisma can't handle whitespace-only lines (for the moment, this is feature)
342 o generic way of saying isabinary and isadsc. (?)
344 o s/distribution/suite/g
347 @ weekly postins to d-c (?)
348 @ backup of report (?)
349 @ backup of changes.tgz (?)
351 o --help doesn't work without /etc/katie/katie.conf (or similar) at
354 o rename andrea (clashes with existing andrea)...
358 o interrupting of stracing jennifer causes exceptions errors from apt_inst calls
359 o dependency checking (esp. stable) (partially done)
360 o override checks sucks; it needs to track changes made by the
361 maintainer and pass them onto ftpmaster instead of warning the
363 o need to do proper rfc822 escaping of from lines (as opposed to s/\.//g)
364 o Revisit linking of binary->source in install() in katie.
365 o Fix component handling in overrides (aj)
366 o Fix lack of entires in source overrides (aj)
367 o direport misreports things as section 'devel' (? we don't use direport)
368 o vrfy check of every Maintainer+Changed-By address; valid for 3 months.
369 o binary-all should be done on a per-source, per-architecture package
370 basis to avoid, e.g. the perl-modules problem.
371 o a source-missing-diff check: if the version has a - in it, and it
372 is sourceful, it needs orig and diff, e.g. if someone uploads
373 esound_0.2.22-6, and it is sourceful, and there is no diff ->
374 REJECT (version has a dash, therefore not debian native.)
375 o check linking of .tar.gz's to .dsc's.. see proftpd 1.2.1 as an example
376 o archive needs md5sum'ed regularly, but takes too long to do all
377 in one go; make progressive or weekly.
378 o katie/jenna/rhona/whatever needs to clear out .changes
379 files from p-u when removing stuff superseded by newer versions.
380 [but for now we have halle]
381 o test sig checking stuff in test/ (stupid thing is not modularized due to global abuse)
382 o when encountering suspicous things (e.g. file tainting) do something more drastic
386 o suite mapping and component mapping are parsed per changes file,
387 they should probably be stored in a dictionary created at startup.
388 o don't stat/md5sum files you have entries for in the DB, moron
389 boy (Katie.check_source_blah_blah)
390 o promote changes["changes"] to mandatory in katie.py(dump_vars)
391 after a month or so (or all .katie files contain in the queue
393 o melanie should behave better with -a and without -b; see
394 gcc-defaults removal for an example.
395 o Reject on misconfigured kernel-package uploads
396 o utils.extract_component_from_section: main/utils -> main/utils, main rather than utils, main
397 o Fix jennier to warn if run when not in incoming or p-u
398 o katie should validate multi-suite uploads; only possible valid one
400 o cron.daily* should change umask (aj sucks)
401 o Rene doesn't look at debian-installer but should.
402 o Rene needs to check for binary-less source packages.
403 o Rene could accept a suite argument (?)
404 o byhand stuff should send notification
405 o catherine should udpate db; move files, not the other way around [neuro]
406 o melanie should update the stable changelog [joey]
411 o drop rather dubious currval stuff (?)
412 o rationalize os.path.join() usage
413 o Rene also doesn't seem to warn about missing binary packages (??)
414 o logging: hostname + pid ?
415 o ANAIS should be done in katie (?)
416 o Add an 'add' ability to melanie (? separate prog maybe)
417 o Replicate old dinstall report stuff (? needed ?)
418 o Handle the case of 1:1.1 which would overwrite 1.1 (?)
419 o maybe drop -r/--regex in madison, make it the default and
420 implement -e/--exact (a la joey's "elmo")
421 o dsc files are not checked for existence/perms (only an issue if
422 they're in the .dsc, but not the .changes.. possible?)
426 o db_access' get_files needs to use exceptions not this None, > 0, < 0 return val BS (?)
427 o The untouchable flag doesn't stop new packages being added to ``untouchable'' suites
429 ================================================================================
434 o Fix stuff to look in sensible places for libs and config file in debian package (?)
436 ================================================================================
439 -----------------------------------------------------------------------------
472 ================================================================================
474 Random useful-at-some-point SQL
475 -------------------------------
477 UPDATE files SET last_used = '1980-01-01'
478 FROM binaries WHERE binaries.architecture = <x>
479 AND binaries.file = files.id;
481 DELETE FROM bin_associations
482 WHERE EXISTS (SELECT id FROM binaries
483 WHERE architecture = <x>
484 AND id = bin_associations.bin);
486 ================================================================================