Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
  • Sign in
S
sickrage
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 27
    • Issues 27
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge Requests 0
    • Merge Requests 0
  • Operations
    • Operations
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
  • SiCKRAGE
  • sickrage
  • Issues
  • #525

Closed
Open
Opened Sep 02, 2020 by KZA@Kensn

tv_shows record not deleted when deleting show

Before submitting your issue:

Enable debug logging from settings in SiCKRAGE then try and reproduce the error

Summary
When deleting a show it appears to work correctly at first, without any errors but after restarting Sickrage the show is back in the list but without episode info, images and so on.

Branch/Commit
SR Version: master / 9.4.222

OS
Windows Server 2016 / Python 3.7.4

Steps to reproduce

  1. Delete a show from SickRage
  2. Restart SickRage
  3. Refresh show list
  4. Show is still there but empty

What is the current bug behavior?
All records related to the show gets deleted in the DB as they should except for the tv_shows table record. I did some minor throubleshooting and tried to delete a faulty record manually, but was blocked due to foreign key missmatch with imdb_info.

What is the expected correct behavior?
The tv_shows record actually gets deleted.

Relevant logs and/or screenshots
2020-09-02 17:35:22 DEBUG::TORNADO::New SHOWQUEUE task 2K5ZB10XE4 added 2020-09-02 17:35:22 DEBUG::SHOWQUEUE-2K5ZB10XE4-REMOVE-SHOW::Worker wVKGZMK7JPB task started... 2020-09-02 17:35:22 INFO::SHOWQUEUE-2K5ZB10XE4-REMOVE-SHOW::Removing show: Spice and Wolf 2020-09-02 17:35:22 DEBUG::SHOWQUEUE-2K5ZB10XE4-REMOVE-SHOW::81178: Saving to database: Spice and Wolf 2020-09-02 17:35:22 INFO::SHOWQUEUE-2K5ZB10XE4-REMOVE-SHOW::Finished removing show: Spice and Wolf 2020-09-02 17:35:22 DEBUG::SHOWQUEUE-2K5ZB10XE4-REMOVE-SHOW::Worker wVKGZMK7JPB task completed... 2020-09-02 17:35:28 DEBUG::SHOWQUEUE::Removing SHOWQUEUE task 2K5ZB10XE4

Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
Reference: SiCKRAGE/sickrage#525