CursorWindow can not be created due to cursor [memory] leak

最新推荐文章于 2022-10-16 10:41:02 发布
原创 最新推荐文章于 2022-10-16 10:41:02 发布 · 8k 阅读 · 2 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#cursor_leak

本文记录了Android系统中因Cursor泄露导致内存耗尽的问题，分析了错误日志并给出了解决方案。

记录了Android系统上由于cursor泄露导致内存耗尽（error -12）导致的CursorWindow不能再创建的Issue。

[Symptom]

08-30 20:27:36.751 E/CursorWindow(  760): Could not allocate CursorWindow '/data/data/com.android.providers.media/databases/external.db' of size 2097152 due to error -12.
08-30 20:27:36.771 E/JavaBinder(  760): *** Uncaught remote exception!  (Exceptions are not yet supported across processes.)
08-30 20:27:36.771 E/JavaBinder(  760): android.database.CursorWindowAllocationException: Cursor window allocation of 2048 kb failed. # Open Cursors=781 (# cursors opened by pid 3105=781)
08-30 20:27:36.771 E/JavaBinder(  760):  at android.database.CursorWindow.<init>(CursorWindow.java:104)
08-30 20:27:36.771 E/JavaBinder(  760):  at android.database.AbstractWindowedCursor.clearOrCreateWindow(AbstractWindowedCursor.java:198)
08-30 20:27:36.771 E/JavaBinder(  760):  at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:162)
08-30 20:27:36.771 E/JavaBinder(  760):  at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:156)
08-30 20:27:36.771 E/JavaBinder(  760):  at android.database.CursorToBulkCursorAdaptor.count(CursorToBulkCursorAdaptor.java:184)
08-30 20:27:36.771 E/JavaBinder(  760):  at android.content.ContentProviderNative.onTransact(ContentProviderNative.java:117)
08-30 20:27:36.771 E/JavaBinder(  760):  at android.os.Binder.execTransact(Binder.java:338)
08-30 20:27:36.771 E/JavaBinder(  760):  at dalvik.system.NativeStart.run(Native Method)

[Analysis]

logcat中有很明显的下列输出

Could not allocate CursorWindow '/data/data/com.android.providers.media/databases/external.db' of size 2097152due to error -12，

主要是due to error -12, ENOMEM，除非是其它原因内存耗尽，否则一般情况下是cursor泄露；注意errno是-12，如果是-24，EMFILE，则表示是进程内文件描述符耗尽，则未必是cursor泄露的原因。

继续从logcat中向前找，会发现大量的下列输出，

08-30 20:27:24.909 D/dalvikvm( 3105): GC_EXPLICIT freed 1686K, 26% free 15810K/21315K, paused 8ms+16ms
08-30 20:27:24.919 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:24.929 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:24.949 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:24.949 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:24.969 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:24.989 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:24.989 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:24.989 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:24.999 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:24.999 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:24.999 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.009 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.009 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.009 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.019 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.019 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.019 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.019 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.029 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.029 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.029 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.039 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.039 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.039 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.039 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.049 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.049 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.049 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.049 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.049 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.049 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.059 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.059 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.059 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.059 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.059 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.059 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.069 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.069 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.069 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.069 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.069 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.069 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.069 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.079 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.079 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.079 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.079 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.079 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:27:25.079 W/CursorWrapperInner( 3105): Cursor finalized without prior close()

08-30 20:26:57.179 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.189 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.209 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.229 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.249 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.259 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.269 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.279 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.299 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.299 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.299 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.309 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.309 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.309 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.309 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.309 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.319 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.319 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.319 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.319 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.319 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.329 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.339 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.339 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.339 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.349 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.349 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.349 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.359 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.359 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.369 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.369 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.369 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.369 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.369 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.379 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.379 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.389 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.389 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.389 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.389 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.399 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.399 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.399 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.399 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.409 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.409 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.409 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.409 W/CursorWrapperInner( 3105): Cursor finalized without prior close()
08-30 20:26:57.419 W/CursorWrapperInner( 3105): Cursor finalized without prior close()

说明有很明显的cursor leak。

解决办法是找到使用cursor的地方，在使用完毕后cursor.close()即可。

Cursor和CursorWindow的关系，参见Concepts of Cursor and CursorWindow on android platform

 

Puppeteer开发过程中遇到的问题及解决方案
m0_54849806的博客
02-21 8046
工欲善其事必先利其器，请先检查本机是否安装NodeJS环境以及查阅API： Google官方文档：https://developers.google.com/web/tools/puppeteer API（v12.0.1）文档：https://pptr.dev/#?product=Puppeteer&version=v12.0.1&show=outline 问题：如何处理各种验证码？ 解决方案：建议大家去搜索对应的解决方案，Puppeteer并无此类解决方案。 问题：某些网站做了JS防爬检测
PostgreSQL 源码解读（12）- 插入数据#11（exec_simple_query）
08-09 2108
本文简单介绍了PG插入数据部分的源码，主要内容包括exec_simple_query函数的实现逻辑，该函数位于src/backend/tcop/postgres.c文件中。 一、源码解读 exec_si...
Could not allocate CursorWindow size due to error -12 错误解决方法
java_zhaoyanli的专栏
05-25 1620
程序出现下面的错误： 08-30 20:27:36.751 E/CursorWindow(u 760): Could not allocate CursorWindow  '/data/data/com.android.providers.media/databases/external.db' of size 2097152 due to error -12.08-30 20:27:36
Android数据库Cursor异常原因和Fd泄露分析
Kelly
10-16 3454
Android常见异常分析
Android 异常解决方法汇总
学习
01-13 3519
（1）异常：Android中引入第三方Jar包的方法(java.lang.NoClassDefFoundError解决办法) 1、在工程下新建lib文件夹，将需要的第三方包拷贝进来。 2、将引用的第三方包，添加进工作的build path。选中jar包->Build Path 3、（关键的一步）将lib设为源文件夹。如果不设置，则程序编译可以通过，但运行的时候，会报：选中lib文件夹->so
Workspace Cannot Be Created
zhangdabusy520的博客
08-13 3250
Java创建项目时，在空间放置中会遇到Workspace Cannot Be Created......一系列的问题，点击OK后，会跳出Workspace Unavailable的错误。遇到的主要问题有： 1、因为磁盘权限只能是写，可以另外选择一个可以写入的磁盘存储；如果想继续存在这个磁盘里面的话，就要修改磁盘权限了。2、有可能是文件夹名字里面含有不规则的符号，例如空格等。 对第一种情况修订过程如下： 点击鼠标右键，属性->安全->编辑->User->写入允许
Could not allocate CursorWindow error -12
jinmv的专栏
08-12 573
android 中使用Cursor 查询数据库时，
FlexGraphics_V_1.79_D4-XE10.2_Downloadly.ir
11-22
- FIX: The TFlexPanel.FindControlAtPoint method maked virtual to realize RealTime-capability when on mouse cursor moving the flex-object search not occurs. - FIX: After deleting the selected points ...
Senfore_DragDrop_v4.1
12-21
I can almost guarantee that I will be able to fix the problem in very short time. Please supply only the source files (pas, dfm, dpr, dof, res, etc.) and mail them as a single zip file. If I need a ...
VclZip pro v3.10.1
03-03
VCLZip Native Delphi Zip/UnZip Component!...Fixed a problem that was not allowing ZipComment's to be added correctly to spanned or blocked zip files. Not the same fix as in 2.22. Directories ...
[已解决]Could not allocate CursorWindow '' of size of size 2097152 due to error -12.
热门推荐
Kodulf的专栏
07-28 1万+
Could not allocate CursorWindow '/data/data/com.wbm.app.activity/databases/cashierDB.db' of size 2097152 due to error -12. 07-26 16:28:14.067 9407-9654/? W/System.err: android.database.CursorWind
android数据库操作问题：could not allocate cursorwindow，errno：-12
OHRadiance的专栏
02-24 3986
android上手没多久，正好涉及到数据库操作，用了android自带的sqlite。     正好需要往数据库导点数据进去测试用，然后直接在主进程写数据库了。。。然后，就出现这个问题：could not allocate cursorwindow，errno：-12。     在网上搜了许久，stack overflow上也有人提问，结果在乐乎上找到答案了。     原来是写数据库时涉及到
Triggers can not be created on system tables
qq_61923405的博客
05-25 3146
Triggers can not be created on system tables 数据库初学者可能出现的问题！！！
出现Could not allocate CursorWindow of size due to error -12.错误的解决方案
成长的味道
03-02 8198
E/CursorWindow( 2703): Could not allocate CursorWindow ‘/data/data/com.navitag/databases/navitel_tracker_db’ of size 2097152 due to error -12. E/CursorWindow( 2703): Could not allocate CursorWindow ‘/
完美解决opencv级联分类器训练过程中报错：Image reader can not be created from -vec F:\opencv\InputIm
蒋程扬的部落格
03-24 1726
这个问题可能是opencv的一个bug，说找不到负样本的描述文件，可是地址也写对了啊，这时候只需要把负样本和描述文件放到训练器的同一目录下就行了： 当然-bg的地址要写为：-bg bg.txt ...
MyEclipse work space in use or can not be created解决方法
Campo_Wolf_Bradley的博客
11-01 405
-- 问题描述：重装系统后发现MyEclipse不能使用以前设置的默认 Work Space.启动软件后报错：work space in use or can not created -- 解决方法：My Eclipse在 Work Space.会建立一个.lock文件。关闭MyEclipse将该文件删除即可。 ...
there is very likely to create a memory leak
最新发布
07-18
### Identifying and Preventing Memory Leaks in Software Development Memory leaks are a common issue in software development, particularly in applications that manage memory manually. A memory leak occurs when a program allocates memory and fails to release it after it is no longer needed. Over time, this can lead to excessive memory consumption, degraded performance, or even application crashes. Detecting and preventing memory leaks is crucial for maintaining application stability and efficiency. #### Identifying Memory Leaks To identify memory leaks, developers can use a combination of tools and techniques: - **Profiling Tools**: Tools like Valgrind for C/C++, VisualVM for Java, or Instruments for macOS and iOS can track memory allocations and detect memory leaks. These tools provide detailed reports on memory usage over time and can pinpoint areas where memory is not being properly released. - **Logging and Debugging**: By logging memory allocation and deallocation events, developers can manually inspect logs to identify discrepancies. Setting breakpoints in a debugger can also help track down where memory is being allocated without being freed. - **Unit Testing**: Writing unit tests that monitor memory usage can help detect memory leaks in specific functions or modules. For example, running a function repeatedly and observing if memory usage increases linearly can indicate a memory leak. - **Code Reviews**: Regular code reviews can help catch memory management issues early. Reviewers should look for patterns such as missing `free()` calls in C, unbalanced `retain`/`release` in Objective-C, or failure to close resources in languages like Java. #### Preventing Memory Leaks Preventing memory leaks involves adopting best practices and using modern programming techniques: - **Use Smart Pointers (C++)**: In C++, smart pointers like `std::unique_ptr` and `std::shared_ptr` automatically manage memory, reducing the risk of leaks. These pointers ensure that memory is released when it is no longer referenced. - **Garbage Collection (Java, .NET)**: Languages with built-in garbage collection, such as Java and C#, reduce the burden of manual memory management. However, developers should still be cautious with object lifetimes and avoid unintentional object retention, such as holding references in static collections. - **Resource Management Patterns**: Use patterns like RAII (Resource Acquisition Is Initialization) in C++ or try-with-resources in Java to ensure that resources are properly released when they are no longer needed. - **Avoid Circular References**: In environments with reference counting (e.g., Objective-C, Python), circular references can prevent objects from being deallocated. Using weak references can help break these cycles. - **Use Memory-Safe Languages**: Consider using memory-safe languages like Rust, which enforce memory safety at compile time without relying on a garbage collector. #### Example: Detecting a Memory Leak in C ```c #include <stdlib.h> #include <stdio.h> void leak_memory() { char *buffer = (char *)malloc(100); // Forgot to free the buffer } int main() { while (1) { leak_memory(); sleep(1); // Simulate ongoing process } return 0; } ``` In this example, the `leak_memory` function allocates memory but never frees it. Over time, this will cause the program's memory usage to grow indefinitely. Tools like Valgrind can detect this leak and report the source. #### Example: Using Smart Pointers in C++ ```cpp #include <memory> #include <iostream> void safe_memory() { std::unique_ptr<int> ptr(new int(42)); std::cout << *ptr << std::endl; // Memory is automatically freed when ptr goes out of scope } int main() { safe_memory(); return 0; } ``` Here, `std::unique_ptr` ensures that the allocated memory is automatically released when the pointer goes out of scope, preventing a memory leak. #### Example: Using Try-With-Resources in Java ```java import java.io.*; public class ResourceExample { public static void main(String[] args) { try (BufferedReader br = new BufferedReader(new FileReader("file.txt"))) { String line; while ((line = br.readLine()) != null) { System.out.println(line); } } catch (IOException e) { e.printStackTrace(); } } } ``` In this Java example, the `BufferedReader` is declared within a try-with-resources statement, ensuring that it is closed automatically at the end of the block. ###
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值