Results 1 to 7 of 7

Thread: RecordingService not does not stop log included

  1. #1
    Join Date
    Feb 2007
    Location
    Kansas
    Posts
    117

    RecordingService not does not stop log included

    The RecordingService does not stop just holds the tuner but the file does not grow after the show is over.

    Thanks greg


    2013-10-08 18:33:57.020 INFO [4] GB-PVR Recording Service starting
    2013-10-08 18:33:57.145 VERBOSE [4] installDirectory is C:\Program Files\Devnz\GBPVR\
    2013-10-08 18:33:57.145 VERBOSE [4] configurationFile is C:\Program Files\Devnz\GBPVR\config.xml
    2013-10-08 18:33:57.176 VERBOSE [4] getValue() loading new key/value into cache: /settings/DatabaseConnectionString
    2013-10-08 18:33:57.176 VERBOSE [4] getValue: /settings/DatabaseConnectionString : Data Source=".\gbpvr.db3";Version=3;New=True;
    2013-10-08 18:33:57.176 VERBOSE [4] getValue() loading new key/value into cache: /settings/DatabaseIdentityQuery
    2013-10-08 18:33:57.176 VERBOSE [4] getValue: /settings/DatabaseIdentityQuery : select last_insert_rowid()
    2013-10-08 18:33:57.176 VERBOSE [4] databaseConnectionString is Data Source="C:\Program Files\Devnz\GBPVR\gbpvr.db3";Version=3;New=True;
    2013-10-08 18:33:57.176 VERBOSE [4] getValue() loading new key/value into cache: /settings/DatabaseProviderFactory
    2013-10-08 18:33:57.176 VERBOSE [4] getValue: /settings/DatabaseProviderFactory : System.Data.SQLite.SQLiteFactory
    2013-10-08 18:33:57.176 VERBOSE [4] getValue() loading new key/value into cache: /settings/LoggingLevel
    2013-10-08 18:33:57.176 VERBOSE [4] getValue: /settings/LoggingLevel : Error
    2013-10-09 19:19:31.355 ERROR [13] Unexpected error checking the conversion queue in database: System.Data.SQLite.SQLiteException: The database file is locked
    database is locked
    at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
    at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
    at System.Data.SQLite.SQLiteDataReader.NextResult()
    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
    at System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
    at System.Data.SQLite.SQLiteCommand.ExecuteDbDataRead er(CommandBehavior behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at GBPVR.RecordingService.x92f6085038c83bb7.xcba1f05f b5a46d5f()
    2013-10-09 19:21:19.511 ERROR [13] Unexpected error checking the conversion queue in database: System.Data.SQLite.SQLiteException: The database file is locked
    database is locked
    at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
    at System.Data.SQLite.SQLiteCommand.BuildNextCommand( )
    at System.Data.SQLite.SQLiteCommand.GetStatement(Int3 2 index)
    at System.Data.SQLite.SQLiteDataReader.NextResult()
    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
    at System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
    at System.Data.SQLite.SQLiteCommand.ExecuteDbDataRead er(CommandBehavior behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at GBPVR.RecordingService.x92f6085038c83bb7.xcba1f05f b5a46d5f()
    2013-10-09 19:21:40.455 ERROR [12] Encountered unexpected error in LiveTVFileManager.WorkerThread(): The database file is locked
    database is locked
    2013-10-09 19:21:40.456 ERROR [12] at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
    at System.Data.SQLite.SQLiteCommand.BuildNextCommand( )
    at System.Data.SQLite.SQLiteCommand.GetStatement(Int3 2 index)
    at System.Data.SQLite.SQLiteDataReader.NextResult()
    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
    at System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
    at System.Data.SQLite.SQLiteCommand.ExecuteDbDataRead er(CommandBehavior behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at GBPVR.RecordingService.xe14ff94ac1bb1522.xcba1f05f b5a46d5f()
    2013-10-09 19:22:51.510 ERROR [13] Unexpected error checking the conversion queue in database: System.Data.SQLite.SQLiteException: The database file is locked
    database is locked
    at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
    at System.Data.SQLite.SQLiteCommand.BuildNextCommand( )
    at System.Data.SQLite.SQLiteCommand.GetStatement(Int3 2 index)
    at System.Data.SQLite.SQLiteDataReader.NextResult()
    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
    at System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
    at System.Data.SQLite.SQLiteCommand.ExecuteDbDataRead er(CommandBehavior behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at GBPVR.RecordingService.x92f6085038c83bb7.xcba1f05f b5a46d5f()
    2013-10-10 19:18:04.236 ERROR [13] Unexpected error checking the conversion queue in database: System.Data.SQLite.SQLiteException: The database file is locked
    database is locked
    at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
    at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
    at System.Data.SQLite.SQLiteDataReader.NextResult()
    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
    at System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
    at System.Data.SQLite.SQLiteCommand.ExecuteDbDataRead er(CommandBehavior behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at GBPVR.RecordingService.x92f6085038c83bb7.xcba1f05f b5a46d5f()
    2013-10-10 19:19:36.292 ERROR [13] Unexpected error checking the conversion queue in database: System.Data.SQLite.SQLiteException: The database file is locked
    database is locked
    at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
    at System.Data.SQLite.SQLiteCommand.BuildNextCommand( )
    at System.Data.SQLite.SQLiteCommand.GetStatement(Int3 2 index)
    at System.Data.SQLite.SQLiteDataReader.NextResult()
    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
    at System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
    at System.Data.SQLite.SQLiteCommand.ExecuteDbDataRead er(CommandBehavior behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at GBPVR.RecordingService.x92f6085038c83bb7.xcba1f05f b5a46d5f()
    2013-10-10 19:21:24.885 ERROR [13] Unexpected error checking the conversion queue in database: System.Data.SQLite.SQLiteException: The database file is locked
    database is locked
    at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
    at System.Data.SQLite.SQLiteCommand.BuildNextCommand( )
    at System.Data.SQLite.SQLiteCommand.GetStatement(Int3 2 index)
    at System.Data.SQLite.SQLiteDataReader.NextResult()
    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
    at System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
    at System.Data.SQLite.SQLiteCommand.ExecuteDbDataRead er(CommandBehavior behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at GBPVR.RecordingService.x92f6085038c83bb7.xcba1f05f b5a46d5f()
    2013-10-10 19:21:43.853 ERROR [12] Encountered unexpected error in LiveTVFileManager.WorkerThread(): The database file is locked
    database is locked
    2013-10-10 19:21:43.854 ERROR [12] at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
    at System.Data.SQLite.SQLiteCommand.BuildNextCommand( )
    at System.Data.SQLite.SQLiteCommand.GetStatement(Int3 2 index)
    at System.Data.SQLite.SQLiteDataReader.NextResult()
    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
    at System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
    at System.Data.SQLite.SQLiteCommand.ExecuteDbDataRead er(CommandBehavior behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at GBPVR.RecordingService.xe14ff94ac1bb1522.xcba1f05f b5a46d5f()

  2. #2
    Join Date
    Mar 2006
    Location
    Carterton, NZ
    Posts
    3,023
    Try re-booting the computer to get rid of the database being locked & then see what it does after that...

  3. #3
    Join Date
    Feb 2007
    Location
    Kansas
    Posts
    117
    OK I will give that a shot thanks

  4. #4
    Join Date
    Mar 2007
    Location
    Gjovik, Norway - PAL
    Posts
    6,600
    Even better, upgrade to npvr once Sub has released the new version he announced for this weekend

    "I'd rather have a bottle in front of me than a frontal lobotomy"

  5. #5
    Join Date
    Feb 2007
    Location
    Kansas
    Posts
    117
    Well it keeps doing it over and over database locked. This is the latest log.

    Thanks Greg

    2013-10-18 19:20:21.562 INFO [4] GB-PVR Recording Service starting
    2013-10-18 19:20:21.750 VERBOSE [4] installDirectory is C:\Program Files\Devnz\GBPVR\
    2013-10-18 19:20:22.062 VERBOSE [4] configurationFile is C:\Program Files\Devnz\GBPVR\config.xml
    2013-10-18 19:20:22.078 VERBOSE [4] getValue() loading new key/value into cache: /settings/DatabaseConnectionString
    2013-10-18 19:20:22.078 VERBOSE [4] getValue: /settings/DatabaseConnectionString : Data Source=".\gbpvr.db3";Version=3;New=True;
    2013-10-18 19:20:22.078 VERBOSE [4] getValue() loading new key/value into cache: /settings/DatabaseIdentityQuery
    2013-10-18 19:20:22.078 VERBOSE [4] getValue: /settings/DatabaseIdentityQuery : select last_insert_rowid()
    2013-10-18 19:20:22.078 VERBOSE [4] databaseConnectionString is Data Source="C:\Program Files\Devnz\GBPVR\gbpvr.db3";Version=3;New=True;
    2013-10-18 19:20:22.078 VERBOSE [4] getValue() loading new key/value into cache: /settings/DatabaseProviderFactory
    2013-10-18 19:20:22.078 VERBOSE [4] getValue: /settings/DatabaseProviderFactory : System.Data.SQLite.SQLiteFactory
    2013-10-18 19:20:22.078 VERBOSE [4] getValue() loading new key/value into cache: /settings/LoggingLevel
    2013-10-18 19:20:22.078 VERBOSE [4] getValue: /settings/LoggingLevel : Error
    2013-10-21 19:14:46.389 ERROR [12] Unexpected error checking the conversion queue in database: System.Data.SQLite.SQLiteException: The database file is locked
    database is locked
    at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
    at System.Data.SQLite.SQLiteCommand.BuildNextCommand( )
    at System.Data.SQLite.SQLiteCommand.GetStatement(Int3 2 index)
    at System.Data.SQLite.SQLiteDataReader.NextResult()
    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
    at System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
    at System.Data.SQLite.SQLiteCommand.ExecuteDbDataRead er(CommandBehavior behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at GBPVR.RecordingService.x92f6085038c83bb7.xcba1f05f b5a46d5f()
    2013-10-21 19:16:26.962 ERROR [12] Unexpected error checking the conversion queue in database: System.Data.SQLite.SQLiteException: The database file is locked
    database is locked
    at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
    at System.Data.SQLite.SQLiteCommand.BuildNextCommand( )
    at System.Data.SQLite.SQLiteCommand.GetStatement(Int3 2 index)
    at System.Data.SQLite.SQLiteDataReader.NextResult()
    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
    at System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
    at System.Data.SQLite.SQLiteCommand.ExecuteDbDataRead er(CommandBehavior behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at GBPVR.RecordingService.x92f6085038c83bb7.xcba1f05f b5a46d5f()
    2013-10-21 19:18:08.918 ERROR [12] Unexpected error checking the conversion queue in database: System.Data.SQLite.SQLiteException: The database file is locked
    database is locked
    at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
    at System.Data.SQLite.SQLiteCommand.BuildNextCommand( )
    at System.Data.SQLite.SQLiteCommand.GetStatement(Int3 2 index)
    at System.Data.SQLite.SQLiteDataReader.NextResult()
    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
    at System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
    at System.Data.SQLite.SQLiteCommand.ExecuteDbDataRead er(CommandBehavior behavior)
    at System.Data.Common.DbCommand.ExecuteReader()
    at GBPVR.RecordingService.x92f6085038c83bb7.xcba1f05f b5a46d5f()

  6. #6
    Join Date
    Nov 2006
    Location
    Louisville, KY, USA
    Posts
    7,870
    You might need to use an SQLite database browser and clear any pending transcodings. (It's been years since I looked at the old database structure so I don't remember where they would be.)

    Sub won't be in a position to supply any patches for you for the old code.

  7. #7
    Join Date
    Feb 2007
    Location
    Kansas
    Posts
    117
    Thanks I will look at that.

    Greg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •