Build Cleanup not Working

Actually, it is working too well. I'm losing most of my builds, even one's that have been pinned.

My cleanup policy is:

]]> keep history for 15 days but not less than 15 builds

I'll try and get more complete details and file a Jira issue, just wanted to see if anyone else was seeing this.

--Tim

8 comments
Comment actions Permalink

Here is one of the cleanup log entries:

INFO - pl.cleanup.HistoryEntryCleaner - Deleting history entries: DELETE FROM history WHERE PIN=FALSE AND START_TIME < 1160269453000 AND BUILD_TYPE_ID='tr7'

That looks like the cleanup time is Sat Oct 07 18:04:13 PDT 2006, which is still eleven hours away. Pretty much everything is going to get cleaned up from there.

The previous entry for the id is:

INFO - pl.cleanup.HistoryEntryCleaner - Deleting history entries: DELETE FROM history WHERE PIN=FALSE AND START_TIME < 1158887053000 AND BUILD_TYPE_ID='tr7'

Which gives us Thu Sep 21 18:04:13 PDT 2006, which seems much more reasonable.

I'm using MySQL if that matters.

--Tim

0
Comment actions Permalink

Are there any log entries from the history cleaner without the "PIN=FALSE" clause?

--
Best regards,
Eugene Zhuravlev
Software Developer
JetBrains Inc.
http://www.jetbrains.com
"Develop with pleasure!"


0
Comment actions Permalink

Also, it is possible to have a look at the contents of the table 'history'?

--
Best regards,
Eugene Zhuravlev
Software Developer
JetBrains Inc.
http://www.jetbrains.com
"Develop with pleasure!"


0
Comment actions Permalink

There are no entries without "PIN=FALSE" in the log. The date is obviously wrong on that one entry. I grab the log of all the entries.

I sent the history table to Kirill (don't have your email and didn't want to post it). It contains 34 entries. It was taken the morning after the "cleanup" (Saturday, I believe). I can send the current if necessary.

--Tim

0
Comment actions Permalink

Could it be so, that you removed a build configuration or edited manually config files and removed/renamed the configuration with
id="tr7"?
If so configurtation with id="tr7" is considered removed and all history entries for this configuration are deleted on db cleanup

--
Best regards,
Eugene Zhuravlev
Software Developer
JetBrains Inc.
http://www.jetbrains.com
"Develop with pleasure!"



"Tim McNerney" <intellij@oneofus.org> wrote in message news:27136140.1160400290853.JavaMail.itn@is.intellij.net...

There are no entries without "PIN=FALSE" in the log. The date is obviously wrong on that one entry. I grab the log of all the
entries.

>

I sent the history table to Kirill (don't have your email and didn't want to post it). It contains 34 entries. It was taken the
morning after the "cleanup" (Saturday, I believe). I can send the current if necessary.

>

--Tim



0
Comment actions Permalink

One correction: by renaming I meant changing configuration id, not name.

"Eugene Zhuravlev (JetBrains)" <jeka@intellij.com> wrote in message news:egg3tl$2j5$1@is.intellij.net...

Could it be so, that you removed a build configuration or edited manually config files and removed/renamed the configuration with
id="tr7"?
If so configurtation with id="tr7" is considered removed and all history entries for this configuration are deleted on db cleanup

>

--
Best regards,
Eugene Zhuravlev
Software Developer
JetBrains Inc.
http://www.jetbrains.com
"Develop with pleasure!"

>
>
>

"Tim McNerney" <intellij@oneofus.org> wrote in message news:27136140.1160400290853.JavaMail.itn@is.intellij.net...

>> There are no entries without "PIN=FALSE" in the log. The date is obviously wrong on that one entry. I grab the log of all the
>> entries.
>>
>> I sent the history table to Kirill (don't have your email and didn't want to post it). It contains 34 entries. It was taken the
>> morning after the "cleanup" (Saturday, I believe). I can send the current if necessary.
>>
>> --Tim
>



0
Comment actions Permalink

I've had to change my configurations by hand to get a unique id (I've been using the same configs since early on and cleaning my DB, so whatever mechanism it uses to name instances gets wonky and I end up with duplicates).

But these changes happened some time ago and so all of the history entries have good values that correspond to the configs.

And even if I had a mismatch, wouldn't that leave builds around and not delete them? The config is in the where clause and should prevent deletion if incorrect.

The thing I'm concerned about was the date that appeared that was after the cleanup ran. That just ain't right. And though the PIN issue is puzzling, I'm not surprised about the rest of the builds getting cleaned up from the command used.

I've opened an issue and have the list of all cleanup entries (keep in mind that I disabled cleanup on the 7th). Also, I had set the cleanup to 10 days part way through.

http://www.jetbrains.net/jira/browse/TW-940


--Tim

0
Comment actions Permalink

Hello,

Thank you for your feedback.
Please see my comments for issue
http://www.jetbrains.net/jira/browse/TW-940.

--
Pavel Sher

"Tim McNerney" <intellij@oneofus.org> wrote in message
news:3781669.1160488713128.JavaMail.itn@is.intellij.net...

I've had to change my configurations by hand to get a unique id (I've been
using the same configs since early on and cleaning my DB, so whatever
mechanism it uses to name instances gets wonky and I end up with
duplicates).

>

But these changes happened some time ago and so all of the history entries
have good values that correspond to the configs.

>

And even if I had a mismatch, wouldn't that leave builds around and not
delete them? The config is in the where clause and should prevent deletion
if incorrect.

>

The thing I'm concerned about was the date that appeared that was after
the cleanup ran. That just ain't right. And though the PIN issue is
puzzling, I'm not surprised about the rest of the builds getting cleaned
up from the command used.

>

I've opened an issue and have the list of all cleanup entries (keep in
mind that I disabled cleanup on the 7th). Also, I had set the cleanup to
10 days part way through.

>

http://www.jetbrains.net/jira/browse/TW-940

>
>

--Tim



0

Please sign in to leave a comment.