Corrupted Database?

Channels DVR Server Troubleshooting
#1

Starting on 3/12 I had a video driver issue while playing a game, comp froze and then restarted. I ended having to update my video drivers to get the game to actually display images again.

After that happened I noticed that Channels DVR was constantly restarting the service. I tried uninstalling windows updates, restoring from an earlier database version for Channels DVR and it would just keep restarting. A a couple of minutes after each reinstall of Channels DVR it would start restarting the service for no reason.

image

image

I even tried updating to the most recent and the Beta versions with no luck.

Last night I decided to just do a new install without using a previous database and so for it has worked. But since it is a new database i don't have any of my shows that were recorded and now i would have to setup the passes again.

Is there any way to import the data or does anyone know of a way to get the old databases to work.

#2

What does the Log file show?

C:/programdata/channelsdvr/data/channels-dvr.log

Try deleting the USA* folders in the same directory

#3

Since I've reinstsalled the old log file is gone. I'll resetup with one of my old databases and then take a look at what the log file says.

#4 
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3085: TV\Dr. Phil\Dr. Phil S13E56 2014-11-25 My Father Offered Me as a Maiden Sacrifice to an Alleged Cult Leader 2018-10-12-0900.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3084: TV\The Big Bang Theory\The Big Bang Theory S02E08 2008-11-17 The LizardSpock Expansion 2018-10-12-0030.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3081: TV\2 Broke Girls\2 Broke Girls S06E07 2016-11-14 And the Sophie Doll 2018-10-11-2230.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3079: TV\NCIS\NCIS S15E03 2017-10-10 Exit Strategy 2018-10-11-2200.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3077: TV\The Big Bang Theory\The Big Bang Theory S02E08 2008-11-17 The LizardSpock Expansion 2018-10-11-2130.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3076: TV\NCIS\NCIS S15E02 2017-10-03 Twofer 2018-10-11-2100.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3075: TV\Last Man Standing\Last Man Standing S04E05 2014-10-24 School Merger 2018-10-11-2030.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3074: TV\NCIS\NCIS S15E01 2017-09-26 House Divided 2018-10-11-2000.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3073: TV\The Big Bang Theory\The Big Bang Theory S12E04 2018-10-11 The Tam Turbulence 2018-10-11-2000.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3072: TV\Last Man Standing\Last Man Standing S04E04 2014-10-17 Sinkhole 2018-10-11-2000.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3071: TV\NCIS\NCIS S14E19 2017-03-28 The Wall 2018-10-11-1900.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3068: TV\NCIS\NCIS S03E13 2006-01-17 Deception 2018-10-11-1700.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3065: TV\NCIS\NCIS S03E11 2005-12-13 Model Behavior 2018-10-11-1600.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3064: TV\Dr. Phil\Dr. Phil S17E24 2018-10-11 Assaults and Arrests Troubled Teen Confronts Her Grandma 2018-10-11-1600.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3060: TV\NCIS\NCIS S03E05 2005-10-18 Switch 2018-10-11-1500.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3058: TV\NCIS\NCIS S03E04 2005-10-11 Silver War 2018-10-11-1400.mpg
2019/03/16 16:15:43 [ERR] Failed to load commercial log for file-3056: TV\NCIS\NCIS S03E03 2005-10-04 Mind Games 2018-10-11-1300.mpg
2019/03/16 16:15:43 [DVR] Refreshing metadata for The Big Bang Theory ( ÀrB,)
panic: runtime error: invalid memory address or nil pointer dereference
[signal 0xc0000005 code=0x0 addr=0x10 pc=0x67fde6]

goroutine 80 [running]:
net/http.(*Client).do(0xc00027b1d0, 0x0, 0x0, 0x0, 0x0)
	/home/vagrant/go/src/net/http/client.go:518 +0x96
net/http.(*Client).Do(0xc00027b1d0, 0x0, 0xc000382880, 0x7c, 0x0)
	/home/vagrant/go/src/net/http/client.go:509 +0x3c
github.com/fancybits/channels-server/tms.Api.requestJSON(0x125d4a9, 0x18, 0xc00027b1d0, 0xc001d4d6c0, 0x61, 0x10c6d20, 0xc00234e000, 0x0, 0x0)
	/home/vagrant/channels-server-win64/tms/api.go:64 +0xd0
github.com/fancybits/channels-server/tms.Api.FindSeries(0x125d4a9, 0x18, 0xc00027b1d0, 0xc001d7a070, 0x6, 0x0, 0x3, 0x4)
	/home/vagrant/channels-server-win64/tms/series.go:58 +0x29d
github.com/fancybits/channels-server/dvr.(*Group).RefreshMetadata(0xc00059e870, 0x0)
	/home/vagrant/channels-server-win64/dvr/group.go:179 +0x147
github.com/fancybits/channels-server/dvr.(*Group).BackfillMetadata(0xc00059e870)
	/home/vagrant/channels-server-win64/dvr/group.go:208 +0x46
github.com/fancybits/channels-server/dvr.(*Recorder).RunProcessor(0xc0000a61a0)
	/home/vagrant/channels-server-win64/dvr/recorder.go:432 +0x8f9
created by github.com/fancybits/channels-server/dvr.(*Recorder).Run
	/home/vagrant/channels-server-win64/dvr/recorder.go:149 +0xb0

I get a lot of that. I also just deleted the USA folders in that directory.

#5

Can you email the recorder.db to [email protected]

#6

Just emailed it over.

#7

Thanks for sending that over. I was able to track down and fix the bug. You can update the latest pre-release build with the fix by opening the DVR web UI, holding the SHIFT key on your keyboard, and clicking the Check For Updates button.

After the update completes, try restoring the old backup and it should work.

#8

Looks like it is now working. It's updating the Guide Data and is now showing programs to be recorded. Also, it hasn't restarted..

Thank you very much!!

2 Likes