Details
-
Bug
-
Resolution: Fixed
-
Critical
-
None
-
0.2.0.0
-
None
-
Operating System: XP
Platform: Intel
Description
While MP is running and the TVGuide gets updated the
h4. Steps to Reproduce
1. Run MP
2. Start Taskmanager
3. Run xmltv for WebEPG to update the TVGuide
You'll notice the memory usage of MP increase it continues to climb even after the TVGuide has finished updating.
The only solution is to restart MP.
h4. Additional Information
24/01/2006 19:50:17 detected new tvguide ->import new tvguide
24/01/2006 19:50:17 xmltv import C:\Program Files\Team MediaPortal\MediaPortal\xmltv\tvguide.xml
24/01/2006 19:50:17 SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:database schema has changed query:DELETE FROM tblPrograms WHERE iEndTime < '20060123000000'
24/01/2006 19:50:17 TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:database schema has changed query:DELETE FROM tblPrograms WHERE iEndTime < '20060123000000' 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 tblPrograms WHERE iEndTime < '20060123000000'
24/01/2006 19:50:17 opening tvdatabase
24/01/2006 19:50:18 SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:vacuum
24/01/2006 19:50:18 TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database 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.Open()
24/01/2006 19:50:18 tvdatabase opened
24/01/2006 19:50:27 dbs:close:TVDatabaseV21.db3
h4. Steps to Reproduce
1. Run MP
2. Start Taskmanager
3. Run xmltv for WebEPG to update the TVGuide
You'll notice the memory usage of MP increase it continues to climb even after the TVGuide has finished updating.
The only solution is to restart MP.
h4. Additional Information
24/01/2006 19:50:17 detected new tvguide ->import new tvguide
24/01/2006 19:50:17 xmltv import C:\Program Files\Team MediaPortal\MediaPortal\xmltv\tvguide.xml
24/01/2006 19:50:17 SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:database schema has changed query:DELETE FROM tblPrograms WHERE iEndTime < '20060123000000'
24/01/2006 19:50:17 TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:database schema has changed query:DELETE FROM tblPrograms WHERE iEndTime < '20060123000000' 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 tblPrograms WHERE iEndTime < '20060123000000'
24/01/2006 19:50:17 opening tvdatabase
24/01/2006 19:50:18 SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:vacuum
24/01/2006 19:50:18 TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database 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.Open()
24/01/2006 19:50:18 tvdatabase opened
24/01/2006 19:50:27 dbs:close:TVDatabaseV21.db3