Purging Old Test Runs

Wednesday, April 24, 2019
Avatar

Just wondering if there are others out there that have experienced the same problem as me, and if so do you have a solution?

We are now approaching the 3 million test run mark and would really appreciate a script to purge old runs.

Manually deleting test runs is a pain to say the least and attempting to create a script is asking for trouble.

I mentioned this to Inflectra a good while back and was told they were looking in to it as they have the same problem when running automated tests.

Cheers.

2 Replies
Tuesday, April 30, 2019
Avatar
re: sedavbe Wednesday, April 24, 2019

Hi

One of the reasons why it's tricky is that the execution status of the test cases, requirement, test sets, and releases is all derived from the test runs. If you purge a bunch of old test runs you may potentially set test cases back to 'Not Run'.

One idea we had is to delete all but the most recent test run that matches any specific unique combination of test set, test case, custom properties, release, etc. but then you have test configurations, so even that may not be correct anymore....

Regards

Jim

Monday, May 6, 2019
Avatar
re: inflectra.jimx Tuesday, April 30, 2019

Thanks for the response Jim, I understand its a tricky issue but none the less its not going to dissapear and the longer your customers stay loyal the more will be wondering how to do this in a more efficient manner as data grows.

In our  own application we've adopted a background process approach for purging unwanted/deprecated records, the proces is highly parameterized and with the possibility to schedule.

I think this would be a good approach even for Spira.

Just my thoughts.

/David

Statistics
  • Started: Wednesday, April 24, 2019
  • Last Reply: Monday, May 6, 2019
  • Replies: 2
  • Views: 146