Database Locked?

stangdaman · 2008-03-31, 04:23 PM

Ok, thanks either way.

stangdaman · 2008-04-09, 05:18 PM

Ok so I went to update my epg today and I'm getting this error again. I've attached the log so you could have a look at it.

***sub*** · 2008-04-09, 05:23 PM

Can you post the complete set of logs? It could be another process that has caused the lock.

stangdaman · 2008-04-09, 05:33 PM

Sure. These are all I could see from today.

stangdaman · 2008-04-09, 05:34 PM

This one too.

***sub*** · 2008-04-09, 05:39 PM

I cant see anything obvious in those logs, but reboot and post the logs next time it happens, then I'll compare the two sets to see if I can find something in common.

Next time zip the entire logs directory into the one zip file (every single file). It makes it much easier to view, and I can easily check the dates on the various files to be sure I'm getting the complete picture.

stangdaman · 2008-04-09, 06:04 PM

I rebooted and it loaded the epg. Thanks for the help.

mkenyon2 · 2008-04-17, 02:34 AM

I'm getting this too:
2008-04-16 22:33:03.031 VERBOSE [1] Looking for capture source to record: Love's Enduring Promise
2008-04-16 22:33:03.031 VERBOSE [1] Possible capture device: DEVICE:Hauppauge PVR150MCE:1
2008-04-16 22:33:03.031 VERBOSE [1] Possible capture device: DEVICE:AVerMedia AVerTV Video Capture (M113 with FM, NTSC):1
2008-04-16 22:33:03.031 VERBOSE [1] Checking 'Hauppauge 150' (DEVICE:Hauppauge PVR150MCE:1)
2008-04-16 22:33:03.031 VERBOSE [1] Checking 'Aver Media' (DEVICE:AVerMedia AVerTV Video Capture (M113 with FM, NTSC):1)
2008-04-16 22:33:03.031 VERBOSE [1] Checking 'Aver Composite' (DEVICE:AVerMedia AVerTV Video Capture (M113 with FM, NTSC):1)
2008-04-16 22:33:03.031 VERBOSE [1] RecordingFactory.save()
2008-04-16 22:33:33.328 ERROR [1] Unabled to save ScheduledRecording: The database file is locked
database is locked
2008-04-16 22:33:33.328 ERROR [1] at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at GBPVR.Backend.Common.x396614b3dae3b1da.xc979432fcc5a510a(ScheduledRecording xe41d2b9d98dc1269)
2008-04-16 22:33:33.328 VERBOSE [1] Requesting recording service schedule reload

***sub*** · 2008-04-17, 02:37 AM

Set <LogSQL>true</LogSQL> in config.xml, then post a complete set of logs next time it happens.

mkenyon2 · (This post was last modified: 2008-06-04, 08:13 PM by mkenyon2.)

Here's the logs.

I go to the show I want to record, set 2 minute paddings, click record, and it goes back to the listing without marking it.

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Huge database (+27GB) - is it a problem?	pme	7	2,650	2011-01-24, 12:37 AM Last Post: gEd
	"database disk image is malformed" during attemped EPG update! (GBPVR v.1.4.7)	DaveA	4	3,118	2011-01-23, 06:35 PM Last Post: DaveA
	GBPVR Database question - Recording Schedule	David B	1	1,470	2010-11-08, 09:21 PM Last Post: sub
	Lost recordings database	keith_leitch	9	3,352	2010-09-22, 09:20 PM Last Post: keith_leitch
	Postprocessing and the recordings database	shsw	1	1,379	2010-08-29, 04:46 PM Last Post: sub
	Lost recordings database	dongna	25	7,043	2010-08-26, 10:00 AM Last Post: martint123
	Strange database problem -- pvrx2 not seeing updates, EWA and Config.exe are.	86atc250r	5	2,120	2010-07-26, 10:09 AM Last Post: martint123
	Cleaning up the database?	Spark	3	1,624	2010-03-28, 07:20 PM Last Post: sub
	database locked error	speising	1	1,058	2010-03-17, 12:45 AM Last Post: sub
	EPG incomplete update - DB locked	pvruser	7	1,772	2010-02-27, 08:08 PM Last Post: sub