MediaPortal & Setup freeze on corrupted programs database

[pbb]

Hi all,

For some reason, my TV Programs database (TVDatabaseV21.db3) got corrupted. The corruption is noticed, there are error messages in the MediaPortal.log and Configuration.log, but still the program freezes. (Alternatingly maxing out the processor, consuming lots of memory, and trashing the harddisk.)

MediaPortal.log (opening TV Guide):

2007-03-28 23:40:09.593750 [Info.][MPMain]: window:MediaPortal.GUI.TV.GUITVGuide init
2007-03-28 23:40:09.843750 [Info.][MPMain]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from channel,tblPrograms,genre where genre.idGenre=tblPrograms.idGenre and tblPrograms.idChannel=channel.idChannel and channel.strChannel like 'TV2 Zebra'  and ( (tblPrograms.iEndTime>='20070328233000' and tblPrograms.iEndTime <='20070329012900')  or (tblPrograms.iStartTime>='20070328233000' and tblPrograms.iStartTime <= '20070329012900' )  or (tblPrograms.iStartTime<='20070328233000' and tblPrograms.iEndTime >= '20070329012900') ) order by iStartTime
2007-03-28 23:40:09.843750 [Info.][MPMain]: TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from channel,tblPrograms,genre where genre.idGenre=tblPrograms.idGenre and tblPrograms.idChannel=channel.idChannel and channel.strChannel like 'TV2 Zebra'  and ( (tblPrograms.iEndTime>='20070328233000' and tblPrograms.iEndTime <='20070329012900')  or (tblPrograms.iStartTime>='20070328233000' and tblPrograms.iStartTime <= '20070329012900' )  or (tblPrograms.iStartTime<='20070328233000' and tblPrograms.iEndTime >= '20070329012900') ) order by iStartTime 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.GetProgramsPerChannel(String strChannel1, Int64 iStartTime, Int64 iEndTime, List`1& progs) select * from channel,tblPrograms,genre where genre.idGenre=tblPrograms.idGenre and tblPrograms.idChannel=channel.idChannel and channel.strChannel like 'TV2 Zebra'  and ( (tblPrograms.iEndTime>='20070328233000' and tblPrograms.iEndTime <='20070329012900')  or (tblPrograms.iStartTime>='20070328233000' and tblPrograms.iStartTime <= '20070329012900' )  or (tblPrograms.iStartTime<='20070328233000' and tblPrograms.iEndTime >= '20070329012900') ) order by iStartTime
2007-03-28 23:40:09.843750 [Info.][MPMain]: opening tvdatabase
2007-03-28 23:40:14.781250 [Info.][2]: dbs:close:TVDatabaseV21.db3

Configuration.log (trying to clean the database):

2007-03-31 16:21:21.875000 [Info.][Config Main]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete from tblPrograms
2007-03-31 16:21:21.875000 [ERROR][Config Main]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete from tblPrograms
2007-03-31 16:21:21.984375 [Info.][Config Main]: TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete from tblPrograms 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.RemovePrograms()
2007-03-31 16:21:21.984375 [ERROR][Config Main]: TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete from tblPrograms 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.RemovePrograms()
2007-03-31 16:21:21.984375 [Info.][Config Main]: opening tvdatabase
2007-03-31 16:21:22.640625 [Info.][2]: dbs:close:TVDatabaseV21.db3

I have already built a new tv database, but I find it weird that the database corruption is noted in the logfiles and still MP crashes.

I still have the corrupted database, if any developer is interested in testing it to make MP more stable.

Peter