DB locked error since 3.3.8

[Bluethunder]

I started a post here http://forums.nextpvr.com/showthread.php...ince-3-3-8 since changing to 3.3.8, I've been getting DB locks. There is a NPVR log file attached to this msg, NPVR.log.2 is the first instance of it happening.

I think have the latest file from the WIKI page.

I've disabled TV Listings, and so far I haven't gotten any more DB locks on EPG update.

It would happen right when it switches from saving EPG files to updating recordings.

Thanks for all the work on a great plugin.

Cheers.

[Bluethunder]

I think have the latest file from the WIKI page.

Cheers.

About to check for plugin interfaces in: C:\Users\Public\NPVR\Plugins\TV Listings\TV Listings.dll
2014-11-19 18:20:15.017 [INFO][1] TV Listings: version is 3.7.0.17582.
2014-11-19 18:20:15.017 [INFO][1] TV Recordings: version is 3.7.0.17582.
2014-11-19 18:20:15.017 [DEBUG][1] TV Listings: Client identifier is 'PC'.
2014-11-19 18:20:15.017 [DEBUG][1] TV Listings: Loading settings...
2014-11-19 18:20:15.017 [DEBUG][1] TV Listings: Using 'Data Source="C:\Users\Public\NPVR\npvr.db3";Version=3;New=True;'
2014-11-19 18:20:15.027 [DEBUG][1] TV Listings: Using 'Data Source="C:\Users\Public\NPVR\Plugins\TV Listings\TV Listings.db3";Version=3;New=True;'
2014-11-19 18:20:15.057 [INFO][1] TV Listings: SkinHelper using resource directory 'C:\Users\Public\NPVR\skin\Default\TV Listings\'
2014-11-19 18:20:15.057 [DEBUG][1] TV Listings: Backend initialised.
2014-11-19 18:20:15.067 [INFO][1] TV Listings: Settings loaded successfully.
2014-11-19 18:20:15.077 [WARN][1] TV Listings: Using as C:\Users\Public\NPVR\\Plugins\TV Listings\TheTVDB fallback for TheTVDBDirectory.
2014-11-19 18:20:15.077 [DEBUG][1] TV Listings: Loading guides...
2014-11-19 18:20:15.077 [DEBUG][1] TV Listings: 'sort_order' column detected in 'guides' table, sorting by 'sort_order' column.
2014-11-19 18:20:15.077 [INFO][1] TV Listings: Falling back to default guide.

[alibert]

Hi,

please remove the plugin's .dll file form the "c:\program files\"... subdirectory, the one at "c:\users\public\"... is sufficient. Seems that both are trying to reload guide data during epg updates.

-alibert

[Bluethunder]

Hi,

please remove the plugin's .dll file form the "c:\program files\"... subdirectory, the one at "c:\users\public\"... is sufficient. Seems that both are trying to reload guide data during epg updates.

-alibert

I deleted the plugins directory from c:\program files\. Must of been a relic from when i ran windows xp.

I'm still getting the database locked messages. It always happens right after "saving epg is finished", when it starts to update the recordings.

I can try completely removing TV Listings, and re-installing. Are there any parts stored outside of the plug-in directory?

Cheers, Joe

[gEd]

I deleted the plugins directory from c:\program files\. Must of been a relic from when i ran windows xp.

I'm still getting the database locked messages. It always happens right after "saving epg is finished", when it starts to update the recordings.

I can try completely removing TV Listings, and re-installing. Are there any parts stored outside of the plug-in directory?

Cheers, Joe

Make sure you have unticked updateepg during live TV in the config. This caused locking problems

[mvallevand]

The problem is more fundamental, each channel delete is taking 5 seconds on average, so with 543 channels that is a long time. It might be worth vacuuming it with a sqlite tool.

Martin

[Bluethunder]

The problem is more fundamental, each channel delete is taking 5 seconds on average, so with 543 channels that is a long time. It might be worth vacuuming it with a sqlite tool.

Martin

It is a brand new DB from november when i first installed 3.3.8, copied from the empty.db file. I could replace it again.

[alibert]

Where is the data for your epg coming from (xmltv file or dvb stream or ...)? And how are you performing the epg update? Via "-onlyupdateepg" commandline switch or somehow else?

-alibert

[Bluethunder]

Where is the data for your epg coming from (xmltv file or dvb stream or ...)? And how are you performing the epg update? Via "-onlyupdateepg" commandline switch or somehow else?

-alibert

I'm using the built in npvr schedules direct guide downloader. The EPG update is triggered by NPVR from the settings.

[Bluethunder]

The problem is more fundamental, each channel delete is taking 5 seconds on average, so with 543 channels that is a long time. It might be worth vacuuming it with a sqlite tool.

Martin

I ran sqlite3 npvr.db3 d vacuum on the database. It cleaned about 10mb of the database file, and sped up the update a bit. I think it took about 20-25 minutes for the update.

I tried TV Listings again after the vacuum, and it gets a DB locked at the same point.