Update 1.2.2 to 1.2.3 -> SQLite Out of Memory Exception in Multiseat Mode | Page 2

Yes there is a migration path. For most people (me included) everything works fine.

Chances are, one of your databases is corrupt, and the new sqlite is less tolerant than the old one.

If this is a widespread problem, obviously we will consider rolling back sqlite to an earlier version. So far, many users have upgraded without a problem, and a very small number have issues.

If you were to move your databases out of the above folder one at a time, and see which one causes the problem, you might then post the database file here for us to have a look at. Maybe we can find out what is wrong.

You have only posted the error.log. We need all logs. Reason - error.log only logs errors. It would be good to find out what MP did successfully before the first error.

However, your logs start with

Code (text):

2012-04-15 21:13:34.010800 [ERROR][(8)]: FRITZ!Box Manager: FritzBox: Connecting failed: Socket Exception
2012-04-15 21:13:35.283800 [ERROR][(11)]: IMAPMail:Processor: Error Getting Email Status: Fehler in der Anwendung.
2012-04-15 21:13:46.607800 [ERROR][MPMain(1)]: SKIN: Missing C:\ProgramData\Team MediaPortal\MediaPortal\Skin\Black Glass Nova for Mediaportal 1.2.0\common.time.xml
2012-04-15 21:13:56.298800 [ERROR][(19)]: SQLiteClient:  cmd:sqlite3_step err:ERROR detailed:bind or column index out of range query:select movie_info_id from filters__movie_info__black_list where filters_id=589
2012-04-15 21:13:57.073800 [ERROR][MPMain(1)]: SKIN: Missing C:\ProgramData\Team MediaPortal\MediaPortal\Skin\Black Glass Nova for Mediaportal 1.2.0\common.osd.buttons.xml
2012-04-15 21:14:04.021800 [ERROR][(9)]: FRITZ!Box Manager: FritzBox: Connecting failed: Socket Exception
2012-04-15 21:14:27.653800 [ERROR][(19)]: SQLiteClient:  cmd:sqlite3_step err:BUSY detailed:database is locked query:delete from filters__movie_info__black_list where filters_id=565
2012-04-15 21:14:34.030800 [ERROR][(9)]: FRITZ!Box Manager: FritzBox: Connecting failed: Socket Exception
2012-04-15 21:14:42.987800 [ERROR][(19)]: SQLiteClient:  cmd:sqlite3_step err:BUSY detailed:database is locked query:delete from criteria where ID = 16806
2012-04-15 21:14:58.048800 [ERROR][(19)]: SQLiteClient:  cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:COMMIT
2012-04-15 21:15:03.555800 [ERROR][Library Sync(21)]: SQLiteClient:  cmd:sqlite3_prepare16:pvm=null err:NOMEM detailed:out of memory query:insert into filters (name, criteriagrouping, generic_type) values (' ', 'ALL', 'MediaPortal.Plugins.MovingPictures.Database.DBMovieInfo, MovingPictures, Version=1.3.1.1350, Culture=neutral, PublicKeyToken=null')
2012-04-15 21:15:03.556800 [ERROR][MPMain(1)]: SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:NOMEM detailed:out of memory query:SELECT Id, Artist, Disk_Image, Source_Image, Type, Source FROM Music_Fanart WHERE Artist IN ('popa chubby','popa chubby') AND Enabled = 'True' AND (Type = 'MusicFanart Scraper' OR Type = 'MusicFanart User') AND restricted = 0;
2012-04-15 21:15:03.573800 [ERROR][(19)]: SQLiteClient:  cmd:sqlite3_prepare16:pvm=null err:NOMEM detailed:out of memory query:delete from node__node where node1_id=569
2012-04-15 21:15:03.575800 [ERROR][Library Sync(21)]: SQLiteClient:  cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:near "=": syntax error query:delete from filters__movie_info__black_list where filters_id=
 

The first few errors seem to be related to plugins that are not part of the standard MP install.

First of all, it seems that a database is locked. I don't know if this should cause a problem, but it would help to work out which database is causing the problem.

Taking quite a bit of my time trying to help you as well.

Not that I can think of.

Not that I am aware of.

You probably have about 7 .db3 files in the location I specified. In the time taken to post, you could have taken 3 of them out and started MediaPortal. If it started fine, you would know it was one of the three. etc.

It won't take long to troubleshoot, but the simple fact is that computers crash, databases can become corrupted and we cannot plan for everything, particularly in 3rd party plugins (which may or may not be to blame).

Ideally you will be able to provide us with the problem database file, so that we can work out why it is causing a problem. That way, this won't happen in future.

Well, better to find the one faulty one than to do a full reinstall.

I don't doubt that there is a tolerance problem with the new sqlite.dll. If we have a database that it doesn't like, maybe we can fix the problem without reverting to the older version.

We really would appreciate your help.