<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 30.03.2015 20:29, Zack Galbreath
wrote:<br>
</div>
<blockquote
cite="mid:CANgkMA4V=supZdQjjpqsciYUnbzacytsu5WTNK1Si5h8Ja-ESw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">On Mon, Mar 30, 2015 at 1:44 PM, Nils
Gladitz <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:nilsgladitz@gmail.com" target="_blank"
onclick="window.open('https://mail.google.com/mail/?view=cm&tf=1&to=nilsgladitz@gmail.com&cc=&bcc=&su=&body=','_blank');return
false;">nilsgladitz@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span
class=""><br>
</span>
The output is now:<span class=""><br>
-- removing old buildids for projectid: 1<br>
-- removing old buildids for projectid: 1<br>
<br>
</span>
But the size of the table still seems to be unchanged.<span
class=""><font color="#888888"><br>
</font></span></blockquote>
<div><br>
</div>
<div>I'm afraid I don't know why this isn't working for
you. In case you feel like investigating this further,
here's a link to the relevant query that collects up all
the old records that should be deleted:</div>
<div><br>
</div>
<div><a moz-do-not-send="true"
href="https://github.com/Kitware/CDash/pull/36/files#diff-6f95875e9921e6792511bfb61afa94b7R114">https://github.com/Kitware/CDash/pull/36/files#diff-6f95875e9921e6792511bfb61afa94b7R114</a><br>
</div>
<div><br>
</div>
<div>Let me know if you discover anything new.</div>
</div>
</div>
</div>
</blockquote>
<br>
As a matter of fact I was trying that right now :)<br>
<br>
Based on that query I tried the following:<br>
cdash=# SELECT cj.startdate, cj.enddate, cjs.startdate, cjs.enddate,
cjs.repeattime, cj.status FROM client_job AS cj LEFT JOIN
client_jobschedule AS cjs ON cj.scheduleid = cjs.id WHERE
cjs.projectid=1 ORDER BY cj.startdate ASC LIMIT 5;<br>
startdate | enddate | startdate
| enddate | repeattime | status <br>
---------------------+---------------------+---------------------+---------------------+------------+--------<br>
2014-09-05 14:26:16 | 2014-09-05 14:26:16 | 2014-09-05 14:24:46 |
1980-01-01 00:00:00 | 24.00 | 3<br>
2014-09-05 14:27:37 | 2014-09-05 14:27:38 | 2014-09-05 14:26:27 |
1980-01-01 00:00:00 | 24.00 | 3<br>
2014-09-05 14:29:59 | 2014-09-05 14:30:00 | 2014-09-05 14:29:27 |
1980-01-01 00:00:00 | 0.04 | 3<br>
2014-09-05 14:31:20 | 2014-09-05 14:31:21 | 2014-09-05 14:29:27 |
1980-01-01 00:00:00 | 0.04 | 3<br>
2014-09-05 14:32:01 | 2014-09-05 14:32:02 | 2014-09-05 14:31:11 |
1980-01-01 00:00:00 | 24.00 | 3<br>
(5 rows)<br>
<br>
Also:<br>
<br>
cdash=# select count(*) from client_jobschedule WHERE enddate
<> '1980-01-01 00:00:00';<br>
count <br>
-------<br>
0<br>
(1 row)<br>
<span class="pl-s1"><span class="pl-s"><br>
Nils<br>
</span></span>
</body>
</html>