24-01-2006 CVS: Problems with recording (2 Viewers)

[laeb66]

Luky you!!

Are you gys running Analog tuners???

I dont even have picture or able to load the card in cvs 01/02-02-06..

Area: Media Portal Program
MediaPortal Version: 0.2.0.0 RC1 - Latest CVS
MediaPortal Skin: BlueTwo
Windows Version: Windows XP (SP2)
.NET CLR Version: 2.0.50727
DirectX Version: 4.09.00.0904 (9.0c)
Audio Codec: nVidia
Video Codec: Mpeg2Dec Filter
CPU Type: Intel Pentium 4 - 3.0GHz 1 mb
Memory: 1 GB
Motherboard: MS-865GS-Fis3 (Micro Star)
TV Card Model: FireDtv DVB-T
TV Card Type: Hardware
TV Card Driver: 2.0.mini bda
Video Card Model: Matrox millenium 650 64 mb AGP
Video Card Driver: Latest
Video Card Resolution: 800.600
Video Render Type: VMR9
Audio Card Model: Terratec Phase 28 pci (WDM)
Audio Card Driver: 5.22


Same resault with mpeg/dscaler codec

 

[Aquarius]

Confirmed: SQL Bug still there with CVS-02-02-2006--01-01

Hi,
must confirm, bug is still there.

2.02.2006 22:22:08 SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:cannot VACUUM from within a transaction query:vacuum
02.02.2006 22:22:08 TVDatabase exception errQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:cannot VACUUM from within a transaction query:vacuum stack: bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm)
bei SQLite.NET.SQLiteClient.Execute(String query)
bei MediaPortal.TV.Database.TVDatabase.RemoveOldPrograms() DELETE FROM canceledseries where iCancelTime < '20060201000000'
02.02.2006 22:22:08 SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:cannot commit - no transaction is active query:commit
02.02.2006 22:22:08 tvdatabase commit failed exception errQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:cannot commit - no transaction is active query:commit

Happens always on importing TVGUIDE.XML i.e. when a new TVGUIDE.XML
is present.

All suspicious plugins are disabled.

 

[Aquarius]

Update: another SQL- problem

This occurs when MP is resumed from hibernate, and a new TVGUIDE.XML is created in the background:

02.02.2006 23:16:12 WebEPG: TimeZone Not valid
02.02.2006 23:16:14 SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:database schema has changed queryELETE FROM tblPrograms WHERE iEndTime < '20060201000000'
02.02.2006 23:16:14 TVDatabase exception errQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:database schema has changed queryELETE FROM tblPrograms WHERE iEndTime < '20060201000000' stack: bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm)
bei SQLite.NET.SQLiteClient.Execute(String query)
bei MediaPortal.TV.Database.TVDatabase.RemoveOldPrograms() DELETE FROM tblPrograms WHERE iEndTime < '20060201000000'
02.02.2006 23:16:14 SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailedQL logic error or missing database query:vacuum
02.02.2006 23:16:14 TVDatabase exception errQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailedQL logic error or missing database query:vacuum stack: bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm)
bei SQLite.NET.SQLiteClient.Execute(String query)
bei MediaPortal.TV.Database.TVDatabase.Open()

After that the mem. leak occurs.

BTW, with the CVS of tonight, analogue radio also does not work
anymore.

 

[ronald2oo2]

I don't know anything about memory leaks and I was not saying that every MP quirk is solved but I can now start the recording from live TV without MP freezing and if I stop the recording I can normally change the channels again (which was the subject of this thread).

In the meantime I found however that if I leave the live TV to e.g. play a movie that I must reset the PC to be able to switch on the TV again. I did not have this problem before, I am sure :!: Maybe this is coming from the same place as the analog tuner issue I now read about?

Although the recording at it self works for me, I just noticed however that in my error log I still have multiple similar "VACUUM" error reports like before. Just 1 example:

3-2-2006 20:06:59 SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:cannot VACUUM from within a transaction query:vacuum
3-2-2006 20:07:00 TVDatabase exception errQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:cannot VACUUM from within a transaction query:vacuum stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.TV.Database.TVDatabase.RemoveOldPrograms() DELETE FROM canceledseries where iCancelTime < '20060202000000'

Go figure :roll:

Probably I will try later if the today's CVS makes a difference with the TV not being able to be switched on.

Cheers,
Ronald

 

[Aquarius]

Problem fixed with CVS 2006-02-05

Thanks guys,
problem is gone.

/Gerd