SQL error

[OrakelJos]

Got this error in GBPVRRecordingService:

2009-02-10 21:40:15.046 VERBOSE [5] - checking Desperate Housewives
2009-02-10 21:40:15.046 VERBOSE [5] - checking E:\MyPVR\Intensive care\Intensive care_20090210_19252000.mpg
2009-02-10 21:40:15.046 VERBOSE [5] - checking E:\MyPVR\Desperate Housewives\Desperate Housewives_20090210_20302125.mpg
2009-02-10 21:40:15.046 VERBOSE [5] - checking Midsomer Murders
2009-02-10 21:40:15.046 VERBOSE [5] pending: (76) Midsomer Murders 14/02/2009 20:40
2009-02-10 21:40:30.765 VERBOSE [14] RecordingFactory.loadScheduleRecordingByOID()
2009-02-10 21:40:30.765 VERBOSE [14] About to start transcode of: E:\MyPVR\Desperate Housewives\Desperate Housewives_20090210_20302125.mpg
2009-02-10 21:40:30.765 VERBOSE [14] getValue cached value: /settings/AutoConvertMpgToFormat : No Conversion
2009-02-10 22:03:30.796 VERBOSE [14] Conversion thread configured for ASAP
2009-02-10 22:33:30.828 VERBOSE [14] Conversion thread configured for ASAP
2009-02-10 23:03:30.859 VERBOSE [14] Conversion thread configured for ASAP
2009-02-10 23:11:29.859 ERROR [2] FATAL UNHANDLED EXCEPTION:: System.Data.SQLite.SQLiteException: Library used incorrectly
library routine called out of sequence
at System.Data.SQLite.SQLite3.Close()
at System.Data.SQLite.SQLiteConnection.Close()
at System.Data.SQLite.SQLiteConnection.Dispose(Boolean disposing)
at System.ComponentModel.Component.Finalize()

What is the reason for this error? This is a recent complete clean install of 1.3.11 with an import of existing recordings from a previous version (1.3.7). I did not import the season recordings because i have noticed problems/corruption in the database with this.

I also have sometimes the problem that deleting a recording takes a rather long time (up to 10 seconds). Are the problems related?

[pBS]

so how did you skip importing the season records? manually edit the dump file?
if so, you probably left an open <> or something... if you still have the file you imported, may be worth a second look...could possibly have a corrupt entry in db because of this..

can try editing db with a sqlite editor, i'd look in recording schedule table for messed up entries/ missing info..
a look at the import file would know for sure if that's what happened...

[OrakelJos]

Yes, I edited the dump file. Checked again but I made no errors. I am also getting a corrupt database when I do a complete import. Most of the season recording show only a single line without further details like station, type of season etc.
The SQL problem shows however another type of error which is related to a transcode that is not even programmed.

[sub]

Post the logs and I'll see if anything stands out.

[OrakelJos]

Sub: please find attached the requested logs.

[sub]

Sorry - I cant see anything obvious in those logs.

Has the error from the original post occurred more than once? Is there a pattern to when it happens?

[OrakelJos]

No, only happened once. After that I made sure that all references to transcode in the config were removed. I have only the 4 analoge tuners (2 x PVR500) and only recording and playing back, so nothing special.

[sub]

Sorry - I dont know. If it only happened the once, then its probably not worth spending too much time investigating.