Databases
StackOverflow2013
Postsdbo
POSQLite Android Database Cursor window allocation of 2048 kb failed
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQLite Android Database Cursor window allocation of 2048 kb failed
    primarykey
    data
    text
    <p>I have a routine that runs different queries against an SQLite database many times per second. After a while I would get the error </p> <p><code>"android.database.CursorWindowAllocationException: - Cursor window allocation of 2048 kb failed. # Open Cursors = "</code> appear in LogCat.</p> <p>I had the app log memory usage, and indeed when usage reaches a certain limit the I get this error, implying it runs out. My intuition tells me that the database engine is creating a NEW buffer (CursorWindow) every time I run a query, and even though I mark the .close() the cursors, neither the garbage collector nor <code>SQLiteDatabase.releaseMemory()</code> are quick enough at freeing memory. I think the solution may lie in "forcing" the database to always write into the same buffer, and not create new ones, but I have been unable to find a way to do this. I have tried instantiating my own CursorWindow, and tried setting it to and SQLiteCursor to no avail.</p> <p>¿Any ideas?</p> <p>EDIT: re example code request from @GrahamBorland:</p> <pre><code>public static CursorWindow cursorWindow = new CursorWindow("cursorWindow"); public static SQLiteCursor sqlCursor; public static void getItemsVisibleArea(GeoPoint mapCenter, int latSpan, int lonSpan) { query = "SELECT * FROM Items"; //would be more complex in real code sqlCursor = (SQLiteCursor)db.rawQuery(query, null); sqlCursor.setWindow(cursorWindow); } </code></pre> <p>Ideally I would like to be able to <code>.setWindow()</code> before giving a new query, and have the data put into the same <code>CursorWindow</code> everytime I get new data. </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USalex
    1. USalex
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQLite Android Database Cursor window allocation of 2048 kb failed
      1. USalex
      1. VTFavorite
    2. VO
      singulars
      1. POSQLite Android Database Cursor window allocation of 2048 kb failed
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSQLite Android Database Cursor window allocation of 2048 kb failed
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI don't know what is the problem..:) but I use to make SQLiteOpenHelper class singleton. So I never found any issues like this.
      singulars
      1. POSQLite Android Database Cursor window allocation of 2048 kb failed
      1. USMohsin Naeem
    2. CONo i don't use SQLiteOpenHelper, I create a static DataAccess class that contains an SQLiteDatabase. This works fine and i doubt the problem is there. The problem has more to do with the SQLite libraries creating a NEW container to place the results of every new query, rather than using the same container over and over again. And although I can close the cursor, the rate at which the GC cleans up is slower than the rate at which new containers are created, thus producing the memory hog.
      singulars
      1. POSQLite Android Database Cursor window allocation of 2048 kb failed
      1. USalex
    3. COCan you show some of your code, particularly what you tried to do with setting your own `CursorWindow`?
      singulars
      1. POSQLite Android Database Cursor window allocation of 2048 kb failed
      1. USGraham Borland
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload