[solved] Slow operation and a large number of errors in the log file. (1 Viewer)

[ajs]

Slow operation and a large number of errors in the log file.
30min -> ~ 600Mb log file.

2016-04-10 20:59:13.775 [INFO][01]: parsing of CREATE TABLE failed!!!
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
2016-04-10 20:59:13.807 [INFO][01]: parsing of CREATE TABLE failed!!!
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
2016-04-10 20:59:13.838 [INFO][01]: parsing of CREATE TABLE failed!!!

 

[ltfearme]

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.

 

[ajs]

Something has made a change to your database such that there is a duplicate column name. Fix it and it should go away.

I checked, there are no duplicate fields in the database.

If you have no idea, then just delete 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.

 

[ajs]

@ltfearme
SELECT * FROM options WHERE property LIKE 'DB%Version'

option_id    property    value
103    DBSeriesVersion    15
104    DBSeasonVersion    5
105    DBEpisodesVersion    9
106    DBIgnoredDownloadedFilesVersion    1
108    dbTorrentVersion    2
109    DBViewsVersion    5
110    DBNewzbinVersion    4
111    DBReplacementsVersion    6
128    DBUserSelectionsVersion    3
146    DBExpressionsVersion    5

SELECT sql FROM sqlite_master WHERE name='season'

CREATE TABLE [season] (
  [ID] String,
  [SeriesID] Int,
  [SeasonIndex] Int,
  [BannerFileNames] String,
  [CurrentBannerFileName] String,
  [HasLocalFiles] Int,
  [HasLocalFilesTemp] Int,
  [HasOnlineEpisodes] Int,
  [HasOnlineEpisodesTemp] Int,
  [Hidden] Int,
  [ForomSubtitleRoot] String,
  [UnwatchedItems] Int,
  [EpisodeCount] Int,
  [EpisodesUnWatched] Int,
  [Summary] String,
  [Title] String,
  [Rating] String,
  [RatingCount] Int,
  [myRating] String,
  [myRatingAt] String,
  CONSTRAINT [sqlite_autoindex_season_1] PRIMARY KEY ([ID]))