SQLite Android Database Cursor window allocation of 2048 kb failed

by

Most often the cause for this error are non closed cursors. Make sure you close all cursors after using them (even in the case of an error).

Cursor cursor = null;
try {
    cursor = db.query(...
    // do some work with the cursor here.
} finally {
    // this gets called even if there is an exception somewhere above
    if(cursor != null)
        cursor.close();
}

To make your App crash when you are not closing a cursor you can enable Strict Mode with detectLeakedSqlLiteObjects in your Applications onCreate: 

StrictMode.VmPolicy policy = new StrictMode.VmPolicy.Builder()
   .detectLeakedClosableObjects()
   .detectLeakedSqlLiteObjects()
   .penaltyDeath()
   .penaltyLog()
   .build();
StrictMode.setVmPolicy(policy);

Obviously you would only enable this for debug builds.

More Related Contents:

  1. java.lang.OutOfMemoryError: bitmap size exceeds VM budget – Android
  2. Android : Static Fields and Memory Leaks
  3. What is The use of moveToFirst () in SQLite Cursors
  4. Retrieve large blob from Android sqlite database
  5. EditText causing memory leak
  6. I am getting this error on my code [closed]
  7. Sqlite for Android
  8. Activity has leaked window that was originally added
  9. How can I avoid concurrency problems when using SQLite on Android?
  10. How to store(bitmap image) and retrieve image from sqlite database in android? [closed]
  11. Best way to work with dates in Android SQLite [closed]
  12. How do I join two SQLite tables in my Android application?
  13. How can I create a user-defined function in SQLite?
  14. Android error – close() was never explicitly called on database
  15. How do I create a database in android? [closed]
  16. Full text search example in Android
  17. Android SimpleCursorAdapter doesn’t update when database changes
  18. When a Fragment is replaced and put in the back stack (or removed) does it stay in memory?
  19. How to implement Export sqlite To excel/csv file in android?
  20. How to store and retrieve a byte array (image data) to and from a SQLite database?
  21. SQLite Query in Android to count rows
  22. How does Bitmap allocation work on Oreo, and how to investigate their memory?
  23. Attempt to reopen an already-closed object sqlitedatabase
  24. How insert image in room persistence library?
  25. SQLite android column not found
  26. SQlite – Android – Foreign key syntax
  27. Activity has leaked window com.android.internal.policy.impl.PhoneWindow$DecorView@44f72ff0 that was originally added here
  28. Inserting values to SQLite table in Android
  29. SQLiteOpenHelper onUpgrade() Confusion Android
  30. SQLite Foreign Key

Leave a Comment