Failed Recordings

[JonRoyle]

Just upgraded to GB-PVR 99.5 and EWA 54 and I am experiencing numerous 'Failed Recording' when trying to scheduled recordings via EWA.

I realised that some were due to recording conflicts (not obvious as other scheduled recording was several pages further down) however others are not.

On investigation it appears to mainly effect EWA when served via IIS - using inbuilt web server it appears to be OK - but not had time to do extensive testing. Any ideas?

Jon

[UncleJohnsBand]

No Ideas at this point......I only develop with IIS and run the internal server for my production box.....perhaps something with Security on how IIS has the site defined???

If you were running EWA via IIS before and didn't have problems than I am not sure what would be different since the last release that would cause this behavoir.

Have you tried simply stoping the IIS website and then restarting it?

[JonRoyle]

This is becoming interesting....

Failed recordings are always happening when I use IIS to serve the page and sometimes happen when I use the inbuilt web server. Looking through logs the only error I can found is:

[INDENT]26/12/2006 10:36:31.196 ERROR [1] Failure in ChannelFactory::updateSummary(): The database file is locked
database is locked
26/12/2006 10:37:02.560 ERROR [1] Error saving CaptureSource: The database file is locked
database is locked
26/12/2006 10:37:02.610 ERROR [1] Stack:
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.xda34526142ca690b.x35ca223d3ef12fee()[/INDENT]

If I click on the EWA log on the Statistics page I get an error (however I try to access the page).

Not sure if the issue is EWA or GB-PVR upgrade to 99.5.

I will keep testing but any ideas/suggestions would be welcome.

Things tried, but not resolved the issue

• IIS and system restarted post upgrade.
  
• I also regressed to previous version of GB-PVR/EWA and the issue went away
  
• NTFS Permission set to Everyone full access on GBPVR directory
  
• Full permissions
  

given in IIS

[JonRoyle]

Hmmm looking like a SQLlite issue.

Whenever I click record (either from EWA non-IIS or GBPVR) I can see the journal file being written but then it can not be written to DB so is rolled back.

When using IIS the journal file does not get created, hence immediate fail.

[HtV]

Are you sure your gbpvr.db3 got updated during the 99.5 install? Some people were having problems with that, including me. When it didn't I think you might have problems with writing to the db.
The new db has the reminder thing included. If you don't have the new one you'll have errors in your gbpvrexe.log. (with a mvp the gbpvrexe.log only applies to the mvp-gbpvr.exe.

[JonRoyle]

Thanks for the suggestion

Just re-ran the install. The DB appears to have been upgraded (timestamp changed to upgrade time) however I am having the same issue ie journal file not being written to DB. Do you know any other way to check to see if the upgrade worked?

There are some errors in the GBPVR.exe log
26/12/2006 12:04:35.528 ERROR [1] Unable to find node: /settings/SpecialElements/SpecialElement[@name="ForegroundTransparency"]
26/12/2006 12:04:35.558 ERROR [1] Unable to find node: /settings/SpecialElements/SpecialElement[@name="MenuType"]
26/12/2006 12:04:35.698 ERROR [1] Unable to find node: /settings/SpecialElements/SpecialElement[@name="MenuType"]


Jon

[HtV]

There are some errors in the GBPVR.exe log
26/12/2006 12:04:35.528 ERROR [1] Unable to find node: /settings/SpecialElements/SpecialElement[@name="ForegroundTransparency"]
26/12/2006 12:04:35.558 ERROR [1] Unable to find node: /settings/SpecialElements/SpecialElement[@name="MenuType"]
26/12/2006 12:04:35.698 ERROR [1] Unable to find node: /settings/SpecialElements/SpecialElement[@name="MenuType"]
Jon

These errors are always there. I think you should really worry if they aren't .
If you don't get any reminder-errors in the gbpvrexe.log the db would be updated. You could check with a sqllite viewer like sqlitespy: http://www.yunqa.de/delphi/sqlitespy/
Just check there is a reminder-field in the db.

[HtV]

Couldn't be this: http://forums.gbpvr.com/showpost.php?p=1...ostcount=7

[JonRoyle]

Couldn't be this: http://forums.gbpvr.com/showpost.php?p=1...ostcount=7

No I read this one - I don't use any conversion.

Just downloaded a SQLlite manager so I can have a look at the DB - looks like it has upgraded as there is a 'Reminder' Table

Jon

[UncleJohnsBand]

This is becoming interesting....

Failed recordings are always happening when I use IIS to serve the page and sometimes happen when I use the inbuilt web server. Looking through logs the only error I can found is:
[INDENT]26/12/2006 10:36:31.196 ERROR [1] Failure in ChannelFactory::updateSummary(): The database file is locked
database is locked
26/12/2006 10:37:02.560 ERROR [1] Error saving CaptureSource: The database file is locked
database is locked
26/12/2006 10:37:02.610 ERROR [1] Stack:
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.xda34526142ca690b.x35ca223d3ef12fee()[/INDENT]If I click on the EWA log on the Statistics page I get an error (however I try to access the page).

Not sure if the issue is EWA or GB-PVR upgrade to 99.5.

I will keep testing but any ideas/suggestions would be welcome.

Things tried, but not resolved the issue

• IIS and system restarted post upgrade.
  
• I also regressed to previous version of GB-PVR/EWA and the issue went away
  
• NTFS Permission set to Everyone full access on GBPVR directory
  
• Full permissions

given in IIS

Since you are serving this via IIS you could try to disable EWA within GBPVR itself......that will turn off the native GBPVR web server....perhaps there is conflict going on between the two......