- March 26, 2007
- 3,715
- 180
- Home Country
-
Germany
Multiple database access can cause the sqlite database to become unavailable when something is written to it. I stumbled upon this problem during the development of aMPdroid/GmaWebservice. For some reason the MP-TvSeries database would sometimes "crash" and after that neither MP-TvSeries nor GmaWebservice could access the sqlite database. A journal file was created (MP-TvSeriesDatabase4.db3.journal) and only after this got deleted the database would become accessible.<br /> <br /> The problem is, that sqlite allows no other locks (not even shared==readonly) when data is written. So when another process has a lock on the database, the client is supposed to wait until the data can be written (which the MediaPortal SQLiteClient doesn't).
Continue reading...
Continue reading...