home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
Electronic Program Guide
WebEPG
MediaPortal & Setup freeze on corrupted programs database
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="pbb" data-source="post: 143950" data-attributes="member: 26308"><p>Hi all,</p><p></p><p>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.)</p><p></p><p>MediaPortal.log (opening TV Guide):</p><p>[CODE]2007-03-28 23:40:09.593750 [Info.][MPMain]: window:MediaPortal.GUI.TV.GUITVGuide init</p><p>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</p><p>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)</p><p> at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm)</p><p> at SQLite.NET.SQLiteClient.Execute(String query)</p><p> 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</p><p>2007-03-28 23:40:09.843750 [Info.][MPMain]: opening tvdatabase</p><p>2007-03-28 23:40:14.781250 [Info.][2]: dbs:close:TVDatabaseV21.db3[/CODE]</p><p></p><p>Configuration.log (trying to clean the database):</p><p>[CODE]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</p><p>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</p><p>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)</p><p> at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm)</p><p> at SQLite.NET.SQLiteClient.Execute(String query)</p><p> at MediaPortal.TV.Database.TVDatabase.RemovePrograms()</p><p>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)</p><p> at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm)</p><p> at SQLite.NET.SQLiteClient.Execute(String query)</p><p> at MediaPortal.TV.Database.TVDatabase.RemovePrograms()</p><p>2007-03-31 16:21:21.984375 [Info.][Config Main]: opening tvdatabase</p><p>2007-03-31 16:21:22.640625 [Info.][2]: dbs:close:TVDatabaseV21.db3</p><p>[/CODE]</p><p></p><p>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.</p><p></p><p>I still have the corrupted database, if any developer is interested in testing it to make MP more stable.</p><p></p><p>Peter</p></blockquote><p></p>
[QUOTE="pbb, post: 143950, member: 26308"] 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): [CODE]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[/CODE] Configuration.log (trying to clean the database): [CODE]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 [/CODE] 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 [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Electronic Program Guide
WebEPG
MediaPortal & Setup freeze on corrupted programs database
Contact us
RSS
Top
Bottom
