NextPVR Forums
  • ______
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public NextPVR Support Legacy (v4.x and earlier) v
« Previous 1 … 279 280 281 282 283 … 433 Next »
SQLiteException: Database file locked

SQLiteException: Database file locked
Hoogineer
Offline

Junior Member

Posts: 14
Threads: 3
Joined: Feb 2009
#1
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.
[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]
Graham
Offline

Posting Freak

UK
Posts: 4,058
Threads: 102
Joined: Dec 2005
#2
2012-12-13, 12:25 PM
The nrecord.log contains this ...

Quote:2012-12-11 18:59:02.968 [DEBUG][7] Started recording (911:1:C:\TV\Jeopardy!\Jeopardy!_20121211_19001930.ts)
2012-12-11 18:59:06.500 [DEBUG][8] Deleting old listings from Channel OID: 8491 (MTV2)
2012-12-11 18:59:12.283 [DEBUG][8] Deleting old listings from Channel OID: 8492 (FUSE)
2012-12-11 18:59:15.643 [DEBUG][8] Deleting old listings from Channel OID: 8493 (ANPT)
2012-12-11 18:59:20.050 [DEBUG][8] Deleting old listings from Channel OID: 8494 (truTV)
2012-12-11 18:59:24.380 [DEBUG][8] Deleting old listings from Channel OID: 8495 (HLN)
2012-12-11 18:59:27.740 [DEBUG][8] Deleting old listings from Channel OID: 8496 (SNY)
2012-12-11 18:59:32.694 [DEBUG][8] Deleting old listings from Channel OID: 8497 (N12TW)
2012-12-11 18:59:32.991 [ERROR][7] Unexpected error saving scheduled recording: System.Data.SQLite.SQLiteException: The database file is locked
database is locked

Try scheduling an EPG update to occur when there is no recording scheduled. For what it's worth, I always try and reboot as soon as possible after a database error.
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)



Possibly Related Threads…
Thread Author Replies Views Last Post
  incorrect frequency in adelaide .ini file spin35 5 3,055 2023-02-01, 05:40 PM
Last Post: sub
  ts file shows length too long? SuttonWillow 2 1,925 2021-03-15, 01:56 PM
Last Post: mvallevand
  Unhandled Exception: file name too long (idiots at pbs made it super long) jobby99 1 1,411 2020-10-29, 09:40 PM
Last Post: mvallevand
  ts file shows length too long SamM 4 2,342 2020-10-06, 02:45 AM
Last Post: Ehrlichia
  EPG displaying small subset of xmltv file. Esteban 9 3,028 2020-07-18, 10:07 PM
Last Post: Esteban
  NextPVR's epg database and xml export hugo84 2 2,559 2020-05-31, 12:01 PM
Last Post: hugo84
  Max File Size jrockow 2 1,537 2020-04-21, 02:38 PM
Last Post: jrockow
  Skip causes fast-forward to the end of the file madbrain 9 3,897 2020-02-27, 10:24 PM
Last Post: Esch
  Be notified when EPG (xml file) is empty ? nonob 2 1,428 2020-02-14, 05:00 PM
Last Post: nonob
  Recording extra 0-byte .ts file seeker_ktf 6 2,683 2020-01-25, 08:40 PM
Last Post: seeker_ktf

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Designed by D&D, modified by NextPVR - Powered by MyBB

Linear Mode
Threaded Mode