Jump to content

Scedules direct fails to retrieve data


Smaky

Recommended Posts

Emby 4.4.0.9 running under ReadyNAS OS 6.10.2 fails to retrieve schedules information from schedulesdirect.

 

I have setup LiveTV's guide provider to my schedules direct account (the very same way I have it setup in a PC box and Synology Box running Emby). While no error is thrown while configuring it, no guide data is displayed. Relevant entries in the log show an error happeing while pulling rhe info from schedules direct.

2020-01-25 10:05:08.288 Info App: Channel Station ID is: 85572
2020-01-25 10:05:08.288 Info HttpClient: POST https://json.schedulesdirect.org/20141201/schedules
2020-01-25 10:05:08.495 Info HttpClient: POST https://json.schedulesdirect.org/20141201/programs
2020-01-25 10:05:08.716 Info HttpClient: POST https://json.schedulesdirect.org/20141201/metadata/programs
2020-01-25 10:05:09.040 Error LiveTvManager: Error getting programs for channel XHIMT
	*** Error Report ***
	Version: 4.4.0.9
	Command line: /apps/emby-server/system/EmbyServer.dll -programdata /home/emby -ffdetect /apps/emby-server/bin/ffdetect -ffmpeg /apps/emby-server/bin/ffmpeg -ffprobe /apps/emby-server/bin/ffprobe -restartexitcode 3 -updatepackage emby-server-netgear_{version}_amd64.deb
	Operating system: Unix 4.4.184.86
	64-Bit OS: True
	64-Bit Process: True
	User Interactive: True
	Runtime: file:///apps/emby-server/system/System.Private.CoreLib.dll
	System.Environment.Version: 3.1.0
	Processor count: 4
	Program data path: /home/emby
	Application directory: /apps/emby-server/system
	SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.StatementImpl.MoveNext()
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItem(IDatabaseConnection db, BaseItem item, Int64 topParentId, Int64 userDataKeyId, IStatement insertItemStatement, IStatement updateItemStatement)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItemsInTranscation(IDatabaseConnection db, List`1 tuples)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.Library.LibraryManager.CreateItems(List`1 items, BaseItem parent, CancellationToken cancellationToken)
	   at Emby.LiveTV.LiveTvManager.RefreshChannelsInternal(ILiveTvService service, IProgress`1 progress, CancellationToken cancellationToken)
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCL.sqlite3, Int32)
	
2020-01-25 10:05:09.040 Info App: Channel Station ID is: 101373
2020-01-25 10:05:09.040 Info HttpClient: POST https://json.schedulesdirect.org/20141201/schedules
2020-01-25 10:05:09.244 Info HttpClient: POST https://json.schedulesdirect.org/20141201/programs
2020-01-25 10:05:09.373 Info HttpClient: POST https://json.schedulesdirect.org/20141201/metadata/programs
2020-01-25 10:05:09.618 Error LiveTvManager: Error getting programs for channel XHIMT
	*** Error Report ***
	Version: 4.4.0.9
	Command line: /apps/emby-server/system/EmbyServer.dll -programdata /home/emby -ffdetect /apps/emby-server/bin/ffdetect -ffmpeg /apps/emby-server/bin/ffmpeg -ffprobe /apps/emby-server/bin/ffprobe -restartexitcode 3 -updatepackage emby-server-netgear_{version}_amd64.deb
	Operating system: Unix 4.4.184.86
	64-Bit OS: True
	64-Bit Process: True
	User Interactive: True
	Runtime: file:///apps/emby-server/system/System.Private.CoreLib.dll
	System.Environment.Version: 3.1.0
	Processor count: 4
	Program data path: /home/emby
	Application directory: /apps/emby-server/system
	SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.StatementImpl.MoveNext()
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItem(IDatabaseConnection db, BaseItem item, Int64 topParentId, Int64 userDataKeyId, IStatement insertItemStatement, IStatement updateItemStatement)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItemsInTranscation(IDatabaseConnection db, List`1 tuples)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.Library.LibraryManager.CreateItems(List`1 items, BaseItem parent, CancellationToken cancellationToken)
	   at Emby.LiveTV.LiveTvManager.RefreshChannelsInternal(ILiveTvService service, IProgress`1 progress, CancellationToken cancellationToken)
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCL.sqlite3, Int32)
	
2020-01-25 10:05:09.761 Error LiveTvManager: Error getting programs for channel XHFAMX
	*** Error Report ***
	Version: 4.4.0.9
	Command line: /apps/emby-server/system/EmbyServer.dll -programdata /home/emby -ffdetect /apps/emby-server/bin/ffdetect -ffmpeg /apps/emby-server/bin/ffmpeg -ffprobe /apps/emby-server/bin/ffprobe -restartexitcode 3 -updatepackage emby-server-netgear_{version}_amd64.deb
	Operating system: Unix 4.4.184.86
	64-Bit OS: True
	64-Bit Process: True
	User Interactive: True
	Runtime: file:///apps/emby-server/system/System.Private.CoreLib.dll
	System.Environment.Version: 3.1.0
	Processor count: 4
	Program data path: /home/emby
	Application directory: /apps/emby-server/system
	SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.StatementImpl.MoveNext()
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItem(IDatabaseConnection db, BaseItem item, Int64 topParentId, Int64 userDataKeyId, IStatement insertItemStatement, IStatement updateItemStatement)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItemsInTranscation(IDatabaseConnection db, List`1 tuples)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.Library.LibraryManager.UpdateItems(List`1 items, BaseItem parent, ItemUpdateType updateReason, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.Library.LibraryManager.UpdateItem(BaseItem item, BaseItem parent, ItemUpdateType updateReason)
	   at MediaBrowser.Controller.Entities.BaseItem.UpdateToRepository(ItemUpdateType updateReason)
	   at MediaBrowser.Providers.Manager.MetadataService`2.SaveItem(MetadataResult`1 result, LibraryOptions libraryOptions, ItemUpdateType reason, CancellationToken cancellationToken)
	   at MediaBrowser.Providers.Manager.MetadataService`2.RefreshMetadata(BaseItem item, MetadataRefreshOptions refreshOptions, CancellationToken cancellationToken)
	   at MediaBrowser.Controller.Entities.BaseItem.RefreshMetadata(MetadataRefreshOptions options, CancellationToken cancellationToken)
	   at Emby.LiveTV.LiveTvManager.RefreshChannelsInternal(ILiveTvService service, IProgress`1 progress, CancellationToken cancellationToken)
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCL.sqlite3, Int32)

Found this other error...

2020-01-25 10:12:31.674 Info App: Channel Station ID is: 99065
2020-01-25 10:12:31.674 Info HttpClient: POST https://json.schedulesdirect.org/20141201/schedules
2020-01-25 10:12:31.886 Info HttpClient: POST https://json.schedulesdirect.org/20141201/programs
2020-01-25 10:12:31.997 Info HttpClient: POST https://json.schedulesdirect.org/20141201/metadata/programs
2020-01-25 10:12:32.101 Error LiveTvManager: Error getting programs for channel XHHCUHD
	*** Error Report ***
	Version: 4.4.0.9
	Command line: /apps/emby-server/system/EmbyServer.dll -programdata /home/emby -ffdetect /apps/emby-server/bin/ffdetect -ffmpeg /apps/emby-server/bin/ffmpeg -ffprobe /apps/emby-server/bin/ffprobe -restartexitcode 3 -updatepackage emby-server-netgear_{version}_amd64.deb
	Operating system: Unix 4.4.184.86
	64-Bit OS: True
	64-Bit Process: True
	User Interactive: True
	Runtime: file:///apps/emby-server/system/System.Private.CoreLib.dll
	System.Environment.Version: 3.1.0
	Processor count: 4
	Program data path: /home/emby
	Application directory: /apps/emby-server/system
	SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.StatementImpl.MoveNext()
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItem(IDatabaseConnection db, BaseItem item, Int64 topParentId, Int64 userDataKeyId, IStatement insertItemStatement, IStatement updateItemStatement)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItemsInTranscation(IDatabaseConnection db, List`1 tuples)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.Library.LibraryManager.CreateItems(List`1 items, BaseItem parent, CancellationToken cancellationToken)
	   at Emby.LiveTV.LiveTvManager.RefreshChannelsInternal(ILiveTvService service, IProgress`1 progress, CancellationToken cancellationToken)
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCL.sqlite3, Int32)
	
2020-01-25 10:12:32.104 Info App: Removing item from database, Type: LiveTvChannel, Name: XHPTPHD, Path: , Id: 8487
2020-01-25 10:12:32.104 Info App: Deleting path /home/emby/metadata/livetv/d236cd6a33d8f4ad838ec00790405ed7/metadata
2020-01-25 10:12:35.363 Info HttpServer: HTTP GET http://smakytaky.synology.me:8096/emby/ScheduledTasks?IsEnabled=true. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36
2020-01-25 10:12:35.366 Info HttpServer: HTTP Response 200 to 189.130.239.167. Time: 2ms. http://smakytaky.synology.me:8096/emby/ScheduledTasks?IsEnabled=true
2020-01-25 10:12:35.369 Info HttpServer: HTTP GET http://smakytaky.synology.me:8096/emby/ScheduledTasks?IsEnabled=true. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36
2020-01-25 10:12:35.371 Info HttpServer: HTTP Response 200 to 189.130.239.167. Time: 2ms. http://smakytaky.synology.me:8096/emby/ScheduledTasks?IsEnabled=true
2020-01-25 10:12:36.364 Info HttpServer: HTTP GET http://smakytaky.synology.me:8096/emby/ScheduledTasks?IsEnabled=true. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36
2020-01-25 10:12:36.366 Info HttpServer: HTTP Response 200 to 189.130.239.167. Time: 2ms. http://smakytaky.synology.me:8096/emby/ScheduledTasks?IsEnabled=true
2020-01-25 10:12:37.358 Info HttpServer: HTTP GET http://smakytaky.synology.me:8096/emby/ScheduledTasks?IsEnabled=true. UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36
2020-01-25 10:12:37.360 Info HttpServer: HTTP Response 200 to 189.130.239.167. Time: 2ms. http://smakytaky.synology.me:8096/emby/ScheduledTasks?IsEnabled=true
2020-01-25 10:12:38.350 Error TaskManager: Error
	*** Error Report ***
	Version: 4.4.0.9
	Command line: /apps/emby-server/system/EmbyServer.dll -programdata /home/emby -ffdetect /apps/emby-server/bin/ffdetect -ffmpeg /apps/emby-server/bin/ffmpeg -ffprobe /apps/emby-server/bin/ffprobe -restartexitcode 3 -updatepackage emby-server-netgear_{version}_amd64.deb
	Operating system: Unix 4.4.184.86
	64-Bit OS: True
	64-Bit Process: True
	User Interactive: True
	Runtime: file:///apps/emby-server/system/System.Private.CoreLib.dll
	System.Environment.Version: 3.1.0
	Processor count: 4
	Program data path: /home/emby
	Application directory: /apps/emby-server/system
	SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.StatementImpl.MoveNext()
	   at Emby.Server.Implementations.Data.SqliteItemRepository.ExecuteWithStringFormatParam(IDatabaseConnection db, String query, String valueText, Int64[] values)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItemsInTransaction(IDatabaseConnection db, Int64[] ids)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItems(Int64[] ids)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItem(BaseItem item, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.Library.LibraryManager.DeleteItem(BaseItem item, DeleteOptions options, BaseItem parent, Boolean notifyParentItem)
	   at Emby.Server.Implementations.Library.LibraryManager.DeleteItem(BaseItem item, DeleteOptions options, Boolean notifyParentItem)
	   at Emby.LiveTV.LiveTvManager.CleanDeadChannels(Int64[] currentIdList, IProgress`1 progress, CancellationToken cancellationToken)
	   at Emby.LiveTV.LiveTvManager.RefreshChannelsInternal(IProgress`1 progress, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCL.sqlite3, Int32)

Many similar errors shown in the log. Please le me know if a full log is needed to deep dive into this.

Edited by Smaky
Link to comment
Share on other sites

I downloaded the library.db file to my desktop computer and ran an integrity check on it using DB Browser for SQLite. The process raised the very same error:

Result: database disk image is malformed
At line 1:
PRAGMA integrity_check;

Not sure where to go from here.

Link to comment
Share on other sites

You'll need to rename that file and run full scans after starting the server.

 

Typical cause for that is abruptly stopping the server process by killing it, turning off the Nas in the middle of operations, etc.

Link to comment
Share on other sites

Thanks just did it. I had to delete my library items as they were picked up as Mixed content. Fortunately this NAS only has movies on it so it was not too much. After recreating the library I am running a full scan now.

 

Probably it was caused by a crash of the NAS about a month ago. It is all well now but probably that corrupted the db.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...