"On Now" Missing (Live TV)

[bmoses 9]

my parents have an emby setup that is almost an exact replica of mine. they have older hdhomerun tuners for live tv running through a windows 7 desktop with serverwmc as the interface for live tv to emby. for some reason a few days ago the "on now" and "latest recordings" lines on emby for android TV (nexus players) keeps disappearing.

 

They open up the emby app and it connects to their desktop server and everything else shows up but the on now and latest recordings sections will display for a second and then go away. we can watch live tv with no issues through the web browser on the desktop the server is running on as well as a laptop.

 

i've tried everything i can think of to try and get this working and i can't figure it out. i'm not sure if its an android tv issue or a server issue so i'm not sure what logs you may need to look at this.

 

they have a non-premier server running the latest stable releases on both the server and the nexus players.

 

if you have any ideas or know what logs would help track this down please let me know and i'll get them posted.

 

thanks!

[ebr 14904]

Sounds like there is an error getting Live TV content.

 

Does it work from the web client?

 

Make sure the user in question has access to Live TV (user access rights).

[bmoses 9]

Sounds like there is an error getting Live TV content.

 

Does it work from the web client?

 

Make sure the user in question has access to Live TV (user access rights).

Yes it works fine in the web client, from both the desktop running the server and a laptop. I'll double check the user access settings but they should be OK since they only have one user and it worked OK on the web client

[ebr 14904]

If you can get them to send a log from the app I might be able to spot something.

 

Instructions are in the "Android TV" section here: How to Report a Problem

[bmoses 9]

If you can get them to send a log from the app I might be able to spot something.

 

Instructions are in the "Android TV" section here: How to Report a Problem

 

double checked the user and everything was good with it. they just submitted a log right after logging into emby, their local username is "moses".

[ebr 14904]

The server is throwing a 500 error trying to retrieve Live TV.  You have the server log from that session?

[bmoses 9]

The server is throwing a 500 error trying to retrieve Live TV.  You have the server log from that session?

 

i attached 3 logs from last night, i believe the test should be in the bigger of the 3.

 

server-63610531200.txt

server-63610597387.txt

server-63610597357.txt

[bmoses 9]

also i just ran a live tv test in the web browser where it worked, here are the logs for that in case you need them to compare too.

 

server-63610617599.txt

ffmpeg-transcode-462ea093-1757-4ae3-aa31-34d7c2365928.txt

[ebr 14904]

It is throwing an error related to the user I think but I also see database corruption being reported during the guide update task which may be the root of the problem:

2016-09-27 07:37:19.8573 Info App: Refreshing guide with 7 days of guide data
2016-09-27 07:37:20.1537 Error SqliteItemRepository: Failed to save children:
	*** Error Report ***
	Version: 3.0.7200.0
	Command line: C:\Users\Brad & Deb Moses\AppData\Roaming\MediaBrowser-Server\System\MediaBrowser.ServerApplication.exe
	Operating system: Microsoft Windows NT 6.1.7601 Service Pack 1
	Processor count: 8
	64-Bit OS: True
	64-Bit Process: True
	Program data path: C:\Users\Brad & Deb Moses\AppData\Roaming\MediaBrowser-Server
	Application Path: C:\Users\Brad & Deb Moses\AppData\Roaming\MediaBrowser-Server\System\MediaBrowser.ServerApplication.exe
	database disk image is malformed
	database disk image is malformed
	System.Data.SQLite.SQLiteException
	   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
	   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
	   at System.Data.SQLite.SQLiteDataReader.NextResult()
	   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
	   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
	   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
	   at MediaBrowser.Server.Implementations.Persistence.SqliteItemRepository.<DeleteItem>d__65.MoveNext()
	
2016-09-27 07:37:20.1537 Error TaskManager: Error
	*** Error Report ***
	Version: 3.0.7200.0
	Command line: C:\Users\Brad & Deb Moses\AppData\Roaming\MediaBrowser-Server\System\MediaBrowser.ServerApplication.exe
	Operating system: Microsoft Windows NT 6.1.7601 Service Pack 1
	Processor count: 8
	64-Bit OS: True
	64-Bit Process: True
	Program data path: C:\Users\Brad & Deb Moses\AppData\Roaming\MediaBrowser-Server
	Application Path: C:\Users\Brad & Deb Moses\AppData\Roaming\MediaBrowser-Server\System\MediaBrowser.ServerApplication.exe
	database disk image is malformed
	database disk image is malformed
	System.Data.SQLite.SQLiteException
	   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
	   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
	   at System.Data.SQLite.SQLiteDataReader.NextResult()
	   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
	   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
	   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
	   at MediaBrowser.Server.Implementations.Persistence.SqliteItemRepository.<DeleteItem>d__65.MoveNext()
	--- End of stack trace from previous location where exception was thrown ---
	   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
	   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
	   at MediaBrowser.Server.Implementations.Library.LibraryManager.<DeleteItem>d__19.MoveNext()
	--- End of stack trace from previous location where exception was thrown ---
	   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
	   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
	   at MediaBrowser.Server.Implementations.LiveTv.LiveTvManager.<CleanDatabaseInternal>d__de.MoveNext()
	--- End of stack trace from previous location where exception was thrown ---
	   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
	   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
	   at MediaBrowser.Server.Implementations.LiveTv.LiveTvManager.<RefreshChannelsInternal>d__b0.MoveNext()
	--- End of stack trace from previous location where exception was thrown ---
	   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
	   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
	   at MediaBrowser.Common.Implementations.ScheduledTasks.ScheduledTaskWorker.<ExecuteInternal>d__b.MoveNext()
	
2016-09-27 07:37:20.1537 Info TaskManager: Refresh Guide Failed after 1 minute(s) and 10 seconds

[bmoses 9]

OK, the guide task has been failing but the information in the guide has been staying current so I didn't think much of it. So with this database corruption what's the best way to fix it without losing watched statuses and what not?

[bmoses 9]

i just checked the other scheduled tasks and the clean database one is failing too. @@Luke is there a good way to fix database issues without losing everything?

[ebr 14904]

I couldn't tell from the error which db had the problem but let's hope it is the library because that is easily re-built (given some time).

 

Shut down the server and delete the library.db file (data folder).  Then re-start the server and wait for it to re-build.

[bmoses 9]

I couldn't tell from the error which db had the problem but let's hope it is the library because that is easily re-built (given some time).

 

Shut down the server and delete the library.db file (data folder).  Then re-start the server and wait for it to re-build.

 

that did the trick, thank you!!!!

[ebr 14904]

Awesome.  Thanks for reporting back.

 

You might want to just be sure that there aren't any drive problems or that you aren't low on space or something - just looking for some reason that the db got corrupted...

[bmoses 9]

the only thing i can think of is i just recently cloned their HDD over to a new SSD. the old HDD was starting to go bad, so it could have either gotten corrupt prior to transferring or during the process.