Scheduler Database Questions

4 posts, 0 answers
  1. Shane
    Shane avatar
    6 posts
    Member since:
    Aug 2012

    Posted 24 Apr 2013 Link to this post

    Hi, 
     
    I have some questions around access to and maintenance of the Scheduled data in the DB.

    We have been getting a lot of communication dropped error messages in the Test List log at the point of Publishing The Results after a big Test List run has completed.  Firstly I didn't understand exactly where it was "Publishing?", "What?" and "To?". So I cleaned up all the Results folders on the execution/scheduled server ( currently the same machine ) and found that wasn't the case.  I then thought about the DB which gets created when you first configure a Scheduled Server and found the tables which contains the data which gets displayed in the Run Results Viewer.  I then found that in just a few weeks of running Test Lists, the dbo.test_result_d_b sits at 750,000 rows and is currently 5GB in size.  I believe this is causing crashes when trying to synch results to the server and in turn we on occasion have had to reboot the scheduling server to get it up and running again as a result of this

    1. Is there a way to delete this data via the Test Studio UI?
    2. Should we be running some kind of maintenance jobs on here to purge this data?
    3. Also is it possible to delete all the data from the dbo.run_result_d_b table rather than via the Test Studio UI or at least A Select All as sometimes deleting all data is required and taking an absolute age to do it 1 page at a time!! Currently even once per week we can have a build up of 30 - 50 test lists per day which results in 30 odd pages to go through.

    I appreciate any thoughts and help regarding this.

    Thanks
    Shane



  2. Plamen
    Admin
    Plamen avatar
    8 posts

    Posted 29 Apr 2013 Link to this post

    Hello Shane,

    Here's how it works. When you hit "Reload from Server" the result is downloaded as a local file in the Project\Results folder, unless you delete the result from the Scheduling database. When you hit "Delete" the local file is being deleted, but it still resides in the Scheduling database and if you hit "Reload from Server" again the result is again downloaded.

    The point here is that the SchedulingServer is a repository and all the results there are shared between all users. So if you want to delete a result from that repository you should go to Results tab > Scheduling Server ribbon > Manage Results window and do it from there. This will completely delete the run results from the Scheduling database. We really don't recommend manually deleting results directly from the database, because this could lead to unexpected behavior.

    Regards,
    Plamen
    the Telerik team
    Quickly become an expert in Test Studio, check out our new training sessions!
    Test Studio Trainings
  3. Shane
    Shane avatar
    6 posts
    Member since:
    Aug 2012

    Posted 07 May 2013 Link to this post

    Hi Plaman,

    That addresses one of my questions and basically an enhancement request has been added to enable us to select all in one go as currently the Manage Results dialog is far too slow to do this multiple times on a page by page basis.

    Please can you let us know how to remove all the data in the dbo.test_result_d_b as I have found that in just a few weeks of running Test Lists, the dbo.test_result_d_b sits at 750,000 rows and is currently 5GB in size.  How do we remove historic data please?

    Thanks
    Shane
  4. Plamen
    Admin
    Plamen avatar
    8 posts

    Posted 08 May 2013 Link to this post

    Hi Shane,

    Unfortunately I cannot provide you with a safe way to delete the results directly from the database. There are different dependencies that could cause your database to become corrupted if you try to delete them. If you want to delete all results you can create a new datebase and delete the old one.

    Regards,
    Plamen
    the Telerik team
    Quickly become an expert in Test Studio, check out our new training sessions!
    Test Studio Trainings
Back to Top