Database Locked?

stangdaman · 2008-03-28, 11:57 AM

I'm trying to update my epg using the MCE2xml plugin but I'm getting an error in my logs that state that the database is locked. What is it that I need to do for that?

***sub*** · 2008-03-28, 04:14 PM

Either stop and restart the various GB-PVR processes or reboot.

stangdaman · 2008-03-29, 05:43 AM

I restarted and am still getting the error.

***sub*** · 2008-03-29, 06:26 AM

Set <LogSQL>true</LogSQL> in config.xml, then reboot and reproduce the problem, then zip and attach a complete set of logs.

stangdaman · 2008-03-29, 11:18 AM

Sorry Sub but do I just copy

Quote:<LogSQL>true</LogSQL>

anywhere into the config.xml? How do I do that? Sorry again just need it spelled out a little more. Thanks.

philly_phenom · 2008-03-29, 01:54 PM

stangdaman Wrote:Sorry Sub but do I just copy

anywhere into the config.xml? How do I do that? Sorry again just need it spelled out a little more. Thanks.

Search the file for LogSQL & change the value from false to true

stangdaman · 2008-03-30, 10:36 AM

Thanks that seems to have taken care of it.

***sub*** · 2008-03-30, 03:23 PM

stangdaman Wrote:Thanks that seems to have taken care of it.

It shouldnt of fixed anything. That setting just causes it to add more messages to the log files.

stangdaman · 2008-03-31, 11:41 AM

Quote:It shouldnt of fixed anything. That setting just causes it to add more messages to the log files.

I don't know. Maybe it was just the third or fourth (whatever it was) time of restarting that finally did something. All I know is I did what you said and when I tried to recreate the error by reloading the epg it actually loaded and I didn't get the error. Wish I could tell you more but I don't really know why. Do you want me to look and see if I have a log for it anyway so you can have a look.

***sub*** · 2008-03-31, 04:05 PM

Leave that <LogSQL>true</LogSQL> setting in place for now, and if it happens again in near future, then post the logs.

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