Cancelled schedules not removed from TV database (1 Viewer)

[elliottmc]

Hi,

Whenever you set a series recording and then cancel an episode, an entry is created in the 'canceledschedule' table in the database.

This allows MP to check and not record this one.

The problem is, these are NEVER removed.

With the fix,

https://issues.team-mediaportal.com/browse/MP1-2719

they are removed if they are older than 48 hours.

(in the GIT branch it waits 5 days, but I changed this to 2 days to make it easier to test)

I have provided an installer for only the TV part.

You need to be running 1.9.0 Pre Release, and if you install this over the top, you will add this fix and a few updated tuning details.

We need testers with MSSQL. Already tested with MySQL, but more testing is also good.

Please provide TV logs (TVService.log). You should see line like

[2014-08-29 19:00:12,926] [Log ] [scheduler thread] [DEBUG] - DeleteAllCancelledSeries: Removing 8/27/2014 7:00:00 PM

(the first time you will probably see lots)

It will help if you know how to check the relevant tables in your database.

Because this fix only removes canceledschedules, the only likely regression is that something will record that you didn't want. However, this is for testing, so take your chances!

Please test and report back!

Thanks!

 

[frankteb]

Thanks. Have this bug a long time (since 1.3 as far as I remember). Unfortunally I'm not using 1.9 pre at this moment, so I can't test it.

 

[Lehmden]

Hi.
Running SQLExpress 2014 and will test later, when I'm back home.

 

[Lehmden]

Hi.
Fix seems to work with SQL Express 2014 too...

[2014-09-01 21:06:35,180] [Log ] [scheduler thread] [DEBUG] - DeleteAllCancelledSeries: Removing 08.08.2014 19:25:00

Will try to look into DB later to see if table really is altered

 

[Lehmden]

Hi.
Had a look into the DB itself. Oldest entry in table is from 2014-08-31 04:25:00.000.
So it's less than 2 days old. With SQL Express 2014 all is working as expected, I think.