[solved] - Slow operation and a large number of errors in the log file.

Discussion in 'My TVSeries' started by ajs, April 10, 2016.

Thread Status:
Not open for further replies.
  1. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,475
    Likes Received:
    2,566
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,494 / 29
    Home Country:
    Ukraine Ukraine
    Show System Specs
    Slow operation and a large number of errors in the log file.
    30min -> ~ 600Mb log file.
    Code (Text):
    1. 2016-04-10 20:59:13.775 [INFO][01]: parsing of CREATE TABLE failed!!!
    2. 2016-04-10 20:59:13.791 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: ID query:ALTER TABLE season ADD ID String', Query = 'ALTER TABLE season ADD ID String'
    3. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: SeriesID query:ALTER TABLE season ADD SeriesID Int', Query = 'ALTER TABLE season ADD SeriesID Int'
    4. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: SeasonIndex query:ALTER TABLE season ADD SeasonIndex Int', Query = 'ALTER TABLE season ADD SeasonIndex Int'
    5. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: BannerFileNames query:ALTER TABLE season ADD BannerFileNames String', Query = 'ALTER TABLE season ADD BannerFileNames String'
    6. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: CurrentBannerFileName query:ALTER TABLE season ADD CurrentBannerFileName String', Query = 'ALTER TABLE season ADD CurrentBannerFileName String'
    7. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: HasLocalFiles query:ALTER TABLE season ADD HasLocalFiles Int', Query = 'ALTER TABLE season ADD HasLocalFiles Int'
    8. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: HasLocalFilesTemp query:ALTER TABLE season ADD HasLocalFilesTemp Int', Query = 'ALTER TABLE season ADD HasLocalFilesTemp Int'
    9. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: HasOnlineEpisodes query:ALTER TABLE season ADD HasOnlineEpisodes Int', Query = 'ALTER TABLE season ADD HasOnlineEpisodes Int'
    10. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: HasOnlineEpisodesTemp query:ALTER TABLE season ADD HasOnlineEpisodesTemp Int', Query = 'ALTER TABLE season ADD HasOnlineEpisodesTemp Int'
    11. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: Hidden query:ALTER TABLE season ADD Hidden Int', Query = 'ALTER TABLE season ADD Hidden Int'
    12. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: ForomSubtitleRoot query:ALTER TABLE season ADD ForomSubtitleRoot String', Query = 'ALTER TABLE season ADD ForomSubtitleRoot String'
    13. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: UnwatchedItems query:ALTER TABLE season ADD UnwatchedItems Int', Query = 'ALTER TABLE season ADD UnwatchedItems Int'
    14. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: EpisodeCount query:ALTER TABLE season ADD EpisodeCount Int', Query = 'ALTER TABLE season ADD EpisodeCount Int'
    15. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: EpisodesUnWatched query:ALTER TABLE season ADD EpisodesUnWatched Int', Query = 'ALTER TABLE season ADD EpisodesUnWatched Int'
    16. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: Summary query:ALTER TABLE season ADD Summary String', Query = 'ALTER TABLE season ADD Summary String'
    17. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: Title query:ALTER TABLE season ADD Title String', Query = 'ALTER TABLE season ADD Title String'
    18. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: Rating query:ALTER TABLE season ADD Rating String', Query = 'ALTER TABLE season ADD Rating String'
    19. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: RatingCount query:ALTER TABLE season ADD RatingCount Int', Query = 'ALTER TABLE season ADD RatingCount Int'
    20. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: myRating query:ALTER TABLE season ADD myRating String', Query = 'ALTER TABLE season ADD myRating String'
    21. 2016-04-10 20:59:13.807 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: myRatingAt query:ALTER TABLE season ADD myRatingAt String', Query = 'ALTER TABLE season ADD myRatingAt String'
    22. 2016-04-10 20:59:13.807 [INFO][01]: parsing of CREATE TABLE failed!!!
    23. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: ID query:ALTER TABLE season ADD ID String', Query = 'ALTER TABLE season ADD ID String'
    24. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: SeriesID query:ALTER TABLE season ADD SeriesID Int', Query = 'ALTER TABLE season ADD SeriesID Int'
    25. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: SeasonIndex query:ALTER TABLE season ADD SeasonIndex Int', Query = 'ALTER TABLE season ADD SeasonIndex Int'
    26. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: BannerFileNames query:ALTER TABLE season ADD BannerFileNames String', Query = 'ALTER TABLE season ADD BannerFileNames String'
    27. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: CurrentBannerFileName query:ALTER TABLE season ADD CurrentBannerFileName String', Query = 'ALTER TABLE season ADD CurrentBannerFileName String'
    28. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: HasLocalFiles query:ALTER TABLE season ADD HasLocalFiles Int', Query = 'ALTER TABLE season ADD HasLocalFiles Int'
    29. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: HasLocalFilesTemp query:ALTER TABLE season ADD HasLocalFilesTemp Int', Query = 'ALTER TABLE season ADD HasLocalFilesTemp Int'
    30. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: HasOnlineEpisodes query:ALTER TABLE season ADD HasOnlineEpisodes Int', Query = 'ALTER TABLE season ADD HasOnlineEpisodes Int'
    31. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: HasOnlineEpisodesTemp query:ALTER TABLE season ADD HasOnlineEpisodesTemp Int', Query = 'ALTER TABLE season ADD HasOnlineEpisodesTemp Int'
    32. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: Hidden query:ALTER TABLE season ADD Hidden Int', Query = 'ALTER TABLE season ADD Hidden Int'
    33. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: ForomSubtitleRoot query:ALTER TABLE season ADD ForomSubtitleRoot String', Query = 'ALTER TABLE season ADD ForomSubtitleRoot String'
    34. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: UnwatchedItems query:ALTER TABLE season ADD UnwatchedItems Int', Query = 'ALTER TABLE season ADD UnwatchedItems Int'
    35. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: EpisodeCount query:ALTER TABLE season ADD EpisodeCount Int', Query = 'ALTER TABLE season ADD EpisodeCount Int'
    36. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: EpisodesUnWatched query:ALTER TABLE season ADD EpisodesUnWatched Int', Query = 'ALTER TABLE season ADD EpisodesUnWatched Int'
    37. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: Summary query:ALTER TABLE season ADD Summary String', Query = 'ALTER TABLE season ADD Summary String'
    38. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: Title query:ALTER TABLE season ADD Title String', Query = 'ALTER TABLE season ADD Title String'
    39. 2016-04-10 20:59:13.822 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: Rating query:ALTER TABLE season ADD Rating String', Query = 'ALTER TABLE season ADD Rating String'
    40. 2016-04-10 20:59:13.838 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: RatingCount query:ALTER TABLE season ADD RatingCount Int', Query = 'ALTER TABLE season ADD RatingCount Int'
    41. 2016-04-10 20:59:13.838 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: myRating query:ALTER TABLE season ADD myRating String', Query = 'ALTER TABLE season ADD myRating String'
    42. 2016-04-10 20:59:13.838 [INFO][01]: SQL Execution Failed. Reason = 'SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: myRatingAt query:ALTER TABLE season ADD myRatingAt String', Query = 'ALTER TABLE season ADD myRatingAt String'
    43. 2016-04-10 20:59:13.838 [INFO][01]: parsing of CREATE TABLE failed!!!



     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. ltfearme
    • Premium Supporter

    ltfearme Community Plugin Dev

    Joined:
    June 10, 2007
    Messages:
    6,448
    Likes Received:
    4,228
    Gender:
    Male
    Occupation:
    Software Test Engineer
    Location:
    Sydney
    Ratings:
    +5,368 / 0
    Home Country:
    Australia Australia
    Something has made a change to your database such that there is a duplicate column name. Fix it and it should go away.

    If you have no idea, then just delete the database.
     
    • Great Idea! Great Idea! x 1
  4. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,475
    Likes Received:
    2,566
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,494 / 29
    Home Country:
    Ukraine Ukraine
    Show System Specs
    I checked, there are no duplicate fields in the database.
    And adjust all over again? It also keeps all the settings plug :(

    I sent you to their database. Can prompt what the problem is.
     
  5. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,475
    Likes Received:
    2,566
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,494 / 29
    Home Country:
    Ukraine Ukraine
    Show System Specs
    @ltfearme
    SELECT * FROM options WHERE property LIKE 'DB%Version'
    Code (Text):
    1. option_id    property    value
    2. 103    DBSeriesVersion    15
    3. 104    DBSeasonVersion    5
    4. 105    DBEpisodesVersion    9
    5. 106    DBIgnoredDownloadedFilesVersion    1
    6. 108    dbTorrentVersion    2
    7. 109    DBViewsVersion    5
    8. 110    DBNewzbinVersion    4
    9. 111    DBReplacementsVersion    6
    10. 128    DBUserSelectionsVersion    3
    11. 146    DBExpressionsVersion    5
    SELECT sql FROM sqlite_master WHERE name='season'
    Code (SQL):
    1. CREATE TABLE [season] (
    2.   [ID] String,
    3.   [SeriesID] INT,
    4.   [SeasonIndex] INT,
    5.   [BannerFileNames] String,
    6.   [CurrentBannerFileName] String,
    7.   [HasLocalFiles] INT,
    8.   [HasLocalFilesTemp] INT,
    9.   [HasOnlineEpisodes] INT,
    10.   [HasOnlineEpisodesTemp] INT,
    11.   [Hidden] INT,
    12.   [ForomSubtitleRoot] String,
    13.   [UnwatchedItems] INT,
    14.   [EpisodeCount] INT,
    15.   [EpisodesUnWatched] INT,
    16.   [Summary] String,
    17.   [Title] String,
    18.   [Rating] String,
    19.   [RatingCount] INT,
    20.   [myRating] String,
    21.   [myRatingAt] String,
    22.   CONSTRAINT [sqlite_autoindex_season_1] PRIMARY KEY ([ID]))
     
Loading...
Thread Status:
Not open for further replies.

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!