<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello Pierre!</p>
<p><br>
</p>
<p>Thank you for reply.</p>
<p>Janitor service is interesting idea. I'm going to explore your
solution next week.<br>
</p>
<p><br>
</p>
<p>This feature is not urgent for me, because I have already done
cleanup script with delete operations <br>
</p>
<p>using sqlalchemy.</p>
<p>Later of course it would be great to have janitor service or
cleanup feature in cleanupdb script.<br>
</p>
<br>
<br>
<div class="moz-cite-prefix">On 03/18/2017 05:37 PM, Pierre Tardy
wrote:<br>
</div>
<blockquote
cite="mid:CAJ+soVeAe887qfCOKc7S-kMSj775x+sHh4XGA8TO4UPQhfa-Eg@mail.gmail.com"
type="cite">
<div dir="ltr">Hi Mike,
<div><br>
</div>
<div>This is for me the last big feature that is missing in
buildbot nine.</div>
<div>I have a wip branch here <a moz-do-not-send="true"
href="https://github.com/tardyp/buildbot/commits/janitor">https://github.com/tardyp/buildbot/commits/janitor</a></div>
<div>which has quite ambitious design, but I didn't manage to
find the contiguous time required to finish it properly.</div>
<div><br>
</div>
<div>The goal of that branch is to add a a janitor service which
would implement the logHorizon and buildHorizon features that
eight already had.</div>
<div>There are challenges to be handled in order to implement
that properly including multimaster in the picture.</div>
<div><br>
</div>
<div>Maybe I was too ambitious indeed, and a smaller step would
be to add a cleanup feature to cleanupdb script.</div>
<div>This would indeed require some more API in the db api, but
nothing particularly hard. The script could be easily written
to not require downtime.</div>
<div><br>
</div>
<div>build horizon is a bit more annoying as there is the need
to take care of foreign keys cleanup ( steps, logs, buildset,
buildrequests, sourcestamps )</div>
<div><br>
</div>
<div>Please let me know if you want to take a look at that
feature</div>
<div>Regards,</div>
<div>Pierre<br>
</div>
<div><br>
</div>
<div>
<div class="gmail_quote">
<div dir="ltr">On Fri, Mar 17, 2017 at 9:17 AM Mike Alexeev
<<a moz-do-not-send="true"
href="mailto:mike.42.alexeev@gmail.com">mike.42.alexeev@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr" class="gmail_msg">Hello.
<div class="gmail_msg"><br class="gmail_msg">
</div>
<div class="gmail_msg">I have a question about deleting
old logchunks from DB in buildbot 0.9.</div>
<div class="gmail_msg">Logchunks table is the biggest
and grows quickly even with compression.</div>
<div class="gmail_msg"><br class="gmail_msg">
</div>
<div class="gmail_msg"><br class="gmail_msg">
</div>
<div class="gmail_msg">I haven't found methods in data
api for delete.</div>
<div class="gmail_msg">So I decided to delete logs and
their logchunks using sqlalchemy in cron task.</div>
<div class="gmail_msg">It's not breaks anything as I can
see.</div>
<div class="gmail_msg"><br class="gmail_msg">
</div>
<div class="gmail_msg">Is there better way? </div>
<div class="gmail_msg">Maybe this feature should be
added in cleanupdb and configured in main config?</div>
<div class="gmail_msg">Maybe there should be options for
delete other old records in DB (builds, steps, etc)?</div>
</div>
_______________________________________________<br
class="gmail_msg">
users mailing list<br class="gmail_msg">
<a moz-do-not-send="true" href="mailto:users@buildbot.net"
class="gmail_msg" target="_blank">users@buildbot.net</a><br
class="gmail_msg">
<a moz-do-not-send="true"
href="https://lists.buildbot.net/mailman/listinfo/users"
rel="noreferrer" class="gmail_msg" target="_blank">https://lists.buildbot.net/mailman/listinfo/users</a></blockquote>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>