2012-12-13, 04:42 AM
I set up an HTPC for my father-in-law with NextPVR installed on Windows XP using a Hauppauge DCR-2650 (although I regret not getting him the HDHomeRun Prime instead) and a Cisco tuning adapter. Unfortunately, I'm seeing SQLiteException (database file locked) everytime there seems to be a DB update. The main symptom that caused me to look into this was the EPG update not appearing to run after initial setup; however, perusing the logs indicates that the EPG update does appear to be taking place -- with listings download -- but they don't appear to be saved in the database, *except* when a manual EPG update is requested from the Settings menu. (I have not used anything to check the database.) When we examined the system last night, we also confirmed that the Recording service was running (both by examining the system tray and the Services control panel).
(1) What causes the SQLiteException? (I feel like sub mentioned a process locking the database and not letting go, but what would cause that?)
(2) Based on the attached logs, does that seem like the likely cause of EPG not being updated automatically?
(3) I asked my father-in-law to reboot the HTPC last night after we made some updates to the config (e.g., disabling "Update DVB EPG during live TV" in Settings: Misc, changing EPG update hour from 2 to 4 in Settings: Misc2), but I didn't talk to him tonight. Does that remove DB locks? Or do they persist beyond the offending process terminating? (I'm not familiar with the SQLite database.) I'd install the Firefox SQLite viewer, but I'm not going to ask someone who isn't a software engineer to make SQL queries remotely...
Thanks to all for your help.
(1) What causes the SQLiteException? (I feel like sub mentioned a process locking the database and not letting go, but what would cause that?)
(2) Based on the attached logs, does that seem like the likely cause of EPG not being updated automatically?
(3) I asked my father-in-law to reboot the HTPC last night after we made some updates to the config (e.g., disabling "Update DVB EPG during live TV" in Settings: Misc, changing EPG update hour from 2 to 4 in Settings: Misc2), but I didn't talk to him tonight. Does that remove DB locks? Or do they persist beyond the offending process terminating? (I'm not familiar with the SQLite database.) I'd install the Firefox SQLite viewer, but I'm not going to ask someone who isn't a software engineer to make SQL queries remotely...
Thanks to all for your help.
[table="width: 500"]
[tr]
[td]HTPC v. 2[/td]
[td]HTPC v. 1[/td]
[/tr]
[tr]
[td]AMD A6-3500[/td]
[td]AMD Athlon 2000+ XP[/td]
[/tr]
[tr]
[td]Gigabyte GA-A75M-UD2H[/td]
[td]ASUS A7V400-MX[/td]
[/tr]
[tr]
[td]AMD Radeon HD 6530D (on-die)[/td]
[td]ATI Radeon 9600 XT[/td]
[/tr]
[tr]
[td]8 GB Corsair DDR3-1600 SDRAM[/td]
[td]512 MB PC-2100 DDR SDRAM[/td]
[/tr]
[tr]
[td]Hauppague HVR-1250 x3[/td]
[td]Hauppauge HVR-1600 x1[/td]
[/tr]
[tr]
[td]Seagate 2TB (Barracuda XT 5900 RPM) HDD[/td]
[td]Seagate 500 GB HDD[/td]
[/tr]
[tr]
[td]nMediaPC 1080p case[/td]
[td]Old Dell mini-tower[/td]
[/tr]
[/table]
[tr]
[td]HTPC v. 2[/td]
[td]HTPC v. 1[/td]
[/tr]
[tr]
[td]AMD A6-3500[/td]
[td]AMD Athlon 2000+ XP[/td]
[/tr]
[tr]
[td]Gigabyte GA-A75M-UD2H[/td]
[td]ASUS A7V400-MX[/td]
[/tr]
[tr]
[td]AMD Radeon HD 6530D (on-die)[/td]
[td]ATI Radeon 9600 XT[/td]
[/tr]
[tr]
[td]8 GB Corsair DDR3-1600 SDRAM[/td]
[td]512 MB PC-2100 DDR SDRAM[/td]
[/tr]
[tr]
[td]Hauppague HVR-1250 x3[/td]
[td]Hauppauge HVR-1600 x1[/td]
[/tr]
[tr]
[td]Seagate 2TB (Barracuda XT 5900 RPM) HDD[/td]
[td]Seagate 500 GB HDD[/td]
[/tr]
[tr]
[td]nMediaPC 1080p case[/td]
[td]Old Dell mini-tower[/td]
[/tr]
[/table]